Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
The week 5 assignment is a very interesting assignment. It gives you the opportunity to do a little forensic audit. The Bookkeeper, Bret Turrin, is cooking the books and taking some
The week 5 assignment is a very interesting assignment. It gives you the opportunity to do a little forensic audit. The Bookkeeper, Bret Turrin, is cooking the books and taking some cash from the business for his personal use. You have been brought in as an expert to help uncover the theft by reconciling the bank statement properly.
What I would like you to do is prepare the bank reconciliation using the excel spreadsheet, answer the questions in the notes section of the excel template. Then instead of the 1,050 words paper, prepare a memo to the Controller, explaining your findings and recommendations for controls over cash to prevent this situation from happening in the future. Incorporate your answers to the initial assignment questions as part of your memo to the controller. Please use the internal controls referenced in the lessons that we are covering. This means you will have to understand the objectives noted in your course text.
Part (b) of the template will be your answer to the first question: Indicate the three ways that Bret attempted to conceal the theft and the dollar amount involved in each method.
Part (c) of the template will be your answer to the second question: What principles of internal control were violated in this case?
Anticipated Questions you may have:
What is a Controller? The controller in a company is the head of the accounting department. This person is responsible for all the accounting functions of the business. The controller reports to the CFO or V.P. of Finance - depending on the size of the company. The accounting manager, bookkeeper, accounting clerks and all other staff in the accounting office will report to the controller.
What is a Forensic Audit? In a forensic audit, the company conducts an examination of their records, internal controls systems and procedures in search of evidence, weaknesses, and behaviors that shed light on fraud in the company. This is a general explanation of a forensic audit.
For those of you who have never written a memo, I have included information on how to access a template, and link to a library article about business memos. On the job, you would attach the memo to an e-mail and send it to the controller or you would create a memo e-mail attach your bank reconciliation, your official memo of findings and any other evidence or created files.
To access a memo template from your word document page:
Select "File"
Select "New"
In the search space type "memo" and press the enter key
Choose the Memo (simple style)
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 revised bank reconciliation using the provided Excel® spreadsheet.
Prepare a memo to the Controller of Daisey Company, explaining your findings and recommendations for controls over cash to prevent fraud from happening in the future. Incorporate in your memo to the Controller 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?
- @
- 165 orders completed
- ANSWER
-
Tutor has posted answer for $20.00. See answer's preview
*********** ************** ************* ************* *********************** 31 ************* ** per **** ******************************************************************************* Checks NoAmountNoAmount 621407586219071 1831808632268 2842532586416528 Total115679 1722321Notes Receivable ******************************************************** ******* **** ****************************** ** *** books 2187772Add Undeposited **************************** ******* ** *** biiks 1808221 (b) *** **************************************************************************************************************************** ****** *** ******* ** ********************************************************************************* also ******* adjusted **** in ***** checks Bank ************** ********* is an ********* ********* ******** which ** ******** by business ************* of all ***** ** ***** *** **** balance of *** **** ********* **** *** ******* ** *** ********* ********* books **** ************** Statement ******* ** ********* *** prevention ** *********** *** ************* ***** ***** **** ****** ** bank employees accountants ******* employees and ********** ******** *********** ** bank ************** ********* is ***** basis *** **** ********* **** ******* **** ************ might ******* ** ********* ************** ********* helps ** Detection ** FraudAs ******* of *********** of **** reconciliation statement ** ** ***** * ********* ****** ****** with the ****** cleared from bank **** *** company's bank ********* a ******* ******* based ** *********** ******** *** ********** helps ** ****** fraudulent ********** ***** *** include ******** *** *** *** ******** ******** ******** ** ************ ********* or unauthorized ******* and ******* check amounts and detailsBank ************** Statement ******** ************ *** **** ******* cash ********** **** customers and **** payments ** vendors ********* and *** ******** *** ******** ********** **** ********* can **** ************ **** ** essential to **** **** gap when * company ** ********* ** **** low **** balance ******* *********** ** **** reconciliations *** **** ********** to postpone ******** that *** ****** ** ******* ********** ******* ****** and ***************** fees *** ************ ************** Statement ********** **** ErrorsTo **** ****** ** ***** nature *** bank employees can **** bank ****** ********* They *** ********* ******* *** record the wrong ***** ****** ****** *** ****** ** *** ***** **** account **** ** ****** **** * ********* **** ********* ** can ****** * ********* transaction Reconciliation ** the **** ******* **** **** **** ***** *** ******* to ****** *** **** ** its ***** allowing *** bank to ******* *** discrepancy *** correct *** *********** ************** Statement Improves ********** *********** reconciliation ** **** ** **** ********* in ****** ********** ** ***** accounts ********** ** * ********** ******* is ******* **** *** bank indicates **** *** ********** ** no longer *********** *** ********* ******** ** further ****** But if the ******** ***** ** *** ******* **** ****** ********** ** ** **** aggressive ** its collection *********** **** **** ********* ** ******* *** ***** and *** dollar ****** ******** ** each method: Company’s accountant Mr Bret *** made *** *** ******** ** ******* *** ***** He ***** ***** ** ******* and **** for *** ******** use and ** applied ********* ***** ****** ******* he *** *** show ***** *********** ****** ** ****** Ch ** Amount621407518318028425325Total574Accountant *** not **** these three checks *** *** *** ******* ** **** reconciliation ********* ******** ** amount ******* ****** *** showing ***** ********* ***** ****** accountant *** committed ******* ** **** ** ***** ** ********** of **** ** ******** ******* as *** bank ********* and ******** balance ** *** **** ***** He *** ***** *** ******** above ******* for *** ******** *** which **** to ** *********** ******* ****** ***** *** *********************** of ******** Control:The ******* ** standard internal control ********** *** ************ ** **** payments Cash Receipts ************** *********** ** ****** and ****** *** ****** *********** to ******* money ** bank ****** deposit *** moneys ** **** ** *** ******** day **** following *** *** of ******* ****** *** ******* ****** * ****** permitting a ********* time ****** *** ** exceed ***** ******** **** next ********* *** *** of receipt for ****** such ******** *** *** ****** ** **** to ********* *** ****** ***** such **** ** *** ****** *** ************ ****** ** **** must ** ********** ** *** ******* ****** ** **** in under **** and keys ****** ******* facility to ***** **** ********** *********** have accessThis *** be a ******** **** ****** **** **** compartment or ****** cabinetThe ****** ** ******** ******** ** ********* **** ****** be ************ with the amounts ***** stored Combinations or **** ** safes *** ***** storage ********** should ** ********** ** *** custodian ** the cash *** authorized **** upCombinations ** ***** ****** ** changed as ********* *** ******** * ****** **** the *********** or *** ** ******** by ****************** *********** ****** ** ***** when ************ cash **** *** ******* ** **** *********** ***** ******** ** those ******** **** ** * regular basis should be ******** ** *** ******* *** transport ****** be **************** no circumstances ****** **** ** **** through ********* ***** of ********* ** ** ******** in ** obvious ********* ** ***** ********* *** set ********** of ******** ******* ** ******* ******** control of cash ***** *** ** below;1 Person handling **** ******** and ******** ****** ******* ****** not ** ******* ** record cash book2 ********* ******* ****** ** ******** ********* responsibilities3 *********** tail ****** *** ** completed by *** ****** ****** ***** There ****** ** ******** ** **** done ** one ****** by another ReportThe ********** has ********* ***** ** concealing ****** *********** *** ** using ****** cash *** ******** useIt ** **** ** ******** ******* ****** and *** following internal control procedures *** ********** ** ****** *** internal ******* ********** ****** ** person should ** ******* ** ****** **** *** maintain **** **** *** ********** cash ** ** **** *** *********** cash from bank ** ***** if *** ****** ** ******* ** ******* **** *** work ** allowed ** ******* ************ ****** ** ************** ******* ****** ** ******** ********* duties and system ****** be **** *** **** ********** that **** ** *** employee ** ***** checked by ******* ****** which will minimize theft *** **************** of ******* ** **** ** performing all ****** ****** **** *** ***** ** ** ***** on *** **** ** *** ***** ******** ***** *** ******** in ** ***** of **** ** ** **** for *** ******** ******* **** should ** handled ** *** ****** *** books ****** ** ******** ** ******* *** **** ************** ********* should ** ******** ** ***** ******
