URGENT !!!!!!!

use excel please

Given below is information you need to complete a bank reconcilliation for you company. Your company name is: Erie 1. On January 31,2022 the balance in the company's cash acccount has a balance of $12731. 2. The company's bank statement shows a balance on January 31,2022 of $16452. 3. Outstanding check at January 31,2022 total $2825. 4. A deposit placed in the bank's night depository on January 31, 2022 totaling $1574 did not appear on the bank statement. 5. Included with the bank statement was a debit memorandum in the amount of $49 for bank service charges. It was not yet recorded in the compny's books. 6. Included with the bank statement was a credit memorandum for collection of a notes receivable in the amount of $1723 The face value of the note is $1500 Interest receivable in the amount of $203 had been previously accrued in previous accounting periods. 7. A cash sales on January 15,2022 that totaled $925 was incorrectly recorded and posted as $952 The bank deposit slip given to the bank had the correct amount. 8. Check 4145 was written and sent to the vendor for payment $567 invoice. The check was correctly written and then processed by the bank correctly. However, the check was incorrectly recorded and posted in the books as $576 9. A check received from a customer in the amount of $564 was incorrectly recored and posted as $546. The bank deposit slip given to the bank had the correct amount. 10. Check #161 was written and sent to the vendor for payment $895 invoice, The check was correctly written and then processed by the bank correctly. However, the check was incorrectly recorded and posted in the books as $859 11. An inspection of the bank statement revealed a deposit in the amount of $832 that did not match anything in the books. Further investigation revealed that the bank had incorrectly deposited the money into the wrong account. The bank was notified regarding the error. A) Prepare a bank reconcilliation statement for the company B) Prepare the journal entries to bring the companies books into balance with the reconciled amount. C) Post cash entries to the cash T-Account and verify that the ending balance is equal to the adjusted bank balance calculated in the bank reconcilliation statement