How to export jobs from Housecall Pro — the two files that reveal unbilled work

Last updated November 16, 2026 · 6 min read

Short answer

Export Jobs and Transactions from Reporting → Reports — CSV, wide date range. The Jobs file shows completed work; Transactions shows billing. Upload both and the check joins them to list completed jobs with no invoice coverage.

The data reality

Where to export: Housecall Pro: Reporting → Reports → Jobs (CSV, full range) and Reporting → Reports → Transactions (CSV, same range). Both files upload to run the check.

Columns that matter: Job ID · Customer Name · Job Status · Job Total · Invoice/Payment Status

Housecall Pro's Transactions export mixes invoices, payments, and estimates in one file — the check filters to invoices and credits payments. Job status values ('Completed', 'Invoiced') overlap confusingly: a job can show 'Completed' with no invoice ever sent. Multi-visit jobs appear as separate job rows joined to one invoice.

Why this system leaks

The office trusts the Jobs list's 'Invoiced' status column as proof of billing. But status is a workflow label maintained by the same clicks that do the invoicing — when the invoicing click never happened, the job shows 'Completed' and nothing prompts anyone to look again. Filtering the Jobs list by status shows today's defaults, not history. Six months later the job is complete, the customer is gone happy, and the revenue exists nowhere but the technician's memory.

Status columns describe workflow intent, not billing reality — and the gap between them is precisely the leak. Only a join across the Jobs and Transactions exports compares what was done to what was billed, which is why no native Housecall Pro view ever surfaces the gaps.

Both files, one join

The Jobs export enumerates work; the Transactions export enumerates billing. Neither contains the answer — the answer is the difference between them. The check ingests both CSVs, filters Transactions to invoices, credits deposits and payments, and returns the completed jobs that never billed.

Beware the status column

'Completed' means the visit happened; 'Invoiced' means someone clicked through the flow. The two drift apart under peak-season load, and the drift is silent. Never audit from status alone — audit from the join of exports, where the truth of both sides sits in raw rows.

Widen the range, then make it a rhythm

Default date ranges are the most common reason a first export misses old gaps. Set the range to your full history once, clear the backlog, then run monthly with a one-month window. The check takes minutes each time; the alternative is a year of quiet accumulation.

A worked example

Housecall Pro exports for a two-truck HVAC shop, Jan–Oct: 312 completed jobs, 306 invoices after filtering and crediting deposits. Six completed jobs have no invoice — a $186 evaporator coil swap in May and a $274 blower repair in August among them.

Recorded work
$460.00
Invoiced
$0.00
Residual
$460.00

Residual = $460 across six unbilled jobs — about two percent of completed volume. All six recoverable: the work was done, the customers were satisfied, and clear late invoices with job details recover most of them at full value.

What the data cannot show

  • Jobs genuinely closed at no charge appear as candidates — the office marks warranty and goodwill cases, converting unexplained gaps into documented decisions.
  • Exports depend on account permissions — run them from an admin login, with date ranges widened beyond the defaults, or older gaps remain outside both files.

Questions shops ask

Where do I export jobs in Housecall Pro?

Reporting → Reports → Jobs, then choose export to CSV. Widen the date range to your full history on a first run. Pair it with the Transactions export — the check needs both to find completed jobs without invoice coverage.

Does the Transactions export include uninvoiced jobs?

No — it lists invoices, payments, and estimates that exist. Uninvoiced jobs appear only in the Jobs export, which is exactly why the check joins the two files rather than trusting either.

Can I automate this monthly?

Yes — the two exports take a few minutes each month, and the check returns the exception list immediately. Housecall Pro's API also supports scheduled pulls if you want to remove the manual step entirely.

See a sample report for your export

See a sample report for your export

Related