How to track travel bookings without a spreadsheet

To track travel bookings without a spreadsheet, you need one shared record per supplier booking that holds the supplier reference, what the client owes and when, what you owe the supplier and when, the cancellation deadline, and a status everyone reads the same way. A tool built for that job also warns you before each date arrives, so nobody has to scan the sheet every morning to catch it.

Most small agencies start with a travel agency spreadsheet because it is free and everyone already knows Excel or Google Sheets. It works with one agent and a handful of trips. Once three or four people are keying in confirmations from a bedbank, a consolidator, an airline and two boutique hotels, the sheet stops telling the truth, and the first sign is usually a balance that went unpaid or a free cancellation window that closed while nobody was looking.

Why the shared travel agency spreadsheet breaks

Nobody chooses a bad system. The sheet grows one column at a time, each added for a good reason, until it has thirty-odd columns and a set of habits that live in people's heads. These are the failures owners tend to recognise.

Two people editing the same file. In a desktop Excel file saved to a shared drive, the second person to open it may get a read-only copy or a conflicting version. Cloud files handle simultaneous editing better, but they still let two agents overwrite each other's notes on the same row.

Dates that turn into numbers. Excel stores every date as a serial number, counting 1 January 1900 as day 1 (Microsoft explains the date systems here). Paste a date from a supplier email into a cell formatted as General or Number and you see something like 46310 instead of a departure date. Paste one typed the American way, month first, and 03/04 might mean March or April depending on who reads it.

Supplier references that get lost. A bedbank booking number, an airline PNR and a hotel's own confirmation code often all belong to the same booking. The sheet has one column for "Ref", so two of them end up in a notes cell or stay in the inbox.

Balance due dates that pass quietly. A due date in a cell does nothing on its own. If nobody sorts by that column on the right day, the supplier balance goes unpaid or the client is never chased.

Cancellation deadlines nobody sees. Free cancellation until 14 days before arrival is a valuable window, but it sits in a long paragraph of supplier terms. It rarely makes it into the sheet at all.

Payment notes crammed into one cell. "Dep £400 pd 12/9 by card, bal due 1/11, client asked to split" is three facts and a request in a single cell. You cannot sort it, filter it or add it up.

No reliable record of who changed what. Google Sheets can show the edit history of a single cell, and files on OneDrive or SharePoint keep earlier versions. Neither tells you why a balance date moved, and on a busy morning nobody goes looking.

What a travel agent booking tracker needs

A good tracker answers three questions at a glance: what is booked, who owes what by when, and what needs doing next. Everything else is detail.

One row per booking or one row per trip?

Use one row per supplier booking and group them with a trip reference. A two-week trip might have flights from a consolidator, two hotels from a bedbank and a transfer booked direct. Each one has its own supplier reference, its own deposit, its own balance date and its own cancellation terms. Squash them into a single trip row and you are back to notes cells.

The client usually pays you per trip, though. So keep the client's deposit and balance on the trip, and keep the supplier's deposit and balance on each booking. Client deposit tracking and supplier payment tracking are two different sets of dates, and mixing them is how an agency ends up paying a supplier before the client has paid in.

The fields worth having

Start a travel agent spreadsheet template with these columns. Keep each fact in its own column so you can sort and filter it.

• Trip reference

• Client name

• Lead agent

• Booking type (flight, hotel, transfer, tour, insurance)

• Supplier

• Supplier reference

• Secondary reference (PNR or hotel confirmation code)

• Start date and end date

• Status

• Currency

• Net cost

• Selling price

• Supplier deposit amount and due date

• Supplier balance amount and due date

• Supplier paid (yes or no)

• Client deposit amount and due date

• Client balance amount and due date

• Client paid (yes or no)

• Cancellation deadline

• Ticketing deadline (for flights)

• Last updated by

• Notes

Status needs a fixed list so everyone means the same thing. Something like Enquiry, Option held, Confirmed, Deposit paid, Fully paid, Ticketed, Travelled and Cancelled covers most agencies.

How to make the spreadsheet you have safer

If you are staying on a spreadsheet for now, three changes catch most of the mistakes above. All of them work in both Excel and Google Sheets.

