Construction WIP Schedule
A percent-of-completion WIP schedule by job.
It measures earned revenue, estimated GP, and over/(under) billing rolled to contract asset vs liability.
Use it to spot under-billing and cash timing risk before the next claim cycle.
Your numbers stay in this browser. Export only — nothing is uploaded. Illustrative, not financial advice.
Construction WIP Schedule
Percent-of-completion by job — earned revenue, estimated GP, and over/(under) billing rolled to a contract asset vs liability.
Sample figures: AU construction / contracting.
Jobs — contract, costs, EAC (estimate at completion), billings
AU construction sample (labelled). Persist locally only · Jump to roll-up
Balance sheet roll-up
Underbillings = contract asset. Overbillings = contract liability. Net = asset − liability.
How this is calculated
- % complete = Costs to date ÷ EAC (estimate at completion)
- Earned revenue = % complete × Contract
- Estimated GP (gross profit) = Contract − EAC
- Over/(under) billing = Billings − Earned (positive = overbilled / liability)
- Contract asset = SUM of underbillings; liability = SUM of overbillings
Illustrative — not advice. AASB 15 / contract asset-liability presentation is simplified for this model.
Sensitivity dials
Shock EAC (estimate at completion) or billings across the book — live net WIP.
What-if dials
Each dial stacks on your base job inputs.
Scales every job’s EAC (cost overrun / underrun).
Scales billings to date across the book.
Take it with you
Get the worked example workbook in Excel — type your own numbers into it.
The Excel is the worked example workbook — type your own numbers into it. Stays on your device.