Softwiro
Free Excel template

Travel Agency Booking Tracker for Excel

A free travel agency booking tracker for Excel, built for a small agency, a home-based travel advisor or a tour operator with a handful of suppliers. You keep a list of clients and suppliers and write one row per booking, from the first enquiry to the trip itself. The workbook works out the deposit, the date the balance is due, the margin on each sale, what the client still owes and what you still owe the supplier, and warns you when either payment is overdue or about to be. One Dashboard shows open quotes, sales and margin, the next ten departures and sales by month and destination. It works in Excel, LibreOffice and Google Sheets and in any currency.

Excel file (.xlsx) · 184 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
As of46342Change the date, deposit rules and currency on the Settings sheet. Sold = Deposit paid, Confirmed or Travelled.
Open enquiries and quotes5Client balances outstanding30,060.00
Open pipeline value18,670.00Of which overdue4,860.00
Sales booked this month12,450.00Bookings with balance overdue3
Margin this month2,210.00Bookings with balance due soon1
Margin % this month17.8%Owed to suppliers37,170.00
Bookings made this month3Of which overdue4,580.00
Margin % on all sold trips18.3%Supplier payments overdue2
Departures in the next 30 days5Supplier payments due soon1
Travellers departing in 30 days12Rows that need a fix (Check column)0
DestinationSold tripsTravellersSalesMarginMargin %
Spain488,920.001,650.0018.5%
Italy389,300.001,790.0019.3%
Greece123,920.00740.0018.9%
Portugal256,010.001,170.0019.5%
Thailand3821,100.003,600.0017.1%
Maldives2414,200.002,690.0018.9%
Japan2414,200.002,350.0016.6%
Iceland258,080.001,590.0019.7%
Mexico269,300.001,650.0017.7%
Caribbean124,800.001,120.0023.3%
Austria146,400.001,100.0017.2%
Croatia000.000.00
All destinations2356106,230.0019,450.0018.3%
Next departuresDays to goBookingClientTripTravellers
463464BK-1026Mason ClarkeBarcelona weekend2
463486BK-1009Isabella ReedMexico beach family week4
4635210BK-1010Mason ClarkeRome long weekend2
4636018BK-1011Charlotte HayesLisbon and Porto2
4636826BK-1012Lucas MurrayCanary Islands winter sun2
4637634BK-1029Amelia WardThailand Christmas2
4638341BK-1013Amelia WardCaribbean cruise2
4638543BK-1015Grace SullivanTokyo New Year2
4640361BK-1014Henry CollinsAustrian ski week4
4642381BK-1028Lucas MurrayVenice carnival2

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: Open enquiries and quotes with their value, sales and margin booked this month, margin on all sold trips, departures and travellers in the next 30 days, client balances and supplier payments (outstanding, overdue, due soon) and the number of rows that need a fix. Below: sales, margin and travellers by destination, bookings by status, sales and margin by month booked, the next 10 departures with payment alerts and four charts.
  • Bookings: One row per booking: reference, client and supplier from dropdowns, trip, destination, booked-on date, departure and return, travellers, status (Enquiry, Quoted, Deposit paid, Confirmed, Travelled, Cancelled), price, supplier cost, commission, client paid and supplier paid. The sheet works out the deposit, the balance due date, margin and margin %, the client balance, what you owe the supplier and its due date, a Balance and a Supplier alert, and a Check column. Room for 500 bookings.
  • Clients: One row per client with email, phone, city and notes. The sheet counts their trips, sold trips, sales, margin and the balance they still owe. Room for 60 clients.
  • Suppliers: The tour operators, hotels, airlines and others you buy from, with sold trips, sales, margin, what you owe now and how much of that is overdue. Room for 30 suppliers.
  • Lists: Your destinations (12), the six booking statuses and your supplier types.
  • Settings: Business name, currency symbol, the As of date, the deposit percentage, how many days before departure the client balance and the supplier payment are due, and how far ahead to warn.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Many free travel spreadsheets are an itinerary or a plain list of clients. This one follows the money: every booking shows its margin, the deposit, when the balance is due and what you owe the supplier, so you chase the right client and pay the right supplier on time. The sample is a small agency with 29 bookings booked between July and November 2026.

How do I track bookings and payments in a travel agency spreadsheet?

Give every booking one row and a status that you move along: Enquiry, Quoted, Deposit paid, Confirmed, Travelled, or Cancelled. Keep the money in four columns: the price, the supplier cost, what the client has paid and what you have paid the supplier. Everything else is calculated from those and from the departure date.

