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
| As of | 46342 | Change the date, deposit rules and currency on the Settings sheet. Sold = Deposit paid, Confirmed or Travelled. | |||
|---|---|---|---|---|---|
| Open enquiries and quotes | 5 | Client balances outstanding | 30,060.00 | ||
| Open pipeline value | 18,670.00 | Of which overdue | 4,860.00 | ||
| Sales booked this month | 12,450.00 | Bookings with balance overdue | 3 | ||
| Margin this month | 2,210.00 | Bookings with balance due soon | 1 | ||
| Margin % this month | 17.8% | Owed to suppliers | 37,170.00 | ||
| Bookings made this month | 3 | Of which overdue | 4,580.00 | ||
| Margin % on all sold trips | 18.3% | Supplier payments overdue | 2 | ||
| Departures in the next 30 days | 5 | Supplier payments due soon | 1 | ||
| Travellers departing in 30 days | 12 | Rows that need a fix (Check column) | 0 | ||
| Destination | Sold trips | Travellers | Sales | Margin | Margin % |
| Spain | 4 | 8 | 8,920.00 | 1,650.00 | 18.5% |
| Italy | 3 | 8 | 9,300.00 | 1,790.00 | 19.3% |
| Greece | 1 | 2 | 3,920.00 | 740.00 | 18.9% |
| Portugal | 2 | 5 | 6,010.00 | 1,170.00 | 19.5% |
| Thailand | 3 | 8 | 21,100.00 | 3,600.00 | 17.1% |
| Maldives | 2 | 4 | 14,200.00 | 2,690.00 | 18.9% |
| Japan | 2 | 4 | 14,200.00 | 2,350.00 | 16.6% |
| Iceland | 2 | 5 | 8,080.00 | 1,590.00 | 19.7% |
| Mexico | 2 | 6 | 9,300.00 | 1,650.00 | 17.7% |
| Caribbean | 1 | 2 | 4,800.00 | 1,120.00 | 23.3% |
| Austria | 1 | 4 | 6,400.00 | 1,100.00 | 17.2% |
| Croatia | 0 | 0 | 0.00 | 0.00 | |
| All destinations | 23 | 56 | 106,230.00 | 19,450.00 | 18.3% |
| Next departures | Days to go | Booking | Client | Trip | Travellers |
| 46346 | 4 | BK-1026 | Mason Clarke | Barcelona weekend | 2 |
| 46348 | 6 | BK-1009 | Isabella Reed | Mexico beach family week | 4 |
| 46352 | 10 | BK-1010 | Mason Clarke | Rome long weekend | 2 |
| 46360 | 18 | BK-1011 | Charlotte Hayes | Lisbon and Porto | 2 |
| 46368 | 26 | BK-1012 | Lucas Murray | Canary Islands winter sun | 2 |
| 46376 | 34 | BK-1029 | Amelia Ward | Thailand Christmas | 2 |
| 46383 | 41 | BK-1013 | Amelia Ward | Caribbean cruise | 2 |
| 46385 | 43 | BK-1015 | Grace Sullivan | Tokyo New Year | 2 |
| 46403 | 61 | BK-1014 | Henry Collins | Austrian ski week | 4 |
| 46423 | 81 | BK-1028 | Lucas Murray | Venice carnival | 2 |
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
- 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.
- On Lists edit your destinations and supplier types. On Suppliers add the companies you buy from. On Clients add your clients.
- 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.
- Move the status along as the booking progresses: Enquiry, Quoted, Deposit paid, Confirmed, Travelled. Use Cancelled when a booking falls through.
- 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.
- 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.
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 sheet | In 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. |
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
- Hotel Guest Folio Template for Excel (Rooms, Reservations, Billing)
- Trip organizer sheet: participants, instalments, costs and itinerary
- Generator Maintenance Log Template for Excel
- Equipment Inspection Log Template for Excel
- Coffee Roasting Log and Costing Spreadsheet for Excel
- Auto Parts Inventory and Sales Spreadsheet for Excel
- Clothing Store Inventory Spreadsheet (Size and Color) for Excel
- Multi-Location Inventory Spreadsheet for Excel
- Production tracking sheet for home textiles factories
- Fabric requirements and marker sheet