I just need the T Accounts from the bank reconciliation! Thanks!

Name: Class Time: Problem: Cubs Hotel received the following bank statement for October: State Bank & Trust 100 N. State Street Chicago, IL 63100 Cubs Hotel Bank Statement 1060 N. Addison Account 34002231 Chicago, Il 63111 October 31, 2016 Beginning Balance 10/1/2016 SI5.000 Total Deposits and credits $7,000 Total Checks and debits $6,000 Ending Balance 10/31/2016 $16.000 Checks and Debits Deposits and Credits Check Number Amount Date Amount 1462 $1,163.00 October 1 $1.000.00 1463 62.00 October 2 1,340.00 1464 1,235.00 October 6 210.00 1465 750.00 October 12 1.940.00 1466 1,111.00 October 17 855.00 1467 964.00 October 22 1,480.00 DM 15.00 CM 175.00 1468 700.00 The hotel's unadjusted cash balance was $16,868 on October 31. During October, the hotel recorded the following checks and deposits: Date October 1 October 5 Deposit Amount $1,340.00 210.00 Date October 1 October 5 October 6 October 9 October 10 October 14 October 19 October 28 Check Number 1463 1464 1465 1466 1467 1468 1469 1470 Check Amount $ 62.00 1,235.00 750.00 1,111.00 964.00 70.00 1,500.00 102.00 October 10 1,940.00 October 16 October 19 October 29 855.00 1,480.00 2,000.00 . . Other Information: The hotel has properly accounted for all items (including bank reconciliations) in previous months. Check #1462 was outstanding from September. The credit memo was for collection of an account receivable. All checks were paid at the correct amount during the period. The debit memo was for service charges. The September 30 bank reconciliation included a deposit in transit of $1,000. Check #1468 was for the purchase of equipment. Required: Use the information above to complete a bank reconciliation as of October 31 for Cubs Hotel. Use the template on the following page