Lead Schedule in Audit: Structure, Tie-Outs and a Worked Example

A lead schedule (or lead sheet) summarizes one financial statement area on a single page. It lists every general ledger account that rolls into a line item, shows the prior-year audited balance, the current-year unadjusted balance, the audit adjustments and the final balance, and points down to the detailed workpapers that support each number. Reviewers usually start an area at its lead schedule, so it needs to be accurate, complete and easy to follow.

This guide explains how a lead schedule is structured, how it ties to the trial balance and the financial statements, how adjustments flow through it, and what reviewers look for.

What is a lead schedule in an audit?

A lead schedule is a summary workpaper for one audit area, such as cash, accounts receivable, inventory or accrued liabilities. It groups the trial balance accounts that make up a financial statement caption and carries them from the unadjusted balance to the final audited balance.

It sits between the trial balance and the detailed testwork:

1. Trial balance: every account in the ledger.
2. Lead schedule: the accounts for one area, with adjustments, totaling to the financial statement line.
3. Supporting schedules: reconciliations, confirmations, samples and analytics for each account or assertion.

If you need a refresher on the trial balance itself, see what a trial balance is and how auditors use it.

Standard columns

Most firms use a layout close to this:

Some firms add a column for proposed but unrecorded entries so the reviewer can see the effect of passed adjustments, but keep those separate from the final balance. Passed adjustments belong on the summary of uncorrected misstatements, not in the audited number.

The lead schedule template has these columns set up with footing and cross-footing formulas.

Worked example (illustrative): accrued liabilities lead schedule

Assume an illustrative client with a December 31, 2026 year end. Amounts in USD.

Reading it top to bottom:

• AJE 4 adds an unrecorded final payroll for the last days of December, found when testing subsequent payroll.
• AJE 7 records interest the client did not accrue on its term loan.
• RJE 2 moves customer deposits to a separate contract liability caption. It does not change net income or total liabilities, but it changes the accrued liabilities line.
• The final total of $165,450 agrees to the accrued liabilities caption on the draft balance sheet.

Credits are shown as positive amounts here for readability, because every account in the area carries a credit balance. Pick one sign convention for the firm and state it on the schedule.

How to tie a lead schedule out

A lead schedule is only useful if every number on it is tied. Before the area goes to review, the preparer should be able to show:

1. Unadjusted column agrees to the trial balance. Each account balance agrees to the client's year-end trial balance, and the total of all lead schedules agrees to the trial balance in total (debits equal credits).
2. Prior-year column agrees to last year's audited figures. Agree each line to the prior-year file and the total to the prior-year financial statements. Differences usually mean the client reclassified accounts or changed the chart of accounts; document the mapping.
3. Adjustment columns agree to the AJE and RJE listing. Every entry on the lead schedule appears on the adjustments workpaper with the same number and amount, and every entry on the adjustments workpaper that affects this area appears here.
4. Final column agrees to the financial statements. The total agrees to the caption, or to the disclosure that breaks the caption down.
5. The schedule foots and cross-foots. Columns add down, rows add across.
6. Each line is referenced to the supporting workpaper, and each supporting workpaper references back to the lead.

Use tick marks to show which tie-outs were done and explain them in a legend. See audit tick marks and how to document them for a standard set.

Opening balances and the prior-year column

The prior-year column does more than provide a comparison. It is evidence that the opening balances used in the current audit agree to what was audited.

