The cash account for Collegiate Sports Co. on November 1, 20Y9, indicated a balance of $12,750. During November, the total cash deposited was $70,790 and checks written totaled $65,730. The bank statement indicated a balance of $24,000 on November 30, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $10,690. A deposit of $8,710, representing receipts of November 30, had been made too late to appear on the bank statement. A check for $940 had been incorrectly charged by the bank as $490. A check for $140 returned with the statement had been recorded by Collegiate Sports Co. as $410. The check was for the payment of an obligation to Ramirez Co. on account. The bank had collected for Collegiate Sports Co. $4,600 on a note left for collection. The face of the note was $4,250. Bank service charges for November amounted to $50. A check for $1,060 from Hallen Academy was returned by the bank because of insufficient funds. Instructions: 1. Prepare a bank reconciliation as of November 30, 20Y9. Collegiate Sports Co. Bank Reconciliation November 30, 20Y9