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,$$$26,580.$

Cash balance according to the bank statement at August $31,$$$27,980.$

Checks outstanding, $$5,400.$

Deposit in transit not recorded by bank, $$4,330.$

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

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 bankfeconciliation, using the format shown in Exhibit $13.$

Creative Design Co$.$

Bank Reconciliation

August $31,20Y6$

Cash balance according to bank statement

Adjusted balance

Previous