How do you find completed Housecall Pro jobs that were never invoiced?
Short answer: Export completed jobs (Jobs → filter Complete → Export CSV) and export invoices (Invoices → Export). Reconcile on job number, then customer plus date. Every completed job needs an invoice with a matching total; every invoice needs a non-void status. The gap between the two lists is your unbilled work.
The exports
Housecall Pro's export screens move around occasionally, but the two you need:
- Jobs: Jobs list → set status filter to "Complete" → date range → Export. You want
Job ID,Customer Name,Customer Email,Job Status,Scheduled At/Completed At,Job Type,Amount,Technician(s),Tags, and any custom warranty fields. - Invoices: Invoices → date range → Export. You want
Invoice Number,Job ID(present on invoices generated from a job),Customer,Date,Total,Balance Due,Payment Status.
If your account uses estimates that convert to jobs, also export converted estimates for the window — the conversion path is where approved-but-never-invoiced work hides.
The reconciliation
- Job ID match. Join invoices to jobs on
Job ID. Every completed job should have exactly one non-void invoice (or two for split billing, which HCP handles via multiple invoices). - Total comparison. Invoice
Totalshould equal jobAmountunless you have a documented reason (membership discount, goodwill credit). A difference is a finding. - Customer + date fallback. Jobs whose invoices lost the
Job IDlink — match on customer name and date window (3 days before to 14 days after completion). - Payment status is not billing. An invoice can be sent and unpaid — that's receivables, not unbilled work. Don't conflate the two, but do flag
Sentinvoices that were never delivered.
A worked example
Completed job for "R. Delgado", Sept 21, $486 (blower motor $310, labor $176). Invoice export shows INV-3021 for R. Delgado, $486 — but its Job ID points to a different job, and the Sept 21 job has no invoice row. Meanwhile the customer appears on the supplier statement: motor purchased Sept 20, $310.
Here the invoice exists and looks right on its own screen; the job screen also looks right. Only the join shows the job itself was never invoiced — the $486 invoice covers a different visit. That's the most expensive HCP pattern because both screens pass a casual glance.
Common mistakes
- Using the payments export instead of invoices. Payments show collected money, not billed work. Deposits and partial payments hide under-collected jobs.
- Forgetting voided invoices. Void an invoice and re-issue it, and the void remains in the export. Count the void as zero coverage, count the replacement once.
- Name normalization. Strip LLC/Inc and punctuation before matching customers, or you'll split one customer into three.
The monthly habit
Run this reconciliation in the first week of each month for the previous month, widen invoice dates two weeks on each side, and log every explanation. The second month is where it pays: the explanations become your exclusion list, and what remains is pure signal.
Author: Unbilled. Or let us run it: send three files, get a one-page report.