Esc

↑↓ move↵ openIndex · Pagefind

How to prepare a WIP schedule, step by step

A work-in-progress schedule turns four numbers per job into earned revenue, gross profit and over or under billing. Here's the month-end procedure in order, from cost cutoff to the journal entry, with a three-job percentage-of-completion example that ties out and the review questions that catch a bad forecast.

Charley Forey7 min readAccountingWIPJob cost
On this page
  1. Step 1: Set the cutoff and close job cost
  2. Step 2: Update contract value
  3. Step 3: Get a real cost to complete from every PM
  4. Step 4: Compute percent complete and earned revenue
  5. Step 5: Compare earned revenue with billings
  6. Step 6: Book the full loss on losing jobs
  7. Worked example: a three-job WIP
  8. Step 7: Review against last month
  9. Step 8: Tie out and post the entry
  10. Common mistakes
  11. How os.construction handles it
  12. FAQ

To prepare a WIP schedule, close the month’s job costs, update each job’s contract value and estimated total cost, then compute percent complete (cost to date ÷ estimated total cost), earned revenue (percent complete × contract value), gross profit to date, and over or under billing (billed to date − earned revenue). Book the full expected loss on any losing job, tie the totals to the general ledger, and post the adjusting entry. Most of the work is in the cost-to-complete review, not the arithmetic.

This is the procedure in the order a controller runs it. For what the over/under column means once it’s built, read over billing vs under billing. To see a schedule assembled column by column, there’s the anatomy of a WIP schedule, and if you just need a working sheet, use the free WIP report template.

Step 1: Set the cutoff and close job cost

The WIP is only as good as cost to date. Before you touch it, make sure the month’s costs are in and dated to the right period:

  • Payroll and labor burden through the period end, including an accrual for days worked but not yet paid.
  • AP: vendor and subcontractor invoices for work done in the month, plus an accrual for work performed but not yet invoiced. Subcontractor pay apps for the period are the usual gap.
  • Equipment charges, if you cost owned equipment to jobs.
  • Uninstalled materials flagged, because they come out of the progress measure in step 4.

Late costs are the most common reason a WIP is wrong: cost to date is too low, so percent complete and earned revenue are too low, and the job looks overbilled when it isn’t.

Step 2: Update contract value

Current contract value is the original contract plus executed change orders. For changes that are approved in scope but not yet priced, or still being negotiated, ASC 606 lets you include an estimate only when it’s probable there won’t be a significant reversal later (the variable consideration constraint, ASC 606-10-32-11). In practice most contractors keep pending changes in a memo column and include them only with documented support. Their cost stays in cost to date either way, which is why unpriced change work drags percent margin down until it’s approved.

Step 3: Get a real cost to complete from every PM

This is the step that decides whether the schedule is honest. For each job, the PM forecasts the cost to complete, and estimated total cost (the estimate at completion) is cost to date plus cost to complete. Ask for it by cost code, not as one number, and ask what changed since last month. A forecast that hasn’t moved while costs have is the single biggest source of a misleading WIP.

Step 4: Compute percent complete and earned revenue

Most contractors measure progress with the cost-to-cost method, an input method under ASC 606-10-55-20:

percent complete = cost to date ÷ estimated total cost

earned revenue = percent complete × contract value

Leave out costs that don’t reflect progress. Under ASC 606-10-55-21, materials delivered but not yet installed are excluded from the progress measure and recognized at zero margin until installed (see uninstalled materials).

Step 5: Compare earned revenue with billings

over / (under) billing = billed to date − earned revenue

Billed to date is everything invoiced, including retainage held (retained amounts are billed, just not collected). A positive number is an over billing, a contract liability; a negative one is an under billing, a contract asset.

Step 6: Book the full loss on losing jobs

If estimated total cost exceeds contract value, the whole expected loss is recognized now, not as the job progresses. This loss provision guidance survived the move to ASC 606 and still sits in ASC 605-35-25. Percent-complete math alone only recognizes the share of the loss incurred so far; the provision books the rest.

