llowing 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,$ $$22,590.$

Cash balance according to the bank statement at August $31,$ $$23,830.$

Checks outstanding, $$4,590.$

Deposit in transit not recorded by bank, $$3,680.$

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

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

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.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,$$$22,590.$

Cash balance according to the bank statement at August $31,$ $$23,830.$

Checks outstanding, $$4,590.$

Deposit in transit not recorded by bank, $$3,680.$

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

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

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$

b$.$ If the balance sheet were prepared for Creative Design Co$.$ on August $31,$ what amount should be reported for cash?