OTA reconciliation is the process of proving that what Booking.com, Expedia, Agoda, and the other online travel agencies owe your hotel is what they actually paid — commission by commission, virtual card by virtual card, cancellation by cancellation. Because OTAs deduct commissions, pay on their own schedule, and bundle dozens of reservations into single settlements, the money that lands in your account almost never matches the revenue on your books. Hotels that don't reconcile OTA activity are, in our direct experience, leaving real money on the table every single month.
This guide covers both OTA payment models, the specific places money leaks, and the monthly workflow that catches it. It builds on our credit card reconciliation guide — OTA reconciliation is its hardest special case.
What is OTA reconciliation?
Every OTA reservation creates a chain of records: the booking in the extranet, the reservation in your PMS, the stay (or cancellation, or no-show), the commission the OTA charges, and the payment — either a guest card you charge or a virtual card the OTA funds. OTA reconciliation ties that chain together for every reservation and verifies four things: the stay data is right, the commission matches your contract, the payment arrived in full, and cancellations and no-shows were handled per policy on both sides.
The two payment models
| Hotel-collect ("pay at property") | OTA-collect (virtual cards / payouts) | |
|---|---|---|
| Who charges the guest | You, on the guest's own card | The OTA; it pays you by single-use virtual card (VCC) or bank transfer |
| How commission flows | OTA invoices you monthly; you pay it | OTA deducts commission before funding |
| Main risks | Commission billed on cancelled/no-show stays, wrong amounts, double-billing | Underfunded VCCs, VCCs that expire or close before you charge them, payouts missing reservations |
| Reconciliation anchor | OTA commission invoice ↔ PMS actual stays | OTA payout/VCC statement ↔ PMS reservations ↔ processor |
Why OTA payouts never match your PMS
- Netting: commissions, adjustments, and marketing fees are deducted before money moves.
- Bundling: one transfer covers many reservations across multiple stay dates.
- Timing: VCCs activate on check-in or checkout dates; transfers run weekly or monthly; your revenue posts nightly at the night audit.
- Modifications: date changes, early departures, and rate adjustments made in the PMS often never make it back to the OTA — so the OTA bills commission on the original, higher amount.
- Cancellation asymmetry: a stay cancelled in the extranet but not the PMS (or vice versa) produces either phantom commission or an uncharged room.
Where the money leaks
| Leak | Mechanism | Found by |
|---|---|---|
| Commission on cancelled stays | Cancellation never synced; OTA invoices commission anyway | Invoice line-by-line vs. PMS actuals |
| Commission at the wrong rate | Rate tier or program change applied incorrectly | Effective % check per reservation vs. contract |
| Underfunded virtual card | VCC loaded for original amount after a stay was extended or rate increased | VCC charged amount vs. folio total |
| Expired / never-charged VCC | Card not charged in its active window at checkout | Departed-guest VCC report at night audit |
| Missing payout reservations | Bank transfer excludes stays with "data issues" | Payout statement vs. PMS departures |
| No-show commission | Commission billed although no-show was reported | No-show log vs. invoice |
The monthly workflow, step by step
- Export the month's OTA reservations from the PMS — stayed, cancelled, no-show, modified — per OTA.
- Pull each OTA's statement: Booking.com commission invoice and reservation statement; Expedia's invoice (hotel-collect) and remittance/payout detail (Expedia Collect); equivalents for Agoda and the rest.
- Match reservation-by-reservation. Confirmation number to folio: stay dates, room revenue, commission amount, payment method.
- Verify the commission math on every line against your contracted rate — not just the invoice total.
- Verify every VCC was charged for the final folio amount of each departed OTA-collect guest, and matched through your card reconciliation to the processor and bank.
- Dispute discrepancies in the extranet promptly — both major OTAs have formal dispute flows for commission and payment errors, with practical time limits. Document everything.
- Track recoveries to the ledger so disputed amounts are followed to the credit note, not just filed.
Recovering what you're owed
Commission errors and VCC shortfalls are recoverable — OTAs correct documented discrepancies through extranet disputes and credit notes, and uncharged VCCs can often still be charged or reissued if caught quickly. The discipline is monthly cadence and relentless documentation. This is exactly what our revenue & merchant verification service and agency billing service do for client hotels: every OTA line verified against the PMS, every discrepancy disputed, every recovery tracked to the books. Caught early at the night audit and closed monthly, OTA leakage stops compounding — our teams have recovered meaningful commission errors for properties of every size.
How much are OTAs quietly costing you? We verify every commission and virtual card against your PMS — and recover what doesn't match.
Explore Revenue VerificationOTA reconciliation checklist
- PMS export of all OTA reservations (stayed / cancelled / no-show / modified), per OTA
- Commission invoices and payout statements pulled for the same period
- Reservation-level match: dates, revenue, commission, payment method
- Commission percentage verified against contract on every line
- Cancelled and no-show stays confirmed commission-free
- Every VCC for departed guests charged for the final folio amount
- Payout transfers tied to reservation lists; missing stays chased
- Disputes filed in the extranet with documentation; credit notes tracked to the GL
Frequently asked questions
How often should OTA reconciliation be done?
Virtual-card charging belongs in the nightly audit; commission and payout reconciliation runs monthly, aligned to each OTA's invoice cycle. Dispute windows are finite, so quarterly catch-ups systematically forfeit recoveries.
What commission do OTAs typically charge hotels?
Standard commissions generally run in the 15–25% range depending on the OTA, market, and program participation — which is exactly why verifying the rate actually applied on every reservation matters.
What is a virtual card (VCC) in OTA payments?
A single-use card number the OTA issues to pay for a specific reservation, loaded with a set amount and active in a set window. If the stay changes and the card isn't reloaded, or it isn't charged in its window, the hotel eats the difference unless it reconciles and disputes.
Can hotels recover overpaid OTA commissions?
Yes. Documented discrepancies — commission on cancelled stays, wrong rates, double-billing — are routinely corrected via the OTAs' dispute processes, within practical time limits. The constraint is having the reservation-level evidence, which only reconciliation produces.
Is OTA reconciliation worth it for a small hotel?
Leakage scales with OTA mix more than hotel size — a 60-room property doing most of its business through OTAs has more at stake than a 300-room hotel that doesn't. One recovered commission error typically pays for the month's reconciliation effort.
Related guides
- Credit Card Reconciliation for Hotels: The Step-by-Step Guide
- Hotel Night Audit: The Complete Operator's Guide
- Hotel Chargebacks: Prevention Playbook & Dispute Guide
Hands On Hotels is a hotel back-office operations company. Our teams run the night audit, books, reconciliations, and sales desks for hotels every single night — and we build the Hands On Operations Suite, software born from that work. This guide is written and reviewed by the operators who do this for a living.