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