OTA and Travel Agent Commission Reconciliation Agent
Reconciles OTA payouts, commission invoices and travel agent commissions to the stays they cover.
- Industry
- Hotel
- Department
- Finance
- Team
- Accounting Operations
- Kind
- Investigator
- Approver
- Revenue Manager
- Code
- FIN-19
It reconciles the payout and commission files the OTAs, wholesalers, travel agent commission clearing houses and the loyalty programme send against the stays the PMS recorded, allocating each payout or invoice line to a reservation and folio and separating commissions, no-show and cancellation adjustments, rate differences, duplicates and stays the hotel never received. It explains every line it cannot allocate, disputes commission charged on cancelled or no-show stays, and posts the allocations and approved adjustments to the city ledger. **The problem it solves:** Why partner payouts and commission invoices do not match the stays recorded: the lines that do not allocate, the rates and commissions charged against the agreements, and the reservation status behind each.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the property management system (PMS) and the channel manager: reservations by source with their status (stayed, cancelled, no-show), rates, folios and commissions expected, and the city ledger balances for each partner..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to Revenue Manager with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the accounting system's city ledger: it posts the allocations and approved adjustments, and records the disputes against each partner. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The distribution agreements: commission rates by OTA and travel agent, merchant versus agency model rules, what commission applies to no-shows, cancellations and taxes, payout timings, the dispute windows, and the loyalty programme's reimbursement rates for award stays.
Reads from
the property management system (PMS) and the channel manager: reservations by source with their status (stayed, cancelled, no-show), rates, folios and commissions expected, and the city ledger balances for each partner.
Acts in
the accounting system's city ledger: it posts the allocations and approved adjustments, and records the disputes against each partner.
Hands back
An object with files (a list, each with partner, type, total_usd, allocated_usd and unallocated_usd), allocations (a list, each with reservation_id, folio_id, amount_usd and commission_usd), disputes (a list, each with partner, reservation_id, reason, amount_usd and evidence), unallocated (a list, each with line, amount_usd, cause, evidence and how_to_confirm) and adjustments (a list).
Asks a person when
A commission variance is outside 0.5 points, a line is classed as a duplicate or a stay not received, a dispute is to be sent to a partner, a short payment is at or above 20, unallocated cash is older than 7 days, or a partner's file is missing.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Allocation tolerance per stay (USD) | 1 | A payout within this of the folio amount allocates. |
| Commission rate tolerance (percentage points) | 0.5 | Commission charged more than this above the contracted rate is disputed. |
| Commission charged on taxes | Off | When off, commission calculated on taxes and mandatory fees is disputed. |
| Dispute window (days) | 30 | Commission lines are disputed within this many days of the invoice. |
| Short payment closed without approval (USD) | 20 | Short payments below this are closed to the variance account. |
| Escalate unallocated payouts after (days) | 7 | Payouts not allocated after this are escalated. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Allocate each payout or commission line to its reservation and folio within 1, oldest stay first.
- Dispute commission charged more than 0.5 points above the contracted rate, on cancelled or no-show stays where the agreement does not allow it, or on taxes and fees when off is false.
- Raise disputes within 30 days of the invoice, with the PMS reservation history as evidence.
- Explain each unallocated line as timing, a rate difference, a stay not received, a duplicate or unknown, and say what would confirm it.
- Close short payments below 20; anything larger goes to the Revenue Manager.
- Escalate payouts unallocated for more than 7 days.
See the OTA and Travel Agent Commission Reconciliation Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.