WIP Schedule Example for Contractors (Step-by-Step Guide)
Contractor Pain Point
A contractor finishes the month feeling busy. Crews are working. Jobs are moving. Cash has come in.
But the financials say something strange.
One job looks wildly profitable. Another job that’s actually going well looks like it’s losing money. Revenue jumps up and down month to month with no clear pattern.
Then the bank, bonding company, or CPA asks for something most contractors have never built:
A Work-In-Progress (WIP) schedule.
Without one, contractors struggle to answer simple questions:
Are we ahead or behind on billing?
Are we actually making money on this job?
Why does profit look different every month?
This is not a bookkeeping problem.
It’s a reporting structure problem.
And it almost always ties back to how job costing, billing, and project setup are organized — which is why the foundation starts with systems like Job Costing Basics for Trades & Contractors.
If you're unsure whether your current reporting is even structured correctly, running a quick Job Costing Health Report can quickly reveal whether your jobs are producing the data a WIP schedule needs.
Core Explanation: Why This Happens
Construction accounting is different from most industries.
Revenue is earned based on progress, not just when an invoice is sent.
A WIP schedule exists to answer one key question:
How much revenue should we recognize based on how much work has actually been completed?
To do that, a WIP schedule compares three things for every job:
Contract value
Costs incurred to date
Billings to date
When these numbers are connected properly, the WIP schedule shows:
Overbilling (billing ahead of work completed)
Underbilling (work completed but not yet billed)
Actual project progress
Estimated final profit
But none of this works if the underlying job data is messy — which often happens when job structure and cost codes aren't consistent, something explained in How Contractors Should Set Up Cost Codes in Their Accounting System.
Step-by-Step Breakdown
1. Start With the Total Contract Value
What to do
Record the total contract price including approved change orders.
Example:
Job: Kitchen Remodel
Contract Value: $200,000
If a change order adds $20,000 later, the contract value becomes $220,000.
This number must stay updated — which is why many contractors rely on systems explained in Change Orders in Construction: How Contractors Protect Job Profit.
Why it matters
The contract value determines how revenue is measured.
What goes wrong if skipped
If change orders are not included:
WIP percentages become wrong
Profit projections become misleading
Jobs appear over or under budget incorrectly
2. Track Total Job Cost Incurred
What to do
Pull actual job costs to date from your accounting system.
Job: Kitchen Remodel
Cost Incurred: $80,000
These costs come from:
Labor
Materials
Subcontractors
Equipment
Allocated overhead (in some systems)
This only works if job costs are tracked consistently, which is why accurate labor tracking systems like those discussed in Labor Tracking & Payroll Allocation for Contractors are critical.
Why it matters
Costs are used to estimate project completion percentage.
What goes wrong if skipped
If job costs are incomplete or delayed:
WIP schedules become unreliable
Job profitability appears inaccurate
Revenue recognition becomes distorted
Running a Job Costing Health Report mid-project often reveals whether costs are actually being captured in the correct job categories.
3. Estimate Total Job Cost
What to do
Estimate the total cost required to complete the project.
Example:
Job: Kitchen Remodel
Estimated Total Cost: $160,000
This number usually comes from the original estimate but should be updated if conditions change.
Why it matters
This number determines the percentage of completion.
Formula
Percent Complete = Cost Incurred ÷ Estimated Total Cost
Example:
$80,000 ÷ $160,000 = 50% complete
What goes wrong if skipped
If estimated total cost is not updated:
WIP schedules hide overruns
Job margins look better than reality
Problems surface too late to fix
4. Calculate Earned Revenue
What to do
Multiply contract value by percent complete.
Example:
Contract Value: $200,000
% Complete: 50%
Earned Revenue: $100,000
This represents the revenue the company has actually earned so far.
Why it matters
This creates the bridge between:
job progress
financial statements
Without this step, income statements fluctuate wildly month to month.
What goes wrong if skipped
Contractors end up with:
revenue spikes
confusing profit swings
inaccurate project performance
5. Compare Earned Revenue to Billings
Now compare earned revenue vs invoices sent.
Example:
Overbilled Example
Earned Revenue: $100,000
Billings To Date: $120,000
Difference: $20,000 Overbilled
Underbilled Example
Earned Revenue: $100,000
Billings To Date: $70,000
Difference: $30,000 Underbilled
Overbilled
You’ve billed ahead of the work completed.
Underbilled
You’ve completed work that hasn't yet been invoiced.
Understanding how these affect cash timing is closely related to topics discussed in Accounts Receivable & Collections for Contractors.
Why it matters
Overbilling and underbilling explain why cash and profit rarely match in construction.
What goes wrong if skipped
Contractors often believe:
jobs are more profitable than they are
or that profitable jobs are losing money
Insider Notes / Contractor Gotchas
Underbilling is often a billing system problem
Many contractors delay invoicing until the end of a phase. This creates massive underbilling that distorts financial reporting.
Change orders break WIP schedules when they are delayed
If approved changes are not added to the contract value immediately, the WIP schedule becomes inaccurate.
Job cost delays destroy accuracy
If labor or vendor invoices hit the books weeks late, completion percentages become meaningless.
This is why clean job structure — explained in Job Folder & Project Setup for Contractors (Why Clean Jobs Make or Break Job Costing) — is more important than most contractors realize.
If you want a fast way to see whether your jobs are producing usable cost data, running a Job Costing Health Report can quickly highlight gaps in cost tracking before they affect reporting.
Real-World Impact
When a WIP schedule is built on reliable job data, contractors gain real operational visibility.
They can see:
which jobs are ahead or behind
projected final profit
billing timing issues
hidden job overruns early
Banks and bonding companies also rely on WIP schedules because they show true project performance, not just accounting snapshots.
More importantly, internally it answers a critical question:
Are we actually making money on this job — right now?
That kind of visibility only happens when job costing, project setup, and billing systems are structured correctly.
Summary Framing
A WIP schedule is not just an accounting report.
It is a control system for job profitability.
When built correctly, it connects:
job costs
contract value
billing progress
real profit
Without it, contractors are left guessing about performance until the job is finished.
And by then, the margin is already gone.
If your jobs feel profitable but the numbers never quite match reality, the next step is reviewing the job cost data itself. Running a Job Costing Health Report is often the fastest way to see whether your project reporting is producing the information a proper WIP schedule requires.
If you want to see how contractors can build financial systems that actually reflect job costs and learn more about the philosophy behind our approach, visit Edgestrat Finance.
FAQ
Do contractors really need a WIP schedule?
If you run multiple jobs that last more than a month, a WIP schedule becomes extremely important. It shows whether revenue matches project progress and helps identify underbilling or cost overruns early.
How does a WIP schedule work in QuickBooks?
QuickBooks tracks job costs and invoices, but the WIP schedule itself is usually built using exported job reports and calculations. The accounting system provides the raw data; the WIP schedule organizes it into progress and revenue recognition.
What happens if a contractor does not use a WIP schedule?
Without a WIP schedule, financial statements can show misleading profits or losses depending on when invoices are sent. This makes it difficult to evaluate job performance during the project.
Is a WIP schedule required or just best practice?
Many banks, bonding companies, and CPAs require WIP schedules for construction companies because they provide a clearer picture of project profitability than standard financial reports.
When should contractors start using WIP schedules?
Most contractors should start using WIP schedules once projects extend beyond a single month or when managing multiple active jobs at once.
Disclaimer
This content is for general educational purposes only and does not constitute tax, legal, or accounting advice. Individual circumstances vary, and tax and reporting requirements can change. Always consult a qualified CPA, tax professional, or legal advisor for guidance specific to your business.
