Bank reconciliationThe following data were accumulated for use in reconciling the bank account of Creative Design Co$.$ for August $20$Y$6$:$1.$ Cash balance according to the company's records at August $31,$ $$32,560\mathrm{.}2.$ Cash balance according to the bank statement at August $31,$ $$46,300\mathrm{.}3.$ Checks outstanding, $$28,540\mathrm{.}4.$ Deposit in transit not recorded by bank, $$16,375\mathrm{.}5.$ A check for $$180$ in payment of an account was erroneously recorded in the check register as $$1,800\mathrm{.}6.$ Bank debit memo for service charges, $$45.$a$.$ Prepare a bank reconciliation, using the format shown in Exhibit $13.$Creative Design Co$.$ Bank Reconciliation August $31,2016$