The ServiceTitan invoice reconciliation report: what it must check

Last updated November 5, 2026 · 5 min read

Short answer

ServiceTitan marks a job Completed when the tech closes it — invoicing is a separate office step. Every handoff is a chance for a completed job to never reach an invoice. The check: export Completed jobs and the Invoice List, match them, measure the residual.

The data reality

Where to export: Reports > Job Reports > Jobs — set Date Type to Completed On, filter Status to Completed, then Export.

Columns that matter: Job # · Customer Name · Job Status · Completed On · Total $ · Invoice # · Invoice Status

Job totals include unsold line items unless filtered to posted items, and the Invoice List total can differ from the job total after adjustments. Status values are capitalized strings and must be filtered before export.

Why this system leaks

The field closes the job; the office opens it from a queue to invoice. Busy weeks, staff turnover, and split invoices (deposit here, balance there) break the handoff.

Because completion and billing are different people using different screens, a job can sit Completed forever with no invoice and no alarm anywhere in ServiceTitan — the queue only shows what someone remembered to open.

Where ServiceTitan hides the leak

The Jobs board shows status, not billing state. A job can be Completed, invoiced, partially invoiced, or never invoiced — the board treats them all the same unless someone builds and maintains a custom view. The leak lives in the gap between 'Completed On' and 'Invoice #'.

What a reconciliation checks that a scan does not

A reconciliation matches each completed job to non-void invoices using the invoice reference, the job number, and finally customer-plus-date-window. It subtracts what was actually invoiced from what was recorded, so partial coverage shows as a remainder — not a duplicate alarm and not a false all-clear.

A worked example

Job #20418 — compressor replacement, $1,140 of labor and parts recorded, completed October 14.

Recorded work
$1,140.00
Invoiced
$0.00
Residual
$1,140.00

Matching the completed-jobs export against the Invoice List finds no non-void invoice referencing Job #20418 or its customer inside the date window. Residual = $1,140 − $0 = $1,140 of recorded work that never reached an invoice.

What the data cannot show

  • A zero-dollar invoice created by warranty policy looks identical to an omission in the export — policy context lives outside the data.
  • Credit memos and adjustments are easy to miss when scanning the Invoice List total.

Questions shops ask

Does ServiceTitan have a built-in unbilled report?

It has invoice-status reports, but 'Completed with no invoice' requires cross-referencing the jobs export against the Invoice List — and even then, partial billing and voided-then-replaced invoices need the arithmetic a reconciliation applies.

How often should a shop reconcile?

Monthly. Drift is dozens of small items; the older the drift, the harder the collection. A monthly cycle catches each leak while the customer relationship is still warm.

See a sample report for your export

See a sample report for your export

Related