The bank portion of the bank reconciliation of Sandhill Ltd$.$ at September $30,2023$ was as follows:

Cash Balance per Bank $$5,416$

Add: Deposit in transit $1,192$

Less: Outstanding cheques:

Ch$.$No$.$ Amount

$261428$

$270945$

$2742811,654$

Adjusted cash balance per bank $$4,954$

The adjusted cash balance per bank agreed with the cash balance per books at September $30,2023$ following the recording of any necessary adjustments to the books after reconciling the bank account.

The accounting records for deposits and cheques for the month of October revealed the following details:

Date Deposit Amount Cheque Number Cheque Amount

Oct$\mathrm{.}3$ $ $1,081$ No$\mathrm{.}275$ $ $1,329$

Oct$\mathrm{.}7832$ No$\mathrm{.}2761,066$ Oct$\mathrm{.}12534$ No$\mathrm{.}277138$

Oct$\mathrm{.}15462$ No$\mathrm{.}278760$

Oct$\mathrm{.}19230$ No$\mathrm{.}279494$

Oct$\mathrm{.}21954$ No$\mathrm{.}280855$

Oct$\mathrm{.}23175$ No$\mathrm{.}281256$

Oct$\mathrm{.}251,070$ No$\mathrm{.}282954$

Oct$\mathrm{.}30722$ No$\mathrm{.}283469$

Total $$6,060$ No$\mathrm{.}284222$

Total $$6,543$

The following is a replica of the bank statement for the month of October listing: cheques, deposits, debit and credit memos entered by the bank on its systems.

Cheques & other charges Deposits Date Balance

Reference Amount

Oct$\mathrm{.}1$ $$5,416$

No$\mathrm{.}270$ $$945$ $ $1,192$ Oct. $35,663$

$1,081$ Oct. $56\mathrm{.}744$ No$\mathrm{.}274281832$ Oct$\mathrm{.}87,295$

No$\mathrm{.}2761,066541$ Oct. $136,770$

No$\mathrm{.}2751,329462$ Oct$\mathrm{.}175,903$

No$\mathrm{.}277138230$ Oct$\mathrm{.}205,995$

No$\mathrm{.}279718954$ Oct$\mathrm{.}226,231$

No$\mathrm{.}2812561,070$ Oct$\mathrm{.}247,045$

No$\mathrm{.}280855175$ Oct$\mathrm{.}276,365$

No$\mathrm{.}283469$ EFT $414$ Oct$\mathrm{.}296,310$

NSF $182$ Oct. $306,128$

S$/$C $56$ Oct$\mathrm{.}316,072$

Totals $$6,295$ $$6,951$

The following footnote notations also appeared on the bank statement as explanations.

NSF$=$Non$-$sufficient funds

S$/$C $=$ Monthly back service charges

EFT$=($Electronic Funds Transfer$)$ Represents collection of a note receivable which includes $$44$ of interest. The interest had not been previously accrued. Additional information:

$1.$ There are no bank errors.

$2$

Any correction of errors $($on book errors$)$ relative to cheques written should be corrected to accounts payable.All deposits are the result of collections on accounts from customers.

Calculate the unadjusted balance per books at October $31,2023$ based on the information provided.

Balance per books at October $31,2023$ Prepare, the bank reconciliation of Sandhill for the month of October $2023.($List items that increase balance as per bank and books first.$)$

SANDHILL Ltd$.$ Bank Reconciliation

$ $

eTextbook and Media

Prepare any necessary journal entries required after performing part b$.($Credit account titles are automatically indented when the amount is entered. Do not indent manually. List all debit entries before credit entries. lf no entry is required, select $"$No Entry" for the account titles and enter $0$ for the amounts.$)$

Account Titles and Explanation Debit Credit

$($To record collection of note and interest$)($To correct for deposit of October $12)$

$($To record bank service charges$)$

$($To record NSF cheque$)$

$($To correct error on cheque $279)$