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
|
|
$21,877.72
|
|
Add: Outstanding checks
|
|
|
|
No. 862
|
$190.71
|
|
|
No. 863
|
226.80
|
|
|
No. 864
|
165.28
|
482.79
|
|
|
|
22,360.51
|
|
Less: Undeposited receipts
|
|
3,795.51
|
|
Unadjusted balance per bank, October 31
|
|
18,565.00
|
|
Less: Bank credit memorandum
|
|
185.00
|
|
Cash balance per bank statement, October 31
|
|
$18,380.00
|
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
|
Provide the entry made by lilly to record the charge
: Assume Lilly's tax rate for 2009 was 26 percent. Compute the tax savings related to the charge.
|
|
Concentration to be higher in houses with basements
: Would you expect radon gas concentration to be higher in houses with basements or concrete slab foundations? Why? How could you test your hypothesis?
|
|
Define fraud and internal control principles
: What level of internal controls is consider to be adequate in a company? What are effective controls for cash and why are these controls considered to be effective? Define Fraud and Internal Control Principles.
|
|
Compute the balance in the pension liability account
: Prepare the journal entries to accrue the pension liability and fund it for 2007, 2008, 2009, 2010, and 2011.
|
|
Indicate three ways that bret attempted to conceal the theft
: 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?
|
|
Compare and contrast the various cognitive models
: In a virtual world (VW) of massively multiplayer online role-playing games (MMORPGs), collaboration and communication are provided through the Internet between MMORPG-ready devices such as the Microsoft Xbox, and Sony PlayStation, and by using the..
|
|
Prepare the journal entries to accrue income tax expense
: Prepare the journal entries to accrue income tax expense and income tax liability for 2007, 2008, 2009, and 2010. Indicate the balance in the deferred income tax account as of the end of each of the four years.
|
|
How fast is the truck moving relative to the highway
: 1. You are driving eastbound on the interstate at 70 mi/h. You observe that you are approaching a truck in your lane at a relative speed of 20 mi/h. a. How fast is the truck moving relative to the highway?
|
|
Different types of research methodology
: Can someone assist me on different types of research methodology (such as quantitative, qualitative and mix methods) on Solar Power Energy? Which includes the proposal, research instruments/techniques used in a justification of decisions.
|