What is a WIP schedule and why does every builder need one?

For custom home builders and residential remodeling contractors managing multiple projects at once, bank balance accounting is a dangerous trap. It’s entirely common for a growing builder to see $300,000 sitting in their business checking account while being only weeks away from serious financial trouble. Why? Because in residential construction, cash received does not equal revenue earned.

A work-in-progress (WIP) schedule, also called a WIP report or percentage-of-completion schedule, is an accounting document that matches recognized project revenue with actual costs incurred to date. Unlike standard monthly profit-and-loss statements, which rely on simple cash deposits or invoice dates, a WIP schedule calculates exactly how much revenue a builder has legally and operationally earned based on physical progress on the job site.

Building on the core principles in our guide on how to calculate job costs in residential construction and our comparison of construction job costing vs. general accounting, the WIP schedule serves as the bridge between field operations and enterprise financial health. Without one, a builder running five custom home builds can’t answer three basic financial questions:

1. True project profitability. Are my active jobs operating at their projected profit margins, or are hidden labor overruns eating into my bottom line?
2. Cash flow vs. profit liability. Is the money in my bank account actual profit I can draw, or unearned client capital I have to pay out to subcontractors next month?
3. Risk of under-billing. Have I completed work on site that I haven’t billed the client for, effectively financing their custom home interest-free?

For general contractors, custom builders and commercial sub-trades alike, the WIP schedule isn’t an optional accounting exercise. It’s the single most important financial radar in construction business management. It gives immediate clarity across multi-project portfolios and protects margins before jobs close.

Overbilling and underbilling explained: The hidden financial forces

The real power of a WIP schedule is its ability to flag overbilling (billings in excess of costs and estimated earnings) and underbilling (costs and estimated earnings in excess of billings). These two metrics are the hidden financial forces that determine whether a construction company stays solvent during growth.

Overbilling: Borrowing profit from tomorrow to pay for today

Overbilling happens when a builder has billed the client more than the percentage of completed work justifies. For example, if a builder bills a client 40% of the total contract price on a custom home build, but actual cost code tracking shows only 25% of total estimated job costs have been incurred, the project is overbilled by 15%.

Operational impact of overbilling: Overbilling is common in residential construction because builders structure draw schedules to stay ahead of expenses. On the surface, it creates positive cash flow. But overbilling creates a financial liability. That excess cash is unearned revenue, money that belongs to future construction phases such as drywall, mechanicals and finishes. If a builder spends it on overhead, personal draws or covering losses on another project, they’ll face a serious cash crunch when trade invoices arrive later in the project.

Underbilling: Financing the client’s custom build

Underbilling happens when a builder has completed physical work on site but billed the client less than the percentage of completion calls for. For example, if a remodeling contractor has incurred 60% of total estimated project costs on a major structural renovation but has only billed the client 45% of the contract value, the job is underbilled by 15%.

Operational impact of underbilling: Underbilling is a direct drain on a builder’s working capital. It means the contractor is using their own cash reserve or line of credit to pay trade partners and material suppliers for work already completed on the client’s property. Persistent underbilling usually signals operational breakdowns, such as delayed billing cycles, unapproved field change orders or unlogged labor hours. On a balance sheet, underbilling shows up as an asset (unbilled receivables), but in practice, it restricts liquidity.

Anatomy of a WIP report: How to read the essential columns

To non-accountants, a work-in-progress spreadsheet can look intimidating, with dozens of numerical columns. But reading a WIP report gets simple once you understand the math behind six core columns.

Here’s the step-by-step breakdown of how a standard WIP schedule is built across active project lines:

WIP column name	Mathematical formula / input	Operational definition and significance
1. Total contract price	Original contract + approved change orders	The total agreed revenue the client will pay for the project upon completion.
2. Total estimated costs	Original estimated COGS + approved cost changes	The baseline budget required to complete the build.
3. Actual costs to date	Sum of direct labor, materials and sub invoices	Total dollars spent on the job site to date across all cost codes.
4. Percentage of completion (% complete)	Actual costs to date ÷ total estimated costs	The true physical and financial benchmark measuring project completion.
5. Earned revenue	Total contract price × % complete	The exact dollar amount of revenue the builder has legally earned based on site progress.
6. Total billed to date	Sum of all client draw invoices issued	Total dollar amount billed to the homeowner or commercial client to date.
7. Over/(under) billing	Billed to date − earned revenue	Positive value equals overbilling (liability). Negative value equals underbilling (asset).

Fully worked-out financial example: The $600,000 custom build

To understand why cash-basis accounting distorts builder profitability, let’s walk through a real-world numerical example of a custom home project managed by Summit Custom Builders.

Project baseline financials

• Total contract price: $600,000
• Total estimated costs (COGS): $480,000
• Estimated gross profit: $120,000 (20% gross margin)

