Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Audit Practice From A To Z

Authors: Patrick Onwura Nzechukwu

1st Edition

149874205X, 978-1498742054

More Books

Students also viewed these Accounting questions