Assignment #10 – Course Case Bank Reconciliations
INSTRUCTIONS – Complete the following in Excel:
1. Use the November and December Bank Statements along with the company’s check register to complete bank reconciliations for the Months of November and December.
Assignments #11 – 13: Use the previous data from the course case to complete the following:
Assignment #11 – Course Case Adjusting Entries – Adjusted Trial Balance
INSTRUCTIONS – Complete the following in Excel:
1. Record and post any year-end adjusting entries Tallpete may need to complete. Assume the following cost information for depreciating the assets:
2. Prepare an adjusted Trial Balance.
3. Verify the cash account balance at the end of the year equals the bank reconciliation.
Assignment #12 – Course Case Financial Statements
INSTRUCTIONS – Complete the following in Excel:
1. Prepare December 31st Financial Statements for Tallpete.
Assignment #13 – Course Case Closing Entries – Post-Closing Trial Balance
INSTRUCTIONS – Complete the following in Excel:
1. Record and post Tallpete’s year-end closing entries.
2. Prepare a post-closing trial balance.