Prepare bank reconciliation and adjusting entries. (LO 5), AP XLS E7-8 The following information pertains to Joyce Company. 1. Cash balance per bank, July 31, $7,328. 2. July bank service charge not recorded by the depositor $38. 3. Cash balance per books, July 31, $7,364. 4. Deposits in transit, July 31, $2,700. 5. Note for $2,000 collected for Joyce Company in July by the bank, plus interest $36 less fee $20. The collection has not been recorded by Joyce Company, and no interest has been accrued. 6. Outstanding checks, July 31, $686. Instructions (a) Prepare a bank reconciliation at July 31, 2014. (b) Journalize the adjusting entries at July 31 on the books of Joyce Company. Exercises 377