Reconciliation Specialist

Job description

**Job Title: OTA Reconciliation Executive** **Location:** Gurugram, Haryana **Company:** OYO **Experience:** 28 Years **Department:** Finance / Revenue Operations **About the Role** OYO is looking for a detail-oriented **OTA Reconciliation Executive** to manage reconciliation of Online Travel Agency (OTA) transactions, ensure accurate revenue recognition, resolve payment discrepancies, and support financial reporting. The ideal candidate should have strong analytical skills, excellent attention to detail, and experience working with hotel revenue and OTA platforms such as Booking.com, Expedia, Agoda, MakeMyTrip, and Goibibo. OTA reconciliation typically involves matching bookings, payments, commissions, cancellations, and refunds against internal systems to identify and resolve discrepancies. **Key Responsibilities** - Perform daily, weekly, and monthly reconciliation of OTA bookings and settlements. - Verify reservations, payments, commissions, refunds, cancellations, and chargebacks. - Investigate and resolve discrepancies between OTA portals, PMS, and internal finance systems. - Coordinate with OTA partners and internal stakeholders to resolve payment-related issues. - Monitor outstanding receivables and follow up on pending settlements. - Prepare reconciliation reports and MIS for management review. - Ensure accurate revenue recognition and maintain financial records. - Support month-end closing activities and financial audits. - Maintain compliance with internal controls, SOPs, and accounting standards. - Identify process improvement opportunities to enhance reconciliation efficiency. - Collaborate with Revenue Management, Operations, and Finance teams for seamless reconciliation. **Required Skills & Qualifications** - Bachelor's degree in Commerce, Finance, Accounting, or a related field. - 28 years of experience in OTA reconciliation, hotel finance, revenue accounting, or hospitality operations. - Good understanding of OTA platforms (Booking.com, Expedia, Agoda, MakeMyTrip, Goibibo, etc.). - Knowledge of PMS, channel managers, and reconciliation processes. - Strong proficiency in Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, formulas). - Excellent analytical, problem-solving, and communication skills. - High attention to detail with the ability to manage multiple tasks and deadlines.