Lead Schedules
Build the lead schedule for every caption: prior year, unadjusted, adjustments, adjusted, movement.
- General ledger alone
- Compares with last year
How the result is read
The lead schedule is the top sheet of each section of the file: the caption as last year closed it, as this year’s ledger closed it, the adjustments still proposed, and the figure the accounts will show. It runs on the ledger alone and takes in proposed adjustments when they are loaded. A caption that moved on last year by more than performance materiality is the movement the section must explain (ISA 520.5 at the overall review, AU-C 520.06); and the adjusted total is proved to balance, so a one-sided adjustment shows here before it reaches the accounts.
In the application
Lead Schedules is filed under Completion, index letter L. "Run all analyses" runs it with every other analysis the ledger can answer. The worksheet states the population it tested on its face — or "Not applicable" with the reason when a column it depends on is empty — and the Excel workbook the engagement exports files it under L, beside an index of the source files with their SHA-256 fingerprints.
Read it with
Run your next audit file test without the Excel crash.
One free engagement to evaluate, valid 60 days. The ledger never leaves the machine.
- 20 minutes
- Runs on a fictional engagement
- No client data required