For most independent travel agents, commission tracking is the part of the business that quietly leaks money. Not because anyone is dishonest — because the system is a spreadsheet that depends on you remembering to update it, and a host-agency statement that arrives weeks after the trip, in a format that doesn't match how you booked it.
Here's how to track commissions so you actually get paid what you earned — and can prove it.
What to record for every booking
The unit of commission tracking is the booking, not the trip. A single Disney World trip might be one package, or it might be a resort booking, separate tickets, a dining reservation, and travel insurance — each with its own commission rate and its own payer.
For every commissionable item, capture:
- Client and trip — so commissions roll up to the trip and the client.
- Supplier — who actually pays (Disney, the host agency, a tour operator, the insurer).
- Booking reference — the confirmation number you'll reconcile against.
- Travel dates — commission is usually earned after travel, not at booking.
- Sale amount and the commissionable amount (often not the same — taxes and fees are frequently excluded).
- Commission rate and the expected commission.
- Your split — if you're under a host agency, the rate they keep vs. pay you.
- Status — pending, traveled, paid.
That last column is the one spreadsheets get wrong. A commission isn't real until it's paid, and the gap between "expected" and "received" is exactly where money goes missing.
Why the spreadsheet breaks down
A spreadsheet is fine for ten bookings. At fifty, three things go wrong:
The splits aren't snapshotted. You change your host-agency tier in March, and now every formula recalculates your January commissions at the new rate. Your historical numbers quietly become fiction. Splits need to be frozen onto the booking at the time it was earned.
Reconciliation is manual and late. The host statement lands as a PDF or a CSV with the supplier's reference numbers, not yours. Matching it line-by-line to your sheet is an evening you'll keep postponing — so you don't, and you never actually confirm you were paid in full.
Nothing connects to the trip. The commission lives in one file, the trip in another, the client in a third. When something's off, the answer is in three places at once.
How to reconcile what you were actually paid
Reconciliation is just answering one question per line: did the money that arrived match what I expected? To make that fast:
- Record the expected commission at booking — rate, commissionable base, and your split, snapshotted.
- Mark items "traveled" once the trip happens — that's when most commissions become eligible.
- When a statement arrives, match by booking reference, not by amount — amounts shift with adjustments and partial payments.
- Flag the gaps. Anything traveled-but-not-paid after the supplier's normal window is a follow-up, not a write-off.
Do this and you turn "I think I got paid" into a number you can defend — and a list of exactly which bookings to chase.
Keeping commissions next to the work
The reason commission tracking feels like a chore is that it's divorced from where the rest of the trip lives. The booking happened in your workspace; the commission ends up in a spreadsheet you have to remember to open.
MagicHop is built to keep the whole business in one place — the client CRM holds every client and their trip history, budgets track what each trip actually costs, and commission tracking is being built to sit right alongside them, with splits snapshotted per booking so your historical numbers stay honest. No re-keying, no second spreadsheet, no guessing whether the statement matched.
If you're running your agency on tabs and formulas today, that's normal — but it's also where the hours (and the occasional unpaid commission) go. Start free and keep your clients, trips, and the money in one workspace, or see how Astra AI handles the research side so you can spend your time on the part that actually pays.