OTA Reconciliation: How to Stop Losing Money to Expedia and Booking.com
Most multi-property hotels lose 0.5%–2% of OTA revenue every month to reconciliation variances they never catch. Across a 10-property portfolio doing $25M in OTA revenue, that is $125,000 to $500,000 a year, gone — usually because the dispute window closes before anyone notices.
This guide explains what OTA reconciliation actually involves, the four variance types that cost the most, and how to automate the entire workflow so nothing slips.
What OTA reconciliation actually is
Every month (or, ideally, every night), you receive a statement from Expedia, Booking.com, and any other OTA channel. The statement lists: bookings, stays, commissions, chargebacks, and net amount due to or from you.
OTA reconciliation is the process of confirming that
Every booking on the statement matches a stay in your PMS (no phantom bookings).
Every stay you fulfilled is on the statement (no missing payouts).
The commission rate matches your contract (no overcharges).
The net deposit matches what hit your bank (no missing or short ACH).
Sounds simple. In practice, with three channels × 30 days × 10 properties, you are reconciling 900+ transactions a month. Most operators do this in Excel, manually, weeks after close.
The 4 variance types that cost hotels the most
1. Phantom bookings
A reservation appears on the OTA statement but never made it to your PMS — usually a sync failure. You get charged commission on a booking that produced no revenue.
How to catch it: match every OTA confirmation number against PMS reservations. Anything on the statement and not in PMS = phantom.
2. Missing payouts
A guest stayed, you serviced the room, but the booking is not on the OTA statement. The OTA owes you.
How to catch it: match every PMS-completed OTA booking against the statement. Anything in PMS and not on the statement = missing payout.
3. Commission overcharge
The OTA applies the wrong commission rate — usually the standard rate instead of your negotiated rate, or fails to apply a loyalty discount.
How to catch it: recompute commission per booking using your contracted rates, compare to what the statement charged.
4. ACH variance
The net amount on the statement does not match the deposit that hit your bank.
How to catch it: match statement net to bank deposits by date and amount.
Why manual reconciliation breaks down at scale
For 1–2 properties, a controller can do this in a half-day a month with Excel. For 5+ properties:
Statement formats vary by OTA and change without notice
PMS exports vary by brand (Choice differs from Wyndham differs from Hilton)
Bank deposits batch multiple properties together
Dispute windows close in 30–60 days
The person who built the spreadsheet leaves
The result: variances pile up, dispute windows close, and the loss becomes invisible (it just looks like lower margin).
How OTA reconciliation automation works
A real automation platform does five things
Ingests OTA statements (Expedia, Booking.com, direct channels) via API or email-in.
Pulls PMS reservations for the matching period.
Three-way matches statement ↔ PMS ↔ bank deposit.
Flags variances by type (phantom, missing, commission, ACH) with the dollar amount and the contract clause that proves the right number.
Generates the dispute packet so your revenue manager can file in one click.
Innrly's reconciliation module does exactly this. On a typical 10-property portfolio, it surfaces $8,000–$40,000 a month in variances that the operator was previously eating.
What to look for in a reconciliation platform
All three sources (OTA statement, PMS, bank) in one match — not just OTA vs PMS
Channel coverage — Expedia, Booking.com, and your direct channel at minimum
PMS coverage for every brand in your portfolio
Variance categorization (phantom / missing / commission / ACH) — not just "mismatch"
Dispute packet generation — exportable to the OTA's dispute portal
Historical reconciliation — can backfill the last 6–12 months on day one
Audit trail — every match, every variance, every override logged
How Innrly handles it
Innrly's reconciliation module ingests OTA statements automatically, pulls PMS data via direct integrations to Choice, Wyndham, Hilton, IHG, and others, and matches against bank deposits the night the ACH hits. Variances are categorized, dollar-weighted, and ready for dispute. Most operators see 0.4–1.5% margin recovery in month one.
See OTA reconciliation in action on your data →
FAQ
How often should we reconcile OTA channels? Nightly is ideal. Monthly is too late — dispute windows close.
Which OTAs does Innrly cover? Expedia, Booking.com, and the direct OTA channel today. Additional channels added on request.
Does Innrly file the disputes for us? Innrly generates the dispute packet (variance amount, booking detail, contract clause). Your revenue manager files in the OTA's portal — most file in under 60 seconds per dispute.
How much does manual reconciliation cost us? For a 10-property operator: roughly 40 hours per month of analyst time, plus 0.5%–2% of OTA revenue in missed disputes.
Can we backfill historical reconciliation? Yes. Innrly can reconcile the trailing 6–12 months on day one to recover unfiled disputes still inside the window.