Guides · By software

How to find unbilled work in Housecall Pro

Reconcile completed Housecall Pro jobs against invoices and payments, with exact export paths and the columns that matter.

Last updated Fri Oct 30 2026 00:00:00 GMT+0000 (Coordinated Universal Time) · 7 min read

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:

  1. 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.
  2. 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

  1. 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).
  2. Total comparison. Invoice Total should equal job Amount unless you have a documented reason (membership discount, goodwill credit). A difference is a finding.
  3. Customer + date fallback. Jobs whose invoices lost the Job ID link — match on customer name and date window (3 days before to 14 days after completion).
  4. 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 Sent invoices 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.

Or let us run it: send three files, get a one-page report.

Related