Carrier Rate Grid Management: How to Digitize and Automate Freight Tariffs

A carrier rate grid (also called a rate card, tariff sheet or price matrix) is the table a carrier hands you when you sign or renew a contract. One axis lists destinations — zones, postcode prefixes or regions. The other lists shipment sizes — weight brackets, pallet counts or loading meters. Each cell is a buy price: what the carrier charges you for that combination.

Your sell price is that buy price plus your margin. So the grid is not paperwork — it is the raw material of every quote you send, and every quoting mistake traces back to how the grid is stored and read.

In practice, grids arrive as Excel or CSV files, occasionally as PDFs, and every carrier structures them differently. One prices per 100 kg across 12 zones. Another prices per pallet from 1 to 6. A third uses loading-meter brackets. A brokerage working with 10–20 carriers ends up with hundreds of spreadsheet tabs, each with its own footnotes, minimums and surcharge rules.

Managing that collection — keeping it current, readable and quotable — is what rate grid management software does. It is also the fastest way to onboard a carrier that has no API, as we explain in our guide to carrier integration for freight brokers.

Before you can digitize a tariff, you need to recognize its model. After enough carrier contracts, a pattern emerges: four structures cover nearly everything in road freight.

Weight-zone grids carry a subtlety called paying-for logic: it can be cheaper to pay for more weight than you ship. Say 950 kg falls in a bracket rated €14.20 per 100 kg — that is €134.90. But the next bracket starts at 1,000 kg and is rated €11.80, so "paying for" 1,000 kg costs €118.00. A correct engine compares both and charges the lower amount — a saving a tired operator will miss on a Friday afternoon.

Whatever the model, the grid is read against a shipment figure you compute first: chargeable weight for weight-zone and hybrid grids, linear meters (LDM) for MPL brackets. Our chargeable weight calculator gives you the figure in a few seconds if you want to check a grid by hand.

Cargavo's pricing engine supports exactly these four models natively, which is why quotes come back in seconds — see our guide to digital freight quoting, the detailed breakdown of the four types of freight rate grid, and linear meter (LDM) pricing explained.

Excel is where almost every brokerage starts, and it is genuinely good at holding a tariff. The problem is everything that happens after storage: finding the right cell, applying the bracket rules, adding the margin, and doing it fast enough to win the load.

The tipping point is volume. At five quotes a day, spreadsheet friction is annoying. At twenty, it costs you loads: the customer who waits three hours for a price has usually booked elsewhere. And a single stale tab — last year’s tariff still open on one operator’s screen — quietly sells below cost for weeks.

If you are weighing this move as part of a bigger tooling decision, our TMS buyer’s guide for small freight brokers covers the full picture.

Digitizing a grid is a one-time effort per carrier, and it is smaller than most brokers expect. A typical grid takes well under an hour to structure; most teams have their main carriers live within a day or two.

1. Inventory your tariffs. List every active carrier contract, its validity dates and its file. Discard superseded versions now — they are the ones that cause below-cost quotes later.
2. Identify the model. Match each grid to one of the four structures above. If a sheet mixes two regimes (flat fee under 100 kg, per-100 kg above), that is a hybrid, not two grids.
3. Clean the source file. Un-merge cells, turn footnotes into explicit rules (minimum charge, surcharges, excluded postcodes), and confirm the unit of every column.
4. Enter the grid as structured data. In Cargavo you create the grid, define zones and brackets, and key in the rates from your Excel or CSV through structured entry screens. structured grid builder is on the roadmap; today the structure does the safeguarding.
5. Verify against reality. Re-quote 10–15 real past shipments and compare with what you actually paid. Fix discrepancies before going live.
6. Retire the spreadsheet. One source of truth, or none.

Step 5 is the one teams skip and regret. Fifteen minutes of checking protects thousands of future quotes. The column-by-column detail of steps 3 and 4 is in how to rebuild an Excel rate sheet into a TMS. You can run this whole process inside a free 14-day Cargavo trial.

A digitized grid gives you correct buy prices. Margins turn them into sell prices — and this is where discipline pays or leaks.

Two margin types cover real-world needs — and the first thing to settle is the arithmetic, because markup and margin are not the same number. Percentage margins scale with the shipment: they protect you on large freight, where a fixed €40 on a €900 buy price would be far too thin. Absolute margins guarantee a floor on small freight: +€45 on a €90 groupage rate keeps the file worth handling, where a percentage would return pocket change.

Granularity matters as much as type. In Cargavo you set margins per customer (a strategic account earns tighter pricing than a one-off shipper), per grid (your express carrier tolerates different markup than your economy one), or per bracket (thin margins on the competitive 1–2 pallet range, fuller ones elsewhere). The engine picks the right rule automatically on every quote.

Two guarantees make this safe. First, margins are applied server-side — no browser trick, typo or hurried operator can bypass them. Second, your customers never see buy prices or margins: the customer portal shows sell prices only, whether a quote is generated by your team or by the customer themselves. How that changes response times is covered in our guide to digital freight quoting; choosing between the two types is covered in margin rules: percentage or fixed amount, and the confidentiality mechanics in how to hide the buy rate from customers.

A rate grid is not a static document. Carriers apply general rate increases every January, renegotiate mid-contract, adjust surcharges, and occasionally re-zone whole regions. However good your initial digitization, the update workflow decides whether your prices stay true.

With spreadsheets, an update means e-mailing a new file to the team and hoping everyone closes the old one. Experience says someone doesn’t. That person quotes January shipments at last year’s rates — and because the error is silent, you find it at month-end in your margin report, not at quote time.

With a grid system the update happens once, centrally. You revise the affected grid, and every quote from that moment on — from your team or from your customer portal — computes on the new rates. Validity dates let you keep a clean boundary between the outgoing tariff and the incoming one.

Traceability closes the loop. Every Cargavo quote carries a reference (Q-2026-0148 style) and every shipment its own (S-2026-0092), so when a carrier invoice surprises you, you can trace exactly which prices were sent and honor them without argument. A practical rhythm for a small brokerage: a yearly refresh of every grid each January, plus an update within 48 hours whenever a carrier announces a change. Indexed fuel surcharges move more often than base rates — our fuel surcharge calculator lets you check a carrier's announced index against your own grid before you apply it.

The market splits in two. Enterprise platforms — Alpega, Transporeon (Trimble), Descartes — are powerful and built for large shippers and carrier networks, with implementation projects and budgets to match. For a brokerage of 2–25 people, the deciding factors are different: can you set it up yourself, this week, at a price that makes sense for your quote volume?

A practical checklist:

• All four grid models supported natively — weight-zone with paying-for logic, per-pallet, linear-meter brackets, hybrid. If your carrier’s structure isn’t supported, you’ll bend the data and pay for it in wrong quotes.
• Self-service grid entry from your existing Excel/CSV tariffs, with no consulting engagement.
• Server-side margins, configurable per customer, grid and bracket.
• A branded customer portal that shows sell prices only — buy rates and margins stay yours.
• Pricing that fits your volume. Cargavo’s Starter plan is €49/month (10 grids, 200 quotes/month, 25 customers); Growth is €149/month (50 grids, 1,500 quotes, assisted onboarding); Scale is €399/month (200 grids, 10,000 quotes, white-label portal). Yearly billing is roughly two months free.

Compare plans in detail on our pricing page, or test with your own tariff: the 14-day trial needs no credit card, and entering one real grid is the most honest evaluation there is. For the broader platform decision, see our TMS guide for small freight brokers.