# Question & Answer: Module 2 Homework 9. Please use the following information to develop a two column bank reconcilation: Account…..

Based upon the information provided, the “book” and the “bank” balances must be reconciled to equal the same amount.

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