I am trying to solve an accounting problem in Sage$50.$ I am trying to do bank reconciliation$\mathrm{.}3$ Set up the linking accounts for the Reconciliation & Deposits Journal for May $31$ to June $30.$

$4$ Record the manual Cash Receipts Journal $($containing bank account entries$)$ as indicated next.

Cheque Invoice Deposit

Date Customer # # Amount Reason$/$Item

Jun $01$ Cotta Dairy Farm $2461210$ $$450\mathrm{.}00$ Invoice in Receivable

Jun $04$ Debly's Dept Store $1416198520\mathrm{.}00$ Invoice in Receivable

Jun $07$ Villa Golf Course Ltd$.1976202273\mathrm{.}00$ Invoice in Receivable

Jun $14$ Chalmers Industrial $689211238\mathrm{.}43$ SR $$211\mathrm{.}00$ plus HST

Jun $15$ Cotta Dairy Farm $2497212211\mathrm{.}88$ SR $$187\mathrm{.}50$ plus HST

Jun $21$ Cotta Dairy Farm $2536213126\mathrm{.}56$ SR $$112\mathrm{.}00$ plus HST

Jun $22$ Villa Golf Course Ltd$.2016214259\mathrm{.}90$ SR $$230\mathrm{.}00$ plus HST

Jun $29$ Chalmers Industrial $712215177\mathrm{.}86$ SR $$157\mathrm{.}40$ plus HST

$5$ Record the manual Cash Disbursements Journal $($containing bank account entries$)$ as indicated next.

Cheque Invoice

Date Vendor # # Amount Reason

Jun $01$ Brigs Engine Supplies $6079653$ $$850\mathrm{.}00$ Invoice in Payable

Jun $04$ Danco Parts Ltd$.60898712320\mathrm{.}00$ Invoice in Payable

Jun $08$ Jason Tools Ltd$.6094152135\mathrm{.}60$ Small tools $$120\mathrm{.}00$ plus HST

Jun $08$ Peel County Telephone $610$ May$/$Tel $254\mathrm{.}25$ Telephone $$225\mathrm{.}00$ plus HST

Jun $11$ Caledon Gas Company $611$ May$/$Gas $361\mathrm{.}60$ May$/$Gas $$320\mathrm{.}00$ plus HST

Jun $13$ A$-1$ Properties Inc. $612$ Jun Rent $700\mathrm{.}60$ Rent $$620\mathrm{.}00$ plus HST

Jun $15$ Office Place Ltd$.6131456890\mathrm{.}40$ Supplies Exp $$80\mathrm{.}00$ plus HST

Jun $18$ Brigs Engine Supplies $6149701237\mathrm{.}30$ Small Tools $$210\mathrm{.}00$ plus HST

Jun $25$ Danco Parts Ltd$.61598879179\mathrm{.}22$ Small Tools $$158\mathrm{.}60$ plus HST

$6$ Advance the date to June $30$ and complete the June $30$th bank reconciliation. Prepare and post journal entries as required. Relevant information is presented below.

a$)$ May $31$ bank reconciliation.

The bank reconciliation at May $31,2023$ is as follows:

Balance per Bank Statement May $31,2023$ $$4,238\mathrm{.}75$

Add:

Outstanding Deposit May $31415\mathrm{.}00$

Sub$-$total $$4,653\mathrm{.}75$

Less:

Outstanding cheques #$598$ $$312\mathrm{.}00$

#$604$ $$211\mathrm{.}86$ $ $523\mathrm{.}86$

Balance per Bank Account and General Ledger May $31,2023$ $$4,129\mathrm{.}89$

b$)$ June $30$ bank statement as follows:

CB

Commercial Bank

$51$ Centennial Road, Orangeville, Ontario L$9$W $3$R$1$

Engine Repairs Ltd$.$

$568$ Northgate Drive

Orangeville, Ontario

L$9$W $2$J$5$

STATEMENT OF ACCOUNT

$0225-315544$

Date: June $1$ June $30,2023$

DATE DESCRIPTION WITHDRAWALS DEPOSITS BALANCE

Jun $1$

Jun $1$

Jun $1$

Jun $1$

Jun $6$

Jun $6$

Jun $6$

Jun $8$

Jun $11$

Jun $11$

Jun $13$

Jun $14$

Jun $14$

Jun $15$

Jun $18$

Jun $18$

Jun $22$

Jun $22$

Jun $27$

Jun $27$

Jun $29$

Jun $29$

Balance forward

Deposit

Cheque $604$

Deposit

Deposit

Cheque $607$

Cheque $608$

Deposit

Cheque $609$

Cheque $610$

Cheque $611$

Deposit

Cheque $612$

Deposit

Cheque $613$

Cheque $614$

Deposit

Deposit

Cheque $615$

Cheque NSF

Service Charge

Loan Payment$/$Interest

$211\mathrm{.}86$

$850\mathrm{.}00$

$320\mathrm{.}00$

$135\mathrm{.}60$

$254\mathrm{.}25$

$361\mathrm{.}60$

$700\mathrm{.}60$

$90\mathrm{.}40$

$237\mathrm{.}30$

$179\mathrm{.}22$

$259\mathrm{.}90$

$11\mathrm{.}80$

$300\mathrm{.}00$

$415\mathrm{.}00$

$450\mathrm{.}00$

$520\mathrm{.}00$

$273\mathrm{.}00$

$238\mathrm{.}43$

$211\mathrm{.}88$

$126\mathrm{.}56$

$259\mathrm{.}90$

$4,238\mathrm{.}75$

$4,653\mathrm{.}75$

$4,441\mathrm{.}89$

$4,891\mathrm{.}89$

$5,411\mathrm{.}89$

$4,561\mathrm{.}89$

$4,241\mathrm{.}89$

$4,514\mathrm{.}89$

$4,379\mathrm{.}29$

$4,125\mathrm{.}04$

$3,763\mathrm{.}44$

$4,001\mathrm{.}87$

$3,301\mathrm{.}27$

$3,513\mathrm{.}15$

$3,422\mathrm{.}75$

$3,185\mathrm{.}45$

$3,312\mathrm{.}01$

$3,571\mathrm{.}91$

$3,392\mathrm{.}69$

$3,132\mathrm{.}79$

$3,120\mathrm{.}99$

$2,820\mathrm{.}99$

c$)$ Additional Information provided.

$$ The bank does not charge the firm for processing a customer's NSF cheque.

$$ The June $29$ Loan Payment$/$Interest deduction is for the Bank Loan Payable account. Interest of $$38\mathrm{.}00$ is included in the $$300\mathrm{.}00$ payment. Note: Don$$t forget to create a journal entry for the loan principal portion.

$7$ Print the following reports:

a$)$ Account Reconciliation Transaction Report.

b$)$ All Journal Entries for June, no corrections.

c$)$ General Journal Entries for June, no corrections.

d$)$ Income Statement, year$-$to$-$date.

e$)$ Trial Balance

To complete the Bank Reconciliation at June $30,$ the $3$ outstanding items $(1$ deposit and $2($cheques$)$ need to be Inserted as Outstanding items, as shown next.