In this guide
- Tracking travel agent commissions in a spreadsheet: when it is enough
- An example spreadsheet for tracking commissions
- Where commission tracking in a spreadsheet breaks
- Common mistakes in calculating travel agent commissions
- What software do travel agents use?
- Travel agent commission software: what it has to do
- Where AgentsPayouts fits, and where it does not
| Date | Agent | Client | Supplier | Amount | Commission | Agent % | Agent commission | Status | Settled |
|---|---|---|---|---|---|---|---|---|---|
| 04/02 | L. Gómez | Ortega fam. | Cruise | US$ 3,000 | US$ 360 | 70% | US$ 252 | Collected | — |
Tracking travel agent commissions in a spreadsheet: when it is enough
A spreadsheet is a reasonable tool to start with, and there is no point replacing it for the sake of it. With few agents, a fixed rate for each and sales collected in the same year, a good commission tracking sheet solves the problem.
At a minimum, that sheet needs one row per sale with these columns: booking and travel dates, agent, client, supplier, sale amount, commission paid by the supplier, the agent’s rate on that sale, the agent’s commission, status (pending, collected from the supplier, settled) and settlement date.
The column almost everyone forgets is the rate on that sale. If the rate lives on another tab as "Juan: 70%", the day Juan moves to 80% all his old sales recalculate on their own. It is the mistake we explain in the guide to travel agency commission settlement.
And the rule that prevents half the arguments: the agent’s commission is a percentage of the supplier’s commission, not of the trip value. If that is not clear at your agency, it is explained in the guide on how travel agents get paid.
An example spreadsheet for tracking commissions
This is an example spreadsheet that is enough to get started. It has three sheets: one for sales, one for payments to agents and a third with a summary per agent.
The sales sheet has one row per sale: the booking date and the travel date, the agent, the client, the supplier, the sale amount, the commission the supplier pays, the agent’s rate on that sale, the agent’s commission and the status (pending, collected from the supplier or settled).
The agent’s commission is the supplier commission times their rate: if the supplier pays 360 dollars and the agent is on 70%, they get 252. That rate is typed on every sale and not copied from somewhere else. That way, when the agent’s rate changes, their old sales stay the same.
The payments sheet has one row for every transfer you made to an agent: the date, who and how much.
The summary sheet has one row per agent with four numbers. How much was settled: the total of their settled sales. How much was paid: the total of their transfers. How much is owed today: settled minus paid. And how much is on the way: their sales already collected from the supplier that have not been settled yet.
An example: Valeria was settled 4,200 dollars this year and was transferred 3,500. She is owed 700 today, and has another 520 on the way. We go into more detail in the guide to commission settlement.
What this spreadsheet does not handle: a sale settled in parts, bonuses that depend on what was sold during the year, corrections someone needs to be able to review later, and several people editing at once. If that already happens to you, keep reading.
Where commission tracking in a spreadsheet breaks
The spreadsheet does not fail because it is bad: it fails because it was never built to keep history. The problems show up when things combine that, at an agency, always combine.
Rates that change over time: tiers based on targets, an agent moving up, a new agreement. Every change forces someone to decide by hand which sales keep the old rate and which move to the new one.
Bonuses and exceptions: extra points for selling a given supplier on given dates, a special rate on a single sale, a client the agency brought in who is paid differently. In a spreadsheet each one is one more formula, and every formula is one more place to get it wrong.
Sales collected months later: commission arrives once the traveler has travelled, sometimes in another year. January’s sheet has to stay alive until September, and nobody is sure the open copy is the latest one.
And the agent who asks: if they want the detail of what they were paid six months ago, the answer has to come in minutes, with evidence. When it has to be rebuilt by hand, the spreadsheet is no longer enough.
Common mistakes in calculating travel agent commissions
Almost every mistake in calculating commissions at a travel agency repeats from one agency to the next. These are the six that move the most money without anyone deciding it.
Calculating on the trip price. The agent’s percentage applies to the commission the supplier pays, not to what the client paid. 70% of a 3,000-dollar trip is not 2,100 for the agent: if the supplier paid 360 in commission, it is 252.
Applying today’s rate to an old sale. When an agent moves up a rate and a sale from last semester recalculates by itself, the agency pays a difference nobody decided. We explain it in detail in the guide to commission settlement.
Settling what the supplier has not paid yet. An expected commission is not a collected commission. Settling before reconciling means the agency advances money that may never come in.
Stacking bonuses that should not stack. A special rate on one sale, a supplier bonus and a goal-based tier can overlap. The rule has to be written down: whether the special rate replaces everything else or adds to it, and in what order.
Not deducting cancellations. If a sale is cancelled after it was settled, the commission already credited to the agent has to be recovered. Deleting the sale is not enough: a deduction has to be recorded, or the agent’s account never balances again.
Settling in full a commission that was paid in parts. When the supplier pays part of it, settle that part. The rest stays pending until it arrives.
What software do travel agents use?
There is no travel agency software that does everything, and it is worth being wary of any that claims to. What agencies use is a combination of tools, each for a different problem.
Booking and distribution: the systems where trips are quoted and booked, including GDSs for air and each supplier’s own portal. That is where the booking lives.
Client management (CRM): tracking each client, their trips and their contacts. That is where the commercial relationship lives.
Invoicing and accounting (back office): issuing tax documents as each country requires, the books and taxes. That is where the tax obligation lives.
Commissions and settlements: how much each agent is owed for each sale, when it is settled and what is still outstanding. It is the part that most often ends up in a spreadsheet, because booking and invoicing systems are not built to handle it.
Travel agent commission software: what it has to do
A commission calculator answers one sale. When the problem is tracking every agent’s commissions over time, these are the questions a system has to answer well, demo or no demo.
Does it store the rate on each sale, or only on the agent? If a rate increase rewrites sales already settled, the spreadsheet problem is still there.
Does it support how your agency actually pays? Tiers based on targets, bonuses by supplier and dates, exceptions on a single sale, special rates for clients the agency brings in.
Does it separate settling from paying? Settling recognizes what the agent is owed; paying transfers it. A system that mixes the two cannot tell you what each agent is owed today.
Does the agent see the same numbers as the agency? If agents have to ask for their numbers, the questions never stop.
Can you get your data out? Exporting to a spreadsheet is not a detail: it is what lets you audit, hand information to your accountant, or switch systems if you ever need to.
Where AgentsPayouts fits, and where it does not
AgentsPayouts solves one part of that combination: agent commissions and settlements. It does not book, does not connect to a GDS, does not issue invoices or tax documents, and works in a single currency per agency. It sits alongside the booking and invoicing systems you already use.
What it does: it calculates each sale’s commission with the rate from each agent’s plan, with target-based tiers reached in one period that apply to the next, and with bonuses by supplier and dates that add points, replace the rate, or step up with the sale amount. When needed, the rate on a single sale can be changed by hand.
When you settle, it credits what the agent is owed to their running account and produces a printable receipt itemizing every sale; the payment is recorded afterwards and brings the balance down. Agents see their sales, commissions and balance in their own panel, also from the iOS and Android app, and reports export to Excel.
And if you track everything in a spreadsheet today, we help you migrate your sales: there is no need to re-enter them one by one.