Constructelligence
Overview
Free tools Pricing Demo Join the beta
Construction software · QuickBooks

QuickBooks job costing for contractors: setup, reports and when you outgrow it

QuickBooks runs the books for a huge number of contractors, and with the right setup it can track job cost well enough to run a growing company. It was not designed for construction, though, and the gaps — retainage, committed cost, a WIP schedule — show up as the jobs get bigger. This guide covers the setup that works, the reports that matter, and the signs it is time for more.

Updated · 10 minute read

Key takeaways
  • Set up jobs, cost codes as items, cost types by class, and estimates as budgets.
  • QuickBooks reports cost to date; forecasting needs a forecast at completion.
  • Retainage, committed cost, WIP and AIA billing are the usual gaps.
  • Outgrowing it is about complexity — retainage, sureties, payroll, entities — not revenue alone.

Setting up job costing

  1. One job per contract. In QuickBooks Desktop, a job under each customer; in QuickBooks Online, a project.
  2. Cost codes as items. Create service and non-inventory items for your cost codes — concrete, framing, electrical — so every bill and timesheet line carries one.
  3. Cost types with classes or item naming. Labor, material, subcontract and equipment need to be separable; classes or a consistent item prefix do it.
  4. Estimates as budgets. Enter the estimate against the job with the same items, so estimates-vs-actuals reports line up.
  5. Time to jobs. Every timesheet hour tagged to a job and an item, or labor cost will not reach the job.

The reports that matter

QuestionReport
Is this job profitable so far?Job (or project) profitability
Where are we over the estimate?Job estimates vs. actuals, by item
What have we billed?Invoices by job, progress invoicing against the estimate
Who owes us?A/R aging by customer and job

All of these describe cost to date. None says where the job will finish — that needs a forecast at completion, usually built in a spreadsheet next to QuickBooks.

CalculatorHave you outgrown QuickBooks?

Where QuickBooks runs out

✓Job costing by job & itemnative✓Estimates vs actualsnative–Retainageadd-on / by hand–Committed costadd-on / by hand–WIP & over/under billingadd-on / by hand–AIA G702 / G703add-on / by hand–Certified payrolladd-on / by hand
The limits in this section as a checklist. Each red item is a spreadsheet someone maintains — which is usually the sign it is time to move up.

Signs you have outgrown it

Not revenue alone. Watch for: more than a handful of jobs with retainage, change orders you track in a spreadsheet, a WIP your bank or surety now asks for monthly, union or prevailing-wage payroll, or more than one company. The calculator below scores it. The construction accounting software guide covers what to move to — and Constructelligence reads QuickBooks Desktop today, so you can get forecasts and WIP before, or instead of, a migration.

Tracking committed cost and retainage around QuickBooks

QuickBooks records cost when a bill is entered, so awarded subcontracts and open purchase orders are invisible until they are invoiced, and retainage needs its own handling. Two practical workarounds while you stay on it:

Both then feed the WIP schedule and the forecast correctly. When the register and the retainage accounts become a second system someone has to maintain, that is the signal it is time for construction accounting software.

Checklist
QuickBooks cost code items in Excel, filled in with example rows — columns: Item name, Type, Cost code, Cost type, Class, Income account, Expense account
The quickbooks cost code items as it opens in Excel: example rows in italics, calculated columns shaded.
Free template · QuickBooks cost code items (Excel & CSV)An Excel workbook with drop-downs, validation and formulas built in — or the same columns as a CSV for Google Sheets and Numbers.
Download Excel (.xlsx)
What this template captures

Each cost code set up as a QuickBooks item, with type, cost type, class and the income and expense accounts it posts to.

7 columns: 7 you fill in. In the Excel version, the header row stays frozen with filters on it, and the workbook opens on an Instructions sheet that lists every column below.

Every column, and how it is captured
ColumnTypeWhat goes in it
Item nameTextFree text.
TypeTextFree text.
Cost codeTextCost code from your cost code list, matching the estimate and the ERP.
Cost typeTextLabor, material, subcontract, equipment or other.
ClassTextFree text.
Income accountTextFree text.
Expense accountTextFree text.

See it on real-looking numbers

Constructelligence is a construction intelligence platform: it reads your ERP, project and field systems read-only and does this arithmetic every week, for every job. The demo runs it on a sample eight-job portfolio.

Try the demoJoin the private beta

Frequently asked questions

Can QuickBooks do job costing for construction?

Yes, with setup: a job or project per contract, cost codes as items, cost types separated by class or item naming, estimates entered as budgets and every timesheet tagged to a job. It reports cost to date and estimates versus actuals well; forecasting, retainage and WIP usually need spreadsheets or add-ons.

What is the best way to track cost codes in QuickBooks?

Create an item for each cost code and use it on every bill, expense and timesheet line, with classes or an item prefix to separate labor, material, subcontract and equipment. Keep the same list in your estimates so budget and actual compare line by line.

Does QuickBooks handle retainage?

Not natively. Contractors typically use a retainage item or negative line on invoices and track the balance by job separately, which is why retainage is often the first thing that pushes a growing contractor to construction-specific software.

When should a contractor move off QuickBooks?

When retainage, committed cost, WIP reporting for a surety, certified or union payroll, or several companies start being managed in spreadsheets around QuickBooks rather than in it — often somewhere between $10M and $50M in revenue.

Can QuickBooks track committed costs for construction?

Not natively — cost appears when bills are entered. Contractors on QuickBooks usually keep a separate commitments register per job and add committed-but-not-invoiced cost when forecasting.

CI
Written by the Constructelligence teamConstruction finance and software. Worked examples use the sample demo portfolio; formulas are standard practice. Reviewed September 2026.
Construction accounting software and ERP: the main systems and how to chooseConstruction accounting software and ERP compared for 2026 — Sage 300 CRE, Sage Intacct Construction, Viewpoint Vista and Spectrum, Foundation, CMiC, Acumatica, QuickBooks — the features that matter and how to choose.Job cost forecasting: how to forecast a job’s cost at completionHow contractors forecast cost at completion (EAC): the four methods, the formulas, a worked example, the mistakes that hide overruns, and how forecasting from past jobs helps.Retainage in construction: how it works and how to get it backHow construction retainage works: typical rates, how it flows from owner to GC to subs, retainage reduction, release at completion, how it shows on the WIP and pay application, and how to track it.

More in Construction software & tech

Free tools for this topic: Construction PDF to Excel converter · Schedule PDF to Excel (P6 & MS Project) · Construction schedule health check

All construction software & tech resources →