Kursuse sissejuhatus · 3 min
WIP-aruanne: valmidusprotsent ja üle-/alaarveldus (USA)
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.
Väljamõeldud projekt- 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
- Töö ERP-s
- Ülesandeid 4, umbes 2 h 10 min
Kes annab kellele mida
Every arrow is a figure or a document that reaches your desk or leaves it, and the task where that happens.
Tuleb sinule
- Project managerYour firm
- Cost to completeÜlesanne 1
- ReforecastÜlesanne 4
- The ownerOwner
- Change orders, signed and unsignedÜlesanne 2
- SuperintendentYour firm
- Stairs delivered, not installedÜlesanne 3
Läheb sinult
- CVR month 2026-10Ülesanne 1
- Earned revenue and gross profitÜlesanne 2
- Over/under billingÜlesanne 3
- Loss provisionÜlesanne 4
Sinu tee läbi projekti
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
Ülesanne 1 · 30 min
Kulu tänaseni, prognoositav kogukulu, valmidusaste
- Sinu tulemus
- Cost to date, estimate at completion, percent complete
- Dokument
- Job cost report, October 2026
- ERP-s
- Cost-Value Reconciliation
The WIP line
Ülesanne 2 · 30 min
Teenitud tulu ja brutokasum
- Sinu tulemus
- Contract value, earned revenue and both gross profits
- Dokument
- Contract sum and change orders CO-01 to CO-03
- ERP-s
- Cost-Value Reconciliation, REV head
Billing check
Ülesanne 3 · 35 min
Paigaldamata materjal ning üle- ja alaarveldus
- Sinu tulemus
- Revenue with the stairs at cost, and the billing position
- Dokument
- AIA G702, pay application 9 (the monthly bill)
- ERP-s
- Cost-Value Reconciliation, Edit cost head
Reforecast
Ülesanne 4 · 35 min
Kahjumlik objekt: kogu kahjum kohe
- Sinu tulemus
- The provision for anticipated loss (the whole expected loss, booked now)
- Dokument
- Reforecast before the close
- ERP-s
- 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.
Sinine on see, mida ülesanne lisab; hall tuleb varasemast.
Lühidalt. 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.