I'll be honest: our warehouse is 32,000 square feet, we own zero trucks, and we can't afford a real TMS — so I built our carrier scorecard in a spreadsheet. For years I picked carriers the way most small operators do: whoever quoted cheapest, whoever I liked. Then one peak season, a "buddy" carrier rejected our loads three days straight, finally picked up on day four, and delivered two days late. The customer canceled a $4,000+ order. That night I sat on the dock and thought: this isn't carrier selection, this is gambling.
So now I run a carrier scorecard. One spreadsheet, four metrics, total cost zero. Laugh if you want — it works. (Every number below comes from our own warehouse's actual data. Saying it up front so nobody accuses me of making things up.)
One Spreadsheet Is Our Entire Carrier Scorecard
Big companies do carrier scorecards with TMS modules, BI dashboards, and quarterly business reviews. We can't afford any of that. My method is embarrassingly simple: a spreadsheet, carriers across the top, four metrics down the side, updated once a month in about 30 minutes.
The headline promises three metrics; I actually track four — the fourth was added after a billing disaster:
On-time rate (40% weight): delivered within 2 hours of the promised time counts as on time. Data source? The driver's signed delivery receipt versus the promised time on the bill of lading. One spreadsheet formula. Critical detail: on-time must mean delivered on time, not picked up on time. More on that trap below.
Rejection rate (25% weight): the share of our tendered loads the carrier turns down. One or two rejections in peak season is human. But some carriers smile all year and vanish in November — that goes on the record.
Claim rate (20% weight): the share of loads with loss or damage, plus a hidden column — average days to claim payout. Lost freight is survivable. Money stuck in "processing" for half a year is not.
Billing accuracy (15% weight): how often the invoice matches the quote. Some carriers quote one price and then the accessorial charges bloom like spring flowers. Skip this one and month-end reconciliation will make you cry.
Each metric scores 0–100, weighted into a total. The rule is written in stone, no exceptions: below 75 goes on the watch list; below 70 two months in a row gets blacklisted, and the volume goes to someone else. I learned the hard way that "giving them one more chance" is how small warehouses lose money.
98% On-Time? Ask Who Defined "On-Time"
Two years ago a carrier's sales rep thumped his chest: "98% on-time rate, best in the industry." I believed him and gave him real volume. Customer complaints started climbing, so I ran my own numbers: 83%.
I confronted him. His answer, delivered with a straight face: "We measure pickup on-time. Our trucks always arrived at your dock on schedule." Sure — the truck showed up on time, then the freight wandered around for three days and delivered two days late. That counts as on-time? From that day on, my rule: never trust a carrier's self-reported numbers, not even the punctuation. On-time rate comes from your own data, measured at delivery.
The epilogue: once I rescored everyone on a delivery-based definition, that carrier dropped to 71 — straight onto the watch list. Two months, no improvement, blacklisted. The prettier the sales pitch, the more you need your own ruler.
A Claim Took Six Months — That's When I Learned to Track Claim Rates
The second lesson hurt more. One shipment: 12 cartons, worth over $8,000. Three cartons never reached the customer. The carrier admitted their hub lost them and promised to pay the claim. That "promise" lasted six months.
I made 20+ phone calls and sent countless emails over those six months. The answer was always "it's in process." The money never came, and meanwhile I had to make the customer whole out of my own pocket. The cash-flow pain of having $8,000 frozen for half a year — only a small warehouse owner understands. At our size, that's payroll money.
After that, the scorecard got a claim-rate metric and an iron rule: any carrier whose average claim payout exceeds 90 days scores zero on claim rate. Don't tell me about "process." Slow process is your problem. Now, before working with anyone new, I ask one question: "How long does your average claim take to pay out?" If they can't answer, I walk away.
Carrier Scorecard in Action: Firing the Bottom Carrier
Late last year I replaced our lowest-scoring carrier. It stung — they were the cheapest quote on the board, about 5% below the runner-up.
Three months later, I pulled the numbers:
- Average cost per shipment rose about 3% (the new carrier charges a bit more)
- On-time rate went from 84% to 93%
- Customer complaints dropped by nearly half
- Zero rejections during peak season
The math is obvious: that extra 3% in freight cost is nothing next to one canceled $4,000 order. And with fewer complaints, the customer-service hours we saved paid for the 3% many times over.
Here's my contrarian take: for a small warehouse, cheapest is not the top criterion — reliability is. A carrier that's 5% cheaper will give it all back the first time they burn you, plus your reputation as a tip. Big companies negotiate "two cents off per shipment." We negotiate "can I sleep tonight." Different game — don't copy the enterprise playbook.
Three Pieces of Advice for Fellow Small Warehouses
After a year and a half of tinkering, this spreadsheet is now our warehouse's heirloom. Three suggestions for operators who also can't afford a TMS:
First, start recording before it's perfect. My first version had two columns: carrier name and "gut feeling (reliable or not)." Get the data flowing; you can standardize definitions later. The most dangerous mindset is "we'll manage carriers once we have a system" — that day never comes.
Second, collect your own data; never use the carrier's. Delivery receipts, bills of lading, invoices — they're all in your hands. Ten minutes of cross-checking beats any BI dashboard.
Third, blacklist decisively. Keep a sub-70 carrier around and the freight you "saved" will come back as claim payments and apology letters. A small warehouse's reputation is a thin wallet — you can't afford to lose it.
We have no big systems and no data team. But small warehouses have their own way of surviving: one spreadsheet, four metrics, thirty minutes a month, and your carriers stay honest. It ain't fancy. It works.
By Xiao Ma, Small Warehouse Owner
