Hotels & Hospitality
Reconciliation for hotels, resorts, and hospitality groups
Reconciliation in Hotels & Hospitality
Hotels and hospitality businesses receive revenue through multiple channels — OTAs (MakeMyTrip, Goibibo, Booking.com, Expedia), direct bookings, walk-ins, restaurant aggregators (Zomato, Swiggy), and corporate accounts. Each channel has a different settlement cycle (3–21 days), different commission structures, and different TDS deduction rules. A mid-size hotel in a metro processes 1,500–5,000 reservation transactions per month across 6–10 channels — with OTA settlements arriving in consolidated weekly batches that cover hundreds of individual bookings.
Where reconciliation breaks down
These are the structural problems that generic tools cannot solve for Hotels & Hospitality businesses.
OTA batch settlement lag
MakeMyTrip, Goibibo, and Booking.com disburse payments 7–21 days after checkout in weekly batches. Each disbursement covers hundreds of bookings with OTA commission and TDS deducted. Matching the batch against individual reservation records requires disaggregation logic that most accounting systems cannot perform.
TDS on OTA payouts (Section 194H)
OTAs acting as agents deduct TDS under Section 194H (commission payments) before remitting hotel revenue. Reconciling TDS deductions against Form 26AS requires matching TDS certificates to individual settlements — which OTAs often batch annually.
Restaurant aggregator reconciliation
Zomato and Swiggy settle weekly with variable commission rates, GST on commission, and TDS. The settlement format changes periodically, requiring regular ingestion template updates.
Multi-channel revenue reconciliation
Property management systems (Opera, IDS, eZee) record reservations at the booked rate. Final settlement amounts differ due to no-shows, early checkouts, and channel-specific pricing. Reconciling PMS revenue against bank receipts requires field-by-field matching across systems.
How TransactIG solves this
TransactIG is built by Terra Insight with hotels & hospitality-specific configuration, not generic matching logic.
OTA settlement disaggregation
TransactIG ingests weekly OTA settlement files and matches each line item to the corresponding booking in your PMS or accounting system — tolerating commission and TDS deductions with pre-configured rates per OTA.
Section 194H TDS classification
OTA commission TDS is classified separately from room revenue TDS, enabling accurate 26AS reconciliation and TDS credit tracking by section.
Aggregator preset library
TransactIG ships with ingestion templates for MakeMyTrip, Goibibo, Booking.com, Expedia, Agoda, Zomato, and Swiggy settlement formats — including the latest column mappings.
Reconciliation patterns
Configuration presets
No custom development
These presets are included with every Hotels & Hospitality deployment of TransactIG. Go live in 2–4 weeks.
Frequently asked questions
MakeMyTrip changes their settlement format periodically. How does TransactIG handle that?
TransactIG uses configurable ingestion templates that can be updated via the admin interface — no code changes required. Format updates are typically applied within 2 business days.
Can TransactIG reconcile both hotel and restaurant revenue in the same instance?
Yes. TransactIG supports multi-entity and multi-revenue-stream reconciliation within a single deployment, with separate matching rules per channel.
How does TransactIG handle no-shows where the OTA still disburses a partial amount?
No-show variances are classified as a named variance type in the hospitality preset, distinguishing them from genuine commission deductions and enabling accurate revenue recognition.
We operate 12 properties under one legal entity. Can TransactIG handle multi-property reconciliation?
Yes. TransactIG supports property-level segmentation with separate clearing accounts per property, consolidated under the single legal entity for tax reporting.
Ready to automate Hotels & Hospitality reconciliation?
Terra Insight will walk you through a live TransactIG demo using hotels & hospitality transaction data — matching patterns, variance taxonomy, and ERP integration.