OpenConstruction Academy
Кіру / Тіркелу
KK

Курсқа кіріспе · 3 мин

WIP кестесі: аяқталу пайызы және артық/кем шот жазу (АҚШ)

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.

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.Ойдан шығарылған жоба
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
ERP-дегі жұмыс
Тапсырмалар: 4, шамамен 2 сағ 10 мин

Кім кімге не береді

Every arrow is a figure or a document that reaches your desk or leaves it, and the task where that happens.

Сізге келеді

  • Project managerYour firm
    • Cost to complete1-тапсырма
    • Reforecast4-тапсырма
  • The ownerOwner
    • Change orders, signed and unsigned2-тапсырма
  • SuperintendentYour firm
    • Stairs delivered, not installed3-тапсырма
СізProject accountant, general contractor

Сізден кетеді

    • CVR month 2026-101-тапсырма
    ControllerYour firm
    • Earned revenue and gross profit2-тапсырма
    • Over/under billing3-тапсырма
    Bank and suretyRead the WIP schedule
    • Loss provision4-тапсырма
    Outside auditorCPA firm

Жоба бойынша жолыңыз

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

    1-тапсырма · 30 мин

    Бүгінге дейінгі шығын, аяқталу кезіндегі болжам, орындалу пайызы

    Нәтиже
    Cost to date, estimate at completion, percent complete
    Құжат
    Job cost report, October 2026
    ERP-де
    Cost-Value Reconciliation
  2. The WIP line

    2-тапсырма · 30 мин

    Тапқан түсім және жалпы пайда

    Нәтиже
    Contract value, earned revenue and both gross profits
    Құжат
    Contract sum and change orders CO-01 to CO-03
    ERP-де
    Cost-Value Reconciliation, REV head
  3. Billing check

    3-тапсырма · 35 мин

    Орнатылмаған материал және артық/кем биллинг

    Нәтиже
    Revenue with the stairs at cost, and the billing position
    Құжат
    AIA G702, pay application 9 (the monthly bill)
    ERP-де
    Cost-Value Reconciliation, Edit cost head
  4. Reforecast

    4-тапсырма · 35 мин

    Залалды жұмыс: бүкіл залал қазір

    Нәтиже
    The provision for anticipated loss (the whole expected loss, booked now)
    Құжат
    Reforecast before the close
    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
1-тапсырмаPercent completeCost to date over the estimate at completion. Cost against cost, nothing else.
Still to earnGross profitCost to date
2-тапсырмаEarned revenueContract value times that ratio. Approved change orders in, unsigned ones out.
Over billingEarned revenue
3-тапсырмаBilling positionEarned revenue, with stored material at cost, against what was billed on the G702 before retainage.
Loss, booked nowContract value
4-тапсырмаLoss provisionWhen the estimate passes the contract value, the whole loss goes in this month.

Көкпен — тапсырма қосатын бөлік; сұрмен — алдыңғы қадамнан келгені.

Қысқаша. 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.