Rate-sheet automation
Turn your existing rate sheets into quote-ready pricing.
Keep the spreadsheet layout your team already knows. Freitt maps the rates, charges, validity and pricing rules so each quote can show exactly where every number came from.
- Your existing Excel layout
- Validity tracked
- Every charge sourced
- No invented rates
LAX-AU_Air_Q3.xlsx
Qantas Freight · 214 rate lines
Column mapping
| Lane | Basis | Rate | Valid to | Status |
|---|---|---|---|---|
| LAX → SYD | per kg | 3.90 | 30 Sep | live |
| LAX → MEL | per kg | 4.15 | 30 Sep | live |
| LAX → BNE | per kg | 4.40 | 31 Jul | expired |
Expired lines are held back from quoting until you refresh the sheet.
Nobody is quite sure which file is the current one.
Rate sheets are not the problem. Rate sheets scattered across a shared drive, an inbox and three people’s laptops, with no way to tell at a glance which lines are still valid, is the problem — and it is the reason a quote occasionally goes out on an expired rate.
- 01Find the sheet. Check it is the one the carrier sent last, not the one before.
- 02Find the tab, then find the lane inside it.
- 03Check the validity dates in a column nobody standardised.
- 04Read across for the basis, the minimum and the surcharges.
- 05Retype the numbers into the quote, or into a calculator first.
- 06Remember, or fail to remember, which markup this customer gets.
- 07Hope nobody asks six weeks later where the figure came from.
The sheets stay yours. The lookup stops being manual.
Mapped once, in the layout the sheet already has. There is no new rate format to learn and nothing to re-key.
- 01Start with the sheets you already use.Upload your existing Excel rate sheets. The columns are mapped during setup in the layout you keep them in, and the mapping is remembered for the next version of that file.
- 02Keep charges and validity visible.Rates, charges and validity dates become records you can see — including which lines are about to expire.
- 03Apply the right rate to the right shipment.The line that matches the lane, mode and basis of the request is selected, and expired lines are excluded from the choice.
- 04Handle missing and expired lines honestly.No valid rate means the gap is flagged and a carrier inquiry is drafted. It does not mean a price is estimated.
- 05Trace every quoted number.Each charge on the quote points back at its sheet, its row, its validity date and the margin rule applied on top of it.
From a workbook row to a quoted charge.
A rate that cannot be traced is a rate you have to defend from memory. Every figure Freitt quotes names the file it came from, the row inside it, the date it is valid until, and the rule that was applied on top — which is a different conversation when a customer queries a price six weeks later.
Where this number comes from
- 1
Sheet LAX-AU_Air_Q3.xlsx · Qantas Freight · 214 lines
- 2
Row 47 · LAX → SYD · per kg · 3.90
- 3
Validity valid to 30 Sep · not expired at quote time
- 4
Basis chargeable weight 480 kg × 3.90 = 1,872.00
- 5
Rule Air · Oceania · +12% → 2,096.64
Illustrative sample data. Fuel, pickup and delivery are quoted as their own lines.
One sheet is expiring
LAX → BNE expired on 31 Jul and is excluded from selection. Draft the renewal request?
What happens when something is missing.
This is the half of automation worth interrogating. Freitt says so rather than filling the gap — no invented rate, no assumed weight, nothing sent unread.
Your rates, and only your rates.
- 01Every charge links to its source rate line.
- 02Expired rates are excluded from selection.
- 03Missing rates are flagged, not guessed.
- 04Your rate data is never used to train shared models.
- 05Each company works in its own encrypted workspace.
Use this when
- Your rates are already agreed and already live in spreadsheets.
- More than one person needs to price from the same sheets consistently.
- Somebody has quoted an expired rate, or nearly has.
- You want to be able to show a customer where a number came from.
Look elsewhere when
- Your problem is collecting and normalising rates from dozens of partners — that is rate procurement, and a different category.
- You need live spot rates and market benchmarking as a core requirement.
- Your pricing genuinely lives in your team’s judgement rather than in any sheet. Get it into a sheet first; that is worth doing either way.
- You are looking for carrier booking rather than customer pricing.
Rate sheets, answered.
Something else on your mind? Bring it to a live quote session — thirty minutes, no deck, on one of your own RFQs.
No. The sheet is mapped in the layout you already keep it in, during setup. Re-keying your rates into somebody else’s template is exactly the work this is meant to remove.
Upload it. The column mapping for that sheet is remembered, so a new version of a known file does not need setting up again.
Rate sheets are mapped from your spreadsheets. PDFs are read as attachments on an incoming RFQ, which is a different job — if your rates only exist as PDF tariffs today, bring one to the call and we will tell you honestly what is involved.
From the lane, mode and rating basis of the request, matched against the valid lines in your mapped sheets. When two could apply, it shows you both rather than choosing silently.
They stay as their own lines on the quote rather than being folded into a single number, so what is included and what is subject-to is visible to you and to your customer.
No. Each company works in a separately encrypted workspace, your rate data is not used to train shared models, and it is never retrieved into another company’s quote.
A cost is not a price.
Margin rules by lane, mode and customer sit on top of the rate line, and approval rules decide which quotes a person has to see before they can be sent.
See margins and approvalsFlow view
Approval
If total > 10,000
Hold for a second pair of eyes
Follow-up chaser
- Tue — quote sent
- Thu — 48 h, no reply
- Follow-up drafted
Chasers and clarifications are drafted, never sent on their own.
See it live
Bring one rate sheet and one RFQ.
We will map the sheet with you and price the request off it, in the same thirty minutes.
30 minutes · no deck · your rates stay private