1. Use the OTA confirmation number to connect the channel record, PMS stay, and commission line.
2. Calculate commission from the contracted base, not automatically from the guest total or payout.
3. Separate room revenue, taxes, promotions, payment costs, refunds, and commission.
4. Close each difference or carry it forward with an owner and supporting evidence.
OTA commission reconciliation in a PMS turns a channel invoice or charge into reservation-level evidence. Instead of accepting one monthly total, the hotel confirms which completed, cancelled, modified, or no-show bookings created each commission amount.
This is different from reconciling a payout. A payout explains cash received from a channel. Commission reconciliation explains the distribution expense attached to each reservation, including bookings where the guest paid the hotel directly.
The aim is a clean record of gross room revenue, commission expense, payment collection, and remaining differences without forcing unrelated numbers to balance.
Start With the Contracted Commission Rule
Keep the current channel agreement, fee schedule, tax treatment, promotion funding, cancellation and no-show rules, and any preferred-placement or program charges with the reconciliation file.
Do not apply one percentage to every OTA or copy a rate from an old invoice. The commission base can vary by channel, property agreement, rate plan, tax type, market, promotion, or reservation outcome.
Write down what belongs in the base: room price, meals, service charges, local taxes, VAT or sales tax, add-ons, cancellation fees, and no-show charges. Mark each item included, excluded, or needing contract confirmation.
Also record when commission becomes reportable under the hotel's accounting policy and channel agreement. Booking date, checkout date, invoice period, and payment date can place the same reservation in different months.
Build One Reservation-Level Record
Use the OTA confirmation number as the primary match. For each booking, capture channel, PMS reservation ID, guest, booking date, stay dates, status, room and rate plan, gross room amount, taxes, fees, discounts, promotion contributions, cancellation or no-show amount, and currency.
Add the contracted commission rate or fixed charge, commissionable base, expected commission, invoiced commission, adjustment, dispute status, and accounting period.
Do not rely on guest name alone. Names can repeat, change, or use different character sets. Multi-room reservations may also have one channel confirmation but several PMS folio lines.
An organized hotel management software record keeps channel source, reservation status, room revenue, and folio history together before finance adds the commission fields.
Match the Final Reservation Status First
Commission cannot be reconciled correctly while the OTA and PMS disagree about what happened. Confirm whether the guest stayed, cancelled within policy, cancelled late, did not arrive, shortened the stay, changed rooms, or received a fee waiver.
Use the final OTA reservation and the operational PMS record. A confirmed booking that later cancelled should not remain as stayed revenue simply because it appeared on the first reservation export.
For modified bookings, use the final commissionable amount supported by the channel record and contract. Keep the original value in history, but do not charge commission twice because the PMS contains old and new versions.
Resolve duplicate PMS records before calculating commission. One OTA confirmation should normally contribute one final reservation outcome to the commission review.
Calculate Expected Commission Clearly
Use a simple reservation calculation:
Expected commission = confirmed commissionable base × contracted rate, plus or minus approved fixed charges or adjustments
Keep the commissionable base separate from the guest total. Some taxes or property charges may be outside the base, while certain meals or service items may be included. The signed agreement and invoice detail control the decision.
Do not calculate commission from the net bank deposit. That amount may already include deductions, refunds, several reservations, payment costs, currency differences, or earlier adjustments.
Keep room revenue and commission expense in separate fields according to the hotel's accounting policy. Reducing the PMS room rate to match net cash makes ADR and channel performance harder to understand.
Smart Order can connect booking source and PMS revenue with the hotel's channel reporting, giving finance a consistent base for reservation-level commission checks.
See Commission Beside the Reservation Result
Use Smart Order to review booking source, stayed revenue, and channel performance before closing commission expenses.
Match the Invoice or Charge Line
Match every commission line to the OTA confirmation number and PMS reservation. Confirm currency, rate, base, tax on commission where applicable, adjustment reference, and invoice period.
Use this six-step routine:
- Find the final OTA reservation and one PMS record.
- Confirm the final stay or cancellation outcome.
- Rebuild the commissionable base from the contracted inclusions.
- Calculate expected commission using the approved rate or charge.
- Compare expected and invoiced amounts, including tax and adjustments.
- Mark the item matched, disputed, or carried forward with evidence and an owner.
Do not let overcharges and undercharges on different bookings cancel each other. The invoice total can be correct while individual reservations remain wrong.
When one invoice line covers several rooms under one reservation, reconcile the combined booking first, then allocate commission internally only if the hotel's reporting requires it.
Explain the Difference in a Fixed Order
Check the most common causes first: wrong commission rate, wrong commissionable base, tax treatment, modified stay, partial cancellation, no-show, fee waiver, promotion contribution, duplicate PMS record, currency conversion, rounding, prior-period adjustment, and invoice timing.
State every difference with an amount and direction. “Invoice exceeds expected commission by USD 24 on confirmation X” is actionable. “Commission is wrong” is not.
If the channel record is correct but the PMS status or amount is wrong, correct the hotel record with approval. If the PMS and booking are correct but the invoice differs, raise a dispute without changing hotel revenue.
Keep valid timing differences open with the confirmation number, expected commission, reason, owner, and anticipated clearing period.
Use Commission Data to Improve Channel Decisions
Once the invoice is reconciled, combine commission with other property-funded costs: promotions, loyalty incentives, payment fees, refunds, and extra operating work. This produces an effective acquisition cost by reservation.
Use hotel reports and analysis to compare gross room revenue, commission, net channel contribution, cancellation rate, ADR, and length of stay by OTA. Booking count alone cannot show which channel contributes the most profit.
Compare OTA acquisition cost with the cost of reservations coming through the hotel's commission-free booking engine. Include website, payment, marketing, and software costs so the comparison remains fair.
The purpose is not to remove every OTA. It is to understand which channels, rate plans, and promotions earn enough net revenue to justify their cost.
Close the Period Without Hiding Open Items
The period is ready to close when every commission line is matched, disputed, or carried forward. The reservation-level total must bridge to the invoice and accounting entry.
Have a second person review manual rate overrides, large cancellations, no-show commission, fee waivers, duplicate bookings, and prior-period adjustments. Preserve the contract version and evidence used for the calculation.
Give management a concise summary: gross OTA room revenue, commissionable base, commission, tax on commission, disputes, adjustments, effective commission rate, and net contribution by channel.
Use recurring differences to improve PMS setup and staff practice. Missing OTA confirmation numbers, wrong channel sources, edited room totals, and unrecorded cancellations are operating problems as well as finance problems.
Frequently Asked Questions
Should commission be calculated from the guest total?
Not automatically. Use the commissionable base defined by the property's channel agreement and the final reservation outcome.
Is OTA commission the same as the difference between revenue and payout?
No. A payout can also include taxes, refunds, payment fees, several reservations, currency differences, and earlier adjustments.
Should commission reduce room revenue in the PMS?
Hotels commonly track gross room revenue and commission expense separately, subject to their accounting policy. This preserves useful ADR and channel-performance reporting.
What makes a commission period complete?
Every invoice line is tied to a reservation and final status, with differences resolved, disputed, or carried forward under an owner.
