Spreadsheets vs tour operator software: when to switch, and how to do it without downtime

What spreadsheets do well

It is worth being fair to Excel and Google Sheets before criticising them. For a small travel business they have real advantages:

• Flexibility.Any pricing model, any column, any odd supplier contract. Nothing forces you into someone else’s idea of a trip.
• Cost. You already own them. There is no subscription and no onboarding.
• Familiarity. Every new hire can use one on day one, and your accountant can read it.
• Transparency. Every number is visible; you can trace exactly how a price was built.
• One-off complexity. A one-time incentive programme with unusual rules is sometimes quicker to model in a sheet than in any tool.

If one person quotes fewer than a handful of trips a month, a well-built costing template plus a good client itinerary template may be all you need. The free tour price calculator can sit beside it for quick markup and margin checks.

Where spreadsheets break

The problems rarely appear on trip one. They grow with volume, with staff and with how many times a trip changes before it travels.

Version control

“Rome_v3_final_REVISED_client.xlsx” is a joke because it is true. Once a quote has been revised three times and sent by two people, nobody is certain which file the client accepted — or which one the supplier bookings were made from.

Pricing errors you cannot see

A formula overwritten with a typed number, a row added below the sum range, a margin target entered in a markup column, an exchange rate from last season. Each looks fine on screen. You find out when the supplier invoices arrive and the trip made half the profit you expected — the classic markup vs margin slip is a 25% target quietly becoming 20%.

On a trip with €12,000 of net costs, that one slip is €1,000: 12,000 × 1.25 = €15,000 when the target meant 12,000 ÷ 0.75 = €16,000. Nothing in the spreadsheet looks wrong, because the formula did exactly what it was told. Errors like this are rarely caught by a second pair of eyes, because the second pair of eyes is reading the same sheet.

Speed of reply

Tailor-made enquiries are often sent to several companies at once. When each quote means opening last month’s file, deleting rows, re-checking rates and rebuilding the document, a reply takes days rather than hours — and the traveller may already be talking to whoever answered first.

Presentation

The costing sheet is not what the client sees, so every quote is built twice: once in Excel, then retyped into a document with photos and descriptions. Every change means editing both, and the two drift apart.

Handover

When the person who built a trip is ill or on holiday, a colleague has to reverse-engineer their sheet, their email thread and their notes. Each person’s spreadsheet tends to have its own logic.

Payments

Deposits and balances live in the bank account; the record of who owes what lives in another sheet, updated by hand. Chasing an unpaid balance two weeks before travel is how many teams discover the sheet was out of date.

Supplier status

Which hotels are requested, which are confirmed, which guide is still pencilled in? A colour-coded column works until two people edit it, or nobody does. Unconfirmed services are the most expensive thing to discover late.

Signs it is time to switch

No single item below means you must buy software. Three or more usually means the spreadsheet is now costing you more than it saves.

• ✓Quotes regularly take longer than a working morning to produce.
• ✓You have lost a booking because a competitor replied first.
• ✓More than one person quotes, and each has their own template.
• ✓You have found a pricing mistake after the client paid.
• ✓Clients ask for changes and you rebuild both the costing and the document.
• ✓You keep supplier descriptions in old itineraries and copy-paste them.
• ✓Nobody else can confidently pick up a colleague’s trip.
• ✓Deposit and balance tracking lives in a separate sheet or in your head.
• ✓You cannot quickly say which supplier bookings are still unconfirmed.
• ✓You do not know your actual margin by trip or by month without a day of work.

What spreadsheets really cost: a worked example

Spreadsheets feel free because there is no invoice for them. The real cost is staff time. You can estimate it with one line:

“Hourly cost” should be what an hour of a quoter costs the business — salary plus employer taxes and overheads — not just their take-home pay.

Compare that saving with the subscription you are considering. If the time saved is worth several times the software cost, the decision is straightforward. If quoting is a small part of your week, the case is weaker — and that is a legitimate answer.

Not ready to switch? Make your spreadsheets safer

If the numbers say software is not worth it yet, you can still remove most of the risk from a spreadsheet workflow. These habits cost nothing and buy you time:

• One master template, locked.Protect every formula cell so only inputs (net cost, quantity, pax) can be typed. New trips start from a copy of the master, never from last month’s trip.
• One pricing mode. Decide whether the business quotes in markup or margin, label the column with the formula, and put the conversion next to it.
• Exchange rates in one cell. Reference a single rate per currency, dated, rather than typing a rate into each row.
• Separate per-person and flat costs. Two blocks with their own subtotals stop the classic error of multiplying a private transfer by the number of travellers.
• A check row. A final line that recalculates the profit a second way and turns red if the two answers disagree.
• A shared status tab.One row per supplier booking with requested, confirmed and paid dates, kept in one shared file rather than in each person’s copy.

Notice what this list cannot fix: the double work of retyping a costing sheet into a client document, and the absence of one version everyone trusts. Those are usually what push teams to software in the end.

What to look for when you leave spreadsheets

Travel agency software ranges from simple itinerary builders to full reservations systems. Coming from spreadsheets, judge each option on the specific problems you are trying to solve:

• Pricing you can audit. You are used to seeing every number. The tool should show net cost, markup or margin, tax and profit per line and per trip — not a black-box total.
• Per-person and flat-rate items together, with the price recalculating when the number of travellers changes.
• A reusable service library, so supplier descriptions, photos and net rates are entered once.
• The client document generated from the same data as the costing — one change, both updated.
• Payments and supplier status on the trip record, not in separate files.
• Import from CSV or Excel, so your existing lists are not wasted.
• Exports, because your accountant will still want a spreadsheet at the end of the month.

Ignore features you will not use in the first six months. A tool your team actually opens every day beats a more powerful one that needs a consultant to configure.

How to migrate without downtime

The fear with any switch is a month where nothing gets quoted. You can avoid it by running both systems side by side for a short, planned period.

1. 01

   Clean your supplier list first

   Export hotels, guides, transfers and activities to one spreadsheet with a name, category, supplier and net price per row. Delete what you no longer use. This list becomes your service library.

2. 02

   Import catalogue and contacts

   Most tools accept CSV or Excel. Import suppliers and services, then client contacts. Check a preview before saving — this is where mismatched columns are cheapest to fix.

3. 03

   Rebuild your three most common trips as templates

   Do not migrate every old itinerary. Rebuild the trips you sell most often, check the price against your spreadsheet, and save them as templates.

4. 04

   Set a cut-over date for new enquiries

   From that date every new enquiry is quoted in the new tool. Trips already confirmed or travelling soon stay in their spreadsheets until they finish — no half-moved bookings.

5. 05

   Retire the spreadsheets

   Once the last old trip has travelled and been paid, archive the files read-only. Keep them for accounting, but stop editing them.

Choosing the tool is a separate question — our itinerary builder software comparison covers who each option suits.

Frequently asked questions