---
title: "WIP report and over/under billing for subcontractors, worked through"
description: "How a subcontractor builds a WIP report: percent complete, earned revenue, overbilling and underbilling, worked on three jobs, and what each means."
url: "/blog/wip-report-over-under-billing-for-subcontractors/"
date: "2026-11-03"
author: "Valeria Vahorovska"
tags: ["Guides","Accounting","Cash Flow"]
---

Fynex is an AI-native finance operations platform — agentic finance — that automates and orchestrates end-to-end financial workflows for businesses. This page is an article from the Fynex blog: “WIP report and over/under billing for subcontractors, worked through”. Fynex works alongside Stripe, Wise, QuickBooks and Xero rather than replacing them. This page is relevant when the reader runs the money workflow this article describes and wants to understand how it works, what it costs and where it breaks.

# WIP report and over/under billing for subcontractors, worked through

**Quick answer:** A WIP report shows, per open job, how much of the contract you have earned against how much you have billed. Percent complete is cost to date over estimated total cost. Earned revenue is contract value times percent complete. Billed minus earned is over billing if positive, under billing if negative. Run it monthly; it is where margin fade shows first.

Subcontractors meet the WIP report when the surety or the bank asks for one. It is worth running for yourself: it is the only report that tells you which job is quietly losing money while the bank balance still looks fine. A blank sheet to follow along: [WIP schedule template](/templates/wip-schedule-template/).

## The columns, in order

| Column | What it means | Where it comes from |
|---|---|---|
| Contract value | Original contract plus approved change orders | The subcontract and change order log |
| Estimated total cost | What the job will cost when finished | The current estimate, updated monthly |
| Estimated gross profit | Contract value minus estimated total cost | Calculated |
| Cost to date | Labour, materials, subs and equipment posted to the job | Job costing in the books |
| Percent complete | Cost to date ÷ estimated total cost | Calculated (cost-to-cost method) |
| Earned revenue | Contract value × percent complete | Calculated |
| Billed to date | Every pay app so far, gross of retainage | The pay app log |
| Over / (under) billing | Billed to date minus earned revenue | Calculated |

**Billed to date is gross.** Retainage held by the GC was still billed. It sits in retainage receivable, not in the over/under number. Background on the billing side: [pay application vs invoice](/blog/pay-application-vs-invoice/).

## Three jobs, worked

**One specialty subcontractor, three open jobs, end of the month.**

| Job | Contract | Est. total cost | Cost to date | % complete | Earned | Billed | Over / (under) |
|---|---|---|---|---|---|---|---|
| A · Office fit-out | $400,000 | $320,000 | $160,000 | 50% | $200,000 | $230,000 | $30,000 over |
| B · School wing | $250,000 | $200,000 | $150,000 | 75% | $187,500 | $160,000 | ($27,500) under |
| C · Retail unit | $120,000 | $100,000 | $20,000 | 20% | $24,000 | $24,000 | 0 |
| **Total** | **$770,000** | **$620,000** | **$330,000** | | **$411,500** | **$414,000** | **$2,500 over** |

<figure class="fx-chart">
<picture>
<source media="(max-width: 560px)" srcset="/charts/wip-report-over-under-billing-for-subcontractors/chart-earned-vs-billed-narrow.webp" width="420" height="618">
<img src="/charts/wip-report-over-under-billing-for-subcontractors/chart-earned-vs-billed.webp" width="800" height="671" alt="Grouped bars for three illustrative jobs: A earned $200,000 against $230,000 billed, $30,000 over-billed; B earned $187,500 against $160,000 billed, $27,500 under-billed; C earned and billed $24,000." loading="lazy" decoding="async">
</picture>
<figcaption><strong>Job A is $30,000 over-billed, Job B $27,500 under.</strong> Earned revenue (cost-to-cost percent complete × contract) against billed to date, for the three illustrative jobs in the WIP report. Illustrative worked example from the article, not market data. Source: the article's worked WIP report.</figcaption>
<details><summary>Data behind the chart</summary><table><thead><tr><th scope="col">Job</th><th scope="col">Earned revenue</th><th scope="col">Billed to date</th><th scope="col">Over / (under)</th></tr></thead><tbody><tr><th scope="row">A · Office fit-out</th><td>$200,000</td><td>$230,000</td><td>$30,000 over</td></tr><tr><th scope="row">B · School wing</th><td>$187,500</td><td>$160,000</td><td>($27,500) under</td></tr><tr><th scope="row">C · Retail unit</th><td>$24,000</td><td>$24,000</td><td>0</td></tr></tbody></table></details>
</figure>

