Bank reconciliation
The following data were accumulated for use in reconciling the bank account of Creative Design Co for August Y:
Cash balance according to the company's records at August $
Cash balance according to the bank statement at August $
Checks outstanding, $
Deposit in transit not recorded by bank, $
A check for $ in payment of an account was erroneously recorded in the check register as $
Bank debit memo for service charges, $
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
Creative Design Co
Bank Reconciliation
August
Cash balance according to bank statement
Adjusted balance
Previous
