Balance Sheet
Every account group in statement order, rolled up through its parents, each level against last year.
- General ledger alone
- Compares with last year
- Key analysis in Planning & analytics
What it checks
- Tree: level 1 Statement → level 2 Class → level 3 FSLI → level 4 Account Group → account → journal entry. Balances live at level 4; every level above is Σ children.
- Assets, in order: PP&E · intangibles · other non-current · inventory · trade receivables · prepayments · cash.
- Liabilities, in order: long-term debt · deferred tax · trade payables · accruals · tax payable · deferred revenue.
- Then equity: share capital · share premium · retained earnings · dividends.
- Columns: CY · PY · Δ · Δ% · % of total assets.
- Two checks: assets = liabilities + equity; closing equity = opening + profit − dividends + OCI.
How the result is read
Only level 4 carries a balance. Every caption above it is an addition, so the statement is fully described by the order of the level 4 groups and which caption each one sits under — that is the table below. An account mapped to no level 4 vanishes silently while the statement still balances, so the join is asserted, not assumed.
The worksheet, on the demo engagement
Balance Sheet, as the application draws it for Harrow Precision Engineering Ltd, the fictional demo engagement — one node per balance-sheet caption, nested to level 4.
- Total Assets
- 48,565
- Total Liabilities
- 29,895
- Balance check
- 0
Ordered most-illiquid to most-liquid. Two identities are asserted rather than assumed: total assets 48,565 = liabilities 29,895 + equity 18,670, and opening equity 14,981 + profit 3,689 − distributions nil = closing equity 18,670, which is what ties this statement to the income statement. Receivables are shown gross with the allowance beneath them rather than netted away, so the provision test has something to point at.
Result grid6 of 8 rows
| FS Caption | CY | PY | Delta Abs | Delta % | % Assets |
|---|---|---|---|---|---|
| Non-current assets | 28,920 | 27,210 | +1,710 | +6.3% | 60.0% |
| Current assets | 19,645 | 16,880 | +2,765 | +16.4% | 40.5% |
| Total assets | 48,565 | 44,090 | +4,475 | +10.1% | 100.0% |
| Non-current liabilities | (14,620) | (16,540) | +1,920 | (11.6%) | — |
| Current liabilities | (15,275) | (12,569) | (2,706) | +21.5% | — |
| Total liabilities | (29,895) | (29,109) | (786) | +2.7% | — |
In the application
Balance Sheet is filed under Planning & analytics, index letter A. "Run all analyses" runs it with every other analysis the ledger can answer. The worksheet states the population it tested on its face — or "Not applicable" with the reason when a column it depends on is empty — and the Excel workbook the engagement exports files it under A, beside an index of the source files with their SHA-256 fingerprints.
Read it with
Run your next audit file test without the Excel crash.
One free engagement to evaluate, valid 60 days. The ledger never leaves the machine.
- 20 minutes
- Runs on a fictional engagement
- No client data required