Cross-referencing lead schedules, papers and statements
How to cross-reference figures between the statements, lead schedules and supporting working papers so that a reviewer can follow every amount both ways.
By Achekam · · 5 min read · For Accountants & audit firms in South Africa, Nigeria, Kenya
A reviewer picks up the draft financial statements, puts a finger on trade receivables and asks a simple question: where is the work that supports this number? On a well-referenced file the answer takes seconds. The statement line points to a lead schedule, the lead schedule points to the papers, and each paper says what was done and what was concluded.
On a poorly referenced file the same question takes an afternoon, and sometimes ends with the discovery that the figure in the statements is not the figure that was audited. Cross-referencing is unglamorous work, but it is what turns a pile of papers into evidence someone else can follow.
What cross-referencing proves
Good referencing proves three things to anyone who reads the file:
- Agreement. The figure in the statements is the same figure that appears on the lead schedule and was tested in the papers.
- Completeness. Every material line has work behind it, and nothing on the lead schedule has been left untested without a reason.
- Traceability. A reader can move from the statements down to the evidence, and back up from the evidence to the statements, without asking the preparer.
The direction matters. Referencing down, from statement to lead to paper, shows that the figure is supported. Referencing up, from a paper back to the lead and the statement, shows that the work done actually relates to a figure that was reported.
ACCA's article on audit working papers explains how auditors should prepare and organise their papers, and why documenting every matter is neither necessary nor practicable. Referencing is how a lean file stays readable.
From statement line to lead schedule
The first link is from each line of the statements to its lead schedule. Lead schedules in Achekam are built from the engagement's trial balance, with each figure traceable to the trial balance lines behind it. They sit in the Lead schedules tab under Audit Procedures > Fieldwork.
That traceability does part of the referencing for you: the lead schedule's balance is the sum of identified trial balance lines, not a number typed in. What remains for the team is to make sure the statement line and the lead schedule say the same thing, and to note it.
In the Working Paper Control Centre, under AUDIT & ASSURANCE > Working Papers, the same papers can be grouped by statement line. The Lead Schedules menu entry opens that statement-line view. Use it to check, line by line, that each statement line has papers attached and that none is empty.
Where adjustments come in
The figure in the final statements is often not the figure in the trial balance. Staff can record an audit adjustment on a lead schedule line, with a reason. When they do, the referencing must show both: the unadjusted balance from the trial balance, the adjustment and its reason, and the adjusted figure that reaches the statements. A reviewer who sees a difference between the lead schedule and the statements, with no adjustment explaining it, has found a problem.
From lead schedule to the supporting paper
Below each lead schedule sit the papers that test its components. The receivables lead schedule might be supported by papers on the age analysis, confirmations, subsequent receipts and the allowance for credit losses.
For each, the reference should be specific:
- which figure on the lead schedule the paper supports;
- which part of the paper agrees to it;
- the conclusion reached on that figure.
A common weakness is the paper that tests a sample from a listing without ever showing that the listing agrees to the lead schedule. Add that agreement explicitly, at the top of the paper, before the sample.
Findings belong in the chain too. Findings can be raised from a working paper and closed or withdrawn, and the reference should make clear which statement line a finding affects.
Figures that refresh from the trial balance
A working paper can have a spreadsheet workbook whose figures are refreshed from the engagement's trial balance. When the trial balance changes, after a late journal from the client for example, the workbook can be refreshed rather than retyped. Any figure the refresh could not read is listed, so nothing is quietly left stale.
Two rules apply. Refreshing is refused on a locked file, and it is refused on a paper that is under review. That protects the reviewer: the numbers they are reviewing do not change under them. It also means the team must plan refreshes, bringing papers up to date before sending them for review, not after.
More on workbooks and lead schedules is in working-paper workbooks and lead schedules.
A short referencing checklist
| Check | Done when |
|---|---|
| Every statement line has a lead schedule | The statement-line view shows no empty lines |
| Each lead schedule agrees to the statements | Differences are explained by recorded adjustments |
| Each supporting paper agrees to its lead figure | The agreement is shown on the paper itself |
| Workbooks refreshed after the last trial balance change | Before the paper went for review |
| Findings linked to the line they affect | The finding names the line |
Review notes on broken links
When a reviewer finds a break in the chain, the place to say so is a review note. A reviewer can raise review notes on a working paper; the preparer answers and the reviewer clears them, and each note's history is kept. They are reached under AUDIT & ASSURANCE > Review Notes or a paper's own Review notes tab. AI can suggest notes, but a person raises each one.
A useful review note on referencing is specific: "Receivables per lead schedule does not agree to the receivables note in the draft statements; please reconcile or record the adjustment." Vague notes such as "check referencing" produce vague answers. Because the history of each note is kept, the file shows not only that the link was broken, but how it was fixed. That record is part of the documentation the firm will rely on, as discussed in audit documentation under ISA 230.
Before the next file goes for manager review, ask the preparer to walk the statement-line view line by line and confirm, for each, the lead schedule, the papers and any adjustment in between.
General guidance only, not advice on your own circumstances. Tax and payroll rules change: check the current position with the authority or your adviser.
