Every forwarder has one file that would cost them a client if it went missing. Start there.

We are a software company, so you would expect us to say rip it out today. We would not. A two-person forwarder doing forty jobs a month on a well-built spreadsheet is running a tighter operation than a twenty-person firm fighting a system nobody wanted. The spreadsheet is not the problem. Outgrowing it without noticing is.

Five signs it has stopped being the right answer

1. Two people cannot safely work on it at once

   The moment somebody has to ask has anyone got the file open, you have introduced a queue into your operations. The cost is not the waiting. It is the copy called Jobs_FINAL_v2_Sam.xlsx that somebody made to get around the queue, which now contains a charge that exists nowhere else.

2. You cannot answer a question about last month in under a minute

   Did we make money on air freight in August? If answering that means opening three files and doing arithmetic in a fourth, you are not measuring your business, you are reconstructing it from memory every time somebody asks. Decisions get made on the reconstruction.

3. Something important is only in one person's head

   The free days on that container. The agreed rate with that agent. The reason that one job has a charge on it that looks wrong but is not. When knowledge lives beside the spreadsheet rather than inside it, a holiday becomes a risk and a resignation becomes an incident.

4. You have found money late, more than once

   Demurrage caught after the fact. A charge that was never invoiced. A job that turned out to lose money once everything landed. Spreadsheets record what happened. They do not put a hand up before it happens, and that gap has a running cost.

5. Somebody outside the company has asked to see something and you were not comfortable

   An auditor, an insurer, a customer disputing a charge, a partner doing due diligence. If the honest answer to who changed this figure and when is nobody knows, that is a governance problem, not an admin one.

Which one to replace first

Not all of them. That is the mistake that makes these projects fail. Replace the spreadsheet where the money is decided, and leave the rest alone until that one has bedded in.

For most forwarders that means the job file: the one holding selling rate, buying rate and therefore profit per job. It is the file everybody argues about, the file that has to be right at month end, and the file where two versions disagreeing costs the most. Get that into one place where the operations side and the accounts side read the same rows, and a surprising number of the other five problems quietly go away.

The second one is usually whatever tracks free days, because it is the only spreadsheet on the list that is supposed to warn you about the future rather than record the past, and a spreadsheet is very bad at that job.

Things to insist on when you move

• Your historic data comes with you. Not a fresh start. Anybody who suggests starting clean is telling you their import is painful.
• You can still get an export out whenever you like, in a format you can open. You are leaving one spreadsheet, not signing away the right to ever have one again.
• Move one thing at a time. A forwarder who changes everything in a week has a bad month. A forwarder who changes one file a quarter barely notices.
• Whoever keeps the spreadsheet today is involved from the first day. They know the awkward cases, and the awkward cases are where these projects die.