Focus Travel Agency Focus Travel Agency Unadusted Trial Balance March 31 Debit Credit 2400 8000 1750 1800 16000 7600 The unadjusted trial balance was prepared as of March 31. Required: 1. Set up unadjusted trial balance in an Excel spreadsheet. 2. Record the adjusting entries. 3. Enter the amounts into the adjustments column. 4. Fill in the adjusted trial balance columns. 5. Prepare formal financial statements. Adjusting entries 1. Depreciation expense for the year is 2. Supplies on hand March 31 is 3. By March 31, unearned commissions earned 4. Insurance expense for the year 5. Accrued salaries payable at March 31 Cash Commissions Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation Accounts Payable Unearned Commissions Common Stock Retained Earnings Dividends Commissions Earned Salaries Expense Rent Expense Advertising Expense Utilities Expense 550 700 4000 9000 1500 820 600 1200 800 900 18990 6500 1870 1000 620 40840 40840