Bank Reconciliation and Entries The cash account for Collegiate Sports Co. on November 1, 2019, indicated a balance of $13,480. During November, the total cash deposited was $74,640 and checks written totaled $69,300. The bank statement indicated a balance of $25,300 on November 30, 2019. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: a. Checks outstanding totaled $11,270. b. A deposit of $9,180, representing receipts of November 30, had been made too late to appear on the bank statement. C. A check for $940 had been incorrectly charged by the bank as $490. d. A check for $360 returned with the statement had been recorded by Collegiate Sports Co. as $630. The check was for the payment of an obligation to Ramirez Co. on account. e. The bank had collected for Collegiate Sports Co. $4,850 on a note left for collection. The face of the note was $4,480. f. Bank service charges for November amounted to $60. g. A check for $1,120 from Hallen Academy was returned by the bank because of insufficient funds. 1. Prepare a bank reconciliation as of November 30, 2019. Collegiate Sports Co. Bank Reconciliation November 30, 2049 Cash balance according to bank statement Total deductions Adjusted balance Cash balance according to company's records $ Total additions Total deductions Adjusted balance 1. Prepare a bank reconciliation as of November 30, 2049. Collegiate Sports Co. Bank Reconciliation November 30, 2019 Cash balance according to bank statement Add: Deposit in transit on November 30 Add: Error in recording check Add: Outstanding checks Deduct: Deposit in transit on November 30 Deduct: Proceeds of note collected by bank, including $370 interest FF Add: Check returned because of insufficient funds Add: Outstanding checks Deduct: Deposit of November 30, not recorded by bank Deduct: Proceeds of note collected by bank, including $370 interest Deduct: Outstanding checks 1. Prepare a bank reconciliation as of November 30, 2049. Collegiate Sports Co. Bank Reconciliation November 30, 2049 Cash balance according to bank statement Add: Check returned because of insufficient funds Add: Error in recording check Add: Proceeds of note collected by bank, including $370 interest Deduct: Bank service charges Deduct: Bank error in charging check as $490 instead of $940 Cash balance according to company's records $ Add: Bank service charges Add: Check returned because of insufficient funds Add: Note collected by bank, including $370 interest Deduct: Deposit of November 30, not recorded by bank Deduct: Note collected by bank, including $370 interest uosus vuuuuuu Total additions $ Add: Check returned because of insufficient funds Add: Error in recording check Deduct: Check returned because of insufficient funds Deduct: Proceeds of note collected by bank, including $370 interest Deduct: Outstanding checks u ove Add: Deposit of November 30, not recorded by bank Add: Outstanding checks Add: Proceeds of note collected by bank, including $370 interest Deduct: Bank error in charging check as $490 instead of $940 Deduct: Bank service charges 2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. a. 2049 Nov. 30 b. Nov. 30 3. If a balance sheet were prepared for Collegiate Sports Co. on November 30, 2049, what amount should be reported as cash? 2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. a. 20Y9 Nov. 30 Cash Cash Short or Over Interest Revenue b. Nov. 30 Notes Receivable Petty Cash 2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. a. 2049 Nov. 30 Cash Interest Receivable b. Nov. 30 Interest Payable Notes Receivable Petty Cash 2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. a. 20Y9 Nov. 30 Cash b. Nov. 30 Interest Payable Interest Revenue 11 Interest Receivable Petty Cash 2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. a. 2049 Nov. 30 b. Nov. 30 Accounts Receivable-Ramirez Co. Accounts Payable-Ramirez Co. Cash Short or Over Interest Revenue 3. If a balar Notes Receivable te Sports Co. on November 30, 2019, what amount should be reported as cash? 2. Journal Accounts Payable-Hallen Academy ase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. a. 2049 N Accounts Receivable-Hallen Academy Petty Cash Interest Expense Interest Revenue b. Nov. 30 2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. a. 2049 Nov. 30 Cash Interest Expense Miscellaneous Expense Notes Payable Notes Receivable b. Nov. 30 2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. a. 2049 Nov. 30 Accounts Payable-Ramirez Co. Accounts Receivable-Hallen Academy Cash Miscellaneous Expense b. Nov. 3 Notes Receivable