The following information pertains to Crane Video Company. 1 Cash balance per bank, July 31, $7,263. 2 July bank service charge not recorded by the depositor $28. 3 Cash balance per books, July 31, $7,284 Deposits in transit, July 31, $1,300. 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. Outstanding checks, July 31, 5591. Instructions Prepare a bank reconciliation at July 31. (6) 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 "?". CRANE VIDEO COMPANY Bank Reconciliation July 31 Cash balance per bank statement Add: $7,263 $1,300 $8,563 $591 $7,972 Less: Adjusted cash balance per bank Cash balance per books Add: $7,284 $716 $8,000 $28 Less: Adjusteed cash balance per books $7,972 31-Jul Account Account Value 31 Account Value Account Value