Why rate management quietly breaks once you pass 20 carriers

Almost every forwarder starts the same way: one workbook, a few tabs, and a colleague who knows where everything is. It works, right up until it doesn't. The tipping point is rarely volume — it's variety. Two dozen carriers, each with their own surcharge naming, validity windows and amendment habits.

The symptoms are familiar. A quote goes out with last month's BAF. A customer asks for a lane nobody can find pricing for, so the enquiry is politely declined. A new hire spends three weeks learning where the real numbers live rather than selling.

What actually fixes this isn't a better spreadsheet. It's a structured rate repository where a lane, a charge and a validity period are first-class objects rather than cells. Once rates are structured, everything downstream — quoting, margin rules, reporting — becomes straightforward instead of heroic.

If you're weighing this up, a useful test is to ask your pricing desk one question: how long would it take to tell me every valid rate we hold on Shanghai to Rotterdam right now? If the answer is measured in hours, the spreadsheet has already broken.