Module 2 Homework 9. Please use the following information to develop a two column bank reconcilation: Accounting Records (The Books) Checkbook Register – April Date CheckAmount 1601 Deposit Records April 1 April 8 April 10 $682.45 1602 $1,354.67 $85.12 April 5 April 15 April 30 Amount $1,267.12 $1,185.34 1603 April 22 0 $345.69 April 25 1605 $291.23 1606 LApril 30 1607 $783.91 21986 $3,672.32 April 28 $856.64 Beginning Cash Balance $3,036.72 Add: Deposits Less: Checks Written Ending Cash Balance $2,309.33 $3,672.32 $4.399.71 Bank Statement Date Activity 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 Beginning Balance 4/5 4/6 4/19 4/25 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. Module Homework 2–3
