Complete a bank reconciliation as of October 31. Then create T-accounts to record the necessary adjustments resulting from he bank reconciliation.
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 1060 N. Addison Chicago, 11 63111 Bank Statement Account # 34-002231 October 31, 2016 $15,000 $7,000 Beginning Balance 10/1/2016 Total Deposits and credits Total Checks and debits Ending Balance 10/31/2016 $16,000 Checks and Debits Amount Check Number 1462 1463 1464 1465 1466 1467 DM 1468 Amount $1,163.00 62.00 1,235.00 750.00 1,111.00 964.00 15.00 700.00 Date October October 2 October6 October 12 October 17 October 22 CM $1,000.00 1,340.00 210.00 1,940.00 855.00 1,480.00 175.00 The hotel's unadjusted cash balance was $16,868 on October 31. During October, the hotel recorded the following checks and deposits: Check Amount Date 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 October 1 October 5 $1,340.00 210.00 S 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. 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 1060 N. Addison Chicago, 11 63111 Bank Statement Account # 34-002231 October 31, 2016 $15,000 $7,000 Beginning Balance 10/1/2016 Total Deposits and credits Total Checks and debits Ending Balance 10/31/2016 $16,000 Checks and Debits Amount Check Number 1462 1463 1464 1465 1466 1467 DM 1468 Amount $1,163.00 62.00 1,235.00 750.00 1,111.00 964.00 15.00 700.00 Date October October 2 October6 October 12 October 17 October 22 CM $1,000.00 1,340.00 210.00 1,940.00 855.00 1,480.00 175.00 The hotel's unadjusted cash balance was $16,868 on October 31. During October, the hotel recorded the following checks and deposits: Check Amount Date 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 October 1 October 5 $1,340.00 210.00 S 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
