Skip to content
Tutorials Center
My learning

Topics

Lesson 26 of 37 ยท Financial Statements

From Trial Balance to Financial Statements

Follow the full path from an adjusted trial balance to an income statement and balance sheet, with a worked example and code that sorts accounts into statements.

You now know the parts: adjustments, the income statement, the balance sheet and the cash flow statement. This lesson connects them into one routine. The starting point is the adjusted trial balance, a list of every ledger account after the period-end adjustments, with debit and credit balances that total the same.

The routine

  1. Adjust. Post accruals, deferrals and depreciation; produce the adjusted trial balance.
  2. Sort each account. Revenue and expense accounts go to the income statement. Assets, liabilities and equity go to the balance sheet.
  3. Prepare the income statement and find the profit.
  4. Prepare the statement of changes in equity: opening retained earnings + profit โˆ’ dividends.
  5. Prepare the balance sheet using the closing equity. It must balance.
  6. Prepare the cash flow statement and tie its closing cash to the balance sheet.

Note one trap: the trial balance still shows opening retained earnings and the dividends account separately. The profit has not yet been added in. That is why the sheet balances only once you include it.

A worked example

Brightside Cycles, a small shop, has this adjusted trial balance at 31 December (invented figures):

Account Debit Credit
Cash 37,000
Receivables 5,000
Inventory 9,000
Equipment 20,000
Accumulated depreciation 6,000
Payables 4,000
Bank loan (non-current) 10,000
Share capital 20,000
Retained earnings (opening) 7,000
Sales 90,000
Cost of sales 40,000
Wages 15,000
Rent 6,000
Depreciation expense 2,000
Dividends 3,000
Totals 137,000 137,000

Income statement: sales 90,000 โˆ’ cost of sales 40,000 = gross profit 50,000; expenses 15,000 + 6,000 + 2,000 = 23,000; profit = 27,000.

Closing retained earnings: 7,000 + 27,000 โˆ’ 3,000 = 31,000.

Balance sheet: assets 37,000 + 5,000 + 9,000 + (20,000 โˆ’ 6,000) = 65,000. Liabilities 14,000. Equity 20,000 + 31,000 = 51,000. 14,000 + 51,000 = 65,000. โœ“

Try it: sort the accounts automatically

This stand-in code stores each account with its type and balance, then builds both statements.

Python Trial balance to statements

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Try it: find an error

Python Why does the sheet not balance?

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The difference of 27,000 equals the profit, which is the classic sign that the profit was left out of equity.

Using a worksheet

Accountants often use a worksheet with columns: unadjusted trial balance, adjustments, adjusted trial balance, income statement, balance sheet. It lays out the whole routine on one page and makes missing adjustments easy to spot. You will practice this in practice set 1.

Common mistakes

  • Putting dividends or drawings in expenses.
  • Forgetting profit when closing retained earnings.
  • Using the unadjusted trial balance.
  • Showing depreciation expense on the balance sheet or accumulated depreciation on the income statement.

Check your understanding

Quick check ยท 3 questions

of 3 answered You scored / 3 ยท perfect!

  1. 1. In an adjusted trial balance, which accounts go to the income statement?

    Revenues and expenses make up the income statement; the rest belong to the balance sheet.
  2. 2. Opening retained earnings $10,000, profit $6,000, dividends $2,000. What is closing retained earnings?

    10,000 + 6,000 โˆ’ 2,000 = 14,000.
  3. 3. The balance sheet is out of balance by exactly the amount of the year's profit. The most likely cause is:

    An unexplained gap equal to profit points to profit missing from equity.

Summary

  • Start from the adjusted trial balance.
  • Revenue and expenses make the income statement; the rest make the balance sheet.
  • Closing retained earnings = opening + profit โˆ’ dividends.
  • The balance sheet must balance, and closing cash must match the cash flow statement.
  • A worksheet organizes the whole process on a page.

Next: Inventory Valuation: FIFO, LIFO and Weighted Average