Why Freight Forwarders Are Still Quoting in Excel in 2026

Many Indian freight forwarders still rely on Excel rate sheets, manually copy information from emails and messages, and calculate margins under time pressure. This can lead to inconsistent pricing, missed enquiries, and mistakes in quotes and invoices that only come to light when a customer raises a dispute.

Freight quotation software can reduce this manual work by automating rate lookup, applying margins, and keeping track of quote versions. And freight forwarders don't necessarily have to replace their existing Transport Management System (TMS) to use it.

What Is Freight Quotation Software?

Freight quotation software turns shipping enquiries into priced, consistent quotes by pulling rates, applying margins, and tracking every version from the first enquiry through to the final invoice. It's a different job from a Transport Management System (TMS), which takes over after a quote is confirmed and manages the shipment itself. That distinction matters more than it sounds like it should. A common source of friction for forwarders is trying to solve the quoting problem with a tool built for shipment execution, or with no dedicated quoting tool at all.

Why do freight forwarders still use Excel for quoting?

Many freight forwarders continue using Excel because their rate sheets started as simple, practical tools and gradually became part of the daily workflow.

As more trade lanes, surcharges, customer-specific rates and exceptions were added, replacing the workflow started to feel more disruptive than continuing to patch it.

Here's what that can look like after a few years.

Rate Sheets That Only One Person Understands

The sheet grows tab by tab: a new lane here, a client-specific exception there, until one person in the office is the only one who can update it without breaking something for a completely different customer. When that person is out sick, on leave, or leaves the company, quoting either stalls or starts producing errors nobody catches until a customer disputes an invoice weeks later.

Copy-Paste Between Email and Spreadsheet

Enquiries arrive by email, WhatsApp or phone, usually without structured information. Someone then has to transfer the details into the rate sheet, calculate the cost, and manually prepare the quote.

Every time information moves from one place to another, there is a chance of a mistake: a number can be missed, a surcharge can be forgotten, or an old rate can be used.

These mistakes don't always look serious at the time. Over many shipments, however, small errors can quietly eat into margins.

Manual Margin Calculation Under Time Pressure

Getting the margin right becomes difficult when someone has to remember every applicable fee and surcharge while handling several enquiries at once.

Two similar shipments can end up with different margins not because the pricing policy changed, but because the calculations were done manually under different circumstances.

The more enquiries a team handles, the harder it becomes to maintain consistent pricing manually.

Multiple Versions of Quotes Without a Single Source of Truth

Many quotes go through multiple revisions before they are finalised: a rate changes, a customer asks for an alternative, or someone corrects a container size.

Each version may end up in a separate file or email conversation. When the invoice later doesn't match what the customer remembers agreeing to, someone has to search through old emails to find the right version instead of checking one clear record.

Enquiries That Get Lost Entirely

This is the quietest failure of all. An enquiry comes in during a busy stretch, gets set aside "to follow up on later," and never gets quoted because nobody wanted the business, but because nothing was tracking which enquiries were still open. This kind of lost business doesn't show up on any report. There's no record it ever existed.

A Typical Quote on a Busy Day

A customer sends an enquiry for an LCL shipment. The salesperson checks the latest ocean rate, looks up the applicable origin and destination charges, confirms a surcharge with the operations team, works out the margin and sends the quote.

Then the customer asks for a revised option.

The rate changes. The quote is edited. A second version goes out.

A few weeks later, when the shipment is finally invoiced, someone has to work backwards to figure out which rate and margin were actually agreed.

None of these steps is complicated on its own. The problem is that they happen across emails, spreadsheets, messages, and people and nothing ties them together.

Does freight quote automation mean we have to get rid of our transportation management system?

No. Freight quote automation and a Transport Management System are designed to handle different stages of the same workflow. They can work alongside each other rather than replacing one another.

Many TMS platforms are primarily designed around shipment execution bookings, documentation, tracking and operational workflows. Quoting, on the other hand, often remains a separate process outside the system.

When quoting isn't connected to the rest of the workflow, teams often fall back to Excel and email because there is no single workflow connecting the two.

The better approach is to automate the quote-to-invoice stage: structured rates, consistent margins, one current version of the quote and a clear trail from enquiry to invoice, while allowing the TMS to continue handling shipment execution.

What does fixing the quoting stage actually solve?

When done correctly this includes:

• Rate sheets that are organised and updated rather than dependent on one person's memory
• Quotes created directly from enquiries without manually transferring information between email and spreadsheets
• Margins applied consistently regardless of who is creating the quote or how busy the team is
• One current version of every quote with a clear history of what changed and why
• Enquiries tracked from first contact through to invoice so nothing quietly falls through

Key Takeaways

• Manual Excel-based quoting causes margin leakage and lost enquiries that rarely show up on a report until a customer disputes an invoice
• Quote automation and a TMS solve different problems; one owns quoting, the other owns shipment execution
• The fix is closing the enquiry-to-invoice gap, not replacing systems that already work