Question
The bank reconciliation prepared by Gatz Company on May 31, 2017, appeared as follows: GATZ COMPANY Bank Reconciliation May 31, 2017 Bank statement balance $9,364.35
The bank reconciliation prepared by Gatz Company on May 31, 2017, appeared as follows:
GATZ COMPANY | |||||
Bank Reconciliation | |||||
May 31, 2017 | |||||
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 | ||||
#876 | $643.00 | charge | $11,655.65 | ||
#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):
Cash | Acct. No. 101 | ||||
Date | Explanation | PR | Debit | Credit | Balance |
2017 | |||||
May 31 | Balance | 7,917.35 | |||
June 1 | Cheque #883 | GJ16 | 1,850.00 | 6,067.35 | |
1 | Cheque #884 | GJ16 | 107.00 | 5,960.35 | |
3 | Cheque #885 | GJ16 | 618.00 | 5,342.35 | |
4 | Cheque #886 | GJ16 | 1,917.00 | 3,425.35 | |
9 | Deposit | GJ16 | 4,586.00 | 8,011.35 | |
12 | Cheque #887 | GJ16 | 425.15 | 7,586.20 | |
12 | Cheque #888 | GJ16 | 3,143.00 | 4,443.20 | |
12 | Cheque #889 | GJ16 | 937.00 | 3,506.20 | |
18 | Deposit | GJ16 | 3,886.00 | 7,392.20 | |
20 | Cheque #890 | GJ16 | 2,540.00 | 4,852.20 | |
21 | Cheque #891 | GJ16 | 1,406.24 | 3,445.96 | |
24 | Cheque #892 | GJ16 | 2,495.00 | 950.96 | |
26 | Cheque #893 | GJ16 | 71.00 | 879.96 | |
29 | Deposit | GJ16 | 1,748.00 | 2,627.96 | |
|
The following bank statement is available for June:
Bank Statement | |||||
To: Gatz Company | June 30, 2017 Bank of Montreal | ||||
Cheques/Charges | Deposits/Credits | Balance | |||
05/31 | 9,364.35 | ||||
#884 | 06/01 | 107.00 | 06/01 | 959.00 | 10,216.35 |
#883 | 06/04 | 1,850.00 | 8,366.35 | ||
#876 | 06/09 | 643.00 | 06/09 | 4,586.00 | 12,309.35 |
#889 | 06/12 | 937.00 | 11,372.35 | ||
#882 | 06/14 | 1,763.00 | 9,609.35 | ||
#887 | 06/18 | 245.15 | 06/18 | 3,886.00 | 13,250.20 |
#885 | 06/20 | 618.00 | 12,632.20 | ||
#891 | 06/21 | 1,046.24 | 11,585.96 | ||
#886 | 06/29 | 1,917.00 | 9,668.96 | ||
SC | 06/30 | 72.00 | 06/30 | 9,596.96 |
NSF = Not Sufficient Funds | SC = Service Charge | PMT = Principal Payment | INT = Interest | ||
|
Required: a. Prepare a bank reconciliation at June 30, 2017. Assume that any errors made were by the book keeper (cheque #887 was for office supplies; cheque #891 was for utilities expense). (Round the final answers to the nearest cent.) b. Prepare the necessary entries resulting from the bank reconciliation. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Round your answers to the nearest cent.)
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