What Is a WIP Schedule and Why Does Every Contractor Need One
A Work-in-Progress schedule is a financial report that shows the status of every active construction job in your company at a specific point in time. For each project, it compares three things: how much work you have completed measured by costs incurred, how much revenue you have earned based on that completion percentage, and how much you have actually billed the project owner. The difference between earned revenue and billed revenue determines whether you are overbilled or underbilled on each job, and that distinction flows directly into your balance sheet, your income statement, your bonding application, and your bank's credit analysis.
In a service business, revenue recognition is straightforward. You perform the service, you bill the client, the revenue is earned. Construction does not operate that way. A $4.2 million school renovation takes 14 months to complete. Costs are incurred unevenly -- heavy on demolition and structural work in the early months, lighter during finishes, then heavy again on punch list and commissioning. Billing follows a schedule negotiated between the contractor and the owner that may have no relationship to actual work performed in a given month. Without a WIP schedule, the contractor has no way to determine whether a job is profitable until the last invoice is paid and the last warranty callback is resolved, which may be two years after the project started.
The WIP schedule imposes financial truth on this complexity by matching costs incurred to revenue earned on a monthly basis. A contractor running 12 active jobs without a monthly WIP is, in a very real sense, flying blind. The contractor may know that cash is flowing and invoices are being paid, but has no mechanism to identify a job that is losing money until it has already consumed tens or hundreds of thousands of dollars in unrealized losses. We see this routinely with contractors in the $5 million to $30 million revenue range who are growing quickly but have not yet built the financial infrastructure to support that growth.
The Percentage-of-Completion Method Explained
How Cost-to-Cost Actually Works
The percentage-of-completion method, specifically the cost-to-cost variant, is the standard revenue recognition approach for construction contracts under both GAAP (ASC 606) and the requirements of virtually every surety company in the United States. The formula is deceptively simple:
Percent Complete = Costs Incurred to Date / Total Estimated Cost at Completion
Consider a concrete example. Your company is the general contractor on a $3.5 million medical office buildout. Your original cost estimate was $2,800,000, yielding an estimated gross profit of $700,000 (20% gross margin). At the end of month four, your job cost ledger shows $1,120,000 in costs incurred to date. Dividing $1,120,000 by $2,800,000 gives a completion percentage of 40%. Applying that 40% to the $3,500,000 contract value produces $1,400,000 in earned revenue. If you have billed $1,550,000 through month four, you are overbilled by $150,000. If you have billed only $1,250,000, you are underbilled by $150,000.
The entire calculation rests on two inputs that demand rigorous discipline. The first is accurate, timely job costing. Every cost associated with the project, including labor, materials, subcontractors, equipment, and allocated overhead, must be coded to the correct job number and posted in the correct period. A subcontractor invoice that sits in accounts payable for three weeks before being posted to the job understates costs incurred and artificially inflates the completion percentage on every project where that subcontractor is working. The second input is honest, current cost-to-complete estimates. This is where the system breaks down for most contractors, and it is worth examining in detail.
Why Estimate Revisions Are the Most Critical Discipline
Construction estimates change. Change orders add scope. Unforeseen conditions increase costs. Material prices fluctuate. Subcontractors overrun their budgets. Weather delays add general conditions costs. A cost-to-complete estimate that was accurate at contract signing may be materially wrong by month three.
The WIP schedule must reflect the current best estimate of total cost at completion, not the original bid number. If the medical office buildout from our example encounters unexpected soil conditions that add $200,000 in foundation work, the total estimated cost is now $3,000,000, not $2,800,000. The completion percentage at month four drops from 40% to 37.3% ($1,120,000 / $3,000,000), and the estimated gross profit drops from $700,000 to $500,000. The gross margin falls from 20% to 14.3%.
Project managers resist these revisions because they make jobs look worse on paper. A PM who admits that a job is running $200,000 over the original estimate is admitting an estimating failure or a management failure or both. But a WIP schedule that uses stale estimates is actively misleading. It shows phantom profits that disappear when the job closes, creating what sureties call profit fade -- the pattern of jobs that look profitable throughout execution but deliver significantly less profit at completion. Chronic profit fade is one of the strongest negative signals a surety can see on your financial statements, and it is often the primary reason bonding capacity is denied or reduced.
Require every project manager to review and certify their cost-to-complete estimates monthly, in writing. The estimate review should coincide with the WIP preparation cycle, ideally completed by the 5th of each month so the WIP schedule can be finalized by the 10th.
Reading the WIP Schedule: Overbilling, Underbilling, and What They Mean
How Overbilling Works in Practice
Overbilling occurs when you have billed the project owner more than you have earned based on your completion percentage. In our medical office example, if you are 40% complete (earned revenue of $1,400,000) but have billed $1,550,000, you are overbilled by $150,000. On your balance sheet, that $150,000 appears as a current liability under the line "Billings in Excess of Costs and Estimated Earnings." It is a liability because you owe the owner $150,000 worth of work that you have been paid for but have not yet performed.
In cash flow terms, overbilling is favorable. You are holding the owner's money, which means your working capital position is stronger than it would be if billings and earnings were perfectly aligned. Well-managed contractors deliberately maintain a moderate level of overbilling across their portfolio, typically 3% to 8% of total backlog, because it reduces the need for external working capital financing.
However, excessive overbilling, particularly on individual jobs, raises red flags. If a single project shows overbilling equal to 15% or more of the total contract value, it may indicate front-loaded billing designed to generate cash for other jobs, billing for stored materials that have not been installed, or billing for work that has not actually been performed. All three scenarios create problems -- the first two with your auditors and surety, the third with the project owner and potentially with the law.
How Underbilling Erodes Cash Flow
Underbilling is the inverse. You have earned more revenue than you have billed, meaning you have performed work for which you have not yet been reimbursed. On the balance sheet, underbilling appears as a current asset under "Costs and Estimated Earnings in Excess of Billings." It is an asset because the owner owes you money for work you have completed.
The problem with underbilling is cash flow. You have spent money on labor, materials, and subcontractors to perform the work, but you have not billed for it and therefore have not collected for it. Your bank account is depleted by the cost of the unbilled work, and you are essentially providing interest-free financing to the project owner.
Chronic underbilling is one of the most serious financial problems a contractor can have. A company running $20 million in annual revenue with 10% underbilling across its portfolio is carrying $2 million in earned-but-unbilled work, which means $2 million in costs that have been incurred but not reimbursed. That $2 million must come from somewhere: retained earnings, the line of credit, or delayed payments to subcontractors and suppliers, none of which are sustainable long-term strategies.
The most common causes of underbilling are poor billing discipline where the project team does the work but does not submit timely pay applications, scope creep where extra work is performed without securing approved change orders, and retainage accumulation where 5% to 10% of each billing is withheld and not collected until substantial completion.
Building a WIP Schedule: Column by Column With a Worked Example
A standard WIP schedule contains the following columns for each active job: job name and number, original contract value, approved change orders to date, revised contract value (original plus change orders), original estimated cost, revised estimated cost reflecting all known changes and overruns, estimated gross profit (revised contract value minus revised estimated cost), estimated gross profit percentage, costs incurred to date, percent complete (costs to date divided by revised estimated cost), earned revenue (percent complete multiplied by revised contract value), total billings to date, and the over/under billing position (total billings minus earned revenue, where a positive number indicates overbilling and a negative number indicates underbilling).
A Worked Example Across Three Jobs
Consider a general contractor with three active jobs at month-end. Job A is a $2,000,000 retail buildout with revised estimated costs of $1,600,000. Costs incurred to date are $960,000, making it 60% complete with $1,200,000 in earned revenue. Billings to date are $1,350,000, so the job is overbilled by $150,000. The estimated gross profit is $400,000 at a 20% margin and the job appears healthy.
Job B is a $5,500,000 school addition with revised estimated costs of $4,675,000 (up from the original estimate of $4,400,000 due to steel price increases and unforeseen abatement work). Costs incurred are $2,805,000, making it 60% complete with $3,300,000 in earned revenue. Billings to date are $3,100,000, so the job is underbilled by $200,000. The estimated gross profit has faded from $1,100,000 to $825,000, a decline of 25% that the PM should have flagged two months earlier.
Job C is a $1,200,000 restaurant renovation with revised estimated costs of $1,080,000. Costs incurred are $810,000 (75% complete), earned revenue is $900,000, and billings are $880,000, so the job is underbilled by $20,000. The estimated gross profit is $120,000 at a 10% margin, which is thin for this type of work.
The portfolio totals reveal net underbilling of $70,000 ($150,000 overbilling on Job A minus $200,000 underbilling on Job B minus $20,000 underbilling on Job C). The total estimated gross profit across all three jobs is $1,345,000, but Job B's profit fade is the dominant story. Without the monthly WIP forcing a revised estimate on Job B, the contractor would still be showing $1,620,000 in estimated gross profit across the portfolio, a $275,000 overstatement.
Why Your Surety Company Treats the WIP as Gospel
When a surety evaluates your bonding capacity, they analyze two dimensions of risk: financial strength and execution capability. Financial strength is assessed through your balance sheet -- net worth, working capital, debt levels, and liquidity. Execution capability is assessed almost entirely through your WIP schedule.
Fade Analysis: How Sureties Detect Estimating Problems
The surety's underwriter will compare original estimated gross profit to revised estimated gross profit for every job on your current WIP and for every completed job in the prior two to three years. This comparison, called fade analysis, reveals whether your estimating department consistently overestimates profitability. If 70% of your jobs show profit fade of more than 3%, the surety concludes that your bid margins are unreliable and that your financial statements overstate true profitability. The practical consequence is a reduction in bonding capacity, sometimes severe.
The opposite pattern -- profit growth, where jobs routinely deliver higher margins than originally estimated -- raises its own concerns. The surety may conclude that you are sandbagging estimates to create a cushion, which suggests your estimating process lacks rigor, or that you are consistently winning bids at prices well above the competitive market, which may not be sustainable.
Billing Pattern Analysis
A healthy WIP shows moderate net overbilling across the portfolio. The surety wants to see that you are managing your billing process to maintain positive cash flow without front-loading bills to an extent that creates liability risk. If your net overbilling exceeds 10% to 12% of total backlog, the surety will ask questions about whether you can sustain the work pace required to earn the revenue you have already billed.
Backlog Concentration Risk
Your WIP reveals whether your backlog is diversified or concentrated. If one job represents more than 30% of your total backlog, the surety must evaluate the financial impact of that single project going sideways. A contractor with $15 million in backlog concentrated in two $6 million jobs has far more risk than a contractor with the same backlog spread across fifteen $1 million jobs. The surety prices this concentration into your bonding capacity.
Common WIP Mistakes That Destroy Financial Credibility
Failing to update cost-to-complete estimates is the single most damaging WIP error. A schedule built on original bid estimates for jobs that are six months into execution is fiction. It creates the illusion of profitability that evaporates at job close, produces profit fade that damages your surety relationship, and delays management intervention on troubled jobs. Require monthly estimate certifications from every project manager, and compare their revisions to actual cost trends to calibrate accuracy over time.
Including unapproved change orders in the contract value inflates earned revenue and understates underbilling. If you have submitted a $150,000 change order that has not yet been approved, the additional contract revenue should not appear in your revised contract value. However, the costs you have already incurred on that change order work should be included in costs to date. This creates a temporary underbilling that resolves when the change order is approved. Overstating contract value with unapproved change orders is one of the most common audit findings on construction financial statements.
Inconsistent overhead allocation makes job-to-job comparison unreliable. If you allocate overhead to jobs, use a consistent methodology -- such as 8% to 12% of direct costs, applied uniformly every month. Changing the allocation percentage or applying it selectively creates noise in the WIP data that obscures real performance differences between jobs.
Preparing the WIP quarterly instead of monthly means you are operating without visibility for two out of every three months. A job can deteriorate significantly in 60 days. By the time the quarterly WIP reveals the problem, the losses may be unrecoverable. Monthly WIP preparation, completed within 10 business days of month-end, should be a non-negotiable operational standard for any contractor with more than $3 million in annual revenue.
From WIP Schedule to Financial Statements and Management Decisions
Your WIP schedule feeds directly into your financial statements under the percentage-of-completion method. The total earned revenue across all active jobs becomes your top-line revenue on the income statement. The net overbilling or underbilling across all jobs appears on the balance sheet as a current liability or current asset. The estimated gross profit for each job, recognized proportionally to the completion percentage, determines your reported gross margin.
If your CPA prepares your annual financial statements on the completed-contract basis, which recognizes all revenue and profit only when a job is complete, the WIP schedule is still essential for management reporting and surety submissions. Most sureties prefer percentage-of-completion statements because they provide a more timely and realistic picture of profitability. If your audited financials are on completed contract, produce supplemental WIP-basis financial statements for your surety and bank submissions.
Beyond external reporting, the WIP schedule is the most powerful management tool available to a construction company owner. It answers the questions that matter most. Which jobs are making money and which are losing? Where is cash tied up in underbilling that could be freed through better billing discipline? Which project managers are delivering consistent results and which are experiencing chronic fade? Is the backlog sufficient to sustain operations for the next 6 to 12 months? Are there jobs in the backlog with margin profiles that suggest they should not have been bid? The contractors who review their WIP monthly with their project management team and use it to drive operational decisions are the ones who grow profitably. The contractors who treat the WIP as an accounting exercise they tolerate for their surety are the ones who discover problems too late to fix them.