Travel agency commission tracking: spreadsheet vs software

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.

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.

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.

Frequently asked questions