Most quote requests are not hard. They are repetitive: find the lane, find the rate, add the charges, type it up, check it, send it. Do that 40 times a week and it eats a person.
This guide shows how to cut that work down with tools you already have: a clean rate table, an Excel calculator (free download below), and AI used only for reading emails. No software to buy.
Download the free quote calculator (Excel)
One row per lane and unit. Not one tab per carrier, not rates in email threads. The columns that matter:
If your sheet isn't there yet, run it against our 15-point rate sheet checklist first.
Terminal, docs, clearance, biosecurity, delivery, fuel levy. Each one gets its own row and a basis:
When charges live in people's heads, two people quote the same job two different ways. Written down, everyone quotes the same price.
The free Excel calculator has three tabs: Rates, Charges and Quote. Fill in the yellow cells from the request and it works out:
Sample rates are in it so you can see how it works. Replace them with yours.
Reading a messy request is where AI helps. Pricing is where it hurts: a model will happily invent a rate that looks right. So split the job. AI pulls the details out of the email. Your rate table and calculator set the price.
Paste this into ChatGPT, Copilot or Claude, followed by the customer's email:
Read the freight quote request below. Do not price it and do not guess. Return only these fields, one per line. Write "missing" for anything not stated: Mode (FCL / LCL / AIR / ROAD): Origin (city, port or postcode): Destination (city, port or postcode): Incoterm: Container type and quantity, or number of pallets: Total actual weight (kg): Total volume (cbm): Commodity: Dangerous goods, temperature control or oversize (yes / no / missing): Cargo ready date: Services asked for (clearance, delivery, insurance): Questions the customer asked: Request: [paste the email here]
Copy the fields into the calculator. Anything marked “missing” goes to step 6, not to a guess.
Customers compare quotes side by side. Make yours the easy one to say yes to: the route, every charge on its own line, the total, what's excluded and how long it's valid.
Hi [first name], Thanks for the enquiry. Please see our quote for [1 x 40HC, FOB Shanghai to Melbourne, delivered to Truganina VIC]. Ocean freight 1 x 40HC ........................ AUD [x] Destination terminal & docs .................. AUD [x] Customs clearance ............................. AUD [x] TOTAL ......................................... AUD [x] Valid until [date]. Excludes GST, duty, storage and detention. Cargo ready [date]: we'll confirm the next sailing once you approve. Quote ref: [ref]. Quote it when you book. Kind regards, [name]
Half-complete requests are normal. Answer within the hour with one short list, so the customer can reply in a single email:
Hi [first name], Happy to quote this. To price it accurately I just need: - [total weight in kg] - [total volume in cbm, or carton dimensions] - [delivery suburb and postcode] Send those through and the quote comes straight back. Kind regards, [name]
Most lost quotes are never chased. Put a reminder on every quote you send. Three days later, one short line:
Hi [first name], just checking you received our quote for [route]. Rates are held until [date]. Reply here and we'll book it in.
Log won and lost against each quote. After a month you'll know which lanes you win and where you're priced out.
This setup works. It still needs a person at the keyboard for every request: reading, copying fields across, building the reply, attaching the PDF. It starts to strain when:
The Quote Desk Scorecard takes 2 minutes: 10 questions, your score, and the fix for each gap.
Laneworks does steps 3 to 6 for you. It reads each request as it arrives, prices every line from your own rate sheet by fixed rules, and drafts the reply and PDF in your company's name for your team to check and send. Lanes that aren't on your sheet are flagged, and the rate request to your partner is written for you. Nothing is guessed.
See it on your own work first: send 20 recent requests and your rate sheet, and get back a one-page report of what would have gone out ready to send.