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

Purchase this Solution


Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.