How to Prepare a bank reconciliation for June. Exercise 5-13 The actual cash received from cash sales was $11,279, and the amount indicated by the cash register total was $11,256. a. What is the amount deposited in the bank for the day?s sales? b. What is amount recorded for the day?s sales? c. How should the difference be recorded? d. If a cashier is consistently over or short, what action should be taken? Exercise 5-18 The following data were accumulated for use in reconciling the bank account of Commander Co. for March: a. Cash balance according to the company?s records at March 31, $13,065. b. Cash balance according to the bank statement at March 31, $12,750. c. Checks outstanding, $4,170. d. Deposit in transit, not recorded by bank, $5,100. e. A check for $180 in payment of an account was erroneously recorded in the check register as $810. f. Bank debit memo for service charges, $15. Prepare a bank reconciliation, using the format shown in Exhibit 7.

Exercise 5-13 a. b. c. d. Exercise 5-18 *Note: The two adjusted balances should be equal. Spectrum Co. Bank Reconciliation March 31, 20-- Cash balance according to bank statement Add $Deduct Adjusted Balance $- Cash balance according to company's records Add $Deduct Adjusted Balance $