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 ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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 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