Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 2016: 1. Cash balance according to the company's records at August 31, $20,870. 2. Cash balance according to the bank statement at August 31, $37,600. 3. Checks outstanding, $23,375. 4. Deposit in transit not recorded by bank, $7,500. 5. A check for $100 in payment of an account was erroneously recorded in the check register as $1,000. 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, 20Y6 Cash balance according to bank statement Adjustments: 37,000 V Deposit in transit not recorded by bank 7,500 Outstanding checks 21,375 V Total adjustments 15,875 21,725 Adjusted balance Cash balance according to company's records Adjustments: Error in recording check Check My Work 900 Province Next