How do you find completed ServiceTitan jobs that were never invoiced?
Short answer: Export completed jobs (Jobs → Export with completed-date filter), export invoices (Invoices → Export), and reconcile them on job number plus customer plus date. A completed job with no invoice reference, or with invoices covering less than its recorded total, is unbilled work. Do it monthly; the leak is dozens of small items, not one dramatic event.
Get the two exports
ServiceTitan's export paths that matter:
- Jobs: Reporting → Job Reports → Jobs, or from the Jobs list view → Export. Filter
Status = Completedand set the completed-date range to your reconciliation month. - Invoices: Reporting → Invoice Reports → Invoices, or the Invoices list → Export. Filter by issued date in the same window (widen by two weeks on each side — jobs completed late in the month get invoiced into the next one).
The columns that matter on the jobs export: Job #, Customer, Location, Status, Completed On, Job Type, Business Unit, Total Amount, Technician, Warranty, and the line-level detail if you can get it (Item, Quantity, Unit Price, Total). On the invoice export: Invoice #, Job # (the one that does the work), Customer, Date, Total, Balance, Status.
The reconciliation
Work in this order — it finds the most money fastest:
- Jobs with no invoice at all. Filter the jobs export to
Completed, then check eachJob #against the invoice export'sJob #column. In a 400-job month you will typically find several. Some are legitimate ($0 warranty, callbacks) — that's what the warranty and callback fields are for. The rest are the leak. - Jobs whose invoice total is less than the job total. ServiceTitan's job
Total Amountincludes everything quoted on the tablet. If the invoice came out lower, either something was removed deliberately (fine — you know why) or a line was dropped at invoicing (the leak). - Zero-dollar invoices on non-warranty jobs. Filter invoices with
Total = 0joined back to non-warranty completed jobs. - Parts cross-check. If you can export purchase orders or inventory usage, match parts consumed per job against invoice lines. This is where compressor and motor swaps most often lose their parts charge.
A worked example
Job #20418, completed Sept 14, customer "Fairview Rentals LLC". Job total $1,140.00 (compressor $780, refrigerant $160, labor $200). The invoice export shows one invoice for Fairview Rentals in September: #INV-8871, $486, dated Sept 16 — but its Job # is 20431. Job 20418 has no invoice row anywhere.
That's $1,140 of completed, documented work with nothing invoiced. The parts are confirmed on the supplier statement (compressor purchased Sept 13 — the day before). This is exactly the pattern the monthly reconciliation catches: nothing about it looks wrong from inside ServiceTitan, because every individual screen looks normal.
Common mistakes
- Reconciling on customer name alone. "Fairview Rentals" appears with and without LLC, with a unit number, as a property manager entry. Match on job number first; use customer matching only when the job number match fails.
- Ignoring the date skew. Jobs completed on the 28th–31st are often invoiced in the first week of the next month. Filter invoices on a window, not the calendar month, or you'll chase ghosts.
- Trusting
Status = Completedonly. Jobs can sit inCompletedwith a follow-up visit still open — the first visit is billable regardless. - Skipping $0 invoices. A zero invoice on a warranty job is correct. On anything else it's either a mistake or a decision nobody documented.
What ServiceTitan's own reports won't show you
The standard reports show billing activity; they don't show the absence of billing. "Unbilled work" is defined by what's missing from a join across exports — which is why the reconciliation has to happen outside the system that produced the data.
Author: Unbilled. We reconcile these exports automatically — send three files, get a one-page report.