OTA Settlement Reconciliation for Indian Hotels

The Hidden Mechanics of OTA Bank Settlements in India

Independent hotel owners frequently notice a significant disparity between the gross booking value shown on an OTA reservation voucher and the actual cash credited to their bank account. When distribution channels like MakeMyTrip, Goibibo, Agoda, and Booking.com process reservations, the gross tariff is subjected to multiple statutory and contractual withholdings.

Failing to conduct weekly settlement reconciliation can lead to undetected revenue leakage, duplicate commission debits on cancelled stays, and unclaimed tax credits.

Anatomy of an OTA Settlement Deduction

To evaluate channel profitability, hoteliers must track how each rupee moves from the guest checkout to the property operating account:

The Net Settlement Formula

The exact mathematical relationship between guest reservation value and net hotel realization is expressed as:

Net Bank Payout = Gross Booking Value 
                - Base Commission 
                - (Base Commission × 18% GST) 
                - (Gross Tariff × 0.1% TDS u/s 194-O) 
                - (Net Sales × 0.5% TCS u/s 52) 
                - Channel Collection / Payment Fee 
                - Hotel-Funded Promotional Subsidies

Numerical Worked Example

Consider a boutique heritage hotel in Jaipur selling a 2-night stay at a gross tariff of ₹10,000 via MakeMyTrip on an 18% base commission contract with a 10% hotel-funded campaign discount:

1. Discounted Room Rate: ₹9,000 (after ₹1,000 hotel promo contribution)
2. Base Commission (18%): ₹1,620
3. 18% GST on Commission: ₹291.60
4. TDS u/s 194-O (0.1% on ₹9,000): ₹9.00
5. TCS u/s 52 (0.5% on ₹9,000): ₹45.00
6. Payment Gateway Fee (2%): ₹180.00
7. Total Channel Deductions: ₹2,145.60
8. Net Deposited into Hotel Bank: ₹6,854.40

In this typical scenario, the hotel surrenders over 31% of the original ₹10,000 booking value to platform costs, statutory withholding, and promotional discounts.

Essential Steps for Weekly Reconciliation

1. Match Unique Channel Reservation IDs

Never reconcile by guest name alone. Export the weekly reservation report from your Channel Manager or PMS and cross-reference the unique 16-digit OTA confirmation code against the settlement payout remittance advice.

2. Verify Cancelled Stays and No-Shows

When a guest cancels a non-refundable booking, check whether the OTA credited the retained cancellation fee without charging full marketing boost surcharges. For flexible bookings cancelled before the penalty deadline, confirm that zero commission was debited from your running ledger balance.

3. Audit Form 26AS for Section 194-O Withholding

OTAs file quarterly TDS returns. Have your finance team verify that the 0.1% TDS withheld matches the credit reflected under Section 194-O in your Income Tax Annual Information Statement (AIS) and Form 26AS.

4. Evaluate Direct Booking Arbitrage

Compare your net OTA settlement per room night against direct booking costs. Our interactive OTA Commission Calculator lets you model your property specific net realization across channels.