9 Please use the following information to develop a two colu

9. Please use the following information to develop a two column bank reconciliation: Accounting Records (The Books) Checkbook Register - April Date Check # Amount April 1 1601 $682.45 April 8 1602 $1,354.67 April 10 1603 $85.12 April 22 1604 $345.69 April 25 1605 $291.23 April 28 1606 $856.64 April 30 1607 $783.91 Deposit Records Date Amount April 5 $1,267.12 April 15 $1,185.34 April 30 $1,219.86 $3,672.32 Beginning Cash Balance Add: Deposits Less: Checks Written Ending Cash Balance $3,036.72 $3,672.32 $4,399.71 $2,309.33 Bank Statement - April Date Activity Beginning Balance 4/1 4/5 4/6 4/11 4/19 4/25 Checks & Deposits Deductions Balance $3,296.77 $165.42 $3,131.35 $682.45 $2,448.90 $1,267.12 $754.32 $2,961.70 $1,354.67 $1,607.03 $1,185.34 $92.67 $2,699.70 $85.12 $2,614.58 $354.69 $2,259.89 $291.23 $1,968.66 $856.64 $1.112.02 $136.00 $976.02 $20.75 $955.27 4/26 4/28 4/30 4/30 NSF Check 4/30 Service Charge Prepare a two column bank reconciliation using the accounting records and bank statement above with this additional information: 1. Reconciling items from March\'s reconciliation included the following check values: $165.42 $92.67, $754.32. There was also a deposit in transit at the end of March: $752.36. 2. The Service Charge includes a $15 NSF Fee on the NSF check. 3. All checks and deposits are correctly recorded in the bank records.

Solution

Bank reconciliation Bank balance 955.27 Add Deposit in transit 1219.86 March deposit in transit 752.36 1972.22 Less Outstanding checks Chq no. 1607 783.91 783.91 Adjusted bank balance 2143.58 Cash balance 2309.33 Add Directly deposited in bank Less Service charge 20.75 NSF check 136 1604 chq no. Incorrectly recorded 9 Unpaid cheque 165.75 Adjusted cash balance 2143.58