Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

  1. Checks outstanding totaled $9,810.
  2. A deposit of $7,990, representing receipts of May 31, had been made too late to appear on the bank statement.
  3. The bank had collected for Brentwood Bike Co. $4,220 on a note left for collection. The face of the note was $3,900.
  4. A check for $270 returned with the statement had been incorrectly charged by the bank as $720.
  5. 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.
  6. Bank service charges for May amounted to $40.
  7. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit And Accounting Guide Employee Benefit Plans

Authors: American Institute Of Certified Public Accountants

1st Edition

ISBN: 0870515756, 978-0870515750

More Books

Students also viewed these Accounting questions

Question

4. Does cultural aptitude impact ones emotional intelligence?

Answered: 1 week ago