The bank reconciliation prepared by Gatz Company on May 31, 2020, appeared as follows: GATZ COMPANY Bank Reconciliation $ 9,364.35 May 31, 2020 Book balance Bank statement balance $19,639.00 Add: Deposit of May 31 in transit 959.00 $10,323.35 Deduct: Deduct: NSF cheque plus service charge $11,655.65 Outstanding cheques: #876 #882 2$ 643.00 1,763.00 2,406.00 Bank service charge 66.00 11,721.65 Adjusted bank balance $ 7,917.35 Adjusted book balance $ 7,917.35 The Cash account in the General Ledger appeared as follows on June 30 (Gatz uses only a General Journal to record transactions): Acct. No. Cash 101 Date Explanation PR Debit Credit Balance 2020 May 31 Balance June 1 Cheque #883 1 Cheque #884 3 Cheque #885 4 Cheque #886 9 Deposit 12 Cheque #887 12 Cheque #888 12 Cheque #889 18 Deposit 20 Cheque #890 21 Cheque #891 24 Cheque #892 26 Cheque #893 29 Deposit 7,917.35 1,850.00 6,067.35 107.00 5,960.35 618.00 5,342.35 1,917.00 3,425.35 8,011.35 425.15 7,586.20 3,143.00 4,443.20 937.00 3,506.20 7,392.20 2,540.00 4,852.20 1,406.24 3,445.96 950.96 GJ16 GJ16 GJ16 GJ16 GJ16 4,586.00 GJ16 GJ16 GJ16 GJ16 3,886.00 GJ16 GJ16 GJ16 2,495.00 GJ16 71.00 879.96 GJ16 1,748.00 2,627.96

Financial And Managerial Accounting
15th Edition
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:WARREN, Carl S.
Chapter7: Internal Control And Cash
Section: Chapter Questions
Problem 21E
icon
Related questions
Question
The bank reconciliation prepared by Gatz Company on May 31, 2020, appeared as follows:
GATZ COMPANY
Bank Reconciliation
May 31, 2020
Bank statement balance
$ 9,364.35
Book balance
$19,639.00
Add:
Deposit of May 31 in transit
959.00
$10,323.35
Deduct:
Deduct:
Outstanding cheques:
NSF cheque plus service charge
$11,655.65
#876
643.00
#882
1,763.00
2,406.00
Bank service charge
66.00
11,721.65
Adjusted bank balance
$ 7,917.35
Adjusted book balance
$ 7,917.35
The Cash account in the General Ledger appeared as follows on June 30 (Gatz uses only a General Journal to record transactions):
Acct. No.
Cash
101
Date
Explanation
PR
Debit
Credit
Balance
2020
May 31 Balance
June 1 Cheque #883
1 Cheque #884
3 Cheque #885
4 Cheque #886
9 Deposit
12 Cheque #887
7,917.35
1,850.00 6,067.35
107.00 5,960.35
618.00 5, 342.35
GJ16
GJ16
GJ16
GJ16
1,917.00 3,425.35
8,011.35
425.15 7,586.20
3,143.00 4,443.20
937.00 3,506.20
7,392.20
2,540.00 4,852.20
1,406.24 3,445.96
950.96
GJ16
4,586.00
GJ16
12 Cheque #888
12 Cheque #889
18 Deposit
20 Cheque #890
21 Cheque #891
24 Cheque #892
26 Cheque #893
29 Deposit
GJ16
GJ16
GJ16
3,886.00
GJ16
GJ16
GJ16
2,495.00
GJ16
71.00
879.96
GJ16
1,748.00
2,627.96
Transcribed Image Text:The bank reconciliation prepared by Gatz Company on May 31, 2020, appeared as follows: GATZ COMPANY Bank Reconciliation May 31, 2020 Bank statement balance $ 9,364.35 Book balance $19,639.00 Add: Deposit of May 31 in transit 959.00 $10,323.35 Deduct: Deduct: Outstanding cheques: NSF cheque plus service charge $11,655.65 #876 643.00 #882 1,763.00 2,406.00 Bank service charge 66.00 11,721.65 Adjusted bank balance $ 7,917.35 Adjusted book balance $ 7,917.35 The Cash account in the General Ledger appeared as follows on June 30 (Gatz uses only a General Journal to record transactions): Acct. No. Cash 101 Date Explanation PR Debit Credit Balance 2020 May 31 Balance June 1 Cheque #883 1 Cheque #884 3 Cheque #885 4 Cheque #886 9 Deposit 12 Cheque #887 7,917.35 1,850.00 6,067.35 107.00 5,960.35 618.00 5, 342.35 GJ16 GJ16 GJ16 GJ16 1,917.00 3,425.35 8,011.35 425.15 7,586.20 3,143.00 4,443.20 937.00 3,506.20 7,392.20 2,540.00 4,852.20 1,406.24 3,445.96 950.96 GJ16 4,586.00 GJ16 12 Cheque #888 12 Cheque #889 18 Deposit 20 Cheque #890 21 Cheque #891 24 Cheque #892 26 Cheque #893 29 Deposit GJ16 GJ16 GJ16 3,886.00 GJ16 GJ16 GJ16 2,495.00 GJ16 71.00 879.96 GJ16 1,748.00 2,627.96
The following bank statement is available for June:
Bank Statement
June 30, 2020
Bank of Montreal
To: Gatz Company
Deposits/Credits
05/31
06/01
Cheques/Charges
Balance
9,364.35
10,216.35
8,366.35
12,309.35
11,372.35
9,609.35
13,250.20
12,632.20
11,585.96
9,668.96
9,596.96
06/01
06/04
06/09
#884
107.00
959.00
#883
1,850.00
643.00
#876
06/09
4,586.00
#889
06/12
937.00
#882
06/14
1,763.00
06/18
06/20
06/21
06/29
06/30
#887
245.15
06/18
3,886.00
#885
618.00
1,046.24
1,917.00
#891
#886
06/30
PMT = Principal
SC
72.00
SC = Service
Charge
NSF = Not Sufficient
INT = Interest
Funds
Payment
Required:
a. Prepare a bank reconciliation at June 30, 2020. Assume that any errors made were by the bookkeeper (cheque #887 was for office
supplies; cheque #891 was for utilities expense). (Round your answers to 2 decimal places.)
Transcribed Image Text:The following bank statement is available for June: Bank Statement June 30, 2020 Bank of Montreal To: Gatz Company Deposits/Credits 05/31 06/01 Cheques/Charges Balance 9,364.35 10,216.35 8,366.35 12,309.35 11,372.35 9,609.35 13,250.20 12,632.20 11,585.96 9,668.96 9,596.96 06/01 06/04 06/09 #884 107.00 959.00 #883 1,850.00 643.00 #876 06/09 4,586.00 #889 06/12 937.00 #882 06/14 1,763.00 06/18 06/20 06/21 06/29 06/30 #887 245.15 06/18 3,886.00 #885 618.00 1,046.24 1,917.00 #891 #886 06/30 PMT = Principal SC 72.00 SC = Service Charge NSF = Not Sufficient INT = Interest Funds Payment Required: a. Prepare a bank reconciliation at June 30, 2020. Assume that any errors made were by the bookkeeper (cheque #887 was for office supplies; cheque #891 was for utilities expense). (Round your answers to 2 decimal places.)
Expert 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
Recommended textbooks for you
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
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
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning