PR 7-4B Bank reconciliation and entries SHOW ME HOW Obj. 5 The cash account for Collegiate Sports Co. on November 1, 2099, indicated a balance of $81,145. During November, the total cash deposited was $293,150, and checks written totaled $307,360. The bank statement indicated a balance of $112,675 on November 30, 2049. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: EXCEL TEMPLATE GENERAL LEOCER A. Checks outstanding totaled $41,840. B. A deposit of $12,200, representing receipts of November 30, had been made too late to appear on the bank statement. C. A check for $7.250 had been incorrectly charged by the bank as $2,750. D. A check for $760 returned with the statement had been recorded by Collegiate Sports Co. as $7,600. The check was for the payment of an obligation to Ramirez Co. on account. E. The bank had collected for Collegiate Sports Co. $7,385 on a note left for collection. The face the note was $7,000. F. Bank service charges for November amounted to $125. G. A check for $2,500 from Hallen Academy was returned by the bank because of insufficient funds. Instructions 1. Prepare a bank reconciliation as of November 30, 2049. Answer 2. Journalize the necessary entries. 3. If a balance sheet were prepared for Collegiate Sports Co. on November 30, 2019, what amount should be reported as cash? 1. COLLEGIATE SPORTS CO. Bank Reconciliation November 30, 2049 Cash balance according to bank statement Adjustments 3 Total adjustments Adjusted balance Cash balance according to company's records Adjustments: 4 05 26 27 28 29 30 31 32 33 34 35 Total adjustments Adjusted balance Pr. 7-4B H B Total adjustments Adjusted balance Nov. 30 30 3. Amount to be reported on November 30, 20Y9, balance sheet 1 -2 53 54 55 56 Pr. 748