Reconciling OTA commission one reservation at a time in your PMS catches errors a batch total hides, and this walks through setting up that workflow properly.
Checking OTA commission against a single invoice total tells you whether the sum looks roughly right, but it hides exactly which reservation, if any, was charged incorrectly. Reconciling reservation by reservation inside your PMS is slower per booking but far more reliable, and this covers how to set that workflow up without it becoming a full-time job.
A commission invoice or payout batch gives you one number for a period covering dozens of reservations. If that number looks approximately right, it's easy to accept it and move on, but an error on one booking — a promotion applied incorrectly, a modification not reflected, a cancellation charged commission it shouldn't have been — can sit inside a total that still looks plausible overall. The only way to catch that specific error is to check the reservation it happened on, not the total it's buried inside.
This doesn't mean auditing every single booking by hand forever — it means having a workflow where each reservation's commission is checked against what it should be, ideally as part of your normal PMS routine rather than a separate audit project.
For each reservation, the commission actually deducted should be checked against your contracted rate for that room type and any promotion that applied to that specific booking, not your standard rate. It should also reflect the booking's final state — if it was modified or partially cancelled after the original booking, the commission basis may have changed along with it. Doing this per reservation means you catch the specific booking where something doesn't add up, rather than discovering a mismatch exists somewhere in a batch of fifty.
Rather than reconciling every reservation retroactively at invoice time, check commission as each reservation is finalized — at check-out or at the point a booking's status is no longer likely to change — so the work is spread across the period instead of piled up at the end. Keep a simple running note of any reservation that doesn't reconcile cleanly, so by the time the invoice or payout arrives, you already know which bookings to expect a discrepancy on rather than starting from zero.
Real commission per channel is built for exactly this — commission is measured from what each actual booking recorded, not a flat percentage applied to a total, so a reservation-level view is the default rather than something you have to reconstruct by hand. Prime Shield adds the guest-side check, comparing the rate you sent, the rate you intended, and what the guest actually paid, flagging any gap over 5% in plain money per booking. The public demo at try.primehostpartners.com is open to try without signing up.