E8.11 Prepare bank reconciliation and adjusting entries The following information pertains to Crane Video Company. 1 Cash balance per bank, July 31, $8,263. 2 July bank service charge not recorded by the depositor $28. 3 Cash balance per books, July 31, $8,284. 4 Deposits in transit, July 31, $1,500. 5 Bank collected $700 note for Crane in July, plus interest $36, less fee $20. The collection has not been recorded by Crane, and no interest has been accrued.. 6 Outstanding checks, July 31, $791. Instructions (a) Prepare a bank reconciliation at July 31. (b) Journalize the adjusting entries at July 31 on the books of Crane Video Company. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?"