Audit Lead Schedule Template
One document and four sheets that turn your trial balance into schedules that tie out, with reference codes that carry forward every year.
Free download · No account needed
Lead Schedule Set — Section E
[Entity] — Property, plant and equipment, net
Balance FY[this year] sits next to Balance FY[prior year] on the same row, footed to a section total before the tie-out runs.
| Code | Account | Bal. FY[this] | Bal. FY[prior] | Change % | Status |
|---|---|---|---|---|---|
| — | — | — | — | — | — |
| — | — | — | — | — | — |
| — | — | — | — | — | — |
Status only reads Continued, New or Retired once the Reference Index has assigned or retired a code for every row in the section.
Most audit lead schedule templates hand the preparer one blank caption per account and an empty reference column, filled in by hand from scratch every single year. None of them state what happens to a code when the account behind it closes, or whether a new account gets the number that account leaves behind. This one is generated from the trial balance itself, current year and prior year on the same row, with a reference index that carries every code forward and never lets one point at two different accounts.
Hollis Cabinet Works, Inc., an illustrative cabinet manufacturer, closes fiscal 2026 with seventeen accounts across seven sections, all footed and tied to the trial balance. Section E adds a right-of-use asset for a new CNC finance lease, coded E-4, appended after E-3 rather than slotted in alphabetically. Section G retires the equipment term loan it replaces, coded G-1, the same month the lease begins. The new lease liability becomes G-2, not G-1, even though it finances the same class of equipment the retired loan once did.
That is the rule this template runs on: a code is assigned once, at an account's first appearance, and a retired code is never reissued, no matter how closely the next account resembles the one that closed. PCAOB AS 1215 requires documentation organized to link clearly to what it supports, for a reviewer with no prior connection to the file. 17 CFR 210.2-06 requires those workpapers kept seven years, so a code reissued inside that window points an old citation at the wrong account with nothing to flag it.
What's in the pack
Workpaper Referencing Convention
The scheme itself: letters for sections, numbers for accounts, and the two rules that govern every code this file carries.
Lead Schedule Set sheet
One row per account, current and prior-year balance side by side, footed to a section total.
Tie-Out Summary sheet
Every section's total checked against the trial balance's control total, the same completeness question balance sheet substantiation asks about support.
Variance Explanations sheet
One sentence per account past a real movement threshold, naming the actual cause instead of restating a percentage.
Reference Index sheet
Every code ever issued, active or retired, its year assigned, and its year retired if it has one.
Space rule
A code is assigned once and never reused, even when the next account closely resembles the one that closed.
How to use it
- 1
Open in River, or download it
Download the blank document and four sheets as Word and CSV files with no account, or open the pack in River and send your own trial balance.
- 2
Send the trial balance, twice
This period's trial balance, the same trial balance for the prior period matched by account, and last year's reference index if one exists.
- 3
Build the set, then extend the index
The Lead Schedule Set gets grouped and footed first; the Reference Index gets extended right behind it so every account has a code before anything is final.
- 4
Tie out, then check coverage
Every section total is checked against the trial balance's own control total, and every account is confirmed to appear on exactly one section, never zero and never two.
Frequently asked questions
Is this template free?
Yes, all of it. One Word document and four CSV sheets, no signup, no card required. Edit with AI is a separate, optional route for anyone who would rather send their trial balance and reference index than build the schedules by hand.
What happens to a reference code when the account behind it closes?
It retires, permanently, marked with the year on the Reference Index. Nothing else ever gets that code again. In this pack's own worked example, the equipment term loan retires as G-1 the same month a new finance lease begins, and that lease's liability becomes G-2, appended after G-1, never reissued from it.
How is this different from the audit preparation pack's Lead Schedule Index?
The audit preparation pack tracks whether each PBC item ties to the trial balance within a stated tolerance; it does not build the schedule itself. This pack generates the schedules, sections them, foots them, and carries the reference code that makes them the same file next year rather than a blank one rebuilt from scratch.
How does a brand-new account get its code?
The next open number in its section, appended after the highest number already there. If Section E currently ends at E-3, a new account becomes E-4, never inserted between E-1 and E-2 just because it would read better there alphabetically.
I don't have a reference index from last year. Can I still use this?
Yes. Send this period's trial balance and say which sections you want, and this pack starts an index from what is on it now, numbering each section's accounts in the order they appear. Every account gets a first-ever code the same way a genuinely new account would in a file with years of history behind it.
Does this also chase confirmations or handle the year-end close?
No, both are separate jobs. Audit confirmation tracker drafts the letters and chases banks, customers and counsel; the year-end close pack drafts the statements and disclosures every December. This pack's only job is the schedules that sit behind both of them and the codes that make them reusable.
Generate schedules that tie on the first pass
Download the blank pack as Word and CSV files, or open this exact pack in River and let it foot your trial balance into schedules with the reference codes carried forward.
Edit with AI