What it is
For a contractor, a missed invoice is more than an unrecorded liability. It lowers cost to date, understates percent complete and moves revenue and gross profit.
The workbook tests invoices against the date work was performed, flags unrecorded and early costs, and calculates the effect on cost to date, percent complete, revenue and gross profit by job.
When to use it
- Searching for unrecorded costs at period end.
- Auditing contract revenue.
- Reviewing subcontractor billing lag.
What’s inside
- Invoices tab with service dates and results
- Jobs tab with adjusted cost, percent complete and revenue effect
- Tie-out between tabs
- Legend tab
Standard cited
This template follows ASC 606-10-55-20 / 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
Which date matters?
The date the work was performed or delivered, not the invoice date.
Does it update the estimate to complete?
No. If unrecorded costs show the estimate is low, update it before relying on the revenue effect.
Related templates
- Construction Job Cost and Percent Complete Audit Program
- Construction WIP Schedule (Over / Under Billings)
- Search for Unrecorded Liabilities Workpaper
- Construction Estimate at Completion and Fade Analysis
Last updated 11/06/2026. All free templates.