Hospitality Operations

How a Budget Hotel Chain Recovered Rs22L in OTA Commission Leakage

Rs22L

OTA commission leakage recovered

68%

Vendor invoice processing time cut

4.2 days

Monthly accounts close achieved

Properties on unified platform

The Problem

Unreconciled OTA Payouts

MakeMyTrip and Booking.com settlements arrived with varying commission deductions, early-bird discounts, and cancellation chargebacks. Finance teams at each property logged payouts manually in spreadsheets, with no cross-check against the original booking value. Discrepancies aged for months before anyone spotted them.

Scattered Vendor Invoices

Housekeeping supplies, laundry vendors, and contract maintenance staff sent invoices to individual properties. With no centralised AP workflow, duplicate payments occurred across sister properties, and month-end reconciliation required physical file audits across all 22 locations.

Manual Housekeeping Rosters

Housekeeping shifts rotated across contract and on-roll staff. Attendance was tracked on paper or WhatsApp, creating payroll errors each cycle. Overtime calculations for GST-impacted hospitality staff were done by hand, and leave balances had no system of record.

Solution Stack

Zoho Books

Centralised AP and OTA Reconciliation

Each property became a branch entity inside a single Zoho Books OTA reconciliation organisation. OTA settlement CSVs from MakeMyTrip and Booking.com were mapped to custom reconciliation rules, auto-matching payouts to original invoices and flagging variance above Rs500 for review. Vendor bills flow through a three-way match before payment release.

Zoho People

Shift Rosters and Attendance for Contract Staff

Housekeeping shift schedules are built in Zoho People attendance tracking‘s roster module, with separate work schedules for on-roll and contract staff. Biometric integration captures attendance at each property; shift allowances and overtime trigger automatically based on configured pay rules, feeding clean data into payroll.

Zoho Payroll

Property-Level Payroll with Statutory Compliance

Zoho Payroll processes payroll for each property independently, with GST hospitality exemption rules and PF/ESI components pre-configured for contract and permanent categories. Payslips are generated and distributed digitally, cutting the previous 11-day payroll cycle to under 3 days.

Zoho Analytics

OTA Performance and Margin Dashboards

Zoho Analytics property dashboards pulls live data from Books and People to surface per-property OTA effective commission rate, vendor spend per occupied room, and payroll cost as a percentage of revenue. The GM of each property reviews a single dashboard every Monday instead of consolidating three separate reports.

Before vs After

Area	Before	After
OTA reconciliation	Manual spreadsheet matching, 3 to 4 weeks lag, Rs22L undetected variance annually	Automated rules in Zoho Books, variance flagged within 48 hours of settlement
Vendor invoice processing	Paper invoices routed by courier to head office, 14-day average processing time	Digital bill upload at property level, 3-way match, average 4.5-day processing time
Housekeeping attendance	WhatsApp roster shared daily, errors corrected at payroll run	Zoho People roster with biometric sync, zero manual corrections in first 2 months
Payroll cycle duration	11 days including manual overtime calculations and statutory deductions	Under 3 days with pre-configured Zoho Payroll rules
Month-end accounts close	12 to 16 business days due to inter-property consolidation delays	4.2 days with branch-level real-time data in Zoho Books
Management visibility	Each GM emailed a custom Excel report once a week	Live Zoho Analytics dashboard, refreshed nightly from Books and People

Implementation Phases

Discovery and Chart of Accounts Design

Weeks 1 to 2

Mapped OTA settlement formats from MakeMyTrip, Booking.com, and GoIbibo. Designed a unified chart of accounts with property-level cost centres and OTA-specific liability accounts for commission payables.

Zoho Books Setup and Branch Migration

Weeks 3 to 5

Configured 22 branch entities, migrated 18 months of historical vendor data, and built OTA reconciliation templates. Vendor master clean-up removed 140 duplicate supplier records across properties.

Zoho People and Payroll Rollout

Weeks 5 to 8

Configured work schedules and housekeeping shift patterns in Zoho People. Integrated biometric devices at 22 properties. Built payroll components for contract and permanent staff with PF, ESI, and hospitality allowance rules compliant with current statutory norms.

Zoho Analytics Dashboards and Go-Live

Weeks 9 to 11

Built GM-level and finance-level dashboards in Zoho Analytics. Ran one parallel payroll cycle and one OTA reconciliation cycle alongside the old process to validate outputs before full cutover. Full go-live completed in week 11 with no payroll disruption.

Results

Rs0L

OTA commission leakage recovered

Vendor invoice processing time cut

0 days

Monthly accounts close achieved

Monthly OTA Variance Recovered (Rs Lakhs)

The Core Takeaway

OTA commission reconciliation is not a finance problem. It is an operational data problem. When booking values, settlement amounts, and commission schedules live in separate systems, variance accumulates invisibly. Connecting Zoho Books directly to OTA settlement data and giving finance a flagging rule rather than a spreadsheet turned a reactive audit exercise into a real-time control. The Rs22L recovery was not found in one big discrepancy. It was found in 400 small ones that no spreadsheet was ever going to surface on its own.

Frequently Asked Questions

How does Zoho Books handle OTA commission reconciliation for MakeMyTrip and Booking.com settlements?

Zoho Books does not have a native OTA connector, but settlement CSV files from MakeMyTrip, Booking.com, and similar platforms can be imported against a custom reconciliation template. Each import row is matched to an existing sales invoice using booking reference as the key. Unmatched or variance rows are flagged in a separate exception report, which the finance team reviews before closing the period. The whole process takes under 2 hours per property per month once templates are configured.

Can Zoho People manage housekeeping shift rosters for properties with both contract and permanent staff?

Yes. Zoho People supports multiple work schedules and shift patterns within a single organisation. Contract staff can be set up under a separate employment type with their own attendance rules, overtime thresholds, and pay components. Shift swaps and roster changes are logged with timestamps, which feeds directly into Zoho Payroll for accurate pay calculations without manual adjustment.

What is the typical implementation timeline for a hotel group with 20 or more properties?

A group of 20 to 25 properties with Zoho Books, People, Payroll, and Analytics typically takes 10 to 14 weeks from kick-off to full go-live. The longest phase is usually data migration and vendor master clean-up, which scales with the volume of historical invoices and the number of duplicate vendor records. Running one parallel cycle before cutover adds 2 to 3 weeks but significantly reduces go-live risk.

Does Zoho Payroll cover the GST and statutory compliance requirements for hospitality staff in India?

Zoho Payroll supports PF, ESI, professional tax, and TDS calculations out of the box. For hospitality-specific allowances such as uniform allowances or food coupons, these can be added as custom pay components with the correct tax treatment. GST is relevant at the invoice and billing layer handled by Zoho Books, while payroll statutory compliance follows standard Indian labour law. Aaxonix configures both layers to align with the client’s specific structure during implementation.

How a Budget Hotel Chain Recovered Rs22L in OTA Commission Leakage

Challenge

Solution

Tools

How a Budget Hotel Chain Recovered Rs22L in OTA Commission Leakage