OpenConstruction Academy
Mag-sign in / Magrehistro
FIL

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.

Simulan ang gawain 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.Kathang-isip na proyekto
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
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
IkawProject accountant, general contractor

Lumalabas sa iyo

    • CVR month 2026-10Gawain 1
    ControllerYour firm
    • Earned revenue and gross profitGawain 2
    • Over/under billingGawain 3
    Bank and suretyRead the WIP schedule
    • Loss provisionGawain 4
    Outside auditorCPA firm

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.

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

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

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.