Managing suppliers and commissions in a travel agency

← Blog
Travel • Suppliers

Managing suppliers and commissions in a travel agency

Supplier commissions are a real profit source for a travel agency — but they slip away easily when tracked in Excel. Managing suppliers and commissions means keeping in one place the contracts, allocations, commissions due and balances for each hotel and carrier. Below are the steps and the data you must track.

How to manage commissions (short answer)

  1. Register each supplier with contract, commission type and settlement currency.
  2. Allocate to each file the suppliers used and the related commission.
  3. Track the commission as an amount receivable, separate from the agency margin.
  4. Reconcile periodically: commissions invoiced vs commissions collected.

What data you keep about a supplier

  • Type: hotel, transport, transfer, insurance, guides.
  • The contract and the validity period of the rates.
  • Commission type: percentage, fixed amount or net rate + markup.
  • Balance: how much you have to collect or pay to date.

Commission types

How the agency earns from suppliers

TypeHow it worksWhen to use it
Percentage commissionA percentage of the supplier's published rateHotels, insurance, tickets
Net rate + markupYou get a net rate and add your markupOwn packages and tours
Fixed commissionA fixed amount per file, regardless of valueOne-off services, transfers

Common mistakes

  • Mixing supplier commission with agency margin and not knowing where profit comes from.
  • Not reconciling commissions and forgetting about real amounts due.
  • Keeping supplier rates in Excel, with expired versions used by mistake.

How 4AgencyTravel helps

  • A supplier record with contracts, currency, default commission and allocations with a release date.
  • Commission is recorded on the booking, as a percentage of the sale, separately from margin.
  • A report of accrued vs paid commissions, separately for agents and suppliers.

See also