๐ WIP Reporting Guide
Your WIP report tells you if you're actually making money. Learn to read it before your accountant gives you bad news.
Revenue recognition doesn't lie. If your WIP shows fade, you have a problem โ even if cash flow looks fine.
What Is a WIP Report?โ
WIP (Work in Progress) is how contractors recognize revenue and measure job profitability. Unlike retail businesses that recognize revenue at sale, contractors use percentage-of-completion accounting.
The basic formula:
Revenue Earned = Total Contract Value ร Percent Complete
Why WIP Mattersโ
| Stakeholder | Why They Care |
|---|---|
| You | Know if jobs are profitable |
| Bank | Lending decisions, covenant compliance |
| Bonding company | Bonding capacity |
| Accountant | Financial statement accuracy |
| Buyer | Company valuation (if selling) |
Key WIP Conceptsโ
Percent Completeโ
How much of the job is done? Two methods:
Cost-to-Cost Method (Most Common)
% Complete = Costs to Date รท Total Estimated Costs
Gross Profit Method
% Complete = Gross Profit Earned รท Total Estimated GP
Earned Revenueโ
What you've earned based on completion:
Earned Revenue = Contract Value ร % Complete
Billings to Dateโ
What you've actually billed the owner (from pay apps).
Over/Under Billingโ
The relationship between earned and billed:
| Situation | Meaning |
|---|---|
| Overbilled | Billed more than earned (liability) |
| Underbilled | Billed less than earned (asset) |
Reading a WIP Reportโ
Sample WIP Lineโ
| Field | Value |
|---|---|
| Contract Value | $1,000,000 |
| Estimated Total Cost | $850,000 |
| Estimated GP | $150,000 (15%) |
| Costs to Date | $425,000 |
| % Complete | 50% |
| Earned Revenue | $500,000 |
| Billings to Date | $550,000 |
| Overbilled | $50,000 |
This job is overbilled by $50,000 โ you've billed ahead of where you actually are.
What Over/Underbilling Tells Youโ
Consistently Overbilled:
- โ Good cash flow management
- โ ๏ธ Could indicate front-loading
- โ ๏ธ May have cash crunch at closeout
Consistently Underbilled:
- โ Poor cash flow
- โ May indicate billing problems
- โ Financing your owner's project
Large Overbilling:
- ๐จ Possible job problems hidden
- ๐จ May have underestimated costs
- ๐จ Bank/bonding company concern
Cost-to-Complete Analysisโ
The most critical WIP input is your Estimated Cost to Complete.
Getting It Rightโ
Wrong approach: Take budget, subtract costs to date
Right approach: Bottom-up estimate of remaining work
- What's left to do?
- What will it cost?
- Any known problems?
- Update monthly
Cost Fadeโ
When estimated total costs increase:
Example:
- Original estimate: $850,000
- Month 1: Still $850,000
- Month 2: Now $880,000
- Month 3: Now $920,000
This is "fade" โ your job is getting worse. Catch it early.
Red Flagsโ
- % complete stuck at same level
- Costs growing faster than progress
- Estimated GP shrinking monthly
- Large underbilling appearing
WIP Best Practicesโ
Monthly Review Processโ
- Update estimates โ Every PM reviews every job
- Challenge assumptions โ Question unchanged estimates
- Document issues โ Note risks and contingencies
- Review with management โ Don't let PMs hide problems
- Reconcile to GL โ Costs match accounting records
Estimate to Complete Tipsโ
- Be honest (optimism doesn't help)
- Include known change orders
- Account for punch list and closeout
- Consider warranty reserves
- Update for schedule changes
Common Mistakesโ
โ Using budget minus costs โ Not a real estimate
โ Not updating monthly โ Stale data is dangerous
โ PM hiding problems โ Culture of honesty required
โ Ignoring underbillings โ Cash flow matters
โ Forgetting closeout costs โ Punch list, documentation, warranty
WIP for Bondingโ
Your bonding company reviews WIP to assess:
- Are jobs profitable?
- Any problem jobs?
- Over/underbilling patterns
- Cost fade trends
What they want to see:
- Consistent gross profit margins
- Reasonable over/underbilling
- No large cost fades
- Accurate historical estimates
WIP for Bankingโ
Your bank uses WIP to:
- Calculate working capital
- Assess borrowing base
- Monitor covenant compliance
- Evaluate credit risk
Key metrics:
- Underbillings are assets
- Overbillings are liabilities
- Net position affects working capital
Schedule of Values vs. WIPโ
They're not the same:
| SOV % | Based on... |
|---|---|
| Pay app percent | What you billed |
| WIP % | Based on... |
|---|---|
| Cost percent | What you actually spent |
If these diverge significantly, you have overbilling/underbilling.
Get Controlโ
Free Template: Download our WIP report template for Excel.
Track Automatically: BLDR Pro tracks job costs in real-time, so your WIP is always current โ no more month-end scrambles to update estimates.