Skip to main content
Skip to main content

๐Ÿ“Š 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.

The Truth Is in the WIP

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โ€‹

StakeholderWhy They Care
YouKnow if jobs are profitable
BankLending decisions, covenant compliance
Bonding companyBonding capacity
AccountantFinancial statement accuracy
BuyerCompany 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:

SituationMeaning
OverbilledBilled more than earned (liability)
UnderbilledBilled less than earned (asset)

Reading a WIP Reportโ€‹

Sample WIP Lineโ€‹

FieldValue
Contract Value$1,000,000
Estimated Total Cost$850,000
Estimated GP$150,000 (15%)
Costs to Date$425,000
% Complete50%
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โ€‹

  1. Update estimates โ€” Every PM reviews every job
  2. Challenge assumptions โ€” Question unchanged estimates
  3. Document issues โ€” Note risks and contingencies
  4. Review with management โ€” Don't let PMs hide problems
  5. 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 percentWhat you billed
WIP %Based on...
Cost percentWhat 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.