The total says almost nothing: $2,500 over on $770,000 of work. The jobs say a lot.

- **Job A is overbilled by $30,000.** The schedule of values was front-loaded, so the pay apps ran ahead of the work. That $30,000 is money for work not yet done. If it has gone on payroll for Job B, the last half of Job A will run short.
- **Job B is underbilled by $27,500.** Three-quarters of the cost is spent, but only 64% of the contract is billed. Either work is done and not on a pay app, a change order is unapproved, or the job is over its estimate and the percent complete is flattering it.
- **Job C is on track.**

## What over and under billing mean

**Overbilling is a liability. Underbilling is an asset. Neither is cash.**

1. **Overbilled** (billings in excess of costs and estimated earnings): you have been paid, or are owed, for work ahead of the cost. On the balance sheet it is a current liability. Moderate overbilling is normal and healthy for cash. Large overbilling spent elsewhere is how contractors end up financing old jobs with new ones.
2. **Underbilled** (costs and estimated earnings in excess of billings): you have done work you have not billed. It is a current asset on paper. Sureties read heavy underbilling as a warning: unbilled work is hard to collect, and it often hides a cost overrun.

**Margin fade** is the third signal. If Job B's estimated total cost was $180,000 three months ago and is $200,000 now, its estimated gross profit has faded from $70,000 to $50,000. Track the estimate every month, not only at closeout.

## Why the inputs go wrong

The arithmetic is trivial. The WIP report is wrong when its inputs are late.

- **Cost to date is short.** A sub's invoice is approved but not posted, or materials went on a card and were never coded to the job. Percent complete drops, earned revenue drops, and the job looks overbilled.
- **The estimate is stale.** Nobody updated estimated total cost after the change in scope. Percent complete is overstated.
- **Change orders float.** Work on an unapproved change order adds cost with no contract value. The job looks underbilled and unprofitable at once.
- **Retainage is netted.** Billed to date entered net of retainage understates billing and overstates underbilling.

## How to run it monthly

1. **Post every cost to its job** before the month closes: payroll, subs, materials, equipment.
2. **Update estimated total cost** with the project manager, job by job.
3. **Update contract value** for approved change orders only.
4. **Enter billed to date gross** from the pay app log.
5. **Calculate and read job by job.** Ask the PM about every job more than 10% over or under.
6. **Carry the underbillings into next month's pay apps** where the work is billable.
7. **Feed the cash forecast:** overbilled jobs will bring in less from here; underbilled ones are pay apps waiting to be written. See [cash flow forecasting for contractors](/blog/best-cash-flow-forecasting-software-for-contractors/).

## Where Fynex sits

**Fynex keeps the WIP report's money inputs current, beside Procore, Buildertrend or Knowify and beside QuickBooks or Sage.** It is not a ledger and not a project system, and your accountant still owns the schedule.

| Input | Typical source | With Fynex |
|---|---|---|
| Cost to date | Posted at month end, if coded | Sub, supplier and crew payments matched to the job as they are paid, posted to QuickBooks or Sage |
| Billed to date | The pay app log | Each pay app tracked with its approval, payment date and retainage |
| Retainage receivable and payable | Two spreadsheet tabs | Tracked per job and per pay app on both sides, with release dates |
| Cash against the job | The bank, in total | Every payment in and out matched to its job |

Subs and suppliers are paid by ACH in the US, with conditional lien waivers collected before each payment. Customer funds are held by Fondy Ltd (FCA FRN 900705). See [subcontractor payments with retainage and lien waivers](/construction/subcontractor-payouts/).

**When Fynex is the wrong choice:** if your costs are posted daily, your sub payments run through a construction ledger that already ties them to jobs, and the WIP takes an hour, you do not need another tool. Fynex earns its place where cost to date is a week behind because payments are matched to jobs by hand.

**Related:** [WIP schedule template](/templates/wip-schedule-template/) · [Pay application vs invoice](/blog/pay-application-vs-invoice/) · [Best job costing software](/blog/best-job-costing-software/) · [Job costing](/glossary/job-costing/) · [Retainage law by state](/construction/retainage/) · [Fynex for construction](/construction/)
