Unbilled replacement parts: the truck-stock leak no invoice scan can catch

Last updated November 5, 2026 · 5 min read

Short answer

A part is unbilled when it was purchased, attributed to a job, and never appeared on that job's invoice. It takes two sources shops rarely combine: the supplier statement and the invoice. The rule is job-level: only a line on an invoice matched to that job clears it.

The data reality

Where to export: Supplier statement: the supplier's monthly PDF or CSV. Work orders with parts: your FSM's parts or job export. Invoices: accounting export with line items.

Columns that matter: Part number · Description · Qty · Unit cost · Work order ref · Tech name · Invoice line · Line total

Part descriptions differ between supplier, tech, and invoice ('ECM blower motor' vs 'BLWR MOT 1/2HP'). Reconciliation normalizes part numbers and fuzzy-matches descriptions at 0.85 similarity.

Why this system leaks

The tech pulls the part from truck stock, installs it, and the invoice is built from the pricebook by memory or habit. The supplier statement at month-end shows the purchase — but nobody reads it against the invoices.

The part was paid for by the shop, installed for the customer, and billed to no one. Every source is individually correct; the leak is the missing connection between them.

The customer-level false all-clear

A naive check asks 'did this customer ever get billed for a blower motor?' — and a different job's invoice answers yes. That is the defect that makes cheap checks look correct while the leak continues. The rule is job-level: the part must appear on an invoice matched to the same work order.

Why the supplier statement is the source of truth

Invoices record what was billed; the supplier statement records what was actually bought. The gap between those two lists — filtered to parts attributed to real jobs — is the truck-stock leak. It is the only list that cannot be edited after the fact.

A worked example

Job #20431 — supplier statement line 88 shows part MOT-3482 (ECM blower motor) at $486, attributed to the tech on job #20431. Invoice INV-9821 for the same job bills labor only.

Recorded work
$486.00
Invoiced
$0.00
Residual
$486.00

The invoice matched to job #20431 contains no line for MOT-3482 or a matching description. Part-level residual = $486 — the shop bought the motor, the customer got the motor, no one paid for the motor.

What the data cannot show

  • Parts bought for stock with no job attribution cannot be attributed honestly — reconciliation leaves them out rather than guessing.
  • Core charges and supplier returns are legitimate non-billable part events and must be excluded.

Questions shops ask

Are small parts worth chasing?

Individually, barely — that is why they leak. A $25 tolerance for legitimate small parts keeps the signal honest; the leak is the pattern of $100–500 parts that never reach any invoice.

How do you match parts when descriptions differ?

Part numbers are normalized (case, spaces, dashes); descriptions are fuzzy-matched at 0.85 similarity. If neither matches, the part is treated as unbilled — a miss is forgiven, a false accusation is not.

Run the free check on your files

Run the free check on your files

Related