Bank reconciliation

The following data were accumulated for use in reconciling the bank account of Creative Design Co$.$ for August $20$Y$6$:

Cash balance according to the company's records at August $31,$$$17,560.$

Cash balance according to the bank statement at August $31,$$$18,570.$

Checks outstanding, $$3,560.$

Deposit in transit not recorded by bank, $$2,860.$

A check for $$480$ in payment of an account was erroneously recorded in the check register as $$840.$

Bank debit memo for service charges, $$50.$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

a$.$ Prepare a bank reconciliation, using the format shown in Exhibit $13.$

Creative Design Co$.$

Bank Reconciliation

August $31,20Y6$

Cash balance according to bank statement

$

Adiucted halance

$$