The following data were accumulated for use in reconciling thebank account of Spectrum Co. for July:
a. Cash balance according to the company's records at July 31,$8,346.50.
b. Cash balance according to the bank statement July 31,$9,066.35.
c. Checks outstanding $3,175.25.
d. Deposit in transit, not recorded by bank, $2,615.40.
e. A check for $240 in payment of an account was erroneouslyrecorded in the check register at $420.
f. Bank debit memorandum for service charges, $20.00.
Prepare bank reconciliation, using the format included.