Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Check Booking.com and Expedia Commission Statements Against the Stays We Actually Had?
Problems We Solve

How Do We Check Booking.com and Expedia Commission Statements Against the Stays We Actually Had?

Hotel OTA commission statements include no-shows, changed stays and cancellations. We build a check that matches each line to your PMS before you pay.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Each month the OTAs send a commission statement based on the reservations they think stayed. Guests who did not arrive, shortened their stay or changed their booking at the desk can still appear at the original value unless you mark them. We build a check that matches every statement line to what actually happened in your PMS and lists the differences, so you can raise them with the OTA before paying.

The statement arrives, and it gets paid

At the start of the month, the Booking.com invoice and the Expedia statement arrive. Each lists reservations and the commission due on them. The front office manager glances at the total, it looks about right, and it gets paid. Checking line by line would mean opening each reservation in the PMS and comparing arrival, nights and value, and there are a lot of lines.

Somewhere in there is the guest who did not turn up and was never marked as a no-show in the extranet. The family who booked five nights, left after three, and settled at the desk. The business traveller who moved his dates by phone rather than through the OTA. The booking that was cancelled within the free period but not processed on the OTA side. Each one is small. Together, every month, they are not.

Why the statement and reality drift apart

OTAs calculate commission from the reservation as they hold it. Most expect the hotel to report changes, such as no-shows, early departures or changed dates, through their extranet within a set period. In a busy independent hotel, that reporting depends on whoever is on shift remembering to do it.

  • No-shows are dealt with in the PMS at night audit but not always reported in the extranet.
  • Early departures and date changes agreed at the desk do not flow back to the OTA.
  • Stays are sometimes modified in the channel manager and the PMS differently.
  • Each OTA has its own statement layout and its own deadline for disputes.
  • Nobody is assigned to reconcile, so it is done occasionally or not at all.

What unchecked statements cost

You pay commission on revenue you never received. Individually the amounts are small enough to ignore, which is exactly why they are never raised. Over a year they add up to money you would rather have kept, and past a certain point the OTA's deadline for disputes closes.

There is a less obvious cost too. If no-shows and early departures are not reported, the OTA's view of your hotel's reliability and your own reports on channel performance are both slightly wrong, which feeds into decisions about which channels to push.

How we build a commission statement check

  1. The statement from each OTA is taken in as the file or export the OTA provides.
  2. Each line is matched to the reservation in your PMS by OTA reference number, with name and date matching as a fallback.
  3. For each match, the tool compares arrival date, nights stayed, room revenue and status (stayed, no-show, cancelled).
  4. Differences are listed by type: no-show charged, shorter stay, different value, cancelled booking, and lines that cannot be matched at all.
  5. The list is presented in a form that makes it easy to raise each item through the OTA's own process before its deadline.
  6. Night audit gets a daily prompt listing that day's no-shows and early departures from OTA bookings, so they are reported at the source and the statement is right in the first place.
Statement linePMS showsFlag
3 nights, full valueGuest left after 1 nightShorter stay, commission on 2 nights to query
2 nights, full valueNo-show, card declinedNo-show not reported
1 nightCancelled within free periodCancelled booking charged
4 nights4 nights, higher value (upgrade paid at desk)No action, check policy

The tool does not dispute anything on its own. It gives the person responsible a clear list with the evidence from your PMS alongside each item.

A monthly routine that takes minutes to review

When the statement arrives, it goes into the check. The front office manager opens a list of items to query rather than a list of every booking. She raises them through the extranet, and the tool keeps a record of which were accepted.

More importantly, the daily prompt at night audit means fewer items reach the statement at all. The monthly check becomes a confirmation rather than a hunt.

Is your hotel paying commission blind?

  • OTA statements are paid on the total without line-by-line checking.
  • No-shows are handled in the PMS but not always reported to the OTA.
  • Guests change their stay at the desk and the OTA is not told.
  • You sell through more than one OTA with different statement formats.
  • You have never counted what disputed items would have been worth.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does this work for both Booking.com and Expedia?

Yes, and for other OTAs that provide a statement file. Each OTA's layout is set up once.

Will it dispute charges automatically?

No. It lists the differences and the evidence. Raising them through each OTA's process is your decision.

What if our PMS and channel manager disagree?

That shows up as a mismatch in its own right, which is useful to know. We check where the difference started.

What drives the cost?

The number of OTAs and properties, how your PMS exports reservations, and whether you want the daily night audit prompt.

What do you need from us?

A few months of statements from each OTA, PMS reservation exports for the same period, and your night audit routine.

Keep reading

More on Problems We Solve

Start here

Tell us where your hotel's admin piles up

Describe the admin that is eating your reservations and accounts team's week: which PMS, channel manager and accounting package you use, which OTAs you sell through and how many properties you run. We will tell you what we would build, and if your existing systems can already do it with the right settings, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →