4. Prepare a bank reconciliation like Exhibit 6.7 in your textbook (page 281)

The following data were accumulated for use in reconciling the bank account of Maplewood Co. for July:

1. Cash balance according to the companys records at July 31, $15,600.

2. Cash balance according to the bank statement at July 31, $16,230.

3. Checks outstanding, $3,180.

4. Deposit in transit, not recorded by bank, $2,950.

5. A check for $270 in payment of an account was erroneously recorded on the books as $720.

6. Bank debit memo for service charges, $50.