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

Cash balance accBank 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,$ $$16,030.$

Cash balance according to the bank statement at August $31,$ $$16,970.$

Checks outstanding, $$3,250.$

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

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

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

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