Travel expense tracking for travel agencies: costs, suppliers and margin per booking
How a travel agency can track trip costs, supplier costs and its own company expenses so it knows the real margin on every booking.
In this article
- The four layers of cost in a travel agency
- Record the cost at the moment you create the booking
- Keep supplier balances separate from client payments
- Do not forget the cost of running the agency
- Reconcile and close each month
- How AerQio helps with travel expense tracking
- How to start tracking costs this week
- End of contents
When people search for travel expense tracking, they usually find tools for employees who claim back hotel and taxi receipts. For a travel agency the problem is different. You are not tracking what a traveller spent; you are tracking what each trip costs you, what you owe to suppliers, what it costs to run the agency itself, and what is left over at the end. This guide explains how to organise those numbers so you can see the real margin on every booking.
The four layers of cost in a travel agency
It helps to separate costs into four layers. The first is the sale price: what the client pays you for the trip. The second is the direct cost of the booking: the net fare, the hotel rate, the transfer or the insurance you bought to build that trip. The third is the supplier side: consolidators, wholesalers and airlines that invoice you and expect to be paid on their own terms. The fourth is the company itself: salaries, rent, software, phone lines, advertising and bank fees.
Many agencies mix these layers in one spreadsheet, and that is where the confusion starts. A booking can look profitable on its own and still lose money once you account for the time and fixed costs behind it. Keeping each layer in its own place, linked where it makes sense, is the basis of useful expense tracking.
Record the cost at the moment you create the booking
The most reliable time to record what a trip costs you is when you create the booking, not at the end of the month. At that moment you know the net fare, the supplier and the sale price. If you wait, you end up reconstructing costs from emails and supplier statements, and small amounts such as service fees or extra baggage get lost.
Importing tickets instead of typing them helps here. When the ticket data comes from the GDS PDF or MIR file, fares and taxes arrive as they were issued, so the cost side of the booking starts from real figures. Your team then only adds what the file cannot know, such as your selling price or a supplier fee.
Keep supplier balances separate from client payments
Money coming in from clients and money going out to suppliers follow different calendars. A client may pay a deposit now and the rest a few weeks before departure, while a consolidator invoices you on its own cycle. If both flows live in the same list, it becomes hard to answer simple questions like how much you owe this month or which bookings are paid by the client but not yet paid to the supplier.
Give each supplier its own record with a running balance, and match the invoices they send you against your bookings. That way a missing or duplicated supplier invoice shows up quickly instead of during the quarterly tax review.
Do not forget the cost of running the agency
Booking margins only tell half the story. Rent, salaries, software subscriptions, advertising and bank charges have to be covered by the sum of all those margins. Record these company expenses every month in the same system where you see your sales, grouped by type, so you can compare them with the profit your bookings generate.
This comparison is what tells you whether the agency is healthy. A month with strong sales can still be weak if a large advertising campaign or a new hire landed in the same period. Seeing both sides together avoids surprises when you close the quarter.
Reconcile and close each month
Expense tracking only works if the numbers are checked against reality. Once a month, match your bank statement with the payments recorded on your bookings and with what you paid suppliers. Then close the month so that later edits do not silently change figures you already reported to your accountant. If a correction is needed, reopen the month on purpose and close it again.
A tax or quarter view is useful at this point because it groups the same figures the way your accountant will ask for them. The less you have to rebuild by hand, the fewer mistakes reach your tax filings.
How AerQio helps with travel expense tracking
AerQio keeps these layers in one place. Bookings can be imported from Amadeus, Galileo and Sabre PDFs or MIR files, payments are recorded per booking, and company expenses such as salaries, rent and software sit next to your sales. The global overview shows revenue, profit and margin compared with the previous period, and bank reconciliation, monthly closing and a tax quarter view are included from the Starter plan at 14.99 EUR per month.
If you also want supplier records with balances and payments, those are part of the Professional plan at 17.99 EUR per month, and consolidator invoices are visible on every plan.
How to start tracking costs this week
Start small. Pick one month, list every booking with its sale price and direct cost, and add your fixed company expenses for that month. Then check the result against your bank statement. Where do the numbers not match? Usually the answer points to the step you should standardise first, whether that is recording supplier fees, logging partial payments or entering expenses on time.
Once one month is clean, repeat the routine every month and close it when it is done. After a few cycles you will know which products, suppliers and clients actually make money for your agency.
Keep reading
All articles
5 Ways to Cut Invoicing Errors in Your Travel Agency
Manual invoicing is one of the most common sources of costly mistakes for travel agencies. Here's how to eliminate the biggest ones.

A Practical Guide to BSP Reconciliation for Travel Agencies
BSP reconciliation eats hours every billing cycle. This guide breaks down what the MIR file actually contains and how to reconcile it without a spreadsheet marathon.

Multi-Currency Invoicing: What Travel Agencies Get Wrong
Selling fares priced in USD or GBP while invoicing in EUR introduces rounding and exchange-rate problems most agencies solve with a workaround instead of a system.