Log in

View Full Version : Bank Reconciliation


MysteryOwl
Oct 6, 2013, 07:24 AM
Donovan Company received a bank statement for the month of September 2012, which showed a balance per bank of $4,200. The company's Cash account in the general ledger showed a
Balance of $2,800 at September 31. Other information that may be relevant in preparing a bank
Reconciliation for September follows:

1.The bank returned an NSF check from a customer for $510.

2.The company recorded cash receipts of $810 on September 30 but this amount does not
Appear on the bank statement.

3.A payroll check correctly written and paid by the bank for $1,480 was incorrectly recorded in
The cash payments journal for $1,840.

4.Checks which were written in August but still had not been presented to the bank for payment
At September 30 amounted to $250.

5.The bank included a credit memorandum for $1,200, which represents a collection of a
Customer's note by the bank for the company; principal amount of the note was $900 and the
Remainder was interest.

6.The bank included a $30 debit memorandum for service charges for the month of September.

7.Checks written in September which have not been paid by the bank at September 30
Amounted to $940.

Instructions:
1.Prepare a bank reconciliation for Donovan Company for September which reconciles the
Balance per books and the balance per bank to their adjusted correct balances.











2.Prepare the necessary adjusting entries for Donovan Company at September 30, 2012.

pready
Oct 6, 2013, 08:06 AM
You have to get the bank balance of $4,200 into agreement with the company's balance of $2,800 by either adding to or subtracting from the bank balance or company's balance the items #1 through #7. You do this by determining where the item came from. In other words who knows about the item. For example number 1 the bank is telling you so you have to either add to or subtract the amount from the company's balance. Number 2 is from the company so you will have to either add to or subtract from the bank balance. You need to do this for all items.

The balance after the reconciliation for the bank balance and the company's balance should be $3820

After the reconciliation you will need to do adjusting entries for the items that you had to either add to or subtract from the company's balance.

rehmanvohra
Oct 7, 2013, 06:02 AM
First adjust cash book balance:

Balance per cash book 2800
1. NSF check (510)
3. Payroll overstated 360
5. Note Receivable collected 900
Interest on note 300
6. Bank charges (30)
Adjusted balance 3820

Bank reconciliation
Balance per bank statement 4200
2. Deposit in transit 810
4. Unpresented checks Aug (250)
7. Unpresnted checks Sept (940)
Adjusted balance 3820