Construction WIP Schedule: What Goes In It and How to Make It Tie

A construction WIP schedule is a one-page grid listing every open contract with its contract value, approved change orders, estimated total cost, cost incurred to date, percent complete, revenue earned to date, amount billed to date, and the resulting overbilling or underbilling. It is prepared as of the last day of each period, and it must reconcile to revenue on your income statement and to the contract asset and liability balances on your balance sheet.

It is also the first document a surety underwriter opens, ahead of your P&L and often ahead of your balance sheet. If you want to understand why your bonding capacity is what it is, the WIP schedule is where the answer is. Here is how to build one, how to make it tie, and what a reviewer is looking for when they read yours.

Why does a contractor need a WIP schedule at all?

Because in construction, the money and the work move on completely different clocks. You bill on a progress schedule that was negotiated before the job started, you hold retainage that will not release for months, and you buy materials long before the draw arrives. So invoices issued in a month bear almost no relationship to work performed in that month.

Under ASC 606, most contractors recognize revenue over time, measuring progress by cost incurred to date against total estimated cost. That is what the industry still calls percentage of completion. The WIP schedule is the calculation. Earned revenue for a job is percent complete multiplied by the revised contract value; percent complete is cost to date divided by estimated total cost. Compare earned revenue to what you actually billed, and the difference is either an underbilling (you earned more than you billed, a contract asset) or an overbilling (you billed ahead of the work, a contract liability).

Without the schedule you have no defensible revenue figure. With it, your income statement, balance sheet and job performance all trace back to the same grid. That is why CPAs, banks and sureties all ask for it, and why an internally-produced WIP that disagrees with the last CPA-prepared one is treated as a serious warning sign rather than a rounding difference.

What columns go in a WIP schedule?

The order below is the conventional presentation, and reviewers read it left to right expecting exactly this sequence.

Standard construction WIP schedule columns

Column	What it holds	Where it comes from
Original contract amount	Value at signing	Executed contract
Approved change orders	Signed changes only	Change order log
Revised contract amount	Original plus approved changes	Calculated
Estimated total cost	Current best estimate of cost at completion	Project manager, updated each period
Estimated gross profit	Revised contract less estimated total cost	Calculated
Cost incurred to date	Actual job cost posted to date	Job cost ledger
Percent complete	Cost to date divided by estimated total cost	Calculated
Revenue earned to date	Percent complete times revised contract	Calculated
Billed to date	Cumulative progress billings	A/R or billing ledger
Overbilling	Billed to date less earned, where positive	Calculated, a contract liability
Underbilling	Earned less billed to date, where positive	Calculated, a contract asset

Two inputs carry all the risk. Estimated total cost is a judgment made by a person, and it is the number that drives percent complete, which drives revenue. If a project manager leaves the original estimate in place while actual costs run over, percent complete is understated, revenue is understated, and the fade shows up violently in a later period. Estimates should be refreshed every month by whoever is closest to the job, not rolled forward.

Approved change orders are the second. Only signed change orders belong in the revised contract amount. Unapproved or pending change orders are a separate disclosure, and putting them in the contract value to make a job look profitable is exactly the kind of thing an audit or review is designed to catch.

How do you make a WIP schedule tie to the financial statements?

Three reconciliations. Run all three every period, and never issue a schedule that fails one.

Revenue. Total revenue earned to date across all open contracts, less total revenue earned to date at the end of the prior period, plus revenue on jobs closed during the period, must equal contract revenue on the income statement for the period. This is the check that proves your revenue recognition is actually driven by the WIP rather than by billings.

Contract assets. The sum of the underbilling column must equal the balance sheet line "costs and estimated earnings in excess of billings". If your chart of accounts does not have that line, add it. Underbillings sitting inside a generic other current assets account is the single most common presentation error in contractor financial statements, and it makes a balance sheet nearly unreadable to an underwriter.

Contract liabilities. The sum of the overbilling column must equal "billings in excess of costs and estimated earnings" on the balance sheet. Same reasoning. Overbillings are effectively customer funding of your work, and a reviewer wants to size them directly.

When one of these does not tie, the cause is almost always a job cost posted to the wrong job, a billing recorded outside the period, or a closed job still sitting on the schedule. Work backwards job by job rather than plugging the difference. A plugged WIP is worse than a late one.

What does a surety underwriter look for in a WIP schedule?

Gross profit fade. They compare the estimated gross profit percentage on each job now against the same job last quarter and last year. Margins that erode across periods say your estimating is optimistic, and an underwriter will discount your future margins accordingly. Consistent or improving margins across a portfolio of jobs is one of the strongest signals you can send.

Large underbillings. A big underbilling means either you are slow to bill, which is a working capital problem you can fix this week, or the job is running over cost and the estimate has not caught up, which is a much more serious problem. Underwriters cannot tell which from the schedule alone, so they will ask, and having the answer ready matters.

Concentration. One contract at 40 percent of backlog, or one general contractor as the customer on most of the work, is a risk regardless of how well the jobs are performing.

Job size relative to history. A contractor whose largest completed job was $2 million taking on a $9 million contract is a different risk than the balance sheet alone suggests. Sureties bond the company and the job.

Whether it ties. Above everything else. A WIP that reconciles to the statements tells the underwriter that the numbers are controlled. One that does not tells them nothing in the package can be relied on.

How often should a WIP schedule be produced?

Monthly, as part of close. Sureties generally expect CPA-prepared year-end financial statements within roughly 90 to 120 days of fiscal year end, and between those, current interim statements with a WIP schedule that agrees to the most recent CPA-prepared version. For a December year end, that puts the annual package with your bond agent around late March or early April.

Missing that window has a direct cost. Bonding capacity is reassessed off the current package, and stale financials get conservative treatment at exactly the point in the year when the work is being awarded. Producing the WIP monthly also means the annual version is a rollforward rather than an archaeology project, and it catches fade while there is still time to do something about the job.

The other discipline worth building alongside it is subcontractor documentation. Underwriters have been noticeably firmer since 2026 about wanting evidence of subcontractor controls, and the most basic version of that is knowing that every sub on every active job carries current coverage. Contractors who track certificates of insurance and their expiry dates centrally rather than in a folder of PDFs answer that question in seconds instead of spending a week chasing agents before a renewal meeting.

The difference between a WIP schedule and a backlog schedule

They get conflated constantly and they answer different questions. The WIP schedule covers contracts currently in progress and reports on their financial status as of a date. The backlog schedule covers signed work not yet performed: total remaining contract value, expected gross profit on it, and usually the expected completion timeline by customer. Backlog is about the future, WIP is about the present. A surety asks for both, and giving them one labelled as the other reads as unfamiliarity with your own reporting.

Where this comes together is in the statement pack. Your WIP feeds revenue and the two contract accounts, which feed the income statement and balance sheet, which drive working capital and the ratios a surety calculates. The full picture, including what underwriters actually compute from your balance sheet and how retainage affects the working capital they will credit you with, is on our construction financial statements page. If you also need to decide which level of CPA engagement your surety requires, compilation vs review vs audit lays out what each one tests and roughly what it costs.