Question
I did all the work but somehow i am getting different balance amounts. Can someone tell me what i am doing wrong? Bank Reconciliation and
I did all the work but somehow i am getting different balance amounts. Can someone tell me what i am doing wrong?
Bank Reconciliation and Entries
The cash account for Brentwood Bike Co. at May 1 indicated a balance of $13,070. During May, the total cash deposited was $64,980 and checks written totaled $60,330. The bank statement indicated a balance of $22,030 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:
- Checks outstanding totaled $9,810.
- A deposit of $7,990, representing receipts of May 31, had been made too late to appear on the bank statement.
- The bank had collected for Brentwood Bike Co. $4,220 on a note left for collection. The face of the note was $3,900.
- A check for $270 returned with the statement had been incorrectly charged by the bank as $720.
- A check for $850 returned with the statement had been recorded by Brentwood Bike Co. as $580. The check was for the payment of an obligation to Adkins Co. on account.
- Bank service charges for May amounted to $40.
- A check for $970 from Jennings Co. was returned by the bank because of insufficient funds.
Instructions:
1. Prepare a bank reconciliation as of May 31.
Brentwood Bike Co. | ||
Bank Reconciliation | ||
May 31 | ||
Cash balance according to bank statement | $22030 | |
Add deposit of May 31, not recorded by bank | $7990 | |
Add bank error in charging check as $720 instead of $270 | 450 | 8440 |
$30470 | ||
Deduct outstanding checks | (9810) | |
Adjusted balance | $20660 | |
Cash balance according to company's records | $17720 | |
Add note and interest collected by bank | 4220 | |
$21940 | ||
Deduct check returned because of insufficient funds | $970 | |
Deduct bank service charges | 40 | |
Deduct bank error in charging check as $720 instead of $270 | 450 | 1460 |
Adjusted balance | $20480 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started