Free tools

How to automate freight quoting yourself

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)

The 8 steps
  1. Put every rate in one table
  2. Write down every charge and how it's charged
  3. Price with the calculator
  4. Let AI read the email, never set the price
  5. Reply from a standard template
  6. Ask for missing details the same way every time
  7. Five checks before anything goes out
  8. Follow up on day three
1

Put every rate in one table

One row per lane and unit. Not one tab per carrier, not rates in email threads. The columns that matter:

  • Mode: FCL, LCL, AIR or ROAD.
  • Origin and destination, spelled the same way every time.
  • Unit: 20GP, 40HC, W/M, kg or pallet.
  • Rate and currency.
  • Valid from and valid to. An expired rate is the most expensive mistake in quoting.

If your sheet isn't there yet, run it against our 15-point rate sheet checklist first.

2

Write down every charge and how it's charged

Terminal, docs, clearance, biosecurity, delivery, fuel levy. Each one gets its own row and a basis:

  • Per unit: per container, per W/M, per kg or per pallet.
  • Per shipment: once per job, like a clearance fee.
  • Percent of freight: fuel levies and similar.

When charges live in people's heads, two people quote the same job two different ways. Written down, everyone quotes the same price.

3

Price with the calculator

The free Excel calculator has three tabs: Rates, Charges and Quote. Fill in the yellow cells from the request and it works out:

  • Chargeable units. Air: the higher of actual kg and volume × 167 (the 1:6000 ratio). LCL: the higher of cbm and kg ÷ 1,000. FCL per container, road per pallet.
  • Freight, charges, cost, your markup and the price.
  • A flag that blocks the price when the lane isn't on your sheet, the rate has expired or details are missing. No price shows until it says “OK to send”.

Sample rates are in it so you can see how it works. Replace them with yours.

4

Let AI read the email, never set the price

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]
Before you paste customer emails into any AI tool, check it is one your company has approved for customer data. Business plans of Microsoft Copilot, ChatGPT and Claude let companies control whether data is used for training. Free consumer accounts are a different matter.

Copy the fields into the calculator. Anything marked “missing” goes to step 6, not to a guess.

5

Reply from a standard template

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]
6

Ask for missing details the same way every time

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]
7

Five checks before anything goes out

  • 1. Every rate is valid on the date you're quotingAnd the quote's own validity doesn't run past the rate's.
  • 2. The Incoterm matches the chargesFOB means no origin charges on your quote; EXW means pickup and origin charges are yours to include.
  • 3. Units are rightChargeable weight for air, W/M for LCL, the right container size for FCL.
  • 4. One currency, or conversions shownNo silent USD to AUD.
  • 5. Exclusions are statedDuty, taxes, storage, detention, demurrage: the same wording every time.
8

Follow up on day three

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.

When doing it yourself stops working

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:

Check where your desk stands

The Quote Desk Scorecard takes 2 minutes: 10 questions, your score, and the fix for each gap.

Or have it run on your inbox

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.

Ask for the report