L10-Excel Assignment Saved Help 1 El Gato Painting Company maintains a checking account at American Bank Bank statements are prepared at the end of each month. The November 30, 2021, reconciliation of the bank balance is as follows: 53,291 1.260 15 points Balance per bank, November 30 Add Deposits outstanding Les Checks outstanding 1363 2365 6300 2381 +382 Adjusted balance per bank, Biovember 30 5.129 201 62 92 400 Pret $3,661 References The company's general ledger checking account showed the following for December Balance, December 1 Receipta Disbursement Balance, December 31 53,661 43,250 42, 453 $ 4,458 The December bank statement contained the following information: Balance, December 1 Deposite Checke proceed Hervice charges Scheeks $ 3,291 43.600 142.510) (20) Prev 1 of 1 Next Saved Help The December bank statement contained the following information: Balance, December 1 Deposits Checks prodused Service charges NSP checko Balance, December 31 $ 3,291 43,600 (42.518) (28) (500) $ 3,845 The checks that were processed by the bank in December include all of the outstanding checks at the end of November except for check #365. In addition, there are some December checks that had not been processed by the bank by the end of the month Also, you discover that check #411 for $410 was correctly recorded by the bank but was incorrectly recorded on the books as a 5140 disbursement for advertising expense. Included in the bank's deposits is a $1,900 deposit incorrectly credited to the company's account. The deposit should have been posted to the credit of the Los Gatos Company, The NSF checks have not been redeposited and the company will seek payment from the customers involved. Required: 1. Prepare a bank reconciliation for the El Gato checking account at December 31, 2021. 2. Prepare any necessary adjusting journal entries indicated Saved 110-Excel Assignment Required 1 Required 2 Prepare a bank reconciliation for the El Gato checking account at December 31, 2021. 1 $ 3,845 Bank Reconciliation Balance per bank statement Add: Deposits outstanding 15 2.810 points Print educt Outstanding checks Bank error References Corrected cash balance Balance per books Deduct Corrected book balance Roma Required 2 > Saved cel Assignment required" in the first account field.) View transaction list Journal entry worksheet 1 Print Record adjustments to cash revealed by the bank reconciliation. Use the miscellaneous expense account to record the bank service charges. eferences Note: Enter debits before credits Event General Journal Debit Credit 1 Record entry Clear entry View general Journal
