Purchase Solution

Bank Reconciliation

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

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 ...

Purchase this Solution


Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Operations Management

This quiz tests a student's knowledge about Operations Management

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.