The Hidden Invoicing Leaks in Spreadsheet-Run Fleets

On a spreadsheet-run fleet, completed trips and issued invoices live in different tabs. Often in different files. Sometimes in different people's heads.

The dispatcher knows the load delivered. The owner knows it's supposed to be billed. The bookkeeper knows last week's invoices went out. None of them knows whether this load specifically got billed unless someone deliberately checks.

Most weeks, nobody checks. There's a driver waiting on an answer, a broker on hold, a load that needs to be dispatched. The reconciliation work is the work that gets pushed to the end of the month, and the end of the month keeps not arriving.

The spreadsheet doesn't enforce anything. It will cheerfully hold a row about a delivered load forever without ever connecting it to an invoice. The leak isn't a bug. It's the absence of a feature.

The four leaks

Most billing losses on small fleets fall into one of these four categories. The first is loud. The other three are quiet and add up to more.

Missed invoices

A delivered load that never gets an invoice. Usually a one-off direct customer, sometimes a broker with unusual paperwork. The load is on the dispatch sheet but never makes the invoice queue.

Typical cost: one to three loads a month is common. At an average of $1,200 a load, that's $14,400 to $43,200 a year.

Under-billed accessorials

Detention agreed verbally and never written into the rate con. Lumper fees the driver paid out of pocket. Layover the broker said they'd cover. Stop-off charges on multi-stop trips. The dispatcher closes the trip without remembering them.

Typical cost: often $200 to $800 a week for a 20-truck fleet. Adds up to $10,000 to $40,000 a year of pure margin.

Untracked detention

The driver sat for four hours. Nobody started a timer. The broker never gets a detention invoice because there's no documented record. The driver is paid detention from the carrier, but the carrier never collects from the broker.

Typical cost: pure loss. Most carriers losing detention are also paying their drivers detention out of operating margin, so it's a double hit.

Late billing aging into bad debt

The invoice goes out 60 days late. The customer has moved on, disputes details, or has gone out of business. Net-30 invoices billed at day 90 collect at materially lower rates.

Typical cost: one to three percent of late-billed AR ages into write-off. On a fleet doing $3M a year that's real money.

The math nobody runs

Most owners running on spreadsheets believe their leakage is small because they've never measured it. Run the math once and the picture changes.

A 20-truck fleet doing $3M a year that loses two invoices a month, $400 a week of accessorials, and one or two detentions a week is leaking roughly $80,000 to $120,000 a year.

That's the gross margin on three drivers. And it's invisible until you reconcile.

Most carriers running on spreadsheets aren't losing trips. They're losing the line items on trips they already ran.

The reason this works as a quiet drain rather than a sudden crisis is that nobody dies of a leak.

The fleet keeps running. Drivers keep getting paid. The bank account doesn't go negative. It just doesn't grow as fast as the work would suggest it should.

Owners who run the reconciliation are usually surprised. Owners who don't, never know.

Why customers learn the pattern

Brokers and shippers see hundreds of carriers a year. They learn quickly which ones track and which ones don't.

A broker who knows your dispatch desk doesn't catch untracked detention isn't going to volunteer it. A shipper whose lumper fees you keep eating isn't going to remind you that you're owed $300.

None of this is malicious. It's how attention works. People pay the line items they're asked to pay. If you don't ask, the question never comes up.

Once the pattern is established, the broker adjusts their internal understanding of what your loads actually cost them. You've quietly given them a discount you never agreed to.

The five-minute audit you can run this week

You don't need a system to find the leak. You just need an afternoon. Here's the smallest version that works:

Pick the most recent fully-closed month.Not the current one, the last one where every load should have been billed by now.
Pull two lists. Every completed trip from your dispatch sheet, and every invoice you issued in the following 30 days. Print them or put them side by side.
Match them. Loads on the dispatch list with no matching invoice are leak number one. Write down what you find.
Cross-check driver pay. Pull your settlement sheet for the same period. Look for any line item the driver was paid for (detention, layover, lumper reimbursement) that doesn't show up as a billed accessorial on your customer invoice. Those are leak two and three, the under-billed accessorials and untracked detention.
Spot-check aging. Pull anything in your AR that's over 60 days. For each, ask: was the invoice itself sent late, or is the customer simply slow? Late invoicing is leak four.

One afternoon. Most fleets find more than expected. Some fleets find more than the cost of the system that would have prevented it.

What fixing the leak actually requires

The fix is structural. Spreadsheets can't fix it because spreadsheets don't enforce relationships.

A TMS that does enforce the relationship, where a closed trip cannot exist without a corresponding draft invoice with the right charges attached, removes the human-memory step that creates the leak in the first place.

But not every TMS does this. A TMS that just digitizes the spreadsheet, where the dispatcher is still expected to remember to create an invoice after closing the trip, is a more expensive spreadsheet.

The leak follows the human, not the tool. The fix is moving the trigger off the human and onto the system.

Frequently asked questions

How much money do small carriers actually lose to invoicing leaks?

It varies, but on most spreadsheet-run fleets the leak is bigger than the owner expects. Two missed invoices a month at an average of $1,200 each is $28,800 a year. Add a few hundred dollars a month in unbilled accessorials and untracked detention, and a small carrier can comfortably leak the equivalent of a truck and a half of revenue without ever seeing it on the P&L. The number is invisible because it shows up as nothing, not as a loss.

Why don't these leaks show up in my P&L?

Because the P&L only shows revenue you billed. An invoice you never sent is not a negative number. It is just absence. The only way to find the leak is to reconcile completed trips against invoices issued, which spreadsheets do not enforce automatically. Most owners discover their leaks the year they finally do that reconciliation and find six figures of work that was delivered but never billed.

What's the single most commonly missed billing item?

Accessorials, by a wide margin. Detention, lumper fees, layover, TONU (truck ordered, not used), and stop-off charges. These get agreed to verbally with the broker, never make it onto a written rate confirmation, and never get billed because the spreadsheet has no field for them. The driver delivers the load, the dispatcher closes the trip, and the accessorial dies on the spot.

How do I find leaks without buying a system first?

Pick last month. Pull every completed trip from your dispatch sheet and every invoice you sent. Match them. Loads with no matching invoice are the obvious leak. Then go back to your driver settlement sheet and look for any line item the driver was paid for that has no invoice line. Detention paid to the driver but not billed to the customer is the second-biggest leak. Most fleets find their year of leakage in one afternoon of doing this.

Will moving off spreadsheets actually fix this?

Only if the new system makes invoicing flow from completed work rather than from a separate manual step. A TMS that just digitizes your spreadsheet without changing who has to remember to invoice is a more expensive spreadsheet. The fix is structural: the moment a trip is closed, the invoice has to exist as a draft, with the right charges already attached, waiting for review rather than for someone to remember to create it.

Are larger fleets immune to this?

No, but they catch it sooner because they have a billing person whose job is reconciliation. Small carriers don't. The dispatcher is also the billing person, also the safety person, and also picking up driver applications between phone calls. Things slip not because anyone is bad at their job but because no one's only job is to look for the slips.