Indicate three ways that bret attempted to conceal the theft
Course:- Accounting Basics
Reference No.:- EM131421346

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Accounting Basics

Assignment: Preparing Comprehensive Bank Reconciliation with Theft and Internal Control Deficiencies

Purpose of Assignment

Reconciling bank accounts is a good way to help maintain internal controls over cash. With time lags and posting errors it is easy for cash transactions to be omitted, recorded in a different accounting period, or reflect incorrect amounts. This assignment with give you practical experience in reconciling the cash balance as noted on the company books to the bank's records.

Assignment Steps

Resources: Financial Accounting: Tools for Business Decision Making

Scenario: Daisey Company is a very profitable small business. It has not, however given much consideration to internal control. For example, in an attempt to keep clerical and office expenses to a minimum, the company has combined the jobs of cashier and book-keeper. As a result, Bret Turrin handles all cash receipts, keeps the accounting records, and prepares the monthly bank reconciliations.

The balance per the bank statement on October 31, 2017, was $18,380. Outstanding checks were No. 62 for $140.75, No. 183 for $180, No. 284 for $253.25, No. 862 for $190.71, No. 863 for $226.80, and No. 864 for $165.28. Included with the statement was a credit memorandum of $185 indicating the collection of a note receivable for Daisey Company by the bank on October 25.

This memorandum has not been recorded by Daisey.

The company's ledger showed one Cash account with a balance of $21,877.72. The balance included undepositied cash on hand. Because of the lack of internal controls, Bret took for personal use all of the undeposited receipts in excess of $3,795.51. He then prepared the following bank reconciliation in an effort to conceal his theft of cash:

Cash balance per books, October 31


Add: Outstanding checks

No. 862


No. 863


No. 864





Less: Undeposited receipts


Unadjusted balance per bank, October 31


Less: Bank credit memorandum


Cash balance per bank statement, October 31


Prepare a 200-word bank reconciliation report (hint: deduct the amount of the theft from the adjusted balance per books) including the following:

• Indicate the three ways that Bret attempted to conceal the theft and the dollar amount involved in each method.

• What principles of internal control were violated in this case?

Show all work in the Excel® spreadsheet and submit with the reconciliation report.

Attachment:- Assignment_Individual_Daisey_Company.xlsx

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Accounting Basics) Materials
Merchandise invoiced at $9,500 is sold on terms 1/10, n/30. If the buyer pays within the discount period, what amount will be reported on the income statement as net sales?
Your roommate is puzzled. During the last year, the company in which she is a stockholder reported a net loss of $675,000, yet its cash increased $321,000 during the same peri
When moving from the changes in fund balances in the Statement of Revenues, Expenditures and Changes in Fund Balances to the changes in net assets in the Statement of Activi
How is the value of a bond determined? What is the value of a 10- year, $1000 par value bond with a 10% annual coupon if its required rate of return is 10%
GW Photography reported net income of $100,000 for 2012. Included in the income statement were depreciation expense of $6,300, patent amortization expense of $4,000, and a gai
Think back over what you have studied and learned in this course. Do you have a new perception of or appreciation for the field of accounting and how it contributes to busin
Of the various methods by which a corporate subsidiary can be separated from the parent company in the public markets (IPO, carve-out, spin-off, split-off, and tracking stock)
They agree to salaries of $12,000 and $18,000 for Singer and McMann respectively and 10% interest on original capital. If they agree to share remaining profits and losses on