Share
Explore BrainMass

Bank Reconciliation

Reconcile the following bank statement to the accounting records.

J & J's Pizza
Check Register
31-Mar-02

Check Number Payee Date Amount
101 Fred's Maintenance 1-Mar 100.00
102 Jan's Cheese 1-Mar 200.00
103 Don Goss 15-Mar 300.00
104 Denise's Consulting 15-Mar 400.00
105 Jan's Cheese 15-Mar 500.00
106 Jan's Cheese 20-Mar 600.00
107 Jan's Cheese 20-Mar 55.75
108 Jan's Cheese 31-Mar 700.00
109 Denise's Consulting 31-Mar 800.00
110 Don Goss 31-Mar 900.00

Total 4,555.75

J & J's Pizza
Deposit List
31-Mar-02

Deposit Payee Date Amount
1 Revenue 3-Mar 2,000.00
2 Revenue 6-Mar 2,000.00
3 Revenue 9-Mar 2,000.00
4 Revenue 12-Mar 2,000.00
5 Revenue 15-Mar 2,000.00
6 Revenue 18-Mar 2,000.00
7 Revenue 21-Mar 2,000.00
8 Revenue 24-Mar 2,000.00
9 Revenue 27-Mar 2,000.00
10 Revenue 30-Mar 2,000.00

Total 20,000.00

Bank of Accounting
Customer Name: J & J's Pizza
31-Mar-02

Beginning Balance 0.00
Total Deposits 18,000.00
Total Withdrawals and Charges 3,525.55
Ending Balance 14,474.45

Checks Cleared Deposits
101 4-Mar 100.00 3-Mar 2,000.00
102 4-Mar 200.00 6-Mar 2,000.00
103 18-Mar 300.00 9-Mar 2,000.00
104 18-Mar 400.00 12-Mar 2,000.00
105 18-Mar 500.00 15-Mar 2,000.00
106 23-Mar 600.00 18-Mar 2,000.00
107 23-Mar 55.55 21-Mar 2,000.00
108 31-Mar 700.00 24-Mar 2,000.00
27-Mar 2,000.00

Total Checks 2,855.55 Total Deposits 18,000.00

Bank Charges
Statement Analysis 3/31/2002 150.00

NSF Check 3/31/2002 500.00
NSF Check Charge 20.00

Total Charges 520.00

Solution Preview

In a bank reconciliation we reconcile the bank and book balance so that both are the same. Transactions which are recorded in the books and are not reflected in the bank (such as checks not cleared or deposits not ...

Solution Summary

The solution explains how to prepare a bank reconciliation for J&J's Pizza

$2.19