From Trial Balance to Schedule III With Formulas Intact: Why Linked Excel Matters
"Is the balance sheet linked back to the trial balance? Can you show me the Excel for the financials?" — that question, or a version of it, comes up in nearly every serious evaluation of a tool that promises to draft Schedule III financials. It's a good question, and the reason it matters more than it sounds is that a lot of "automated financial statements" quietly fail it: the output looks right on screen, but the Excel behind it is pasted values, not formulas — which means the moment a single trial balance figure changes, the entire statement is stale and nobody notices until review.
The gap between "looks right" and "is actually linked"
A Schedule III balance sheet, P&L, and cash flow statement generated from a trial balance can be presented two fundamentally different ways. One is a finished document — numbers in the right cells, correctly formatted, that happens to match the TB at the moment it was generated. The other is a live spreadsheet where every Schedule III line is a formula that pulls from the mapped trial balance ledgers, so a correction anywhere upstream — a reclassification, a late adjusting entry — flows through automatically. Only the second one is actually a working paper in the SA 230 sense: something a reviewer can re-perform, not just re-read.
The distinction sounds academic until you're the reviewer three days before sign-off, and a late adjustment lands. With pasted values, that means manually finding and re-editing every downstream cell the change touches — the balance sheet, the ratios, any note that referenced the old figure — with real risk of missing one. With linked formulas, it means the numbers move on their own, and the review is confirming the update happened correctly, not hunting for what still needs fixing.
What "linked" actually means in the export
On CORAA, the Schedule III reporting module exports the locked statement set — Balance Sheet, P&L, Cash Flow (indirect method), the 11 Schedule III financial ratios with variance flagging, and 32 disclosure notes with CY vs PY comparatives — in both Excel and DOCX, generated from the same locked figures as the on-screen faces the auditor reviewed. The Mapping tab itself is a read-only view pulling from the ledger classification, so the statement set and the classification that produced it can never quietly drift apart into two different stories.
One detail worth calling out specifically: not every figure on a financial statement comes from the ledger. Some notes are populated from management representations rather than computed trial-balance data — contingent liability disclosures, for instance, or certain related-party terms. Those cells carry an explicit "auditor to confirm" tag in the export, so a reviewer can tell at a glance which numbers are computed and traceable back to the TB, and which rest on a client statement that needs independent corroboration. Conflating the two — treating an MRL-sourced figure as if it had the same evidentiary weight as a ledger-derived one — is exactly the kind of thing a reviewer or an NFRA inspector would want to see distinguished, not blended.
Why this matters beyond convenience
The practical value isn't just saving re-typing time when a number changes — it's that a linked, formula-driven statement set is inherently more defensible. If a peer reviewer or inspector asks "show me how this balance sheet figure was derived," the answer is the formula chain itself, traceable back to the trial balance, not a verbal explanation of a manual process that happened once and wasn't preserved. That's the difference SA 230 is actually drawing when it requires documentation sufficient for an experienced auditor to understand the work performed.
What to check before trusting a "financial statements" export
Open the actual Excel file a vendor produces, not just the on-screen preview, and click into a few cells. Are they formulas referencing a mapping sheet, or hardcoded numbers? Does changing a source figure in the trial balance actually flow through, or does the export need to be regenerated from scratch? And does the file distinguish computed figures from management-representation figures, or present everything with the same visual weight regardless of where it actually came from?
Frequently Asked Questions
Is the Schedule III Excel export just a formatted copy of the numbers, or does it stay linked to the trial balance?
It's generated from the same locked figures as the on-screen statements, with the Mapping tab reading directly from the ledger classification — the export and the review copy are drawn from one source, not two separately maintained versions.
What does the "auditor to confirm" tag mean in a Note?
It flags a figure that comes from management representations rather than computed ledger data — for example, certain contingent-liability or related-party disclosures — so a reviewer can distinguish computed, traceable figures from ones resting on a client statement.
What format does the exported statement set come in?
Excel and DOCX, both generated from the same locked figures — Balance Sheet, P&L, Cash Flow (indirect method), the 11 Schedule III ratios with variance flagging, and 32 disclosure notes with CY vs PY comparatives.
Why does it matter whether the Excel has live formulas versus pasted values?
A late adjustment or reclassification flows through automatically with linked formulas; with pasted values, every downstream cell it touches has to be found and re-edited by hand, with real risk of missing one before sign-off.
Related: Reporting module · Start a free trial