Excel vs freight forwarding software: when a spreadsheet stops being enough

A sample shipment, the spreadsheet way

The following is a fictional, simplified example of a common small-forwarder setup. Your tools may differ, but the pattern is usually recognisable. A customer, Example Imports Ltd, asks for a price on one 40' container of furniture from Ningbo to Rotterdam, delivered to their warehouse.

Where the same data is typed again

Counting from the table above, in this sample:

• the customer name is typed in five places (quote, booking email, tracker, document file names, invoice);
• the route and container are typed three times (quote, booking, tracker);
• the sell charges are typed twice (quote, invoice) and the costs twice (quote estimate, tracker actuals);
• the file reference has to be copied by hand into every tool so the pieces can be matched later.

None of these steps is hard. The problem is that each copy can drift: a rate is updated in the quote tab but not on the invoice; the tracker says 1 × 40'HC while the booking says 1 × 40'; a customer's legal name is spelled two ways. Each mismatch costs a phone call or a credit note, and some are never noticed.

Handoffs that depend on memory

Duplication is visible. Missed handoffs are not, because nothing records that a step should have happened:

• Accepted quote → booking. The acceptance arrives by email to whoever sent the quote. If that person is out, the booking waits.
• Documents → customer. Whether the arrival notice was sent depends on someone remembering to attach it.
• Supplier cost → profit. A late destination invoice can turn a profitable file into a loss after the customer was already billed, and nobody sees it until month-end.
• Shipment done → invoice. Finance needs to know a file is ready to bill. In a spreadsheet that is usually a colour or a status cell someone has to update.

When Excel is enough

A spreadsheet is a reasonable choice when most of these are true:

• one or two people handle every file end to end, so there are few handoffs;
• volumes are low enough that every open file fits on one screen;
• you rarely work in more than one currency or across branches;
• customers are happy with status by email;
• someone on the team maintains the workbook carefully — locked formulas, a template per quote, consistent references.

If that is you, invest in a good template first. Our free freight quotation template separates internal costing from the customer-facing quote and handles weight, volume and currency conversion.

Signs you have outgrown it

• More than one person touches a file between quote and invoice.
• You regularly ask "which version of the quote did the customer accept?"
• Profit per shipment is only known after month-end reconciliation.
• Finding a document means searching email.
• You have added a second branch, a second currency, or a customer who wants self-service visibility.
• The workbook has a single owner, and it stops when they are on holiday.

What a connected system changes — and what it does not

The point of forwarding software is not that it is software. It is that the shipment becomes one record that every step reads from and writes to. In a connected system such as Tranvoro, the sample shipment above would look like this:

• the quote holds customer, route, container and buy/sell lines once; converting it creates the shipment with all of them;
• the shipment shows which required documents are missing, and documents are shared with the customer from the shipment;
• supplier costs are recorded against the shipment, so profit updates as they arrive rather than at month-end;
• the invoice is built from the shipment's charges, and payments are allocated against it.

What it does not change: someone still negotiates rates, chases documents from shippers and checks what customs needs. Software removes re-typing and makes missing steps visible; it does not do the forwarding for you. Moving also takes some setup — your customers, charge codes and document rules need to be in place before the first live file.

How to evaluate forwarding software

Whichever product you consider, run one real recent shipment through it during the trial and check:

1. Can a quote become a shipment without re-entering route, cargo and charges?
2. Are costs and sell prices kept separate, and does the customer only ever see sell prices?
3. Can you see which documents are missing for this shipment?
4. Is the invoice generated from the shipment's charges, in the currencies you bill in?
5. Can customers see their own shipments without seeing anyone else's?
6. How is it priced — per user, per shipment or per module — and what does that mean at your volume next year?
7. Can you get your data back out, and who can you ask for help during setup?

Moving off spreadsheets without disruption

1. Start with new files. Leave shipments already in progress where they are; run new quotes in the new system.
2. Import customers first. A clean customer list with one spelling per company prevents most later mismatches.
3. Set up charge codes and document rules to match how you actually bill and what you actually need per mode.
4. Run one file end to end — quote to payment — before moving everyone over.
5. Retire the tracker once two weeks of new files live only in the system.