The bank reconciliation prepared by Gatz Company on May $31,2023,$ appeared as follows:

GATZ COMPANY

Bank Reconciliation

May $31,2023$

Bank statement balance $ $8,564\mathrm{.}35$ Book balance $ $17,959\mathrm{.}00$

Add:

Deposit of May $31$ in transit $879\mathrm{.}00$

$ $9,443\mathrm{.}35$

Deduct: Deduct:

Outstanding cheques: NSF cheque plus service charge $ $10,655\mathrm{.}65$

#$876$ $ $587\mathrm{.}00$

#$8821,611\mathrm{.}002,198\mathrm{.}00$ Bank service charge $58\mathrm{.}0010,713\mathrm{.}65$

Adjusted bank balance $ $7,245\mathrm{.}35$ Adjusted book balance $ $7,245\mathrm{.}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

$2023$

May $31$ Balance $7,245\mathrm{.}35$

June $1$ Cheque #$883$ GJ$161,826\mathrm{.}005,419\mathrm{.}35$

$1$ Cheque #$884$ GJ$16107\mathrm{.}005,312\mathrm{.}35$

$3$ Cheque #$885$ GJ$16618\mathrm{.}004,694\mathrm{.}35$

$4$ Cheque #$886$ GJ$161,917\mathrm{.}002,777\mathrm{.}35$

$9$ Deposit GJ$164,530\mathrm{.}007,307\mathrm{.}35$

$12$ Cheque #$887$ GJ$16425\mathrm{.}156,882\mathrm{.}20$

$12$ Cheque #$888$ GJ$163,103\mathrm{.}003,779\mathrm{.}20$

$12$ Cheque #$889$ GJ$16929\mathrm{.}002,850\mathrm{.}20$

$18$ Deposit GJ$163,830\mathrm{.}006,680\mathrm{.}20$

$20$ Cheque #$890$ GJ$162,516\mathrm{.}004,164\mathrm{.}20$

$21$ Cheque #$891$ GJ$161,406\mathrm{.}242,757\mathrm{.}96$

$24$ Cheque #$892$ GJ$162,471\mathrm{.}00286\mathrm{.}96$

$26$ Cheque #$893$ GJ$1671\mathrm{.}00215\mathrm{.}96$

$29$ Deposit GJ$161,724\mathrm{.}001,939\mathrm{.}96$

The following bank statement is available for June:

Bank Statement

To: Gatz Company June $30,2023$

Bank of Montreal

Cheques$/$Charges Deposits$/$Credits Balance

$05/318,564\mathrm{.}35$

#$88406/01107\mathrm{.}0006/01879\mathrm{.}009,336\mathrm{.}35$

#$88306/041,826\mathrm{.}007,510\mathrm{.}35$

#$87606/09587\mathrm{.}0006/094,530\mathrm{.}0011,453\mathrm{.}35$

#$88906/12929\mathrm{.}0010,524\mathrm{.}35$

#$88206/141,611\mathrm{.}008,913\mathrm{.}35$

#$88706/18245\mathrm{.}1506/183,830\mathrm{.}0012,498\mathrm{.}20$

#$88506/20618\mathrm{.}0011,880\mathrm{.}20$

#$89106/211,046\mathrm{.}2410,833\mathrm{.}96$

#$88606/291,917\mathrm{.}008,916\mathrm{.}96$

SC $06/3072\mathrm{.}0006/308,844\mathrm{.}96$

NSF $=$ Not Sufficient

Funds SC $=$ Service

Charge PMT $=$ Principal Payment INT $=$ Interest

Required:

a$.$ Prepare a bank reconciliation at June $30,2023.$ 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.$)$

b$.$ Prepare the necessary entries resulting from the bank reconciliation.