QuickBooks Online cannot produce a WIP schedule for homebuilders on its own, and neither a PM-tool sync nor a bolt-on connector fixes that gap — they move transactions, not reports. Builders forced onto QuickBooks end up rebuilding their WIP in Excel every month, leaving numbers weeks stale by the time anyone reads them.
Key takeaways
WIP and QBO: QuickBooks Online records posted transactions but has no native capability to compute percent complete, earned revenue, or over/under billing by lot.
Where the data lives: Contract price, total estimated cost, cost-to-date, and progress billings live in the PM tool and lender draw schedule — not in QuickBooks Online.
The formula: Percent complete under the cost-to-cost method equals cost-to-date divided by total estimated cost, and overbilling occurs when progress billings exceed revenue earned.
Two approaches: The SmoothX-plus-Excel workaround leaves numbers weeks stale; a live-data platform that reads Buildertrend, Procore, or JobTread in real time computes WIP natively without a manual rebuild step.
Homebuilder specificity: Homebuilder WIP differs from general contractor WIP because of lot and land cost separation, construction loan draws, and the choice between percentage-of-completion and completed-contract revenue recognition.
What is a WIP schedule for homebuilders?
A WIP schedule is a lot-by-lot report showing percent complete, revenue earned to date, and over/under billing for every active build in a homebuilder's portfolio. Under percentage-of-completion accounting — the practice of recognizing revenue as construction progresses rather than at closing — the WIP schedule is the document that ties earned revenue to actual build progress, preventing a large lender draw from being mistakenly recorded as profit.
For lenders and bonding companies, the WIP schedule is often a required deliverable. It demonstrates that draws align with completed work and that the builder isn't pulling ahead of construction. A platform like Flow ERP computes that schedule from live project data rather than requiring a manual Excel rebuild each period. Without that kind of real-time connection, the WIP schedule is always a rear-view mirror — accurate as of a date that's already passed.
Where do the numbers in a homebuilder WIP schedule come from?
The four inputs a WIP schedule requires — contract price, total estimated cost, cost-to-date, and progress billings or draws — live in the PM tool and the lender draw schedule, not in QuickBooks Online. QuickBooks only sees transactions after they've been posted to the ledger, so it has no visibility into contract values, budget totals, or draw schedule milestones. That structural gap is why rebuilding WIP in Excel every month isn't a workaround failure — it's the only option QuickBooks gives you.
What the PM tool holds
Buildertrend, Procore, and JobTread each store the core data a WIP schedule needs: contract price by job, estimated total cost broken down by phase, cost-to-date as costs are posted against the job, and draw milestone progress tied to inspection approvals. This is where the live numbers live throughout the build. For more on how job-cost accounting for homebuilders works end-to-end, the mechanics start here in the PM tool.
What QuickBooks Online actually sees
QuickBooks Online sees posted AP transactions, checks, and invoices — the downstream financial record of costs that have already been incurred and entered. It has no field for contract value or total estimated cost at the job level. That means QBO can tell you what you've spent, but it can't tell you what percentage of a $600K contract that spending represents or whether you've billed ahead of or behind your actual progress.
How do you calculate WIP for a homebuilding project?
Homebuilder WIP is calculated using the cost-to-cost method, where percent complete equals cost-to-date divided by total estimated cost. All three WIP formulas follow directly from that starting point and can be applied lot-by-lot once you have the four required inputs from your PM tool and draw schedule.
The three core WIP formulas
Percent complete = cost-to-date ÷ total estimated cost
Tells you what fraction of the project's total budgeted cost has been incurred — the basis for all downstream WIP calculations.Revenue earned = percent complete × contract price
Tells you how much revenue you've legitimately earned through the reporting date, regardless of how much you've billed.Over/under billing = revenue earned − progress billings
A positive result means you're underbilled (you've earned more than you've collected); a negative result means you're overbilled (you've collected more than you've earned).
Worked example: $600K homebuilding contract
The following example walks through a single-lot WIP calculation using all three formulas in sequence.
The result tells you the builder has collected $50,000 more than the work completed justifies. Left uncorrected, that overbilling creates a future obligation — work that must be performed against cash already received. Lenders and AICPA-CIMA guidance both flag persistent overbilling as a financial risk indicator that should appear on the WIP schedule and be reconciled monthly.
The table below defines each WIP schedule component for builders building their first schedule or auditing an existing one.
What makes homebuilder WIP different from standard construction WIP?
Homebuilder WIP differs from general contractor WIP in four specific ways: draws are tied to lender inspections rather than billing milestones, lot and land costs must be capitalized separately from vertical construction, spec and presold homes follow different revenue recognition methods, and change orders reset the estimated cost denominator mid-build. Generic construction WIP guides skip all four of these distinctions — which is why homebuilder finance teams spend time adapting templates that were never built for them.
Spec homes vs. custom/presold contracts
Spec builders — those constructing homes before a buyer is under contract — frequently use completed-contract accounting, the practice of recognizing all revenue at the closing date rather than as construction progresses. Presold and custom contract builders typically use percentage-of-completion instead. The WIP schedule structure differs between these two methods: under completed-contract, the schedule tracks capitalized inventory and costs-in-progress rather than earned revenue by period. A builder running both spec and presold inventory needs a WIP schedule that handles both revenue recognition methods simultaneously. SEC guidance and Forvis Mazars both treat the method selection as an entity-level accounting policy that requires consistent application across all jobs in the same category.
Land and vertical cost separation
Homebuilder WIP must separate lot acquisition and land development costs — capitalized as CIP (construction-in-progress), meaning costs accumulated on the balance sheet during the build period — from the vertical construction costs used to compute percent complete. Lumping land cost into the cost-to-date numerator inflates the percent-complete calculation and understates the remaining cost to finish. A $150,000 lot cost included in a $360,000 cost-to-date figure turns a 75% complete job into a 50% complete job once land is properly stripped out.
Construction loan draws and lender draw schedules
For homebuilders, "progress billings" are frequently lender-approved construction loan draws — disbursements tied to inspection milestones set by the lender rather than invoices sent to a buyer. The draw schedule is managed between the builder, the title company, and the lender, and it lives entirely outside QuickBooks. That's the key reason the draw schedule isn't in QBO: it's not an AR transaction until it posts; it's a financing event driven by the lender's inspection process. See construction accounting for multi-location homebuilders for how draw timing affects cash flow management across an active lot portfolio.
Change orders and budget resets
Approved change orders increase both the contract price and the total estimated cost, which resets the percent-complete denominator and can swing a job from overbilled to underbilled in a single entry. A $40,000 approved upgrade added to a 75%-complete job with a $480,000 budget drops percent complete to roughly 69% — a 6-point swing that changes the revenue earned calculation by $36,000. Change orders not entered promptly into the PM tool are one of the most common sources of WIP inaccuracy, and the error compounds every month the update is delayed.
Why can't QuickBooks Online generate a WIP report for homebuilders?
QuickBooks Online has no fields for contract value, total estimated cost, or percent complete — the three inputs a WIP schedule requires — because it was built as a bookkeeping ledger, not a job-cost reporting engine. PM-tool syncs like SmoothX move transaction data into QuickBooks but don't create WIP fields or compute earned revenue. Connectors and sync add-ons move transactions; they don't move the report.
According to LiveFlow's Finance in the AI Era report (May 2026), 78% of finance teams still move data primarily via manual spreadsheet exports — and for homebuilder WIP, that manual step isn't optional on QuickBooks. There's no configuration change or integration that gives QuickBooks a contract-value field. The Excel rebuild is the architecture. Finance teams that want to understand when homebuilders outgrow QuickBooks Online consistently find WIP reporting as one of the first friction points that triggers the evaluation.
Deloitte's research on finance operations confirms that manual data movement between systems is the leading driver of reporting lag in mid-market companies — a pattern that shows up plainly in homebuilder finance teams that export cost data from a PM tool, enter it manually into a spreadsheet, and then apply WIP formulas by hand each month.
What are your two options for getting a live homebuilder WIP schedule?
Homebuilders on QuickBooks have two practical options for getting a WIP schedule: build and maintain one manually in Excel using a sync add-on like SmoothX to pull transaction data, or move to a platform that reads job data from Buildertrend, Procore, or JobTread in real time and computes WIP natively. Both are real options with different tradeoffs — the choice depends on how many active lots you're managing and how much manual work your team can absorb each month.
The workaround: sync add-on plus Excel
The SmoothX-plus-Excel workflow operates as follows: transactions sync from QuickBooks into a spreadsheet, the controller manually inputs the contract price and total estimated cost for each lot, and WIP is computed by formula. The failure modes are predictable — sync lag between the PM tool and QBO means cost-to-date is always a few days behind; formula errors compound across dozens of lots; estimated costs go stale when change orders aren't updated; and the whole schedule is as current as the last time someone ran the sync and updated the sheet. For a builder managing 10 active lots, that's a manageable monthly task. For a builder managing 40, it's a half-week project every close. Harvard Business Review research on finance operations confirms that manual reconciliation work scales linearly with transaction volume — which is exactly what happens to Excel-based WIP schedules as lot count grows.
The live-data approach: Flow ERP
Flow ERP reads project data directly from Buildertrend, Procore, or JobTread in real time and computes WIP without a manual rebuild step. The WIP schedule updates as costs post and draw milestones are approved, so the numbers are current throughout the month rather than accurate as of the last Excel refresh. Flow also adds cash-flow forecasting by job on top of the WIP schedule, giving finance teams a forward view of draw timing and cash requirements alongside the backward-looking earned revenue calculation.
Flow ERP's AI Month-End Close Agent runs a dynamic close checklist tied to actual data rather than a static template, so each lot's WIP status is part of the close review rather than a separate offline exercise. Bank reconciliation runs continuously via Plaid rather than as a month-end batch, so close starts mostly reconciled. That combination means the WIP schedule isn't assembled under close-deadline pressure — it exists throughout the period. Gartner identifies continuous-close capability as a top-three differentiator in ERP selection for construction finance teams, and it's where the Excel workaround breaks down most visibly for growing homebuilders. For teams evaluating an ERP built for homebuilders, the absence of a monthly rebuild step is the most immediate operational change.
Ready to close your books with a live WIP schedule?
Homebuilders who want accurate WIP without a monthly Excel rebuild need a platform that computes it from live project data, not a sync add-on layered onto QuickBooks. The lot-by-lot view, lender draw reconciliation, and cash-flow forecast by job are what separate a real WIP schedule from a spreadsheet approximation that's accurate as of last Wednesday.
QuickBooks will keep recording your posted transactions. It won't tell you whether you're 63% or 75% complete on Lot 14, or whether the $180,000 draw you just received puts you overbilled by $30,000. That calculation requires contract price, estimated cost, and draw data that only your PM tool holds — and a platform built to read it in real time rather than wait for a manual export.
Flow ERP connects that data, computes the WIP schedule, and keeps it current throughout the period so close becomes a review rather than a rebuild. Book a demo to see how it works for a homebuilder portfolio.
Frequently asked questions
Can QuickBooks Online generate a WIP report for homebuilders?
QuickBooks Online cannot generate a WIP report for homebuilders. QBO has no fields for contract price, total estimated cost, or percent complete — the three inputs required to compute earned revenue and over/under billing by lot. Builders on QuickBooks must reconstruct their WIP schedule manually in Excel each month, using cost data exported from QBO and contract data entered by hand.
Does syncing Buildertrend or JobTread to QuickBooks give me a WIP schedule?
Syncing Buildertrend or JobTread to QuickBooks moves transaction data into QBO but does not produce a WIP schedule. Sync connectors move costs and invoices into the QuickBooks ledger; they don't create WIP fields or compute percent complete, earned revenue, or over/under billing. The WIP calculation still requires a manual step outside QuickBooks, typically in a separate Excel workbook. Flow ERP reads project data from Buildertrend, Procore, and JobTread in real time and computes WIP natively, eliminating the manual rebuild.
How do homebuilders get a live WIP schedule without leaving QuickBooks?
Homebuilders cannot get a fully live WIP schedule within QuickBooks Online — QBO's architecture does not support the contract-value and percent-complete fields required. The closest workaround is a sync add-on like SmoothX combined with a hand-built Excel model, which gives you WIP numbers that are current as of the last sync and manual update. For a schedule that's live throughout the period without a monthly rebuild, the practical path is a platform like Flow ERP that connects directly to the PM tool and computes WIP from real-time project data.
What's the percent-complete formula?
The percent-complete formula under the cost-to-cost method is: percent complete = cost-to-date ÷ total estimated cost. For a job with $360,000 incurred against a $480,000 budget, percent complete is 75%. That figure then drives the revenue-earned calculation (percent complete × contract price) and the over/under billing position (revenue earned minus progress billings or draws collected to date).
What is included in a WIP report?
A WIP report for homebuilders includes seven components for each active lot: contract price, total estimated cost, cost-to-date, percent complete, revenue earned to date, progress billings or draws collected, and the resulting over/under billing balance. Homebuilder WIP schedules also typically separate land and lot development costs from vertical construction costs, and note which lots are under percentage-of-completion vs. completed-contract revenue recognition. Lenders frequently require the WIP schedule as part of draw request packages, so it must reconcile directly to the draw schedule and the construction loan balance.
