The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company's records at August 31, $22,840. Cash balance according to the bank statement at August 31, $24,240. Checks outstanding, $4,640. Deposit in transit, not recorded by bank, $3,720. A check for $170 in payment of an account was erroneously recorded in the check register as $710. Bank debit memo for service charges, $60. a.  Prepare a bank reconciliation, using the format shown in Exhibit 13. Creative Design Co. Bank Reconciliation August 31, 20Y6 Cash balance according to bank statement   $fill in the blank 0bcdbe01704cf97_1     fill in the blank 0bcdbe01704cf97_3     fill in the blank 0bcdbe01704cf97_5 Adjusted balance   $fill in the blank 0bcdbe01704cf97_6 Cash balance according to company's records   $fill in the blank 0bcdbe01704cf97_7     fill in the blank 0bcdbe01704cf97_9     fill in the blank 0bcdbe01704cf97_11 Adjusted balance   $fill in the blank 0bcdbe01704cf97_12   b.  If the balance sheet were prepared for Creative Design Co. on August 31, what amount should be reported for cash? $fill in the blank 0f2ec3fd1f8a00b_1 c.  Must a bank reconciliation always balance (reconcile)?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Bank Reconciliation

The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6:

  1. Cash balance according to the company's records at August 31, $22,840.
  2. Cash balance according to the bank statement at August 31, $24,240.
  3. Checks outstanding, $4,640.
  4. Deposit in transit, not recorded by bank, $3,720.
  5. A check for $170 in payment of an account was erroneously recorded in the check register as $710.
  6. Bank debit memo for service charges, $60.

a.  Prepare a bank reconciliation, using the format shown in Exhibit 13.

Creative Design Co.
Bank Reconciliation
August 31, 20Y6
Cash balance according to bank statement   $fill in the blank 0bcdbe01704cf97_1
    fill in the blank 0bcdbe01704cf97_3
    fill in the blank 0bcdbe01704cf97_5
Adjusted balance   $fill in the blank 0bcdbe01704cf97_6
Cash balance according to company's records   $fill in the blank 0bcdbe01704cf97_7
    fill in the blank 0bcdbe01704cf97_9
    fill in the blank 0bcdbe01704cf97_11
Adjusted balance   $fill in the blank 0bcdbe01704cf97_12
 

b.  If the balance sheet were prepared for Creative Design Co. on August 31, what amount should be reported for cash?
$fill in the blank 0f2ec3fd1f8a00b_1

c.  Must a bank reconciliation always balance (reconcile)?
 

 
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education