How to Automate WIP Reports in QuickBooks Online

The manual WIP process — what you're replacing

Here's what building a WIP report manually looks like for most construction bookkeepers:

Total: 2–4 hours per client, every month. Multiply by 10 clients and you've lost a full week of work.

Why QBO can't do this automatically on its own

QuickBooks Online has strong job tracking — costs by customer, invoices, estimates. But it doesn't have a native WIP schedule. The core problem is that QBO stores the raw data (billings, costs, estimates) but doesn't compute the WIP calculations on top of it:

• QBO doesn't calculate % complete using the cost-to-cost method
• QBO doesn't compute revenue earned vs. billed
• QBO doesn't calculate over-billings or under-billings per job
• QBO doesn't track retainage as a separate WIP line item
• QBO doesn't output a combined, formatted WIP schedule

You can get the inputs from QBO — but you have to do all the WIP-specific calculations yourself. That's where the 2–4 hours goes.

Option 1 — Semi-automation with a live-connected spreadsheet

If you want to stay in Excel, the best approach is to use a spreadsheet that pulls live data from QBO via a connector (e.g. Coupler.io, Layer, or the QBO export via CSV). You set up the formulas once and refresh the data each month.

Pros:

• You control the exact format
• No new software to learn
• Works for one or two clients

Cons:

• Setup takes several hours upfront
• Each client needs their own spreadsheet
• Connectors break when QBO changes its API or report format
• Still requires manual review and cleanup every month
• Doesn't scale beyond 3–4 clients

Option 2 — Full automation with a QBO-connected WIP tool

The fully automated approach connects directly to QBO via the official QuickBooks API and computes the WIP schedule in real time — no exports, no manual steps. You log in, pick the client, and the WIP schedule is already calculated and ready to download.

What this looks like in practice:

Total: Under 10 minutes per client. For 10 clients, that's less than 2 hours vs. the 20–40 hours it was before.

What still requires human judgment (even with automation)

Automation handles the data and calculations. But a few things still need a human eye:

• Reviewing estimated costs for staleness. If the contractor hasn't updated their estimate for a job that's clearly going over budget, the % complete will be inflated. You need to ask: are these estimated costs still realistic?
• Confirming change orders are in QBO. Approved change orders that haven't been entered yet will make the contract value look low and the billing percentage look high.
• Catching jobs that are complete but still marked active. Finished jobs should come off the WIP schedule. Automated tools flag them, but you need to confirm with the contractor.
• Reviewing unusual variances before sending to the client. A job suddenly 80% over-billed might be a QBO data entry error — worth checking before it goes to a bonding company.

The prerequisite: clean QBO data

No automation works if the underlying QBO data is bad. Before you can automate WIP, every active job needs:

• A sub-customer entry in QBO
• An accepted estimate with contract value and budgeted costs
• All bills, expenses, and payroll coded to the correct job
• Invoices linked to the correct customer/job

If you're onboarding a new construction client, QBO cleanup usually comes first. Once the data is clean, automation is immediate.

Questions about automating WIP reports? Email us or browse more guides.