OpenConstruction Academy
Нэвтрэх / Бүртгүүлэх
MN

Сургалтын танилцуулга · 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 completeДаалгавар 1
    • ReforecastДаалгавар 4
  • The ownerOwner
    • Change orders, signed and unsignedДаалгавар 2
  • SuperintendentYour firm
    • Stairs delivered, not installedДаалгавар 3
ТаProject accountant, general contractor

Танаас гардаг

    • CVR month 2026-10Даалгавар 1
    ControllerYour firm
    • Earned revenue and gross profitДаалгавар 2
    • Over/under billingДаалгавар 3
    Bank and suretyRead the WIP schedule
    • Loss provisionДаалгавар 4
    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
Даалгавар 1Percent completeCost to date over the estimate at completion. Cost against cost, nothing else.
Still to earnGross profitCost to date
Даалгавар 2Earned revenueContract value times that ratio. Approved change orders in, unsigned ones out.
Over billingEarned revenue
Даалгавар 3Billing positionEarned revenue, with stored material at cost, against what was billed on the G702 before retainage.
Loss, booked nowContract value
Даалгавар 4Loss 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.