Indicate three ways that bret attempted to conceal the theft

Assignment Help Accounting Basics
Reference no: EM131421346

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

Reference no: EM131421346

Outsourcing, especially to low labor-cost countries

Outsourcing. Outsourcing, especially to low labor-cost countries, has grown substantially. What are the advantages and disadvantages of outsourcing? Include and describe a p

Construction accounting & financial management

Time cards are being entered into the accounting system for four employees. The costs for Employee 1 areto be billed to job cost code 302.01.01100L. Ten hoursof Employee 2 t

Problem regarding the lefties-seatbelts

A lecture hall has 200 seats with folding arm tablets, 30 of which are designed for left-handers. The typical size of classes that meet there is 188, and we can assume that

Find the payback for investment

George Williams buys a machine for his business. The machine costs $150,000. George estimates that the machinecan produce $40,000 cash inflow per year for the next fiveyears

Real limitations on the ability of owners of certain types

As we covered in Weeks 2 and 3, the passive loss limitation rules impose real limitations on the ability of owners of certain types of ventures to take losses from those ven

Partner in the kkm partnership

Tom is a 40% partner in the KKM Partnership. During the current year, KKM reported gross receipts of 160,000 and a charitable contribution of 10,0000.

Find the average rate of change

Find the average rate of change of y with respect to x from P to Q. Then compare this with the instantaneous rate of change of y with respect to x at P by finding mtan at P.

Identify and discuss an advantage using for it systems

Identify and discuss an advantage using for IT systems in the materials conversion process. Please make sure that you address the conversion process by focusing on an activi


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd