Course introduction · 3 min
WIP schedule: percent complete and over/under billing (US)
You are the project accountant at a general contractor building a block of shops with apartments above. Each month the firm reports every open job on one line of its work-in-progress (WIP) schedule, which banks and bonding companies read. In four tasks you close October for this job: how complete it is, how much revenue it has earned, whether billing runs ahead of the work, and the loss the new forecast reveals.
Fictional project- Building
- Three stories: retail on a concrete podium, two wood-frame apartment floors
- Contract
- AIA A101 stipulated sum (one fixed price) with A201 general conditions; revenue counted under ASC 606
- Period
- October 2026 month-end close
- Work in the ERP
- 4 tasks, about 2 h 10 min
Who hands what to whom
Every arrow is a figure or a document that reaches your desk or leaves it, and the task where that happens.
Comes to you
- Project managerYour firm
- Cost to completeTask 1
- ReforecastTask 4
- The ownerOwner
- Change orders, signed and unsignedTask 2
- SuperintendentYour firm
- Stairs delivered, not installedTask 3
Goes from you
- CVR month 2026-10Task 1
- Earned revenue and gross profitTask 2
- Over/under billingTask 3
- Loss provisionTask 4
Your route through the job
Two tasks build the WIP line, one checks it against stored material and billing, one tests it against a loss. Start with task 1: from the job cost report you work out cost to date, the forecast final cost and the percent complete.
The WIP line
Task 1 · 30 min
Cost to date, estimate at completion, percent complete
- You produce
- Cost to date, estimate at completion, percent complete
- Document
- Job cost report, October 2026
- In the ERP
- Cost-Value Reconciliation
The WIP line
Task 2 · 30 min
Earned revenue and gross profit
- You produce
- Contract value, earned revenue and both gross profits
- Document
- Contract sum and change orders CO-01 to CO-03
- In the ERP
- Cost-Value Reconciliation, REV head
Billing check
Task 3 · 35 min
Uninstalled material and over/under billing
- You produce
- Revenue with the stairs at cost, and the billing position
- Document
- AIA G702, pay application 9 (the monthly bill)
- In the ERP
- Cost-Value Reconciliation, Edit cost head
Reforecast
Task 4 · 35 min
A loss job: the whole loss now
- You produce
- The provision for anticipated loss (the whole expected loss, booked now)
- Document
- Reforecast before the close
- In the ERP
- Cost-Value Reconciliation, LOSS head
How cost turns into revenue on a WIP line
Each bar is one task, in the order the October close runs.
Blue is what the task adds; grey is carried over from before.
In short. Cost against cost for the percent. Stored material at cost, no margin. Gross billings against earned revenue. A loss goes in whole, the month you see it.