Option #2: Manipulated Bank Reconciliation

Anonymous
timer Asked: Oct 19th, 2018
account_balance_wallet $15

Question Description

Please refer to problem 6.53 in your textbook. Please note that there is an image of the bank statement that you will want to review that is included with the problem in the textbook.

You must use the computer-based Electronic Workpapers in Excel on the textbook website to prepare the bank reconciliation solution. Please refer to Lynda.com video tutorials for assistance working with Excel. Lynda.com can be found on CSU-Global Library database.

Caulco Inc. is the audit client. The February bank statement is shown in Exhibit 6.3 in the text. You have obtained the client-prepared bank reconciliation as of February 28 (see the following).

Required:

Check 2231 was the first check written in February. All earlier checks cleared the bank, some during January and some during February. Assume that the only February-dated cancelled checks returned in the March bank statement are 2239 and 2240 showing the amounts listed in the February bank reconciliation. They cleared the bank on March 3 and March 2, respectively. The first deposit on the March bank statement was $1,097.69 credited on March 3. Assume also that all checks entered in Caulco's cash disbursements journal through February 29 have either cleared the bank or are listed as outstanding checks in the February bank reconciliation.

Determine whether any errors exist in the bank reconciliation. If errors exist, use Excel to prepare a corrected reconciliation and explain the problem. You should provide your explanation in the Excel document at the bottom of the workpaper.

Tutor Answer

profNdegwa
School: Carnegie Mellon University

...

flag Report DMCA
Review

Anonymous
Thanks, good work

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors