Last reviewed October 7, 2026 · By the NYBACS advisory team
Short answer
Audit schedules are company-prepared workpapers that break each financial statement balance into its components and show how it was calculated, such as a bank reconciliation, a fixed-asset roll-forward or an accrued-liabilities list. A lead sheet sits above them and summarizes every account in a financial statement line. Auditors need them because they test balances by selecting items from these schedules, so a schedule that does not tie to the trial balance stops testing.
Key takeaways
- Each schedule must agree to the trial balance at the audit date; any difference has to be explained before submission.
- Roll-forward schedules start from the prior-year closing balance and show additions, reductions and the closing balance.
- A lead sheet typically shows the prior-year balance, current unadjusted balance, adjustments and final balance for each account in a line item.
- Schedules are management's records; the auditor tests them and documents its own conclusions separately in its working papers.
- Reusing the same format each year makes the next audit faster, because the prior year's schedule becomes the opening point.
How lead sheets and schedules fit together
Think of audit support as three layers. At the top are the financial statements. Beneath each statement line is a lead sheet that lists the general-ledger accounts making up that line. Beneath each account is a supporting schedule that breaks the balance into items that can be traced to source documents.
For example, the "Accrued expenses" line on the balance sheet might be supported by a lead sheet listing accrued payroll, accrued professional fees and accrued interest. Each of those accounts then has a schedule listing the individual accruals, how each was calculated and the invoice or payroll report behind it. The same structure applies to income-statement lines, although for revenue and expenses the supporting detail is usually a transaction listing or analysis rather than a roll-forward.
What a lead sheet looks like
| Account | Prior year (final) | Current year (unadjusted) | Adjustments | Current year (final) | Schedule ref |
|---|---|---|---|---|---|
| 2100 Accrued payroll | 18,400 | 22,950 | — | 22,950 | L-1 |
| 2110 Accrued professional fees | 9,000 | 4,500 | 6,200 | 10,700 | L-2 |
| 2120 Accrued interest | 1,150 | 1,310 | — | 1,310 | L-3 |
| Total accrued expenses | 28,550 | 28,760 | 6,200 | 34,960 |
Illustrative figures only.
The adjustments column captures entries proposed after the books were closed, whether found by management or by the auditor. Keeping it separate shows clearly how the final number differs from the original close.
The schedules most audits need
- Cash: bank reconciliation for every account, with outstanding items listed and cleared in the following month.
- Accounts receivable: aging by customer, allowance for doubtful accounts calculation, and receipts after year-end.
- Prepaid expenses: each prepayment with start and end dates and the monthly amortization.
- Fixed assets: cost and accumulated depreciation roll-forward with additions, disposals and depreciation method.
- Accrued liabilities: each accrual with its basis and source.
- Deferred revenue: roll-forward from opening balance through billings and recognized revenue.
- Debt: principal, interest rate, accrued interest and maturity for each facility.
- Leases: right-of-use asset and lease liability roll-forward.
- Equity: roll-forward of shares, SAFEs, conversions and option activity, tied to the cap table.
- Intercompany and related parties: balance by counterparty, agreed to the other side.
- Income taxes (C-Corps): current tax payable and deferred tax calculation.
Standards a good schedule meets
A schedule that helps rather than hinders the audit has five features:
- Ties to the trial balance, with the TB figure shown on the schedule.
- Starts from the agreed opening balance, for any roll-forward.
- References its source, such as invoice numbers, contract IDs or bank statement pages.
- Shows its calculation, rather than hard-coded totals with no visible formula.
- Identifies the preparer, the reviewer and the date, so the auditor knows who to ask and which version is current.
Version control matters. Auditors who receive three versions of the same schedule must work out which one is final, which wastes time on both sides.
Why auditors depend on them
Auditors select samples from populations. To test whether accrued liabilities are complete and accurate, they need a list that adds up to the balance, from which they choose items to vouch to invoices. Without a schedule, the auditor must build the population itself from the ledger, which takes longer and, for a firm auditing the company, raises independence questions if it starts doing management's work.
Schedules also let management catch its own errors first. Building a roll-forward that will not balance is often how a missing disposal, a double-booked invoice or an unrecorded loan is found before the auditor finds it.
Finally, schedules carry forward. The audited closing balance on this year's fixed-asset, debt or equity roll-forward is next year's opening balance, so a schedule built properly once becomes a template that cuts preparation time in every later audit, review or due-diligence exercise.
Common mistakes to avoid
- Sending schedules that do not agree to the trial balance, or agree only to an earlier version of it.
- Pasting values instead of formulas, so the auditor cannot see how a figure was calculated.
- Starting a roll-forward from a balance that differs from last year's audited closing figure.
- Netting unrelated items together, such as customer deposits inside accounts receivable.
- Sending multiple versions of the same schedule with no version date or preparer name.
- Leaving reconciling items on bank reconciliations that never clear in later months.
NYBACS 360° support
How NYBACS helps
- Builds lead sheets for each financial statement line, cross-referenced to supporting schedules.
- Prepares cash, receivables, prepaid, fixed-asset, accrual, deferred revenue, debt, lease and equity schedules that tie to the trial balance.
- Sets up a reusable workbook format so each year's closing schedule becomes the next year's opening point.
- Controls versions and logs each schedule against the auditor's PBC request number.
- Updates lead sheets and schedules for adjustments management accepts during the audit.
Frequently Asked Questions
Are lead sheets prepared by the company or the auditor?
Either, depending on the firm. Many auditors build their own lead sheets in their audit software from the trial balance; others ask the company for them. Providing them yourself helps you understand how each line is built.
Do schedules need to be in Excel?
Spreadsheet format is the most common because auditors can check formulas and filter data. PDF exports from accounting systems are usually accepted for source reports, but schedules themselves are easier to test in a working spreadsheet.
What materiality should we use when preparing schedules?
Schedules should account for the whole balance. Auditors set their own materiality and do not normally share it in detail, so leaving out "small" items in advance can create unreconciled differences.
Can a schedule replace source documents?
No. A schedule organizes and summarizes; the auditor still vouches selected items to invoices, contracts, bank statements or confirmations.