From cost to earned revenue to over or under billingCost to date divided by estimated total cost gives percent complete. Percent complete times contract value gives earned revenue. Earned revenue is compared with billed to date: billed above earned is an over billing, a contract liability; billed below earned is an under billing, a contract asset. For Job A: 850,000 divided by 1,700,000 is 50 percent; 50 percent of 2,000,000 is 1,000,000 earned; billed 1,050,000, so 50,000 over billed.COST TO DATE$850,000EST. TOTAL COST$1,700,000% COMPLETE50%CONTRACT$2,000,000EARNED$1,000,000BILLED TO DATE$1,050,000OVER BILLED$50,000BILLED − EARNED: ABOVE ZERO IS A LIABILITY, BELOW ZERO AN ASSET
Four inputs per job. Only two of them, billings and cost to date, come straight from the books.

Worked example: a three-job WIP

Illustrative numbersThree made-up jobs at a month end. Contract values include approved change orders only.
Job A Job B Job C Total
Contract value 2,000,000 1,200,000 800,000 4,000,000
Estimated total cost 1,700,000 1,020,000 840,000 3,560,000
Estimated gross profit 300,000 180,000 (40,000) 440,000
Cost to date 850,000 765,000 420,000 2,035,000
Percent complete 50% 75% 50%
Earned revenue 1,000,000 900,000 400,000 2,300,000
Billed to date 1,050,000 820,000 430,000 2,300,000
Over / (under) billing 50,000 (80,000) 30,000 0
Gross profit to date 150,000 135,000 (40,000) 245,000
Revenue left to earn (backlog) 1,000,000 300,000 400,000 1,700,000

Three things to notice.

The total over/under is zero, and that hides everything. Jobs A and C are over billed by $80,000 between them and Job B is under billed by $80,000. Netted, the portfolio looks perfectly billed. On the balance sheet they’re presented gross: an $80,000 contract liability and an $80,000 contract asset. Always review the jobs, not the total.

Job C’s gross profit to date is the whole loss. Percent-complete math gives earned revenue of $400,000 against $420,000 of cost, a $20,000 loss so far. But the job will lose $40,000 in total, so a $20,000 loss provision brings the recognized loss to the full $40,000 now. That’s why total gross profit to date is $245,000 ($150,000 + $135,000 − $40,000) and not $265,000.

Job B’s under billing needs an explanation. It might be an approved change order not yet billed, which is easy to fix on the next pay app. Or the cost to complete is too low, which inflates percent complete and creates an under billing you can’t actually bill. Ask which before you report it.

Step 7: Review against last month

Put this month’s schedule next to last month’s and look at each job’s estimated gross profit. A drop is margin fade, and it needs a reason: a known overrun, a pricing miss, unapproved change work. Then compare cost-to-cost percent complete with the PM’s view of physical progress; a gap of more than a few points deserves a sentence. Finally compare total over billings with cash, the check a surety will run anyway (see what sureties look for in your WIP).

Step 8: Tie out and post the entry

The WIP should agree with the general ledger: contract revenue billed with AR billings, cost to date with job cost, and the prior period’s over/under balances with what’s on the books. Then post the adjustment that moves revenue from billed to earned:

  • Over billings: debit revenue (or billings), credit contract liability, $80,000 in the example.
  • Under billings: debit contract asset, credit revenue, $80,000.
  • Loss provision: debit cost of revenue, credit accrued loss on contracts, $20,000.

Many contractors post these as reversing entries so each month’s WIP starts clean. Your CPA will have a view on account names and presentation.

Common mistakes

  • Building it before costs are closed, so late invoices make good jobs look overbilled.
  • Including unapproved change orders in contract value without support, which inflates earned revenue.
  • Stale cost-to-complete forecasts, the usual source of a large, persistent under billing.
  • Spreading a loss over the remaining work instead of booking it all now.
  • Netting the over/under total and never looking at individual jobs.

