What Is a Construction WIP Schedule?
A construction WIP schedule, or work-in-process schedule, helps a contractor understand the financial performance of active jobs.
It typically compares each project's:
contract value;
estimated total cost;
costs incurred to date;
estimated gross profit;
percentage complete;
revenue earned;
billings to date; and
overbilling or underbilling position.
A dependable WIP schedule answers a question that invoices and bank balances cannot:
How much have we actually earned on this project based on the work performed and the cost expected to complete it?
For contractors, that makes WIP much more than a year-end accounting schedule.
It can be one of the most useful financial management tools in the business.
Why Do Contractors Need a WIP Schedule?
Construction projects frequently span multiple accounting periods.
That creates timing differences between:
work performed
costs incurred
amounts billed
and
cash collected.
Those amounts are rarely identical at any point during a project.
A contractor might have billed 70% of a contract while having completed only 55% of the work.
Another project might be 80% complete but only 65% billed.
Looking only at invoices or cash receipts can therefore create a misleading picture of project performance.
A WIP schedule connects the operational status of the project to the financial statements.
What Information Is Included on a WIP Schedule?
A typical contractor WIP schedule may include:
project or job number;
customer;
contract amount;
approved change orders;
revised contract value;
estimated total project cost;
costs incurred to date;
estimated cost to complete;
estimated gross profit;
estimated gross margin;
percentage complete;
revenue earned to date;
billings to date;
overbillings;
underbillings; and
remaining backlog.
The exact format varies by contractor.
The important point is that the schedule connects contract value, project cost, progress, revenue, and billing in one place.
How Is Percentage Complete Calculated?
One common approach uses project cost as a measure of progress.
A simplified calculation is:
Costs incurred to date ÷ Estimated total project cost = Percentage complete
For example:
Costs incurred to date: $600,000
Estimated total cost: $1,000,000
Percentage complete: 60%
If the revised contract value is $1.25 million, the project may have approximately:
$1,250,000 × 60% = $750,000 of earned revenue
The actual accounting can be more complex depending on the contract and applicable revenue-recognition requirements, but this illustrates why estimated total cost is so important.
Estimated Cost to Complete Drives the WIP
One of the most important numbers in construction accounting is often not an amount that has already occurred.
It is the estimated cost remaining to complete the job.
Suppose a project has incurred $600,000 of costs.
If management estimates another $400,000 is needed, estimated total cost is $1 million.
But if updated project information shows another $550,000 is actually required, estimated total cost becomes $1.15 million.
That change affects:
percentage complete;
expected gross profit;
gross margin;
earned revenue; and
the project's overall financial outlook.
That is why a WIP schedule is only as reliable as the estimates behind it.
What Is Estimated Gross Profit?
Estimated gross profit is generally the difference between the expected contract revenue and expected total project cost.
For example:
Revised contract value: $1,500,000
Estimated total cost: $1,200,000
Estimated gross profit: $300,000
Estimated gross margin: 20%
As the project progresses, management should continually evaluate whether that $1.2 million cost estimate is still realistic.
If estimated cost increases to $1.35 million, expected profit falls to $150,000, assuming there are no approved change orders increasing total contract value.
The WIP schedule should reflect that deterioration rather than continuing to report the original margin.
What Is Margin Fade?
Margin fade occurs when the expected gross margin on a project declines as the job progresses.
Common causes include:
underestimated labor;
material overruns;
productivity problems;
subcontractor issues;
rework;
schedule delays;
missed scope;
unresolved change orders; and
incomplete cost-to-complete estimates.
For example:
Original expected margin: 22%
Updated expected margin: 17%
That five-point decline matters.
A monthly WIP review gives leadership an opportunity to identify that trend before the project is finished.
What Is Margin Gain?
The opposite can also occur.
A project may perform better than originally expected because of:
labor efficiency;
favorable purchasing;
effective project management;
resolved contingencies; or
conservative original estimates.
The expected margin may increase as the job progresses.
Unexpected gains deserve review too.
Strong WIP reporting is not only about identifying bad projects.
It is about understanding why actual job performance differs from the estimate.
What Is Overbilling?
A project is generally overbilled when billings to date exceed revenue earned to date.
For example:
Revenue earned: $750,000
Billings to date: $900,000
Overbilling: $150,000
Overbilling may be favorable from a cash-flow perspective because the contractor has billed ahead of recognized revenue.
But it is not additional profit.
The contractor still has future work and costs associated with the project.
What Is Underbilling?
A project is generally underbilled when revenue earned to date exceeds billings to date.
For example:
Revenue earned: $750,000
Billings to date: $625,000
Underbilling: $125,000
Underbilling may occur because of:
billing timing;
unapproved change orders;
project documentation delays;
contractual milestones;
missed billing opportunities; or
other project conditions.
Significant or aging underbillings should be investigated because they can create cash-flow pressure and may indicate collection or project-management risk.
Related Resource: What Is Overbilling vs. Underbilling in Construction? →
Overbilling Is Not Automatically Good
Contractors sometimes view overbilling as entirely positive because it improves short-term cash flow.
There is value in billing efficiently.
But excessive overbilling can create a misleading sense of available cash.
Suppose the company has received significant cash from a project but still has substantial work remaining.
Some of that cash effectively needs to fund future:
payroll;
materials;
subcontractors; and
project costs.
If the contractor spends that cash elsewhere, the project can create liquidity pressure later.
The WIP schedule helps management understand that obligation.
Underbilling Is Not Automatically Bad
Underbilling also requires context.
A temporary underbilling caused by normal invoice timing may not be concerning.
A persistent underbilling caused by:
disputed work;
unsigned change orders;
billing errors;
weak project administration; or
customer collection problems
is a very different situation.
The important question is not simply whether a project is overbilled or underbilled.
It is:
Why?
How Does WIP Affect the Financial Statements?
For contractors using revenue-recognition methods that recognize revenue based on project progress, the WIP schedule helps determine how much revenue and gross profit should be reflected in the financial statements.
That can create differences between:
billing;
revenue;
accounts receivable;
contract assets;
contract liabilities; and
cash.
Without a reliable WIP process, interim financial statements can materially misrepresent project profitability and company performance.
Why WIP Matters to Sureties
Sureties often rely heavily on WIP reporting when evaluating a contractor.
The schedule can provide insight into:
backlog;
profitability;
margin trends;
job performance;
overbillings;
underbillings;
project concentration; and
management's estimating discipline.
A clean balance sheet matters.
So does demonstrating that management understands what is happening inside the jobs generating those financial results.
Related Resource: What Does a Surety Look for in Contractor Financial Statements? →
Why WIP Matters to Banks
Banks may also use WIP information when evaluating:
lines of credit;
borrowing capacity;
liquidity;
working capital;
financial trends; and
overall business risk.
Large underbillings, unexplained margin deterioration, or inconsistent job reporting may raise questions even when the company's income statement appears profitable.
WIP Should Be a Management Tool
One of the biggest missed opportunities is preparing WIP only because the CPA, bank, or surety asks for it.
A strong WIP process should help management identify:
which jobs are improving;
which jobs are deteriorating;
where estimates need updating;
where billing is lagging;
where cash may become constrained;
which project managers consistently outperform estimates; and
where leadership should focus attention.
That makes WIP part of the operating rhythm of the company.
Not simply a year-end accounting exercise.
How Often Should Contractors Update WIP?
For many contractors, monthly is a useful cadence.
The WIP review can align with the monthly financial close and include input from:
accounting;
project managers;
estimators;
operations leadership; and
ownership.
The objective is to update financial expectations while management still has time to affect project outcomes.
A WIP schedule updated once a year can explain what happened.
A WIP schedule reviewed every month can help management decide what to do next.
Related Resource: How Often Should Contractors Update Their WIP Schedule? →
Who Should Own the WIP Process?
WIP should not belong solely to accounting.
Accounting can maintain the schedule and ensure it reconciles to the financial records.
But project and operations teams often have the best information about:
project progress;
remaining labor;
material requirements;
subcontractor commitments;
delays;
change orders;
project risks; and
estimated cost to complete.
A strong WIP process connects operations and finance.
For example:
Project manager: What has changed operationally?
Accounting: What has been recorded?
Controller: Does the schedule reconcile and make sense?
CFO/Owner: What does this mean for profit, cash, capacity, and decisions?
What Should Management Review Each Month?
For each significant active job, management should consider questions such as:
Is the contract amount current?
Are approved change orders included?
Are pending change orders being tracked separately?
Are costs coded correctly?
Are committed costs complete?
Is estimated cost to complete still realistic?
Has expected gross margin changed?
Is the project overbilled or underbilled?
Are collections current?
Are there unresolved claims or disputes?
Does the remaining backlog make operational sense?
Is there a risk the job will lose money?
The conversation matters as much as the spreadsheet.
Common WIP Mistakes
Common problems include:
using outdated estimated costs;
failing to include committed costs;
ignoring pending or disputed change orders;
updating WIP only at year-end;
allowing accounting to estimate project completion without operations input;
failing to reconcile WIP to the general ledger;
assuming billed revenue equals earned revenue;
ignoring large underbillings;
treating overbillings as profit;
failing to investigate margin fade; and
carrying obviously inaccurate estimates month after month.
These issues can affect financial statements, taxes, banking relationships, bonding, cash-flow planning, and management decisions.
A Simple WIP Example
Consider a contractor with the following project:
Contract value: $2,000,000
Estimated total cost: $1,600,000
Costs incurred to date: $800,000
Billings to date: $950,000
Using cost-to-cost progress:
$800,000 ÷ $1,600,000 = 50% complete
Estimated revenue earned:
$2,000,000 × 50% = $1,000,000
Estimated gross profit earned:
$1,000,000 − $800,000 = $200,000
Billings are $950,000 while earned revenue is $1 million.
The project is therefore approximately:
$50,000 underbilled.
Now assume the project manager updates estimated total cost from $1.6 million to $1.8 million.
The project is no longer 50% complete based on cost.
It is approximately:
$800,000 ÷ $1,800,000 = 44.4% complete
That changes estimated earned revenue and expected project profit.
One updated cost estimate can materially change the financial picture.
That is why WIP requires active management judgment.
The Bottom Line
A construction WIP schedule helps connect what has happened on the job to what should appear in the financial statements.
It provides visibility into:
project progress
estimated total cost
earned revenue
gross profit
margin fade or gain
billings
overbillings and underbillings
and
remaining backlog.
But the schedule is most valuable when contractors stop treating WIP as something prepared for an outside stakeholder.
Used consistently, WIP can become a monthly management tool that helps owners understand project performance, protect margins, improve cash-flow visibility, and identify problems while there is still time to respond.
How Bilotta & Company Can Help
Bilotta & Company, CPAs, LLC works with construction contractors across accounting, WIP reporting, job-cost analysis, financial statement assurance, tax, forecasting, and financial leadership.
Through our Contractor Compass® Financial Stewardship program, we help contractors establish a recurring financial rhythm around project performance and company-level financial results.
That includes connecting WIP, job costing, cash flow, dashboards, forecasting, controllership, and fractional CFO support so leadership can move from simply reporting results to actively managing them.
Our Financial Stewardship as a Service® rhythm is:
Close → Analyze → Forecast → Decide.
WIP is one of the places where that rhythm becomes especially powerful.
Related Resource: How Often Should Contractors Update Their WIP Schedule? →
Related Resource: What Is Overbilling vs. Underbilling in Construction? →
Visit the Construction Contractor Financial Resource Center →
This article is provided for general educational purposes and should not be considered accounting, tax, legal, bonding, lending, or financial advice for a specific contractor or construction contract.