1. Force real dates. Select every date column, format it as a date, then add data validation so the cell rejects anything that is not one. In Excel that is Data, then Data Validation, then Allow: Date (Microsoft's guide). In Google Sheets, use Data, then Data validation, with the "is valid date" criterion. Agree one display format, such as 01 Nov 2026, so nobody has to guess between day-first and month-first.

2. Turn Status, Supplier and Booking type into drop-down lists. The same data validation screen lets you build a list of allowed values. Typos like "Confrimed" disappear, and filtering by status starts giving you a true count.

3. Colour the due dates. Conditional formatting with a custom formula can flag a row before the money is due. If the supplier balance date sits in column P and the "Supplier paid" column is Q, apply a rule to your data range with the formula =AND($Q2<>"Yes",$P2<>"",$P2<TODAY()) and a red fill for overdue. Add a second rule, =AND($Q2<>"Yes",$P2<>"",$P2-TODAY()<=7), with an amber fill for anything due within a week. Put the overdue rule first so it wins when both match. Google's help page covers custom formulas in conditional formatting, and the same formulas work in Excel under Conditional Formatting, then New Rule, then "Use a formula to determine which cells to format".

Repeat the colour rules for the client balance, the cancellation deadline and the ticketing deadline. Then freeze the header row, protect the formula columns, and make "Last updated by" a habit rather than a hope. None of this makes the spreadsheet a travel agent back office, but it stops the most expensive misses.

When it is time to move to travel booking management software

A hardened spreadsheet still depends on someone opening it, sorting it and acting on the colours. Most agencies move when one of these starts happening every week:

• An agent is off, a client calls, and nobody else can find the booking in under a minute

• More time goes on retyping supplier confirmations than on selling

• A deadline was missed and it cost money or goodwill

• Client confirmations are being built by hand from copied tables and forwarded supplier emails

• You cannot say, without an afternoon of maths, what margin a trip made

The test is simple. If the travel agency workflow only holds together because one careful person checks the sheet each morning, the system is that person, and they will go on holiday eventually.

How Confirmbee handles booking tracking

Confirmbee is a back office built for small travel agencies, and it starts where the spreadsheet starts: the supplier email. You forward the confirmation to your Confirmbee inbox address, or upload the PDF, and AI reads it and drafts the booking. An agent reviews what it extracted, fixes anything it misread, and assigns it to a client and trip. Your suppliers do not change anything, and nothing is saved until a person has checked it.

From there the booking sits in one shared tracker the whole team works from. You can search by client, trip, supplier or reference, add custom columns, and group the view to match how your agency already thinks. Cancellation, ticketing and payment deadlines are flagged as each booking is extracted, you can turn any flag into a task for whoever owns it, and the dashboard shows what needs you today. Key actions are recorded in an activity trail, so "who changed this?" has an answer.

The same trip then becomes a branded confirmation, invoice or quote, with the agent choosing which sections the client sees. Costs and margins work in more than 160 currencies with live exchange rates.

It costs £49 a month for the first agent and £4 a month for each additional agent, with a 14-day free trial and no card required. Paying yearly gets you 2 months free. There is nothing to migrate: you start by forwarding your next confirmation. See how each feature works.

FAQ

Is there a free travel agent spreadsheet template?

You can build one in an hour from the column list above. Use one row per supplier booking, a trip reference to group them, separate columns for client and supplier deposits and balances, and drop-down lists for status and supplier. Add conditional formatting for due dates before you put real bookings in it.

Should I track deposits per booking or per trip?

Both, on different sides. Your client normally pays you per trip, so client deposit and balance dates belong on the trip. Each supplier has its own deposit and balance terms, so supplier payments belong on each booking.

How do I stop Excel showing dates as numbers?

Excel stores dates as serial numbers and shows the raw number when the cell is formatted as General or Number. Select the column, change the format to Date, and add data validation that only accepts dates so pasted text cannot slip in.

Can Google Sheets remind me when a balance is due?

Not out of the box in a way your team will notice. Conditional formatting can colour a row as the date approaches, but someone still has to open the sheet. Automated email reminders in Google Sheets need a script or an add-on.

What is the difference between a booking tracker and a CRM?

A CRM follows leads and sales conversations. A travel agent booking tracker follows what has been booked, with whom, for how much, and which dates are coming up. Small agencies usually feel the pain of missing deadlines long before they feel the need for a sales pipeline.