The following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July $31.$

a$.$ On July $31,$ the company's Cash account has a $$25,302$ debit balance, but its July bank statement shows a $$27,790$ cash balance.

b$.$ Check Number $3031$ for $$1,560,$ Check Number $3065$ for $$556,$ and Check Number $3069$ for $$2,328$ are outstanding checks as of July $31.$

c$.$ Check Number $3056$ for July rent expense was correctly written and drawn for $$1,270$ but was erroneously entered in the accounting records as $$1,260.$

d$.$ The July bank statement shows the bank collected $$6,000$ cash on a note for Branch. Branch had not recorded this event before receiving the statement.

e$.$ The bank statement shows an $$805$ NSF check. The check had been received from a customer, Evan Shaw. Branch has not yet recorded this check as NSF$.$

f$.$ The July statement shows a $$9$ bank'service charge. It has not yet been recorded in miscellaneous expenses because no previous notification had been received.

g$.$ Branch's July $31$ daily cash receipts of $$7,132$ were placed in the bank's night depository on that date but do not appear on the July $31$ bank statement.

Required:

Prepare the bank reconciliation for this company as of July $31.$

$\backslash$table$[[$BRANCH COMPANY$],[$Bank Reconciliation$],[$July $31],[$Bank statement balance,,Book balance,$],[$Add$,,$Add:$],[$Deposit of July $31],[,0,$:$.,0],[,0,,0],[$Deduct$.,,$Deduct$],[$NSF check,,Check Number $3031,],[$Service charge,:.,Check Number $3065,],[,$Check Number $3069,],[0,,0],[$Adjusted bank balance,$$,$Adjusted book balance,$