Panimula ng kurso · 3 min
WIP schedule: porsyento ng pagkakumpleto at 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.
Kathang-isip na proyekto- 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
- Trabaho sa ERP
- 4 gawain, mga 2 oras 10 min
Sino ang nagbibigay ng ano kanino
Every arrow is a figure or a document that reaches your desk or leaves it, and the task where that happens.
Dumarating sa iyo
- Project managerYour firm
- Cost to completeGawain 1
- ReforecastGawain 4
- The ownerOwner
- Change orders, signed and unsignedGawain 2
- SuperintendentYour firm
- Stairs delivered, not installedGawain 3
Lumalabas sa iyo
- CVR month 2026-10Gawain 1
- Earned revenue and gross profitGawain 2
- Over/under billingGawain 3
- Loss provisionGawain 4
Ang ruta mo sa proyekto
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
Gawain 1 · 30 min
Gastos hanggang ngayon, estimate at completion, porsyento ng pagkakumpleto
- Ang gagawin mo
- Cost to date, estimate at completion, percent complete
- Dokumento
- Job cost report, October 2026
- Sa ERP
- Cost-Value Reconciliation
The WIP line
Gawain 2 · 30 min
Kinitang kita at gross profit
- Ang gagawin mo
- Contract value, earned revenue and both gross profits
- Dokumento
- Contract sum and change orders CO-01 to CO-03
- Sa ERP
- Cost-Value Reconciliation, REV head
Billing check
Gawain 3 · 35 min
Hindi pa nailalagay na materyales at over/under billing
- Ang gagawin mo
- Revenue with the stairs at cost, and the billing position
- Dokumento
- AIA G702, pay application 9 (the monthly bill)
- Sa ERP
- Cost-Value Reconciliation, Edit cost head
Reforecast
Gawain 4 · 35 min
Trabahong lugi: ang buong pagkalugi ngayon
- Ang gagawin mo
- The provision for anticipated loss (the whole expected loss, booked now)
- Dokumento
- Reforecast before the close
- Sa 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.
Asul ang idinadagdag ng gawain; abo ang dala mula sa naunang hakbang.
Sa madaling salita. 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.