Truck stock value calculator: what your trucks consumed versus what you billed

Last updated November 16, 2026 · 6 min read

Short answer

Enter restock value per truck and parts billed per tech per month; the calculator returns the gap — parts consumed but never billed — and its annual pace. A typical two-truck shop's first run shows $612/month of consumed-but-unbilled stock, an annual pace near $7,300 of pure margin.

The data reality

Where to export: Inputs: monthly restock orders (value) per truck from your inventory or supplier invoices; parts totals per tech from invoice exports. Output: consumption, billed, gap, annual pace. The check computes this from exports directly, per tech.

Columns that matter: Truck · Restock value · Parts billed · Gap · Annual pace

Restock value approximates consumption — transfers between trucks, internal use, and expired stock distort it. The calculator uses restock as the consumption proxy and lets you enter a non-billable allowance (warranty, internal) to subtract. The check, fed exports, does the same subtraction from flagged categories.

Why this system leaks

The truck is a rolling warehouse, and every part it dispenses is either billed or forgiven silently. Restock orders keep arriving — the shop buys the same capacitors every month — while invoice parts lines stay flat. The gap is invisible because inventory math (what remains) and billing math (what was charged) are never joined: the shop replenishes its own leakage at retail cost, monthly, and reads the restock bill as 'normal operating expense.'

The calculator's inputs are numbers most shops already have — restock orders, invoice parts totals — but never put side by side. Joined, they show the truck's true financial role: a vending machine whose contents are sometimes charged for and sometimes not, at a rate no one has measured. The measure is the fix; without it, the drift is unnamed and unpaid.

The two numbers you already have

Monthly restock value sits in supplier invoices or inventory reports; monthly billed-parts totals sit in your invoice export. Neither alone means anything — joined, they are the truck's P&L. The calculator performs the join; the check does it per tech, from exports, monthly.

Read the annual pace, then act on the ritual

A $612 monthly gap is $7,300 a year of already-spent money never recovered. The fix is procedural: the close-out ritual (part used → line added), verified monthly per tech. The calculator sets the baseline; the trend after the ritual is the proof it worked.

Margin math makes this urgent

Unbilled truck stock is not revenue at cost — it is retail-priced parts lost at pure margin, plus the labor context that sold with them. Few leaks in the shop have a higher margin percentage per dollar. That is why this calculator's number deserves a line in the owner's monthly review.

A worked example

Two trucks, one month: restock orders total $847; invoice parts lines total $235. With a $100 allowance for warranty and internal use, the gap is $612 — capacitors, contactors, line sets, and filter stock consumed and never billed.

Recorded work
$612.00
Invoiced
$0.00
Residual
$612.00

Residual = $612/month — an annual pace of $7,344 at near-pure margin, since the parts are already bought. The calculator's output converts a vague sense ('we go through a lot of stock') into a managed number with a per-tech breakdown.

What the data cannot show

  • The calculator shows the gap; attributing it — close-out misses, internal use, theft — is the office's follow-up with the per-tech detail from the check.
  • Restock-based consumption is a proxy — shops with full inventory scanning get exact numbers; the calculator's allowance input accounts for the difference where scanning is partial.

Questions shops ask

How do I calculate my truck stock's unbilled value?

Monthly restock value minus parts billed on invoices, minus a non-billable allowance (warranty, internal). The calculator walks the inputs; the check computes it per tech from your exports and itemizes what the gap contains.

What is a normal truck-stock gap?

Shops running the comparison for the first time commonly find 30–60% of restock value unbilled after allowances — one two-truck shop found $612/month. The number should trend toward a small steady value once the close-out ritual is verified monthly.

Is truck-stock drift theft?

Almost never — it is transcription drift under time pressure. The per-tech detail from the check distinguishes patterns; the conversation to have is about the close-out ritual, not suspicion. Measurement first, ritual second, accountability as a trend.

Run the real reconciliation

Run the real reconciliation

Related