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 $
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,864.35 | Book balance | $ | 20,685.00 | ||||||||
Add: | |||||||||||||
Deposit of May 31 in transit | 1,012.00 | ||||||||||||
$ | 10,876.35 | ||||||||||||
Deduct: | Deduct: | ||||||||||||
Outstanding cheques: | NSF cheque plus service charge | $ | 12,274.65 | ||||||||||
#876 | $ | 677.00 | |||||||||||
#882 | 1,857.00 | 2,534.00 | Bank service charge | 68.00 | 12,342.65 | ||||||||
Adjusted bank balance | $ | 8,342.35 | Adjusted book balance | $ | 8,342.35 | ||||||||
The Cash account in the General Ledger appeared as follows on June 30 (Gatz uses only a General Journal to record transactions):
Cash | Acct. No. 101 | ||||||||||
Date | Explanation | PR | Debit | Credit | Balance | ||||||
2020 | |||||||||||
May 31 | Balance | 8,342.35 | |||||||||
June 1 | Cheque #883 | GJ16 | 1,876.00 | 6,466.35 | |||||||
1 | Cheque #884 | GJ16 | 112.00 | 6,354.35 | |||||||
3 | Cheque #885 | GJ16 | 647.00 | 5,707.35 | |||||||
4 | Cheque #886 | GJ16 | 2,007.00 | 3,700.35 | |||||||
9 | Deposit | GJ16 | 4,660.00 | 8,360.35 | |||||||
12 | Cheque #887 | GJ16 | 425.15 | 7,935.20 | |||||||
12 | Cheque #888 | GJ16 | 3,192.00 | 4,743.20 | |||||||
12 | Cheque #889 | GJ16 | 952.00 | 3,791.20 | |||||||
18 | Deposit | GJ16 | 3,960.00 | 7,751.20 | |||||||
20 | Cheque #890 | GJ16 | 2,580.00 | 5,171.20 | |||||||
21 | Cheque #891 | GJ16 | 1,406.24 | 3,764.96 | |||||||
24 | Cheque #892 | GJ16 | 2,533.00 | 1,231.96 | |||||||
26 | Cheque #893 | GJ16 | 74.00 | 1,157.96 | |||||||
29 | Deposit | GJ16 | 1,774.00 | 2,931.96 | |||||||
The following bank statement is available for June:
Bank Statement | |||||||||
To: Gatz Company | June 30, 2020 Bank of Montreal | ||||||||
Cheques/Charges | Deposits/Credits | Balance | |||||||
05/31 | 9,864.35 | ||||||||
#884 | 06/01 | 112.00 | 06/01 | 1,012.00 | 10,764.35 | ||||
#883 | 06/04 | 1,876.00 | 8,888.35 | ||||||
#876 | 06/09 | 677.00 | 06/09 | 4,660.00 | 12,871.35 | ||||
#889 | 06/12 | 952.00 | 11,919.35 | ||||||
#882 | 06/14 | 1,857.00 | 10,062.35 | ||||||
#887 | 06/18 | 245.15 | 06/18 | 3,960.00 | 13,777.20 | ||||
#885 | 06/20 | 647.00 | 13,130.20 | ||||||
#891 | 06/21 | 1,046.24 | 12,083.96 | ||||||
#886 | 06/29 | 2,007.00 | 10,076.96 | ||||||
SC | 06/30 | 75.00 | 06/30 | 10,001.96 | |||||
NSF = Not Sufficient Funds | SC = Service Charge | PMT = Principal Payment | INT = Interest | ||||||
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 place b. Prepare the necessary entries resulting from the bank reconciliation.
Record to account for error in Cheque #887.
Record to account for error in Cheque #891.
Record bank service charges for June.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started