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.
- 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.
- 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.
- 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.
- 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.