Finance Codex
← Accounting knowledge map Professional case study · €000

From Trial Balance to P&L, Balance Sheet and Cash Flow

A fully connected example for Northstar Services Ltd. Follow every account from the closing trial balance into the financial statements, complete the closing entry, derive indirect cash flow and prove that every statement reconciles.

PART 01

The reporting architecture

The trial balance is the accounting source. A controlled mapping layer translates natural accounts into statement lines. P&L accounts measure activity during the year; balance-sheet accounts show the closing position. The cash flow statement explains the movement between opening and closing balance-sheet cash.

1. Trial Balance Every posted ledger balance. Debits must equal credits.
→
2. Mapping layer Account → statement → line → sign → cash-flow treatment.
→
3A. P&L Revenue, cost and profit for the period.
3B. Balance Sheet Assets, liabilities and equity at period end.
3C. Cash Flow Opening-to-closing cash bridge.
Critical professional rule: one closing trial balance can produce the P&L and closing balance sheet. It cannot, by itself, produce a reliable cash flow statement. Cash flow also needs opening comparative balances and movement details for non-cash items, capex, debt, equity, disposals and dividends.
PART 02

Step 1 — Start with the adjusted closing Trial Balance

This pre-closing TB is dated 31 December 2026. Revenue and expense accounts remain open, while retained earnings still contains the opening balance after the €2k dividend.

Code Account Debit Credit
1000 Cash 180 —
1100 Trade receivables 260 —
1200 Inventory 140 —
1300 Prepayments 20 —
1500 PPE at cost 600 —
1590 Accumulated depreciation — 135
2000 Trade payables — 190
2100 Accrued expenses — 80
2200 Tax payable — 22
2500 Bank debt — 300
3000 Share capital — 300
3100 Retained earnings — pre-close — 108
4000 Revenue — 1,200
5000 Cost of sales 720 —
6100 Payroll expense 210 —
6200 Marketing expense 55 —
6300 Other operating expenses 75 —
6400 Depreciation expense 35 —
7100 Interest expense 18 —
8100 Income-tax expense 22 —
Total 2,335 2,335
TB control: total debits €2,335k − total credits €2,335k = €0 difference. This proves arithmetic balance, not accounting correctness; classification, cut-off, valuation and completeness still require review.
PART 03

Step 2 — Map every account

The mapping table is the bridge between bookkeeping and reporting. Each account must have one primary statement destination and, where relevant, a cash-flow rule.

Code TB account Statement Report line Cash-flow logic
1000 Cash BS Cash & equivalents Closing control only
1100 Receivables BS Current assets Increase = subtract in CFO
1200 Inventory BS Current assets Increase = subtract in CFO
1300 Prepayments BS Current assets Increase = subtract in CFO
1500/1590 PPE / accum. depreciation BS Non-current assets Capex in CFI; D&A non-cash
2000 Payables BS Current liabilities Increase = add in CFO
2100 Accruals BS Current liabilities Increase = add in CFO
2200 Tax payable BS Current liabilities Movement adjusts tax cash
2500 Debt BS Borrowings Proceeds/repayment in CFF
3000 Share capital BS Equity Share issue in CFF
3100 Retained earnings BS Equity Profit/dividend roll-forward
4000 Revenue P&L Net revenue Included in net income
5000 Cost of sales P&L Cost of sales Included in net income
6100–6300 Operating expenses P&L OPEX Included in net income
6400 Depreciation P&L D&A Add back in indirect CFO
7100 Interest P&L Finance costs Policy-dependent cash class
8100 Tax P&L Income tax Expense vs cash reconciliation
PART 04

Step 3 — Post and review closing adjustments

The worked TB is already adjusted. In practice, finance prepares entries before statement mapping: accruals, prepayments, depreciation, inventory, expected credit losses, payroll, tax and foreign-exchange remeasurement.

Example depreciation entry (€000)
Dr 6400 Depreciation expense ........ 35
Cr 1590 Accumulated depreciation ... 35

Example year-end accrual (€000)
Dr 6300 Other operating expense .... 12
Cr 2100 Accrued expenses ........... 12

The expense debit enters the P&L; the corresponding credit remains on the BS. Depreciation reduces profit but not cash, so it is added back in the indirect cash flow.

PART 05

Step 4 — Build the P&L

Northstar Services Ltd — P&L for 2026 (€000)

Revenue 1,200
Cost of sales (720)
Gross profit 480
Payroll (210)
Marketing (55)
Other OPEX (75)
EBITDA 140
Depreciation (35)
EBIT 105
Interest expense (18)
Profit before tax 87
Income tax (22)
Net income 65
Gross profit = 1,200 − 720 = 480; gross margin = 480 / 1,200 = 40.0%
OPEX before D&A = 210 + 55 + 75 = 340
EBITDA = 480 − 340 = 140; EBITDA margin = 11.7%
EBIT = 140 − 35 = 105
PBT = 105 − 18 = 87
Net income = 87 − 22 = 65; net margin = 5.4%
PART 06

Step 5 — Close temporary accounts to retained earnings

