(Bank Reconciliation and Adjusting Entries) The cash account of Aguilar Co. showed a ledger balance of $3,969.85 on June 30, 2017. The bank statement as of that date showed a balance of $4,150. Upon comparing the statement with the cash records, the following facts were determined.1. There were bank service charges for June of $25.2. A bank memo stated that Bao Dai’s note for $1,200 and interest of $36 had been collected on June 29, and the bank had made a charge of $5.50 on the collection. (No entry had been made on Aguilar’s books when Bao Dai’s note was sent to the bank for collection.)3. Receipts for June 30 for $3,390 were not deposited until July 2.4. Checks outstanding on June 30 totaled $2,136.05.5. The bank had charged the Aguilar Co.’s account for a customer’s uncollectible check amounting to $253.20 on June 29.6. A customer’s check for $90 (as payment on the customer’s Accounts Receivable) had been entered as $60 in the cash receipts journal by Aguilar on June 15.7. Check no. 742 in the amount of $491 had been entered in the cash journal as $419, and check no. 747 in the amount of $58.20 had been entered as $582. Both checks had been issued to pay for purchases and were payments on Aguilar’s Accounts Payable.Instructions(a) Prepare a bank reconciliation dated June 30, 2017, proceeding to a correct cash balance.(b) Prepare any entries necessary to make the books correct and complete.

College Accounting (Book Only): A Career Approach
13th Edition
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:Scott, Cathy J.
Chapter6: Bank Accounts, Cash Funds, And Internal Controls
Section: Chapter Questions
Problem 5E
icon
Related questions
Question

(Bank Reconciliation and Adjusting Entries) The cash account of Aguilar Co. showed a ledger balance of $3,969.85 on June 30, 2017. The bank statement as of that date showed a balance of $4,150. Upon comparing the statement with the cash records, the following facts were determined.
1. There were bank service charges for June of $25.
2. A bank memo stated that Bao Dai’s note for $1,200 and interest of $36 had been collected on June 29, and the bank had made a charge of $5.50 on the collection. (No entry had been made on Aguilar’s books when Bao Dai’s note was sent to the bank for collection.)
3. Receipts for June 30 for $3,390 were not deposited until July 2.
4. Checks outstanding on June 30 totaled $2,136.05.
5. The bank had charged the Aguilar Co.’s account for a customer’s uncollectible check amounting to $253.20 on June 29.
6. A customer’s check for $90 (as payment on the customer’s Accounts Receivable) had been entered as $60 in the cash receipts journal by Aguilar on June 15.
7. Check no. 742 in the amount of $491 had been entered in the cash journal as $419, and check no. 747 in the amount of $58.20 had been entered as $582. Both checks had been issued to pay for purchases and were payments on Aguilar’s Accounts Payable.
Instructions
(a) Prepare a bank reconciliation dated June 30, 2017, proceeding to a correct cash balance.
(b) Prepare any entries necessary to make the books correct and complete.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Bank reconciliation statement
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
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,