Ask a freight broker how the business is doing and you usually get a confident answer. Ask which customers cost them margin last quarter and the answer takes a day, because someone has to export three reports and put them in a spreadsheet first.
That spreadsheet is where good data goes to lose its credibility. One person builds it, another edits a copy, and by the time it reaches the owner there are two versions and nobody is sure which one is right. Then the meeting stops being about the customer and starts being about whose numbers are correct.
Here are five reports a brokerage should be able to run directly from its system, without exporting anything. If yours can’t, it’s worth knowing why.
1. Margin by load, lane, customer and rep
Revenue is easy to report. Margin is the number that decides whether the business is healthy, and it’s the one most often hidden.
The key is seeing it at more than one level. A customer can look profitable on average and still contain a few lanes that lose money every week. A rep can look busy and still be booking freight at thin margin. Average margin hides all of that.
The question this report should answer in under a minute: which customers and lanes made us money last quarter, and which cost us?
2. Carrier performance over time
Most brokerages track carriers in a shared memory: the dispatcher knows who shows up late, and the new rep learns it the hard way.
A proper carrier report puts that knowledge on the record. On-time pickup and delivery, how often a carrier accepts a tender, how often a load ends in a claim, and how their rates have moved on the lanes you use them for.
The value is in the trend. A carrier who was reliable in spring and slipping by autumn is a risk you want to see before a shipper calls to complain.
3. Aging and unbilled loads
Delivered but not invoiced is cash sitting in a drawer.
In a busy brokerage, loads get delivered on Friday and forgotten until someone reconciles at month end. A simple list of delivered loads that haven’t been billed, sorted by age, is often the fastest way to recover cash that was already earned.
The same view should show what is owed to you and what you owe carriers, by how long it has been outstanding. If that takes a finance person half a day to assemble, it won’t be looked at often enough to matter.
4. Lane profitability against the market
Knowing your margin on a lane is useful. Knowing whether that margin makes sense for the lane is better.
This report compares what you charge and pay on a lane with where the market sits. It shows you where you are winning, and where you are quietly subsidising a customer because the rate was set a year ago and never revisited.
A common example: a lane priced comfortably last spring, when trucks were easy to find. Carrier costs rise over the summer, the customer rate stays where it was, and the lane keeps moving freight every week while the margin on it slowly disappears. Nobody notices, because the load count looks healthy.
5. Exceptions and detention
Every brokerage has loads that go wrong: late pickups, missed appointments, detention, damaged freight, rolled loads. The problem is rarely one bad load. It’s the pattern.
An exceptions report shows how often it happens, on which lanes and for which customers, and what it cost. That tells you whether a problem is a one-off or a structural one, such as a shipper whose dock regularly holds trucks for hours.
Without it, exceptions live in emails and memory, and the lessons are lost.
It also changes the conversation with customers. “Your dock held our trucks for an average of three hours on eleven loads last month” is a very different discussion from “we’ve had some detention issues lately.” One is a fact you can price into the next rate. The other is a complaint that is easy to brush aside.
Why “we just export it” stops working
Exports are fine as a stopgap. The trouble is what they do to trust.
- The moment data leaves the system it starts going out of date.
- Two people will build the same report slightly differently.
- Nobody can trace a number back to the load that produced it.
Once a leadership team stops trusting the numbers, they stop using them, and decisions go back to instinct. Reporting only works if people believe it.
A simple test for any system
When you evaluate software, or review the one you already have, don’t ask whether it has reporting. Nearly everything does. Ask it to answer one of the questions above, live, on your own data, without exporting.
Pick the one you would use most. For many brokerages that is which customers cost us margin last quarter? If the answer takes a spreadsheet, you have found the gap.
Most brokerages don’t lack data. They lack a way to ask it a question and trust the answer the first time.
The fix is usually not a better spreadsheet. It’s keeping the load, the carrier, the documents and the margin in one record, so the report is simply a view of data that’s already there. For more on what to look for, see our guide to what freight brokers need to see in TMS reporting.
About the author: The Polt.ai team builds transportation management software for freight brokers and 3PLs. Learn more at polt.ai.