Revenue and expenses are temporary accounts. After reporting, their net credit balance of €65k is transferred to retained earnings. The post-closing TB contains only permanent balance-sheet accounts.

Conceptual closing entry (€000)
Dr Revenue ........................ 1,200
Cr Cost of sales .................. 720
Cr Payroll expense ................ 210
Cr Marketing expense ............... 55
Cr Other operating expenses ........ 75
Cr Depreciation expense ............. 35
Cr Interest expense ................. 18
Cr Income-tax expense ............... 22
Cr Retained earnings — current profit 65
Retained earnings roll-forward: opening retained earnings €110k − dividends €2k + net income €65k = closing retained earnings €173k.
PART 07

Step 6 — Build the Balance Sheet

Northstar Services Ltd — Balance Sheet at 31 Dec 2026 (€000)

Assets
Cash 180
Trade receivables 260
Inventory 140
Prepayments 20
Total current assets 600
PPE at cost 600
Less: accumulated depreciation (135)
Net PPE 465
Total assets 1,065
Liabilities
Trade payables 190
Accrued expenses 80
Tax payable 22
Bank debt 300
Total liabilities 592
Equity
Share capital 300
Retained earnings 173
Total equity 473
Total liabilities and equity 1,065
Accounting equation: Assets €1,065k = Liabilities €592k + Equity €473k. Difference = €0.
PART 08

Step 7 — Add opening balances and movement evidence

The indirect cash flow starts with profit and removes accrual/non-cash effects. This comparative schedule provides the missing information that a single closing TB cannot supply.

Balance Opening Closing Movement Cash interpretation
Cash 100 180 +80 Outcome to prove
Receivables 225 260 +35 − CFO
Inventory 120 140 +20 − CFO
Prepayments 15 20 +5 − CFO
PPE at cost 450 600 +150 − CFI capex
Accumulated depreciation 100 135 +35 + CFO non-cash
Payables 160 190 +30 + CFO
Accruals 70 80 +10 + CFO
Tax payable 20 22 +2 + CFO
Debt 350 300 −50 − CFF repayment
Share capital 100 300 +200 + CFF issue
Movement is not automatically cash: investigate acquisitions, disposals, leases, FX, reclassifications and non-cash financing. Here we assume no disposals, no FX and no non-cash asset additions; therefore the €150k PPE-cost increase equals capex.
PART 09

Step 8 — Calculate operating cash flow

Under the indirect method, begin with net income, add back non-cash expense and adjust for working-capital movements. An increase in an operating asset consumes cash; an increase in an operating liability preserves cash.

Cash flow from operating activities (€000)

Net income 65
Add: depreciation 35
Increase in receivables (35)
Increase in inventory (20)
Increase in prepayments (5)
Increase in payables 30
Increase in accruals 10
Increase in tax payable 2
Net cash from operations (CFO) 82
CFO = 65 + 35 − 35 − 20 − 5 + 30 + 10 + 2 = 82
Cash taxes paid = tax expense 22 − increase in tax payable 2 = 20
PART 10

Step 9 — Complete investing and financing cash flows

Complete Cash Flow Statement (€000)

Net cash from operating activities 82
Purchase of PPE (150)
Net cash used in investing (CFI) (150)
Repayment of bank debt (50)
Issue of share capital 200
Dividends paid (2)
Net cash from financing (CFF) 148
Net increase in cash 80
Opening cash 100
Closing cash 180
Cash bridge: CFO €82k − capex €150k + financing €148k = €80k net increase; opening €100k + €80k = €180k closing cash.
PART 12

Final reconciliation controls

TB control ✓Debits 2,335 = credits 2,335.
BS control ✓Assets 1,065 = L+E 1,065.
Profit link ✓65 flows to retained earnings.
Cash link ✓CF closing cash 180 = BS cash 180.
Completeness No unmapped active account; mapping changes approved and version-controlled.
Sign logic Credits/debits display consistently; contra-assets and expenses are not double-negated.
Opening roll-forward Opening BS equals prior-year signed closing BS after approved restatements.
Movement evidence Capex, debt, equity and dividends agree to subledgers, bank support and board records.
Cash definition Cash and cash equivalents are consistent across BS, CF and bank reconciliation.
PART 13

Professional month-end workflow

1Freeze
Lock posting period and extract the final TB with entity, currency and timestamp.
2Validate
Reconcile banks, AR, AP, inventory, fixed assets, payroll, tax and intercompany.
3Adjust
Post accruals, prepayments, depreciation, provisions, tax and consolidation journals.
4Map
Apply governed account-to-report mapping; resolve every unmapped account.
5Build
Produce P&L and BS, then create cash flow from comparatives and movement schedules.
6Tie out
Run the four controls above and document exceptions to zero.
7Review
Compare budget, prior year and forecast; investigate material and unusual movements.
8Approve
Controller and CFO sign-off with source files, journals and reconciliation evidence retained.
Professional conclusion: the statements are not three independent reports. They are one accounting model: profit changes equity; balance-sheet movements explain cash; and closing cash must return to the balance sheet.
Deep dive: Professional P&L course →