Required information

$[$The following information applies to the questions displayed below.$]$

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 $$24,773$ debit balance, but its July bank statement shows a $$27,481$ cash balance.

b$.$ Check Number $3031$ for $$1,650,$ Check Number $3065$ for $$601,$ and Check Number $3069$ for $$2,418$ are outstanding checks as of July $31.$

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

d$.$ The July bank statement shows the bank collected $$9,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 $$14$ 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 $$10,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$],[\backslash$table$[[$Bank Reconciliation$],[$July $31]]],[$July $31],[$Bank statement balance,,Book balance,,$],[$Add:$,,$Add:$],[$Deposit of July $31,,$Proceeds from note,,$],[,0,$B$,,0],[,0,,,0],[$Deduct:$,,$Deduct:$],[$Check Number $3031,,$Service charge,,$],[$Check Number $3065,,$Error $($Check $3056),,],[$Check Number $3069,,$NSF check,,$],[,0,,,0],[$Adjusted bank balance,$$,$Adjusted book balance,$$,0]$