Trial Balance Worksheet 
3 Trial Balance Project XLSX File Edit View Insert Format Data Tools Help Last edit was 5 minutes ago 100% $ 0.00123 Delut Y 11 B I =rly Pr 389 ! M 1 D Gus's Gone Fishing Expeditions Trial Balance Worksheet December 31, 2020 Adjustments Adjusted Trial Balance Debit Credit Debit Credit 4 Income Statement Debit Credit Statement of Ret Earnings Debit Credit Balance Sheet Debit Credit Unadjusted Trial Balance Debit Cred 11,580 8,320 1,100 7,380 14,000 7,635 30,000 99,000 143,500 64,770 8,500 5 Account Cash T Accounts receivable . Otice supplies Prepaid insurance 10 Notes receivable Investments in stocks and bonds 12 Land 13 Buildings Equipment 15 Accumulated depreciation 16 Accounts payable 17 Salaries payable Accrued payroll taxes 19 Accrued real estate taxes Unearned revenue - customer downpayments 21 Notes payable - line of credit 22 Long-term loans payable Common stock 24 Retained earnings 25 Dividends 26 Foos earned 27 Salarios expense Payroll taxes Employee benefits Rent expense 31 Advertising expense 32 Insurance expense 23 Office Supplies expense * Gas, Fuel & Oil 35 Repairs and maintenance expense Real estate taxes 27 Utilities expense Depreciation expense Travel expense Interest expense Totals 42 Net income 4,860 945 14.875 5,000 40,000 50,000 67,605 15,000 511,250 332,500 30,875 31 225 7,200 4,800 3,865 1,225 5,500 4,855 36 3.780 4,765 600 767,805 767,805 Ending retained earings 45 45 A E F 45 Adjusting Entries Debit 47 40 Credit 51 53 54 55 56 57 61 54 65 66 67 70 71 72 73 74 75 76 77 70 79 The annual premium for the insurance policy was paid on September 1, 2020 for $7,380 and posted to prepaid insurance The office supplies were counted on 12-31-20 and had a balance of $558. The sales & adminstrative staff have salaries of $375 per day and the guides have salaries of $750 a day The last payroll paid was on Tuesday December 29, 2020 for period ending Friday December 25, 2020. Assume that everyone works a six day work weak for this problem. Sundays are not work days Employees received Christmas day off with pay, but worked on Saturday the 26th 14 05 Depreciation for 2020 is $24,500. 07 The actual customer downpayments left at 12-31-20 are $3,650. The 2019 real estate taxes were paid in 2020 for the amount $5,800. The bo20 real estate taxes will be paid in 2021 The 2020 real estate taxes are expected to be more than 2019. 90 91 The annual premium for the insurance policy was paid on September 1, 2020 for $7,380 and posted to prepaid insurance. The office supplies were counted on 12-31-20 and had a balance of $658. The sales & adminstrative staff have salaries of $375 per day and the guides have salaries of $750 a day. The last payroll paid was on Tuesday December 29, 2020 for period ending Friday December 25, 2020. Assume that everyone works a six day work week for this problem. Sundays are not work days. Employees received Christmas day off with pay, but worked on Saturday the 26th. Depreciation for 2020 is $24,600. The actual customer downpayments left at 12-31-20 are $3,650. The 2019 real estate taxes were paid in 2020 for the amount of $5,800. The 2020 real estate taxes will be paid in 2021. The 2020 real estate taxes are expected to be 2% more than 2019. This information is not for adjusting entries - balance sheet only Current portion of long-term debt $4,500 how much they have to pay for the coming year 40000 on balance sheets gets broken into current and noncurrent liabilities
