Guides · By software

How to find unbilled work in Jobber

Reconcile completed Jobber jobs against invoices with exact export paths, the quote-to-job gap, and the visit-level traps.

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

How do you find completed Jobber jobs that were never invoiced?

Short answer: Export completed jobs (Jobs → Export) and invoices (Invoices → Export), then reconcile on job number, falling back to client plus visit date. Jobber's structure — quotes that convert to jobs, jobs that contain multiple visits, visits billed separately — creates three specific places where completed work silently never reaches an invoice.

The exports

  1. Jobs: Jobs → filter Status "Complete" → Export CSV. Columns that matter: Job Number, Job Title, Client, Status, Completed On, Line Items (or export line items separately), Total, Assessment/Visit fees.
  2. Invoices: Invoices → Export. Columns: Invoice Number, Client, Date, Total, Balance, Status, and the linked Job/Visit reference.
  3. Quotes: Quotes → Export. Needed later — a quote accepted 30 days ago with no job and no invoice is a lead you paid for and dropped.

The three Jobber-specific traps

1. Multi-visit jobs. A job with three visits can be invoiced per visit or at completion. If your office bills per visit and one visit was never invoiced, the job still shows "invoiced" on the job screen. Reconcile at the visit level where possible, or compare total invoiced against total job value.

2. Quote → job → invoice conversions. When a quote converts to a job and the job completes, the invoice should carry the quoted amount. An invoice for less means lines were dropped during conversion. Check quotes accepted in the last 60 days: accepted → job created → invoiced at quote value.

3. Property managers and monthly accounts. Work for accounts billed monthly sits "complete but not invoiced" until the month rolls up. That's legitimate — but only if you know which accounts those are. Without a written exclusion list, they're indistinguishable from leaks.

A worked example

Job #J-4417, "Fernando's Deli — rooftop unit no-cool", completed Sept 9, total $892 (capacitor $95, contactor $65, refrigerant $280, labor $452). Invoices show #10233 for Fernando's Deli, $452, Sept 10 — labor only.

The parts ($440 combined) never made it onto the invoice. The supplier statement confirms the capacitor and contactor purchased Sept 8. Job value $892, invoiced $452, residual $440 — parts that were bought, installed, and never charged. That's the single most common Jobber pattern we find, and it repeats across months until someone reconciles.

Common mistakes

  • Matching on client display name. "Fernandos Deli", "Fernando's Deli Inc." and the property manager variant are one customer with three names. Normalize before matching.
  • Treating "Invoice Sent" as "invoiced correctly". Sent is delivery, not accuracy. Compare amounts.
  • Ignoring deleted visits. Deleted-but-completed visits vanish from some views; export before cleanup happens.

Run it monthly

First week of the month, previous month's window, invoice dates widened ±14 days. Track four numbers: jobs completed, invoices issued, jobs with no invoice, invoice-vs-job gaps. When jobs-with-no-invoice stabilizes near your legitimate exclusions, the process is working.

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