OpenConstruction Academy
Sign in / Register
EN

Cheat sheet

WIP schedule: percent complete and over/under billing (US)

Every rule of the course on one page: how each figure is built, the mistake people usually make, and where it comes up at work. Print it or keep it open while you work.

Task 1

Cost to date, estimate at completion, percent complete

Theory (10 min)
Rule
Cost-to-cost compares cost with cost: cost to date over the estimate at completion, accruals in both.
How it is built
  • Estimated cost at completion = Cost to date + Cost to complete
  • Percent complete = Cost to date ÷ Estimated cost at completion
Usual mistake
The accrued costs are missing. Cost to date is posted plus accrued, in the estimate too.
At work
Every month-end, the project accountant collects posted and accrued cost per cost code and asks the project manager for the cost to complete.

Task 2

Earned revenue and gross profit

Theory (10 min)
Rule
Revenue follows cost: contract value × cost to date ÷ estimate. An unsigned change order is not revenue.
How it is built
  • Earned revenue = Percent complete × Contract value
  • Gross profit to date = Earned revenue − Cost to date
  • Estimated gross profit = Contract value − Estimated cost at completion
Usual mistake
CO-03 is in the contract value. It is not signed: leave it out.
At work
The accountant books earned revenue each month and reports it with the gross profit in the work-in-progress (WIP) schedule.

Task 3

Uninstalled material and over/under billing

Theory (11 min)
Rule
Material bought is not work done: it earns revenue at cost. Billing is compared at the gross.
How it is built
  • Earned revenue, material at cost = Percent complete without the stored material × Contract value + Cost of the stored material
  • Over/(under) billing = Total completed and stored to date, gross − Earned revenue, material at cost
Usual mistake
You compared the earned revenue with billing net of retainage. Use the gross, total completed and stored to date.
At work
Each month, the accountant compares the pay application with earned revenue and books the gap as over or under billing.

Task 4

A loss job: the whole loss now

Theory (11 min)
Rule
A loss is booked the month you see it: the provision adds what cost-to-cost has not yet shown.
How it is built
  • Anticipated loss = Contract value − Estimated cost at completion after the reforecast
  • Provision for anticipated loss = Anticipated loss − Loss already shown in the gross profit to date
Usual mistake
That books the whole loss again. Cost-to-cost already shows part of it in the gross profit to date.
At work
When a reforecast shows a loss, the accountant books the whole of it in that month and tells the bonding company and the lender.

Back to the course