Excel Trainers, Inc. Worksheet Month Ended January 31 Adjustments Debit Credit 2009 Adjusted Trial Balance Debit Credit Trial Balance Debit Credit 60,000 10,000 19,000 36,000 64,000 5,000 12,000 30,000 3,000 Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Dep. - Equipment Accounts Payable Notes Payable Unearned Revenue Interest Payable Salaries Payable Common Stock Retained Earnings Service Income Salaries Expense Insurance Expense Depreciation Expense Supplies Expense Utilities Expense Interest Expense Totals 96,000 7,000 70,000 28,000 2002 1800 6,000 150g report. i) Put in the adjusting entries. In video, I am using sample entries. For your homework, you will you the entries in #5 below. Supplies expense 1,000 Insurance Expense 2,000 Supplies 1,000 Prepaid Insurance 2,000 j) We are using an IF statement for the Adjusted Trial Balance. In Excel, here is the function:=IF(Condition, what to do if condition is true, what to do if condition is false). Watch the video for a demonstration of how to apply it to this worksheet. k) Build totals at the bottom of the page. These must be formulas. Now that you see how it works, delete the adjusting entries above and insert the adjusting entries below: a. Depreciation for period was $800. e. One-third of unearned revenue ha b. Accrued interest is $500. now been earned. C. Insurance expired is $2,000 f. Unpaid salaries are $1,500 d. Supplies on hand is $17,800 Check Figure: Total on Adjusted Trial Balance should now be: $225,800