OpenConstruction Academy
ورود / ثبت‌نام
FA

معرفی دوره · 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.