Accounting Q&A · Financial Accounting · Topic 15

An accounting worksheet carries balances from the trial balance through adjustments to the statement columns. Follow that sequence and practise checking each pair of columns.

25 short-answer questions. Try each question before revealing the answer.

Worked worksheet adjustment

Prepaid Insurance has a 1,200 debit balance before adjustment. Enter a 300 credit adjustment to Prepaid Insurance and a 300 debit to Insurance Expense. Extend the remaining 900 to the balance sheet debit column and 300 to the income statement debit column.

Worksheet format

1. What is an accounting worksheet?

An internal schedule that organises ledger balances, adjustments and amounts for the financial statements.

2. Is a worksheet a financial statement?

It is an internal working paper. The financial statements are prepared from reviewed accounting records and supporting schedules.

3. What are the five pairs of columns in a typical ten-column worksheet?

Trial balance, adjustments, adjusted trial balance, income statement, and balance sheet. Each pair has debit and credit columns.

4. Where do you enter the unadjusted ledger balances?

Enter them in the trial balance columns on the side of each balance.

5. Which information goes in the adjustment columns?

Enter period-end changes such as accrued wages, expired prepayments and depreciation, keeping adjustment debits and credits equal.

6. Should adjustments on the worksheet also be posted?

Yes. Journalise and post approved adjustments so the ledger reflects the figures used for reporting.

7. How do you calculate an adjusted account balance?

Combine the unadjusted balance with its adjustment debits and credits, then enter the net result on the appropriate side.

Adjustments and statement columns

8. Prepaid Insurance is 1,200 debit and 300 has expired. What adjusted balance appears?

900 debit. Credit Prepaid Insurance 300 and debit Insurance Expense 300 in the adjustment columns.

9. Wages Expense is 1,700 debit and unpaid wages are 250. What adjusted expense appears?

1,950 debit. The adjustment also creates a 250 credit to Wages Payable.

10. Equipment is 10,000 debit and the period’s depreciation is 500. What happens to Equipment?

Equipment normally remains 10,000. Debit Depreciation Expense 500 and credit Accumulated Depreciation 500.

11. Unearned Revenue is 800 credit and 500 has been earned. What is the adjusted liability?

300 credit. Debit Unearned Revenue 500 and credit the relevant revenue account 500.

12. Supplies are 600 before adjustment and 180 remain. What is supplies expense?

420, assuming the purchases are already in Supplies and there are no other adjustments. Debit Supplies Expense and credit Supplies 420.

13. Which accounts are extended to the income statement columns?

Revenues and expenses go there to calculate the period’s result.

14. Which balances go to the balance sheet columns?

Assets, liabilities and equity balances go there. In traditional sole-trader worksheets, drawings may also appear in these columns for the equity calculation.

15. What happens to Accumulated Depreciation in the worksheet?

It normally goes to the credit column of the balance sheet section as a contra-asset.

16. What happens to Depreciation Expense?

It goes to the debit column of the income statement section.

Profit, loss and review

17. Income statement columns contain 7,800 in credits and 6,200 in debits. What is the result?

Net income is 1,600. Subtract expenses from revenues in this simplified example.

18. Where does that 1,600 profit go in a traditional ten-column worksheet?

Enter it as a balancing amount on the debit side of the income statement pair and on the credit side of the balance sheet pair.

19. If income statement debits exceed credits by 400, how is the loss shown?

Enter 400 on the credit side of the income statement pair and the debit side of the balance sheet pair.

20. Why can an account appear even when it has no unadjusted balance?

A period-end adjustment may create the balance. Accrued wages can create a Wages Payable line for the first time.

21. What should you check when adjustment columns do not balance?

Trace each adjustment as a debit and credit, check amounts and look for an omitted or duplicated line.

22. Can the adjusted trial balance agree while an adjustment is missing?

Yes. Omitting both sides of an accrual can keep the totals equal. Review schedules and period-end evidence.

23. What should you do if an account appears in the wrong statement columns?

Correct its classification and trace its proper balance to the ledger. The worksheet may still balance even when classification is wrong.

24. How can spreadsheet formulas reduce worksheet errors?

Link statement columns to adjusted balances and use checks on each pair of columns. Review mappings and protect formulas against accidental edits.

25. What review should happen before the statements are prepared?

Check adjustments against evidence, confirm approved entries were posted, review classifications, and reconcile the adjusted totals to the ledger.