When Spreadsheets Stop Working for Supplier Rates

A spreadsheet is a genuinely reasonable way to manage supplier rates when you're small. This isn't a piece arguing that every tour operator needs dedicated software from day one, that's not true, and pretending otherwise doesn't do you any favours. The honest question is: at what point does that stop being true for your specific operation, and what actually breaks first when you're past it.

Spreadsheets genuinely work, up to a point

A well-organised spreadsheet, clear tabs, consistent naming, one source of truth per supplier, can handle a meaningful amount of complexity. If you're working with a handful of suppliers, quoting in a single currency, and building a manageable number of quotes a month, the overhead of learning and paying for dedicated software can genuinely outweigh what it saves you.

One tour operator technology guide puts a rough number on this: below around 15 active suppliers, operating in fewer than 3 currencies, and under 50 bookings a month, a structured spreadsheet system can serve an operation better than software it can't fully use. That's a useful sanity check before assuming you've outgrown spreadsheets just because someone's telling you to.

Where the threshold actually sits

What actually changes as you grow isn't really the number of suppliers on its own, it's the number of things that have to stay in sync at once. A handful of suppliers in one currency means one person can hold the whole picture in their head, or at least in one well-maintained file. Add a few more suppliers, a second currency, seasonal rate changes, and different pricing for adults sharing versus a single supplement versus a child, and the number of cells that need to update correctly every time something changes grows much faster than the supplier count alone suggests.

That's the real threshold: not a headcount or a supplier count in isolation, but the point where a single rate change (a supplier updates their pricing, a season shifts, a currency moves) means manually finding and correcting that number in several different places, quotes already drafted, a master rate sheet, sometimes a second copy someone else is working from. Miss one of those and a client gets quoted the wrong price, which is a worse outcome than the time spent maintaining the spreadsheet in the first place.

What breaks first, and why it's rarely the spreadsheet's fault

When operators describe spreadsheets "not working anymore," the actual failure is rarely the spreadsheet itself, spreadsheets are capable tools. It's usually one of a few specific things: a rate gets updated in one place and missed in another, a new supplier's rates arrive as a PDF and get manually retyped (introducing the exact kind of transcription error a spreadsheet can't catch on its own), or building a quote for a mixed group means manually working out sharing, single supplement, and child rates each time rather than having them calculated consistently.

None of those are spreadsheet failures exactly, they're the natural result of manual data entry scaling past what one careful person can reliably keep correct. Centralising supplier rates in one place, rather than retyping them into a spreadsheet each time a quote comes up, is really just removing the step where errors get introduced, not replacing something that was broken.

If you're below that rough threshold, that's a genuinely fine place to be, worth revisiting once your supplier count, currencies, or quote volume start climbing, not before. See if it's for you when it does.

Frequently asked questions

How many suppliers before I should stop using a spreadsheet?

There's no exact universal number, but one tour operator technology guide suggests below roughly 15 active suppliers, fewer than 3 currencies, and under 50 bookings a month, a well-organised spreadsheet can genuinely still serve you well. Past that, the number of things needing to stay in sync tends to grow faster than the supplier count alone suggests.

Is it always a mistake to use spreadsheets for rate management?

No. For a small operation with a manageable number of suppliers and a single currency, a clean, consistently maintained spreadsheet is a perfectly reasonable tool. The problems tend to show up as complexity grows, not because spreadsheets are inherently flawed.

What actually causes errors when managing rates in spreadsheets?

Usually manual data entry: a supplier's rate changes and gets missed in one of several places it's recorded, a new PDF rate sheet gets retyped by hand, or per-traveller pricing (sharing, single supplement, child rates) gets recalculated manually for each quote rather than pulled from a consistent source.

When is it worth centralising supplier rates instead of using a spreadsheet?

Once rate changes, multiple currencies, or the complexity of per-traveller pricing mean a single update has to be manually repeated in several places to stay accurate, that's the point where the risk of an inconsistency, and the time spent avoiding one, usually outweighs the cost of a dedicated tool.