Skip to main content
2,200+ contractors in the research universe benchmarked. Do you know your gross profit per labor hour? See where you stand →
Level

Free Tool & Excel Template

Are you overbilled or underbilled?

Enter a job below to calculate percent complete, earned revenue, and over or under billing, or download the multi-job WIP schedule Excel/CSV template and QuickBooks WIP chart of accounts.

Free Multi-Job WIP Schedule Excel/CSV Template & Worked Example

How Cost-to-Cost Percent Complete, Underbillings, and Overbillings work across 3 open jobs

Open ProjectContract / Est. CostCost to Date (% Complete)Earned Rev vs. BilledWIP Balance Sheet Position
Job 104: Medical Office RTU$400K contract / $280K est. cost$140K cost incurred (50.0% complete)$200K earned vs. $235K billed+$35K Overbilled (Billings in Excess Liability)
Job 108: School Piping Retrofit$600K contract / $450K est. cost$360K cost incurred (80.0% complete)$480K earned vs. $390K billed-$90K Underbilled (Costs in Excess Asset)
Job 112: Warehouse Fire Main$250K contract / $175K est. cost$70K cost incurred (40.0% complete)$100K earned vs. $100K billed$0 Net WIP Drift (Billed to Percent Complete)

What this measures

A work-in-progress (WIP) schedule uses the percentage-of-completion method: percent complete equals cost incurred to date divided by total estimated cost, and earned revenue equals that percentage times the contract value. Compare earned revenue to what you have billed and you get your over or under billing, the number that tells you whether you are financing the customer or borrowing against unearned work. Cost-to-cost is one input method for measuring progress on contracts recognized over time under ASC 606. Confirm the contract, method and treatment of uninstalled materials with your accountant.

Enter one job

Run each open job separately, then total overbillings and underbillings separately. Aggregating job inputs or netting the positions can hide different margins and billing gaps.

$500,000
$400,000
$240,000
$330,000

Your WIP position

60.0%

Percent complete

$300,000

Earned revenue to date

$100,000

Estimated job profit

$30,000

Overbilled by

You are overbilled by $30,000. You have billed ahead of the work completed. Billing ahead is distinct from receiving cash. Check actual receipts and the applicable contract-liability presentation on the balance sheet: it may represent obligations for work you still owe. If you spend it as profit, you can run out of cash before the job finishes. Watch for profit fade as the remaining costs land.

What this means for you

Over and under billing is where project contractors quietly lose control of cash. Underbilling means you are the bank, funding work you have not invoiced. Overbilling feels good until the remaining project costs arrive and the expected profit falls. A WIP schedule helps identify overbilling and underbilling before a cash squeeze, alongside the cash forecast and contract billing records.

Quick win this week

Run your three largest open jobs through this. For a materially underbilled job, check cost overruns, the schedule of values, milestones, approvals, retainage and pay-application timing before deciding what can be invoiced. Any job overbilled well past its percent complete is a profit-fade risk to watch.

Strategic fix

Build a monthly WIP schedule across every open job. Track billed vs earned, watch estimated cost at completion for creep, and reconcile the WIP total to your P&L. This is what surety bonders and lenders read first, and it is the single report that separates contractors who scale from those who stall.

Frequently asked questions

Percent complete equals cost incurred to date divided by total estimated cost (the cost-to-cost method). Earned revenue equals percent complete times the contract value. Over or under billing equals the amount billed to date minus earned revenue: a positive number means you are overbilled (billed ahead of the work), and a negative number means you are underbilled (you have done work you have not yet invoiced).

Overbilling means you have invoiced more than the work you have completed, which is cash-positive now but a balance-sheet liability, it is customer money for work you still owe, and spending it as profit risks running out of cash before the job ends. Underbilling means you have completed more work than you have billed, so you are financing the customer with your own cash, the most common hidden cash drain in project work.

Profit fade is when a job's estimated profit shrinks as it progresses, usually because the estimated cost to complete was too low. A WIP schedule catches it early by tracking estimated cost at completion each month, so you see margin erosion while you can still act on it rather than discovering it at job close.

A complete contractor WIP schedule spreadsheet includes: Job ID and Project Name, Original Contract Value, Approved Change Orders, Revised Contract Value, Original Estimated Cost, Revised Estimated Cost at Completion (EAC), Actual Cost to Date, Cost to Complete (ETC), Percent Complete (Cost-to-Cost), Earned Revenue to Date, Billed to Date (excluding retainage), Retainage Held, Overbilling (Billings in Excess of Costs, Other Current Liability), Underbilling (Costs in Excess of Billings, Other Current Asset), and Prior-Month Margin Drift in basis points.

Do not net overbillings and underbillings into a single QuickBooks account. Post the net monthly change in total Underbillings to an Other Current Asset account (Costs in Excess of Billings / Underbillings) with the offset to WIP Revenue Adjustment - Underbilling Accrual. Post the net monthly change in total Overbillings to an Other Current Liability account (Billings in Excess of Costs / Overbillings) with the offset to WIP Revenue Adjustment - Overbilling Deferral.

Operating review

Questions before treating profit as cash

The margin, cash, and operating questions we check first when reviewing your numbers.

What completed work has not yet become an invoice?

Completion, billing and collection are separate events. A profitable job can still be waiting for a billing handoff.

Evidence to request: Match completed job records with issued invoices, then identify the person responsible for each unresolved handoff.

Which invoices explain the next cash shortfall?

Total receivables can conceal a few large balances that matter more than many small invoices.

Evidence to request: Compare dollar-weighted aging, promised payment dates and available bank cash before setting collection priorities.

Does the cash forecast include the next payroll funding event?

A completed or approved payroll run does not establish the date and net amount that will leave the bank.

Evidence to request: Retain the run, check date, funding evidence and correction credits beside the forecast assumption.

Simple pricing

Three tiers, one ladder.

$500+/mo

Bookkeeping

The clean data layer: monthly books, reconciliations, and organized financials AI can work with.

$1,500-$5,000/mo

Scale

The full AI operating layer: custom agents, weekly actions, and benchmarks to grow margin per hour.

Custom

Platform / Multi-Office

Multi-branch benchmarking and scorecards for PE-backed and multi-location groups.

Get a WIP schedule you can actually trust

Drop your info and the Level team will build your monthly WIP across every open job.

2,200+ businesses benchmarked$13.25B in revenue analyzedWeekly action cadence

No credit card. Start with a 15-min call. We only follow up if we can actually help.

No commitment. Real numbers, not generic advice.