In this template a booking counts as sold from Deposit paid onwards. The sample has 23 sold trips worth 106,230 with a margin of 19,450, which is 18.3%. Another 5 enquiries and quotes worth 18,670 are open in the pipeline and are not counted as sales yet.

How do I work out margin and commission on each booking?

Margin = price - supplier cost + commission. If you sell a package at a marked-up price, the margin is the difference. If a supplier pays you commission after the trip, type the full supplier cost and put the commission in its own column; if the supplier keeps its commission back and you pay the net, type the net cost and leave commission empty.

In the sample, booking BK-1002 (Amalfi Coast week) sells for 5,600, costs 4,650 and carries 120 commission, so its margin is 1,070. Thailand is the biggest earner at 3,600 margin on 21,100 of sales, while the Caribbean cruise has the best margin rate at 23.3% because of its 320 commission.

How do I keep track of deposits, balances and supplier payments?

Set your deposit percentage and the number of days before departure that the balance and the supplier payment fall due on Settings. The sheet then shows the deposit, the balance due date and the supplier due date for every booking, and compares them with the As of date. Payment terms and refund rules differ from place to place, so check your local rules before you copy any figures.

As of 16 November 2026 clients owe 30,060, of which 4,860 is overdue on three bookings. BK-1014 (Austrian ski week) has a balance of 4,800 due soon. You owe suppliers 37,170, of which 4,580 is overdue and one more payment of 3,050 is due soon. Five trips with 12 travellers leave in the next 30 days. Related sheets: invoice template and cash book.

How to use it

  1. On Settings type your business name, currency symbol and the As of date (today). Set your deposit percentage and how many days before departure the balance and your supplier payments fall due.
  2. On Lists edit your destinations and supplier types. On Suppliers add the companies you buy from. On Clients add your clients.
  3. On Bookings add one row per booking: reference, client and supplier from the dropdowns, trip, destination, booked-on date, departure and return dates, travellers, status, price, supplier cost, any commission, and what has been paid by the client and to the supplier.
  4. Move the status along as the booking progresses: Enquiry, Quoted, Deposit paid, Confirmed, Travelled. Use Cancelled when a booking falls through.
  5. Update Client paid and Supplier paid as money moves. The sheet works out the deposit, the balance due date, margin, balance owed and what you still owe the supplier.
  6. Read the Dashboard for open quotes, sales and margin, balances and supplier payments overdue or due soon, the next ten departures, and sales and margin by month and destination. The Check column on Bookings flags rows that need a fix.

Before you start:

  • Capacity: 500 bookings, 60 clients, 30 suppliers and 12 destinations. The Dashboard lists the next 10 departures.
  • A booking counts as sold once its status is Deposit paid, Confirmed or Travelled. Enquiries and quotes show as pipeline value only. A cancelled booking counts as 0.
  • Margin = price - supplier cost + commission. If a supplier pays you commission afterwards, leave the supplier cost at the full price and type the commission in its own column. If you keep the commission out of the supplier payment, type the net cost.
  • Deposit = price x the deposit percentage on Settings. Balance due date = departure date - the balance days on Settings. Supplier due date = departure date - the supplier days on Settings.
  • Sales and margin by month use the booked-on date. Alerts look at the As of date: overdue when the due date has passed, due soon when it falls inside the warning window.
  • This sheet is a record, not advice: payment terms, refunds, deposits and package-travel rules differ by country, so check your local rules.
  • Use one currency in one workbook. The currency symbol on Settings is only a label.

Excel file (.xlsx) · 184 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

Is this travel agency booking tracker free?

Yes. Download it, use it for your agency and change anything you like. There is nothing to sign up for to open the file.

Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. In Google Sheets, upload the file to Drive and open it with Sheets.

How many bookings, clients and suppliers can it hold?

500 bookings, 60 clients, 30 suppliers and 12 destinations. The Dashboard lists the next 10 departures. When the log is full, save a copy and start a new file.

Where do I enter commission?

In the Commission column of the booking. Margin is price minus supplier cost plus commission. Use it for commission a supplier pays you separately; if you pay the supplier the net amount, just enter the net cost.

How do the overdue and due soon alerts work?

The sheet compares the balance due date and the supplier due date with the As of date on Settings. A date in the past with money still unpaid shows overdue, and one inside the warning window (14 days in the sample) shows due soon. Change the As of date to today when you open the file.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Travel agencies

More free templates

All templates · Free tools