How os.construction handles it

The WIP app in Accounting computes a dated snapshot per period: contract value from the executed prime schedule of values and approved prime change orders, cost from posted job cost, billings from posted AR, and the estimate at completion from the forecast frozen at period end. Each row shows earned revenue, over or under billing and retainage; pending change orders sit in a memo column and enter the price only through an override recorded with a reason. A different person approves, and posting writes the over/under-billing and loss provision entry as a reversing entry. Period-to-date and year-to-date earned columns aren’t built yet. See job cost and WIP, the construction cost reporting guide, or construction WIP software.

General information, not accounting advice. Revenue recognition, loss provisions and presentation depend on your facts and your accounting policies; work with your CPA. Sources: FASB ASC 606, Revenue from Contracts with Customers (606-10-25-27, 606-10-32-11, 606-10-45-1 to 45-3, 606-10-55-20 and 55-21), Deloitte Roadmap: onerous performance obligations and ASC 605-35.

FAQ

What is the formula for a WIP schedule?

For each job using cost-to-cost: percent complete = cost to date ÷ estimated total cost; earned revenue = percent complete × current contract value; over or (under) billing = billed to date − earned revenue; gross profit to date = earned revenue − cost to date. A job expected to lose money recognizes the whole expected loss at once, not just the share earned so far.

How often should you prepare a WIP schedule?

Monthly is the norm for contractors who manage by it, and banks and sureties typically want it at least quarterly and at year end alongside financial statements. A monthly schedule also lets you see fade and billing drift while there is still time to act on a job.

Should unapproved change orders be in the contract value on the WIP?

Generally only approved changes go in. Under ASC 606, an unpriced or unapproved change can be included when the modification is approved in scope and it is probable that a significant revenue reversal won't occur (the variable consideration constraint). Many contractors keep pending changes in a memo column and include them only with documented support. Costs for that work stay in cost to date either way.

Is over billing the same as a contract liability?

Close. Over billing, or billings in excess of costs and estimated earnings, is the traditional WIP label. Under ASC 606 the balance-sheet presentation is a contract liability, and under billing is a contract asset. Present the job totals gross, not netted against each other.

What do sureties look for on a WIP schedule?

They usually compare it with the prior one for gross profit fade, look at the size of under billings and how long they've persisted, compare total over billings to cash, and check that the schedule ties to the financial statements. A clean schedule with honest cost-to-complete forecasts does more for bonding capacity than an optimistic one.

Share this article

Written by

Charley Forey

Founder of os.construction. We're building the operating system for construction. Project Financials follows job money, and company Accounting covers the books and controls. AI agents remain planned. We write about how money and data actually move on a job, and we build in public.

Apply to the founding program →Start a free trial →
Keep readingAll articles →
Job cost

Direct vs indirect costs in construction: job cost, general conditions and overhead

Direct costs can be traced to a specific job or piece of work. Indirect costs support the work without belonging to one item: the job's general conditions and the company's overhead. Here is how to draw the line, how each gets recovered, a worked estimate and the coding mistakes that distort margins.

5 min read

Estimating

How to calculate construction overhead and markup for a bid

Your markup has one job: recover company overhead and leave the profit you planned. To set it, you need an annual overhead budget, a realistic revenue volume, a profit target, and the margin-to-markup conversion most estimators get wrong. Here's the method step by step, with a worked bid and what happens to the number when volume drops.

5 min read

Accounting

How to close the month in construction accounting: a step list from cutoff to lock

A construction month-end close gets every cost and every billing into the right month, proves cash and the subledgers against the ledger, updates the WIP schedule from current cost-to-complete, has someone else review it, and then locks the period. Here is the step list, an example close calendar and a worked example of what one late invoice does to WIP.

7 min read

Open file