QuickBooks Online + Field Operations Tie-Out
How to Build an Accurate QuickBooks WIP Report Without Enterprise ERP
A QuickBooks WIP report workflow is a two-source monthly reconciliation process for $2M to $50M contractors that combines QuickBooks Online Inception-to-Date Accrual job actuals (Accounts 4000 and 5100-5400) with field-system or estimator Revised Contract and Estimate-at-Completion (EAC) budgets so every active job ties to $0.00 variance against the General Ledger. Because QuickBooks Online does not natively store monthly revised cost-to-complete or carve out uninstalled staged materials (Account 1360), exporting the right 2 reports and merging them in WIP Calculator takes under 5 minutes per close.
Five QuickBooks Export Traps That Corrupt Contractor WIP Schedules
| QuickBooks Export Trap | How It Distorts WIP Math | Exact Export Setting Required |
|---|---|---|
| 1. YTD Date Range Instead of All Dates | Jobs started in November of last year lose prior-year costs and billings when QBO defaults to This Fiscal Year-to-Date, manufacturing fake overbillings or underbillings. | Set Report Period to All Dates (or custom start date prior to your oldest open project) through your month-end cutoff date. |
| 2. Cash Basis Report Toggle | Excludes unpaid customer progress invoices (1200/1210) and open supply-house/subcontractor bills (2000), turning WIP into a bank-timing accident. | Select Accrual accounting method before exporting CSV or Excel. |
| 3. Unallocated "Not Specified" COGS Column | Field payroll journals or supply-house checks posted without a Customer:Job tag sit in QBO's Not Specified column, making individual jobs look 20 to 35 points more profitable than company P&L. | Require $0.00 in Not Specified Direct COGS (5100-5400) before signing off WIP; our parser automatically flags any Not-Specified leak. |
| 4. P&L Revenue Mistaken for Progress Billings | If prior-month WIP journal entries (4010/4020) or direct bank-feed deposits were coded to Customer:Job, P&L Total Income no longer equals cumulative customer billings. | Post WIP adjustments to dedicated 4010/4020 accounts at company level (or reverse Day 1) so Account 4000 + Retainage 1210 equals exact cumulative progress billings. |
| 5. Parent Customer vs. Sub-Project Subtotal Rows | QuickBooks exports inject "Total [Customer]" rows below sub-projects, double-counting contract and cost totals if imported blindly. | Use stable Job IDs (preserving leading zeros like 0104) and let WIP Calculator strip Total/Subtotal rows automatically. |
Two-File Merge Procedure (QuickBooks Actuals + Field/PM Budget)
- Export File 1 (Budget & Contract Tracker): Export active open jobs from BuildOps, ServiceTitan, Procore, Knowify, or your estimator spreadsheet with columns for Job ID, Project Name, Original Contract, Approved COs, and current Revised Estimated Cost (EAC). Drop File 1 into the WIP Workbench.
- Export File 2 (QuickBooks Cumulative Job Actuals): In QuickBooks Online, open Profit and Loss by Customer (or Project Profitability), set All Dates through your close cutoff, set Accrual, and export CSV/Excel.
- Check "Merge 2nd File (QBO + Budget)" and Drop File 2: The parser joins rows by Job ID first (then exact Project Name), flags any unmatched jobs or Not-Specified COGS leaks, and computes gross 1350/2450 adjustments instantly.