How Yatra automated PLB calculation and improved revenue recovery by 75%
.svg)
The Challenge
Due to manual reconciliation of thousands of invoices and collections from corporate clients, the finance team lacked accurate visibility into receivables.
Moreover, Yatra offered a credit period of 45 - 60 days to their corporate customers, which also led to cash flow challenges.
The substantial credit gap between payments to airlines or hotels and payments received from corporate clients adversely affected their cash flows due lack of visibility into where their payments are stuck or coming from.
Manual reconciliation of flight data from 30+ airlines took 7 days every month.
Furthermore, sales data, airline reports, and finance accruals were maintained in spreadsheets.
Manually matching booking data with airline statements was error-prone. Inaccurate data and complications/errors in reconciliation led to delays and in some cases, loss of PLB revenue.
A team of four people took 10 days each month to generate reports
Loss of PLB revenue due to inaccurate data and complications in reconciliation
The Solution
By implementing Bluecopa’s revenue reconciliation solution, the online travel agency automated workflows, improved data accuracy, and gained real-time cash flow visibility.
Data ingestion for 16 large files of flight data from airlines is now cut down to 2 hours from seven days.
Thanks to Bluecopa's MIS, airline contract terms are recorded accurately
Accurate calculation of PLB revenue due to automated reconciliation has improved revenue recovery by 75%.
The time taken to generate monthly reports has been cut down from 10 days to 30 minutes, by automating it through a self-service dashboard.
The Outcome
- 3x faster PLB incentive recognition
- 7x faster AR reconciliation
- 80% reduction in manual reconciliation effort
- 90% faster month-end close
- 75% improvement in PLB revenue recovery
- 200x faster report generation
The Conclusion
By automating the reconciliation process, Yatra significantly reduced manual effort and increased the speed and accuracy of their revenue recovery. As their PLB/airline sales incentive claims depended on their ability to produce accurate flight booking data, Bluecopa's reconciliation automation and management reporting has improved their visibility into their financial health and plugged significant revenue leaks.
.svg)
.svg)
