Commission tracking for travel agents: spreadsheet, CRM or inbox

Commission tracking means keeping, for every booking, what the supplier promised to pay, when it is due, what actually arrived and whether the two match. Verification is the matching step. Most agents do the first part somewhere and the second part rarely, which is why shortfalls go unnoticed for months. There are three ways to run it, and they fail in different places.

The spreadsheet

One row per booking: supplier, reference, travel dates, commission expected, commission received, date. It costs nothing and every agent has one, and it fails in four predictable places.

• No due dates. Late never becomes visible, because nothing turns red when a date passes.
• Updated after the fact. The row is filled in when there is time, which is after the statement arrived, so the matching is from memory.
• It does not read documents. Every remittance PDF is typed in by hand or not at all, and "not at all" wins on a busy week.
• It does not chase. A row that says overdue stays overdue.

A spreadsheet is a fine record of what you were promised. It is a poor detector of what you were not paid.

The CRM module

Most travel CRMs built for agents have a commission section: you record the expected amount on the booking, mark it paid when the statement comes, and run a report of what is outstanding. This fixes the first spreadsheet failure, because due dates exist and the outstanding report is a real list.

It does not fix the other three. The statement still has to be read by a person and the figures entered, the matching is still done by eye, and the chase is still an email you write. For an agency with an administrator, that is a reasonable division of labour. For one person selling and administering, the module is only as current as the last afternoon they spent on it.

The second question for any CRM is whether it understands a host agency in the middle. If the supplier pays your host and your host pays you, there are two statements to reconcile and two places a shortfall can hide. Many modules model one.

Reading the inbox

The third way starts from where the documents already are. Every confirmation that states a commission and every remittance that pays one arrives in the inbox. Software that reads the inbox can note the promise when the confirmation lands, with its rate, base, currency and due date, and check the payment when the statement lands, line by line, without anyone typing anything.

That changes what tracking is. It is no longer a record you maintain but a check that runs on every email, which means it catches short payments the week they happen and overdue ones the day they become overdue. The remaining human job is the one that needs judgment: reading the drafted query and deciding whether to send it.

What to verify, whichever way you track

• Rate against the confirmation, not against memory. An 8 per cent payment on a booking agreed at 10 is the most common shortfall and the easiest to recover.
• Base against the booking. Commission on a smaller amount than the booking usually means something was excluded. Sometimes correctly.
• Currency. A euro commission paid into a sterling account arrives at the supplier's bank's rate that day. Keep the expected figure in the booking's currency so a rate difference is not mistaken for a shortfall.
• Reference. Match on the supplier's reference, which is what the statement carries, not yours.
• Missing lines. A statement can be correct for every line it contains and still be short, because a booking that travelled last month is not on it. Only a list of what was due catches that.

How Holidr does it

Holidr is the third way. It reads the inbox you already work in, notes every promised commission with its due date, checks every remittance against it to the penny, and flags short or late payments with the query already drafted for your approval. Software that chases unpaid commissions explains what that category of tool can and cannot do, and the 90 days are free.