Week 5 Assignment Prepare Bank Reconciliation Report

Week 5 Assignment Prepare Bank Reconciliation Report in $15 OnlyWeek 5 Assignment Prepare Bank Reconciliation Report

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 must 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?

Loading...