The balance per books amount at 11/30 is $40,859. This determined by adding the cash amount balance at 11/1 of $34,789 with the cash deposits of $33,652 and deducting checks written of $27,582 The ash account for Collegiate Sports Co. on November 1, 2016. Indicated a balance of 534,729. During November, the total cash deposited was $33.652, and checks written totaled 527,582 The bank statement indicated a balance of $50,228 on November 30, 2015. a. The bank erroneously credited Collegiate Sports Co. with a deposit made by Grant Co. In the amount of S900. b. Checks outstanding totaled $12,333 C. A check for $400 had been incorrectly charged by the bank as $450 d. The bank had collected for Collegiate Sports Co.$1,111 on a note left for collection. e. Bank service charges for November amounted to $60. f. A check for 550 returned with the statement had been recorded by Collegiate Sports Co.as $500. The check was for the payment of an obligation to Ramirez Co. on account. g. An ATM with drawal of $200 on November 18 by Collegiate Sports Co. for personal use was not recorded on the books. h. A deposit of $5,720, representing receipts of November 30, had been made too late to appear on the bank statement. 1. The bank reported a credit of $150 for interest on the average balance. J. The bank erroneously charged a check drawn by Smith Co. In the amount of S200 to Collegiate k A check for $1,000from Hallen Academy was retumed by the bank because of insufficient funds. I. Checks from September that have not yet cleared the bank totaled 52,655 Balance per bank - 11/30 50,228 Balance per books - 11/30 40,259 Add: Add: Sample bank reconciliation problem and solution On the following page there is a sample bank reconciliation problem with the solution. I have indicated on the bank reconciliation, where each of the individual problems belong on the bank reconciliation, by putting the letter of the problem next to the dollar amount on the bank reconciliation. (This is done only to assist you and not actually done in real life). Bankerror Deposits in transit Bankerror 50 (c) 6,720 (h) 2000) 57,198 Note collection Bookerror Interest collected 1.111 (d) 450 (f) 1500) 42,570 Deduct: Deduct: Please redo it on your own and submit it. Bank error 0/S checks 0/5 checks 900 (a) 12,333 (b) 2,6550 15,888 SC ATM NSF ched 60(e) 200 (8) 1.000 (k) 1.250 41,310 41,310 Please redo the bank reconciliation problem and fill this chart. REVENUE EXPENSE ACCOUNTS ASSETS LIABILITIES EQUITY Wages Insurance Accounts Payable Drawing Depreciation Accounts Receivable Notes Payable Furniture and Equipment Utilities Rent Unearned Revenue Supplies Land Prepaid Insurance Capital Services Advertising Fees Buildings Travel Cash Repairs The following is a sample of the chart that will be on the final test. The balance per books amount at 11/30 is $40,859. This determined by adding the cash amount balance at 11/1 of $34,789 with the cash deposits of $33,652 and deducting checks written of $27,582 The ash account for Collegiate Sports Co. on November 1, 2016. Indicated a balance of 534,729. During November, the total cash deposited was $33.652, and checks written totaled 527,582 The bank statement indicated a balance of $50,228 on November 30, 2015. a. The bank erroneously credited Collegiate Sports Co. with a deposit made by Grant Co. In the amount of S900. b. Checks outstanding totaled $12,333 C. A check for $400 had been incorrectly charged by the bank as $450 d. The bank had collected for Collegiate Sports Co.$1,111 on a note left for collection. e. Bank service charges for November amounted to $60. f. A check for 550 returned with the statement had been recorded by Collegiate Sports Co.as $500. The check was for the payment of an obligation to Ramirez Co. on account. g. An ATM with drawal of $200 on November 18 by Collegiate Sports Co. for personal use was not recorded on the books. h. A deposit of $5,720, representing receipts of November 30, had been made too late to appear on the bank statement. 1. The bank reported a credit of $150 for interest on the average balance. J. The bank erroneously charged a check drawn by Smith Co. In the amount of S200 to Collegiate k A check for $1,000from Hallen Academy was retumed by the bank because of insufficient funds. I. Checks from September that have not yet cleared the bank totaled 52,655 Balance per bank - 11/30 50,228 Balance per books - 11/30 40,259 Add: Add: Sample bank reconciliation problem and solution On the following page there is a sample bank reconciliation problem with the solution. I have indicated on the bank reconciliation, where each of the individual problems belong on the bank reconciliation, by putting the letter of the problem next to the dollar amount on the bank reconciliation. (This is done only to assist you and not actually done in real life). Bankerror Deposits in transit Bankerror 50 (c) 6,720 (h) 2000) 57,198 Note collection Bookerror Interest collected 1.111 (d) 450 (f) 1500) 42,570 Deduct: Deduct: Please redo it on your own and submit it. Bank error 0/S checks 0/5 checks 900 (a) 12,333 (b) 2,6550 15,888 SC ATM NSF ched 60(e) 200 (8) 1.000 (k) 1.250 41,310 41,310 Please redo the bank reconciliation problem and fill this chart. REVENUE EXPENSE ACCOUNTS ASSETS LIABILITIES EQUITY Wages Insurance Accounts Payable Drawing Depreciation Accounts Receivable Notes Payable Furniture and Equipment Utilities Rent Unearned Revenue Supplies Land Prepaid Insurance Capital Services Advertising Fees Buildings Travel Cash Repairs The following is a sample of the chart that will be on the final test