Preparing Comprehensive Bank Reconciliation with Theft and Internal Control Deficiencies

profileskizzy
Week5_ExcelTemplateAssignment_Individual_Daisey_Company.xlsx

Problem 7-8A

Name
Section
Date Daisey Company
(a)
DAISEY COMPANY
Bank Reconciliation
October 31, 2017
Cash balance per bank statement 1
Plus: 2
Total Receipts 1
Less: 1
No. Amount No. Amount
4
4
0.00 5
Adjusted cash balance per bank $ - 0 1
Cash balance per books 1
Add: 2
Adjusted balance per Books (before theft) 1
Less: 2
Adjusted cash balance per books 1
26 possible points
(b)
Indicate the 3 ways that Bret attempted to conceal the theft and the dollar amount
involved in each method:
Please answer this in your Word document according to the Grading Guide 3 possible points
(c)
Internal control activities that were violated include:
Please answer this in your Word document according to the Grading Guide 2 possible points
31 total possible points

418