Number and amount of each check issued in July: Check No. Amount Check No. Amount Check No. Amount 614 $243.50 621 $309.50 628 $ 837.70 615 350.10 622 Void 629 329.90 616 279.90 623 Void 630 882.80 617 395.50 624 707.01 631 1,081.56 618 435.40 625 158.63 632 325.40 619 320.10 626 550.03 633 310.08 620 238.87 627 381.73 634 241.71 Total amount of checks issued in July $8,379.42

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter6: Investing And Financing Activities
Section: Chapter Questions
Problem 4.9C
icon
Related questions
Question

Bank reconciliation and entries

Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours.The data required to reconcile the bank statement as of July 31, 20Y0, have been taken from various documents and records and are reproduced as follows.The sources of the data are printed in capital letters. All checks were written for payments on account.

CASH ACCOUNT:  
Balance as of July 1 $9,578.00
CASH RECEIPTS FOR MONTH OF JULY  6,465.42
DUPLICATE DEPOSIT TICKETS:  

Date and amount of each deposit in July:

Date Amount  Date Amount Date Amount
July 2 $569.50 July 12 $580.70 July 23 $713.45
       5 701.80         16 600.10       26 601.50
      9 819.24         19 701.26        31 1,777.87

CHECKS WRITTEN:

Number and amount of each check issued in July:

 

BANK RECONCILIATION FOR PRECEDING MONTH:

Sunshine Interiors 

Bank Reconciliation 

June 30,20Y0

Cash balance according to bank statement   $9,422.80
Adjustments:    
Deposit of June 30 not recorded by bank $780.80  
Outstanding Check No. 580 (310.10)  
Outstanding Check No.602 (85.50)  
Outstanding Check No.612 (92.50)  
Outstanding Check No.613 (137.50)  
Total adjustments   155.20
Adjusted balance    $9,578.00
Cash balance according to company's records   $9,605.70
Adjustments:    
Bank service charges    (27.70)
Adjusted balance    $9,578.00

Instructions

1. Prepare a bank reconciliation as of July 31,20Y0.If errors recording deposits or checks are discovered, assume that the errors were made by the company.

Assume that all deposits are from cash sales.All checks are written to satisfy accounts payable.

2. Journalize the necessary entries.

3. What is the amount of cash that should appear on the balance sheet as of July 31, 20Y0?

4. Assume that a canceled check for $180 has been incorrectly recorded by the bank as $1,800.Briefly explain how the error would be included in a bank reconciliation and how it should be corre

Number and amount of each check issued in July:
Check No.
Amount
Check No.
Amount
Check No.
Amount
614
$243.50
621
$309.50
628
$ 837.70
615
350.10
622
Void
629
329.90
616
279.90
623
Void
630
882.80
617
395.50
624
707.01
631
1,081.56
618
435.40
625
158.63
632
325.40
619
320.10
626
550.03
633
310.08
620
238.87
627
381.73
634
241.71
Total amount of checks issued in July
$8,379.42
Transcribed Image Text:Number and amount of each check issued in July: Check No. Amount Check No. Amount Check No. Amount 614 $243.50 621 $309.50 628 $ 837.70 615 350.10 622 Void 629 329.90 616 279.90 623 Void 630 882.80 617 395.50 624 707.01 631 1,081.56 618 435.40 625 158.63 632 325.40 619 320.10 626 550.03 633 310.08 620 238.87 627 381.73 634 241.71 Total amount of checks issued in July $8,379.42
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 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
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
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
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 General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
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