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.
Signal Lab · Model
Construction WIP Schedule
Percent-of-completion by job — earned revenue, estimated GP, and over/(under) billing rolled to a contract asset vs liability.
Illustrative AU construction / contracting sample until you enter actuals. Not financial advice.
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 the desk.
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
Download a prompt, export the Excel workbook, or email yourself.
Downloads stay on your device. Inputs are saved in this browser (localStorage).