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.
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.
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 |
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 |
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.
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.
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 |
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.
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
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 |
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 |
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 |
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 |
How the three statements connect
Final reconciliation controls
Professional month-end workflow
Lock posting period and extract the final TB with entity, currency and timestamp.
Reconcile banks, AR, AP, inventory, fixed assets, payroll, tax and intercompany.
Post accruals, prepayments, depreciation, provisions, tax and consolidation journals.
Apply governed account-to-report mapping; resolve every unmapped account.
Produce P&L and BS, then create cash flow from comparatives and movement schedules.
Run the four controls above and document exceptions to zero.
Compare budget, prior year and forecast; investigate material and unusual movements.
Controller and CFO sign-off with source files, journals and reconciliation evidence retained.
