Question
Required:a) Enter the opening balances from the October 2023 balance sheet into the general ledger accounts.d) Create the income statement, statement of owner's equity and
Required:a) Enter the opening balances from the October 2023 balance sheet into the general ledger accounts.d) Create the income statement, statement of owner's equity and the classified balance sheet.e) Prepare the journal entries for the adjustments and post them to the appropriate general ledger accounts.g) Create the post-closing trial balance.Paid $7,540 advertising expense for the promotion of the travel and tours in themonth of November.Paid $578 cash for the bank loan which included $375 principle and $203 interest. Theloan is due in 6 years with monthly repayments of $375 principle plus interest at 9%on outstanding balance.At the end of November, the following adjustment had to be journalized to properly report the balances of thecompany's accounts:b) Prepare the journal entries for the month of November and post them to the appropriate general ledgeraccounts.c) Create the trial balance in the worksheet, and then complete the remaining section of the worksheet takinginto account the information for adjustments shown above.f) Prepare the journal entries to close the books for the month of November 2023 (use the income summaryaccount), and post the journal entries to theappropriate general ledger accounts.g) Create the post-closing trial balance.Paid $7,540 advertising expense for the promotion of the travel and tours in themonth of November.Paid $578 cash for the bank loan which included $375 principle and $203 interest. Theloan is due in 6 years with monthly repayments of $375 principle plus interest at 9%on outstanding balance.At the end of November, the following adjustment had to be journalized to properly report the balances of thecompany's accounts:b) Prepare the journal entries for the month of November and post them to the appropriate general ledgeraccounts.c) Create the trial balance in the worksheet, and then complete the remaining section of the worksheet takinginto account the information for adjustments shown above.f) Prepare the journal entries to close the books for the month of November 2023
Case Study Journal Ledger Worksheet Case Accounting Cycle Adjustments -$12,500 Quest Cruise is a travel agency that offers international and local travel packages. The company is owned and operated by Gray Pelletier. The closing balances at the end of October 2023 and the chart of accounts are shown below. Assets Cash Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation Total Assets Quest Cruise Balance Sheet As at October 31, 2023 Liabilities $29,920 Accounts Payable $11,800 Unearned Revenue $0 Bank Loan $41,000 Note Payable $11,500 $9,000 $27,000 $0 Total Liabilities $47,500 Pelletier, Capital $22,720 $70,220 Total Liabilities & Owners' Equity $70,220 Account Description Account # Account Description Account # ASSETS REVENUE Cash 101 Service Revenue 400 Accounts Receivable 105 EXPENSES Prepaid Insurance 110 Advertising Expense 500 Equipment 120 Depreciation Expense 510 Accumulated Depreciation 125 Insurance Expense 515 LIABILITIES Interest Expense 520 Accounts Payable 200 Salaries Expense 545 Interest Payable 205 Telephone Expense 550 Salary Payable 210 Travel Expense 555 Unearned Revenue 215 Rent Expense 560 Bank Loan 220 Note Payable 225 OWNER'S EQUITY Pelletier, Capital Pelletier, Withdrawals Income Summary 300 310 315 Nov 1 Nov 1 Nov 1 Nov 2 Nov 2 Nov 5 Nov 15 Nov 18 Nov 20 Nov 23 Paid $9,110 cash for employee's salaries. Nov 26 Nov 28 For the month of November 2023, Quest Cruise had the following transactions: Gray invested $14,600 cash and equipment valued at $15,000 into the business. Prepaid $15,000 for insurance for one year. Paid $5,200 cash for November's rent. Provided travel services to group of travellers; they paid $32,500 now and will pay $6,500 later. Purchase equipment by signing a Note Payable for $21,000, due in 3 years plus accrued interest at 12%. Recorded travel expenses for $12,450 to be paid next month. Paid $9,200 cash to reduce the balance of accounts payable. Received $5,900 cash from customers for the travel services provided last month. Received a telephone bill for $995 which will be paid next month. Received $31,450 cash in advance from travellers for travel services to be provided next month. Paid $7,540 advertising expense for the promotion of the travel and tours in the month of November. Nov 29 The owner withdrew $8,000 cash for personal use. Paid $578 cash for the bank loan which included $375 principle and $203 interest. The loan is Nov 30 due in 6 years with monthly repayments of $375 principle plus interest at 9% on outstanding balance. At the end of November, the following adjustment had to be journalized to properly report the balances of the company's accounts: Nov 30 $34,150 of the balance of unearned revenue, still remains unearned. Nov 30 One month of prepaid insurance worth $1,250 has been used. Nov 30 Monthly depreciation on the equipment was $1,440. Nov 30 Accrued salary expense of $4,555 for an employee. Nov 30 Accrued interest on the Note Payable amounts to $210. Required: a) Enter the opening balances from the October 2023 balance sheet into the general ledger accounts. b) Prepare the journal entries for the month of November and post them to the appropriate general ledger accounts. c) Create the trial balance in the worksheet, and then complete the remaining section of the worksheet taking into account the information for adjustments shown above. d) Create the income statement, statement of owner's equity and the classified balance sheet. e) Prepare the journal entries for the adjustments and post them to the appropriate general ledger accounts.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started