Skip to content

How a Hotel Group Automated OTA Commission Checks and City Tax Reports Across 5 Properties

A case study: how a hotel group with 5 properties stopped paying OTA commission on cancellations and no-shows by matching every commission invoice to PMS reservations, and made city tax reports automatic.

tl;dr

A hotel group with 5 properties checked OTA commissions against stays by hand each month and regularly paid commission on cancellations and no-shows. City tax reporting took a full day per property. Code2b built a system that matches PMS reservations to each OTA's commission invoices line by line, lists every wrongly billed booking with the evidence, and generates city tax reports in the format each city requires.

Code2b
Code2b
November 18, 2026 · 3 min read

Short answer: In 2024 Code2b built a commission checking and city tax system for a hotel group in Montenegro that now catches wrong OTA commissions every month and makes city tax reports automatic. The group, with 5 properties, automated OTA commission reconciliation by having the system match reservations from the PMS against each OTA’s commission invoices line by line. Every wrongly billed booking is listed with the evidence, ready to dispute. City tax reports are generated each month in the format each city requires, and finance only reviews and submits.

This is one of the ten projects on our projects page. The client stays anonymous, but the numbers are theirs.

The problem: commission on stays that never happened

OTA commission invoices were checked against actual stays by hand, each month. It is slow work, and it was not catching everything: the group regularly paid commission on cancellations and no-shows, bookings where no guest ever stayed.

On top of that, city tax reporting took a full day per property. With 5 properties, that is a working week every reporting cycle spent filling in forms.

What we built

1. Every commission line checked against the PMS. Reservations from the PMS and commission invoices from each OTA are matched line by line. Every booking that was billed wrongly is listed with the evidence, ready to dispute.

2. City tax reports generated automatically. Each month the reports are produced in the format each city requires. Finance only reviews and submits.

A dispute needs evidence, not a hunch. Listing each wrong line next to the matching reservation turns “we think we were overcharged” into a claim the OTA can check and correct.

A person stays in the path. The system does the matching and the paperwork. Finance decides what to dispute and submits the reports.

The result

  • Wrongly billed commissions are disputed every month, with the evidence for each booking already listed.
  • City tax reports no longer take a day per property. They are generated automatically in each city’s format.

What other hotels can take from this

If you run one hotel or several, three questions are worth asking:

  1. Does anyone check OTA commission invoices against actual stays? If it happens by hand, or not at all, commission on cancellations and no-shows is likely being paid.
  2. Can you list the wrongly billed bookings with evidence? That list is what gets money back from an OTA.
  3. How long does city tax reporting take per property? If it is a day, it is a report that can be generated from data the PMS already holds.

This is how to automate OTA commission reconciliation for hotels: pull reservations from the PMS, match them to each commission invoice line by line, and hand finance a list of exceptions instead of a pile of invoices.

If your team still checks OTA invoices by hand, a free 20-minute call is enough for us to tell you whether it is worth automating.

Bring one process that eats your week.

It starts with a free 20-minute call.

Get your back-office audit

Frequently asked questions

How do you check OTA commission invoices automatically?

Reservations from the PMS and commission invoices from each OTA are matched line by line. Every booking billed wrongly, such as a cancellation or a no-show, is listed with the evidence, ready to dispute.

Why do hotels pay commission on cancellations?

Because checking every invoice line against actual stays by hand is slow, and wrong lines slip through. This hotel group regularly paid commission on cancellations and no-shows before the check was automated.

Can city tax reports be automated?

Yes. The reports are generated each month in the format each city requires. Finance only reviews and submits them.

How long did city tax reporting take before?

A full day per property, across 5 properties. Now the reports are generated automatically.

Who decides what to dispute with the OTA?

Finance. The system lists every wrongly billed booking with the evidence, and the team decides what to dispute.

Read more