What it is
The most common finding in a lease audit is a lease that was never put on the schedule. A reconciliation of lease-type expense in the ledger to the lease schedule shows where expense has no lease behind it.
The workbook lists ledger accounts, sums the schedule by account, accepts exempt, variable and other explained items and shows what is unexplained. The Leases tab checks dates, status and account mapping.
When to use it
- Testing completeness of the lease population.
- Implementing or auditing ASC 842.
- Year-end review of lease accounts.
What’s inside
- GL expense tab with the reconciliation by account
- Leases tab with schedule data and checks
- Flags for follow-up
- Legend tab
Standard cited
This template follows ASC 842 / AU-C 330. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use. See AU-C 330 explained.
Questions
What if the unexplained amount is negative?
A negative amount means the lease schedule is higher than the ledger, so a lease may not be expensed or may be mapped to the wrong account.
Which accounts should I list?
Every account that could hold lease cost, including equipment rental, vehicles, storage, hosting and utilities with capacity charges.
Related templates
- Lease Accounting Audit Program (ASC 842)
- ASC 842 Lease Schedule (Lessee)
- ASC 842 Lease Classification Test Worksheet
- Search for Unrecorded Liabilities Workpaper
Last updated 11/06/2026. All free templates.