Month 4 operational progress status

At the end of month four, Summit Custom Builders has completed foundation, framing and rough mechanicals. Their financial tracking shows:

• Actual costs incurred to date: $240,000 (framing sub invoices, lumber packages, foundation concrete).
• Total billed to date: $360,000 (collected 60% of contract value via initial draw schedule).

The traditional accountant’s P&L view (without WIP)

If Summit Custom Builders relies solely on a standard profit-and-loss statement from general accounting software, their month-end report looks extraordinarily profitable:

• Revenue billed: $360,000
• Less expenses paid: ($240,000)
• Reported P&L net income: $120,000 (apparent 33.3% margin)

The owner might celebrate seeing $120,000 in net profit. But that figure is a dangerous financial illusion.

The WIP schedule view (percentage-of-completion accounting)

Now let’s run the same numbers through a work-in-progress calculation:

• Step 1: Calculate % complete. $240,000 (actual costs) ÷ $480,000 (estimated costs) = 50% complete.
• Step 2: Calculate earned revenue. $600,000 (contract price) × 50% (% complete) = $300,000 earned revenue.
• Step 3: Calculate over/under billing variance. $360,000 (billed to date) − $300,000 (earned revenue) = +$60,000 overbilling.
• Step 4: Calculate true earned gross profit. $300,000 (earned revenue) − $240,000 (actual costs) = $60,000 true earned profit (20% margin).

The financial reality uncovered by WIP

The standard P&L reported $120,000 in profit. The WIP schedule proves the exact profit earned to date is only $60,000. The remaining $60,000 in the builder’s bank account isn’t profit. It’s an overbilling liability representing unearned client cash that must fund the remaining $240,000 in upcoming drywall, finish carpentry and landscaping costs. Without this insight, the builder might spend that $60,000 on overhead, leaving the company insolvent during project completion.

How automated WIP generation in Buildertrend makes complex calculations accessible

Historically, generating a monthly WIP report required an experienced construction CPA or hours of tedious manual spreadsheet maintenance. According to the Association of Professional Builders’ State of Residential Construction Industry report, over 50% of residential contractors struggle with accurate financial forecasting because of disconnected systems. Manual spreadsheets introduce formula breakage, data entry lag and version control errors.

Buildertrend turns complex percentage-of-completion accounting into an automated, real-time workflow accessible to non-accountant builders. Here’s how modern construction technology automates the WIP schedule:

Step 1: Centralized cost code budget setup.

When a project is estimated in Buildertrend, baseline cost code budgets get established automatically. Every line item, from excavation to finish hardware, is assigned to a standard cost code, setting the exact total estimated costs baseline.

Step 2: Live expense and committed cost capture.

As field supervisors capture material receipts on mobile devices and subcontractor invoices are processed, expenses tag directly to project cost codes. At the same time, issued construction purchase orders lock in committed costs, so actual costs to date update continuously without waiting for end-of-month bookkeeping.

Step 3: Seamless change order synchronization.

When homeowners request upgrades, digital change orders managed through Buildertrend change order software automatically update both the total contract price and the underlying estimated cost budgets once the client approves electronically. That eliminates stale budget figures that corrupt WIP calculations.

Step 4: Automated percent complete and revenue recognition.

Buildertrend’s financial engine continuously calculates actual costs ÷ estimated costs across every active cost code. The system instantly generates earned revenue figures, compares them against client draw schedules and flags overbilling and underbilling variances across your entire active job portfolio.

Step 5: Direct accounting integration push.

Rather than maintaining duplicate books, Buildertrend pushes WIP journal entries directly to QuickBooks Online, QuickBooks Desktop or Xero via Buildertrend accounting software integrations. That ensures your corporate balance sheet reflects accurate overbilling liabilities and underbilling assets for bank reporting and tax preparation.

Strategic decision-making framework: WIP maturity for growing builders

As outlined in the Buildertrend “Modern builder playbook,” financial literacy is the primary dividing line between contractors who plateau at $1 million in revenue and those who scale sustainably past $10 million. Here’s how builder growth stages typically line up with WIP management readiness:

Builder stage and volume	Financial management approach	WIP capability and risk level
Emerging builder ($0 to $500,000 volume)	Cash-basis or simple accrual accounting in QuickBooks Online, with manual checking account tracking.	No WIP schedule. High risk of mistaking client draw deposits for personal profit.
Transitioning builder ($500,000 to $2 million volume)	Job costing in accounting software plus periodic manual WIP spreadsheets.	Basic WIP tracking that’s prone to formula breakage and delayed change order entry.
Scaling builder ($2 million to $20 million-plus volume)	Automated percentage-of-completion WIP in Buildertrend synced to QuickBooks or Xero.	Real-time portfolio WIP, active margin protection, accurate bank bonding and zero cash surprises.

Frequently asked questions