On a recurring engagement, agreeing the prior-year column to last year's audited file and confirming the client's opening trial balance agrees to the prior-year closing balance (after last year's adjustments) addresses the carryforward of balances. A common error is a client that never recorded last year's AJEs, so the current-year opening balance does not agree to the audited prior-year figure. That difference flows into current-year income or equity and must be resolved.

On a first-year engagement, AU-C 510 sets out the procedures for opening balances, which may include reviewing the predecessor auditor's workpapers. The prior-year column then shows the predecessor's audited figures, and the file should document how the auditor obtained evidence over the opening balances.

Using the lead schedule for analytics

The change columns turn the lead schedule into a quick analytical review. Compare the current-year final balance with prior year and with expectations built from what you know about the business.

For a small area, a simple scan of significant changes is enough for planning analytics under AU-C 315. For a substantive analytical procedure under AU-C 520, the lead schedule is not sufficient on its own: the auditor needs an independent expectation, a threshold for investigation and corroborated explanations, documented on a separate workpaper.

In the example above, accrued professional fees fell from $22,000 to $18,000 while the client had a lawsuit open during the year. That is worth a question, and it links naturally to the search for unrecorded liabilities and the legal letter.

Where materiality fits

Some firms show overall materiality and performance materiality at the top of each lead schedule so the reviewer can judge which accounts were scoped in for testing and which were left to analytics. Accounts below performance materiality are not automatically out of scope; their risk and the aggregation risk still matter. See AU-C 320 for how materiality is set and the materiality calculator for a quick computation.

What reviewers look for on a lead schedule

• Unadjusted balances that do not agree to the trial balance version in the file.
• Prior-year balances typed in rather than tied to the prior-year file.
• Adjustments on the lead that do not match the AJE listing, or vice versa.
• Accounts with significant balances and no workpaper reference.
• A final total that does not agree to the draft financial statements after late AJEs.
• Missing explanations for significant fluctuations.
• No conclusion. Some firms put a short area conclusion on the lead schedule: "Based on the procedures performed at L-1 through L-5, accrued liabilities are fairly stated in all material respects."

Lead schedules in review engagements

In a review under AR-C 90 there is no substantive testing, but lead schedules are still a useful way to organize the file. The detailed support beneath each lead is the analytical procedures and inquiries for that area, and the lead schedule still ties the trial balance to the financial statements.

Keeping lead schedules current through wrap-up

Late adjustments are where lead schedules go stale. When a new AJE is agreed near the end of the engagement:

1. Post it to the adjustments listing.
2. Update every affected lead schedule.
3. Re-tie the final columns to the updated financial statements.
4. Update any analytics or conclusions that relied on the old balances.

Under AU-C 230, the auditor completes the assembly of the final audit file within 60 days following the report release date, and any additions to documentation after that date are documented with the reason, who made them and when. Get the final version right before the file is assembled.

Frequently asked questions

What is the difference between a lead schedule and a trial balance?

A trial balance lists every account in the ledger. A lead schedule takes the accounts for one financial statement area and carries them from unadjusted to final, with adjustments and references to the detailed testwork.

Should passed adjustments appear on the lead schedule?

They should not change the final balance. Passed adjustments belong on the summary of uncorrected misstatements; some firms show them in a memo column on the lead for information only.

Does every account on the lead schedule need a supporting workpaper?

Every account should be covered by some procedure, but the procedure depends on risk and size. A small, low-risk account may be covered by analytics documented on the lead itself, while a significant account needs its own supporting workpapers.

What should the prior-year column agree to?

It should agree to the prior-year audited figures, line by line to last year's file and in total to the prior-year financial statements. Differences from account remapping should be documented.

Who prepares the lead schedule, the client or the auditor?

Either. Some clients provide lead schedules as PBC items, but the auditor must tie them to the trial balance, prior-year figures and adjustments before relying on them.

CORAA prepares ready-to-review audit files for US CPA firms; see /us.

Sources

• AICPA, AU-C Section 230, Audit Documentation (assembly of the final audit file; changes after the completion date)
• AICPA, AU-C Section 510, Opening Balances: Initial Audit Engagements
• AICPA, AU-C Section 315 (risk assessment analytical procedures), AU-C Section 520, Analytical Procedures, and AU-C Section 450, Evaluation of Misstatements Identified During the Audit
• AICPA, AU-C Section 320, Materiality in Planning and Performing an Audit; AR-C Section 90, Review of Financial Statements

AU-C references are to AICPA Professional Standards, paraphrased here; read the standard itself before relying on a requirement. This page is guidance, not professional advice. Report an error