Supplier Settlement for Travel Agencies: A Practical Guide
Supplier settlement is working out what each supplier is owed across the components of a booking, and therefore what the agency actually made. It is the most under-modelled function in travel software, and the one where margin is determined — which is why so many agencies only learn how a month went several weeks after it ended.
Travel money moves in an awkward shape. A client pays a deposit, then a balance, sometimes in instalments. Suppliers are paid on their own schedules, which rarely align with the client’s. Amendments and cancellations move money in both directions. None of that is difficult individually; together, across a few hundred live bookings, it is beyond what a spreadsheet reliably holds.
- Client payment schedules and supplier payment schedules do not align. Both must be tracked.
- Margin per booking is not reliable until settlement completes.
- Amendments and cancellations are routine in travel, not edge cases.
- Spreadsheet reconciliation does not fail loudly — it just gets quietly wrong.
What settlement has to account for
- Components, not bookings. A booking is several supplier commitments, each with its own cost, price and terms.
- Deposit and balance schedules per supplier, which differ from the client’s.
- Commission versus net rates. Whether you are paid a commission or buying at net changes the arithmetic entirely.
- Currency, where a supplier invoices in something other than sterling and the rate moves between booking and payment.
- Amendments — a date change that alters supplier cost after the client has paid.
- Cancellations and the portion each supplier retains.
Where it goes wrong in spreadsheets
| Failure | How it shows up |
|---|---|
| A supplier balance missed | A chasing email months later, usually from the supplier |
| An amendment not reflected in cost | Margin reported higher than it was |
| Currency fixed at booking rate | Quiet erosion on every foreign-currency supplier |
| Cancellation retention not recorded | A refund calculated wrong, discovered by the client |
| Two people editing the same sheet | Nobody can say which figure is current |
What good looks like
A settlement figure you can trace back to the components that produced it. That is the single test. If the system can show you why a booking made what it made — which supplier was owed what, what the client paid and when, what an amendment changed — then reporting is trustworthy and month-end is a report rather than an investigation. If it cannot, you have a number and no way to check it.
Frequently asked questions
Does settlement replace our accounting system?
No. Settlement answers what is owed and what was made on a booking; accounting software remains the system of record for statutory accounts and VAT. The useful integration is making sure both agree, not replacing one with the other.
How do agencies usually handle currency?
Badly, in spreadsheets — typically by fixing a rate at booking and never revisiting it. The honest approach is recording the rate at the point of payment and accepting that the margin on a foreign-currency booking is not final until the supplier is paid.
When should an agency move off spreadsheets for this?
When more than one person needs to see the current position, or when you cannot answer “what are we owed” without an afternoon of work. Volume matters less than how many people depend on the answer.
Can this be automated entirely?
The calculation and tracking, yes. The judgement calls — whether to absorb an amendment cost, how to handle a goodwill refund — should stay with a person. The aim is removing the arithmetic, not the decisions.
This is what TravelCRM’s back office models, and why the product exists in the shape it does.
