How Much Money Is Sitting in Your OTA Virtual Cards Right Now?

Revenue that has already been earned but not yet collected is one of the most common blind spots I see across hotel finance operations: it sits in OTA virtual card balances because nobody has the bandwidth to check every transaction by hand. It doesn’t look like a crisis. A few euros here, a currency rounding difference there, a card charged a little late. But multiply that across hundreds of reservations a month, per property, per OTA, and it becomes one of the largest sources of quiet revenue loss in hotel finance.

I recently walked through this in a webinar, Recover Lost OTA Revenue with Automated VCC Reconciliation, and wanted to share the two things I think matter most for anyone who couldn’t join live: what the leak actually looks like inside a real portfolio, and what changes once you stop trying to catch it by hand.

What the Automation Actually Does

Reconciling OTA virtual credit cards sounds like a simple five-step process: a booking is confirmed, a VCC is issued, the folio is posted in the PMS, the hotel charges the card, and the OTA settlement window closes. None of these steps is complicated on its own. The problem sits between them, where amount mismatches, late charges, and status differences slip through unnoticed, because nobody has time to compare all five steps for every reservation, every day.

The workflow automation runs as a loop every morning. It logs into each OTA portal and pulls the previous day’s virtual card data, matches every transaction to the corresponding PMS folio, and validates the amount, tax, currency, and reservation status. Where it can, it charges the full amount or the remaining balance itself, and it builds a structured exception report only for what still needs a human. It doesn’t just flag the gaps, it closes the ones it can, all within PCI-DSS compliant environments.

Where the Money Actually Disappears

In practice, the same four failure modes show up again and again. Virtual cards get undercharged or never charged at all, often from a data entry error or an interface lag. Tax and city fee amounts get miscalculated when the interface splits them incorrectly from the room revenue. Currency rounding gaps appear on cross-border bookings and compound quietly across thousands of reservations. And PMS and OTA statuses fall out of sync: a reservation shows as checked out in the PMS while it’s still active at the OTA, the charge attempt fails silently, and the dispute window closes before anyone notices.

None of this is a people problem. Asking the operations  team to eyeball tens of thousands of sub-transactions a month and catch every discrepancy simply isn’t something the math allows. Manual reconciliation for one OTA at one property runs about 30 minutes a day. Multiply that across ten properties and three OTAs, and you’re at 450 hours a month before any actual recovery work has even started.

What Eleven Hotels Taught Us in One Month

During the webinar I shared a number I still find striking: one portfolio, 11 hotels, one OTA, one month. $228,000 in virtual card balances had not yet been processed. To be clear, most of that wasn’t pure leakage, it was revenue that would likely have been collected eventually, just late and inconsistently, only after someone worked through 7,559 individual transactions by hand. With the automation running, 43% of the exceptions in that batch resolved themselves with no human touch at all, and annualized, that single OTA represented roughly $2.5 million moving through the reconciliation process each year for that portfolio.

Scale that logic to a typical mid-size group of ten properties working with Expedia, Booking, and Agoda, and you get close to $108 million a year in OTA virtual card volume being reconciled, with around $1 million a year in recoverable variances. Operations teams get back close to 3,600 hours a year, the equivalent of two full-time positions, and direct labor savings alone run near $200,000. Put together, the annual value for a group that size lands above $1.3 million.

I once witnessed how a five-euro-per-booking city tax gap cost one hotel more than €100,000 over three years before anyone caught it. What the numbers above show is what that same blind spot looks like once you stop waiting for someone to notice it by accident, and start checking every transaction, every day, from day one.

The leak itself isn’t dramatic. It’s small, frequent, and individually below the threshold anyone would flag by hand, which is exactly why it survives quarter after quarter even inside well-run finance teams. But talk to the people who run these portfolios, and labor hours saved aren’t what they bring up first. What they care about is the audit trail on every transaction, and revenue being recognized the same day it’s earned instead of weeks or months later. That’s the real shift: your team stops reconciling and starts reviewing, with the boring 90% of the work already done.

👉 Watch the webinar replay on YouTube: Recover Lost OTA Revenue with Automated VCC Reconciliation

Or explore the OTA Virtual Card Balance Reconciliation automation directly.

If you’d rather start with your own numbers, write to [email protected] with "workshop" in the subject line.