The cash account for Brentwood Bike Co. at May 1 indicated a balance of $13,360. During May, the total cash deposited was $67,250 and checks written totaled $62,440. The bank statement indicated a balance of $22,800 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 $10,150. A deposit of $8,270, 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,370 on a note left for collection. The face of the note was $4,040. A check for $580 returned with the statement had been incorrectly charged by the bank as $850. 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 $70. A check for $1,010 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 $ Add deposit of May 31, not recorded by bank $ Add bank error in charging check as $850 instead of $580 $ Deduct outstanding checks Adjusted balance $ Cash balance according to company's records $ Add note and interest collected by bank $ Deduct check returned because of insufficient funds $ Deduct bank service charges Deduct error in recording check Adjusted balance
The cash account for Brentwood Bike Co. at May 1 indicated a balance of $13,360. During May, the total cash deposited was $67,250 and checks written totaled $62,440. The bank statement indicated a balance of $22,800 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 $10,150. A deposit of $8,270, 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,370 on a note left for collection. The face of the note was $4,040. A check for $580 returned with the statement had been incorrectly charged by the bank as $850. 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 $70. A check for $1,010 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 $ Add deposit of May 31, not recorded by bank $ Add bank error in charging check as $850 instead of $580 $ Deduct outstanding checks Adjusted balance $ Cash balance according to company's records $ Add note and interest collected by bank $ Deduct check returned because of insufficient funds $ Deduct bank service charges Deduct error in recording check Adjusted balance
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
The cash account for Brentwood Bike Co. at May 1 indicated a balance of $13,360. During May, the total cash deposited was $67,250 and checks written totaled $62,440. The bank statement indicated a balance of $22,800 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 $10,150.
- A deposit of $8,270, 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,370 on a note left for collection. The face of the note was $4,040.
- A check for $580 returned with the statement had been incorrectly charged by the bank as $850.
- 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 $70.
- A check for $1,010 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 | $ | |
Add deposit of May 31, not recorded by bank | $ | |
Add bank error in charging check as $850 instead of $580 | ||
$ | ||
Deduct outstanding checks | ||
Adjusted balance | $ | |
Cash balance according to company's records | $ | |
Add note and interest collected by bank | ||
$ | ||
Deduct check returned because of insufficient funds | $ | |
Deduct bank service charges | ||
Deduct error in recording check | ||
Adjusted balance |
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education