Prepare a bank reconciliation as of July 31,

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 5PA
icon
Related questions
Question

The Quilt Shop deposits all receipts in the bank each evening and makes all payments by check. On July 31, its ledger balance of cash is $2,830.15. The bank statement balance of cash as of July 31 is $3,215.20. Use the following information to reconcile the bank statement:

  1. The reconciliation for June, the previous month, showed three checks outstanding on June 30: no. 1820 for $85.00, no. 1822 for $115.20, and no. 1823 for $120.00. Check no. 1820 and no. 1822 were returned with the July bank statement; however, check no. 1823 was not returned.
  2. Check no. 2500 for $255.00, no. 2517 for $332.00, no. 2518 for $115.00, and no. 2519 for $28.85 were written during July and have not been returned by the bank.
  3. A deposit of $446.80 was placed in the night depository on July 31 and did not appear on the bank statement.
  4. The canceled checks were compared with the entries in the checkbook, and it was observed that check no. 2587, for $26, was written correctly, payable to J. L. Lang, the owner, for personal use, but was recorded in the checkbook as $62.
  5. Included in the bank statement was a bank debit memo for service charges, $25.
  6. Included in the bank statement was an NSF check from Jeremy Jones in the amount of $30.

Required:

1. Prepare a bank reconciliation as of July 31, assuming that the debit memo and NSF check have not been recorded.

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
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,