OTA Reconciliation: Unlocking $2M in Annual Revenue

The Gap

For most hotels, cross-referencing Online Travel Agencies (OTAs), such as Expedia and Booking.com, with Property Management Systems (PMS) is a manual, error-prone ordeal. With hundreds of reservations to sift through, discrepancies often go unnoticed, leading to significant uncaptured revenue that hotels simply "eat" due to a lack of time and granular visibility. My goal was to design a solution that surfaced these hidden losses and provided a clear path to recovery.

Strategic Prioritization

To meet a strict four-month MVP deadline, I led the design strategy by focusing on "insight over automation." While the long-term vision included automated PMS adjustments, we prioritized a high-value manual intervention model. I utilized a progressive disclosure framework to manage data density, bubbling up critical discrepancies at a high level while allowing users to drill down into specific reservations and recommended follow-up actions only when needed.

The Business Impact

By transforming a chaotic manual process into a streamlined, insight-driven workflow, we successfully shipped a functional MVP that projected $2M in annual recurring revenue (ARR). The solution replaced guesswork with actionable data, giving hotels the visibility required to reclaim lost revenue without the overhead of manual audits.