OpenConstruction Academy
Sign in / Register
EN

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.

Start task 1

A three-story building on a fenced site: a concrete podium with sheathed wood-frame floors above, a steel stair resting on pallets by the fence and three workers in hi-vis vests on the street.Fictional project
Quillfield CommonsRetail podium and two floors of apartments
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
YouProject accountant, general contractor

Goes from you

    • CVR month 2026-10Task 1
    ControllerYour firm
    • Earned revenue and gross profitTask 2
    • Over/under billingTask 3
    Bank and suretyRead the WIP schedule
    • Loss provisionTask 4
    Outside auditorCPA firm

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.

  1. 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
  2. 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
  3. 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
  4. 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.

Cost to completeCost to date
Task 1Percent completeCost to date over the estimate at completion. Cost against cost, nothing else.
Still to earnGross profitCost to date
Task 2Earned revenueContract value times that ratio. Approved change orders in, unsigned ones out.
Over billingEarned revenue
Task 3Billing positionEarned revenue, with stored material at cost, against what was billed on the G702 before retainage.
Loss, booked nowContract value
Task 4Loss provisionWhen the estimate passes the contract value, the whole loss goes in this month.

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.