A reservation-by-reservation method for OTA commission reconciliation

A remittance total can look plausible and still leave commission behind. The reliable check is booking by booking: what was promised, what arrived, and what explains the difference.

That applies whether an OTA statement covers several stays or a property pays your agency directly. The payment route changes; the reconciliation question does not. Start with the booking’s expected commission, not the size of the deposit in your bank account.

1. Set the expected amount for each booking

Build a simple working record for each confirmed reservation. Capture the booking reference, property or supplier, stay dates, currency, commission basis, agreed rate or amount, and expected payment timing. Keep a copy of the confirmation or agreement that supports the calculation.

For Airbnb and Booking.com reservations, use the terms that apply to that specific booking. Do not assume every reservation follows the same rate, calculation basis or payment arrangement. If the commission is a percentage, record the amount it applies to and calculate the expected commission from that figure. If the agreement specifies a fixed amount, record that instead.

For a direct property payout, record the amount the property agreed to remit to your agency. Do not confuse that figure with the total value of the stay or with client funds passing through your books. A payout may include amounts that are not agency commission; reconcile each category on its own terms.

2. Identify the payment route before matching

Separate reservations into the route by which money is due. An OTA commission remittance, a property paying commission directly, and a settlement that includes other funds are not interchangeable. Label the expected payer and expected amount for each reservation.

This small distinction prevents a common error: comparing a deposit or batch total with the wrong figure. If a payment covers several reservations, the total is not enough to confirm that every booking was paid correctly. You need the statement or other supporting detail that shows how the amount was allocated.

3. Gather the statement and payment evidence

Collect the remittance notice, commission statement or supplier email, along with the payment record available to your agency. For each item, note the date, currency, amount, booking reference and any listed adjustment. Keep the original document or message available so you can check an unclear entry rather than relying on a copied total.

Holidr integrates directly with Gmail and parses incoming emails and PDF attachments for dates, balances and booking references. It also reconciles commission remittances against promised amounts and flags short payments. That can reduce manual extraction from inbox paperwork, but it does not remove the need to verify the booking terms and the money received.

4. Match by reference, then check the figures

Use the booking reference as the first match. If it is absent or inconsistent, compare the property, travel dates and other available details, then confirm the match against the booking record. Avoid assigning a payment to a reservation based on amount alone; two stays can have similar commission values.

Compare the expected and received amounts in the same currency. If they differ, check the statement for a documented adjustment, correction or other explanation. Record the reason and the evidence. If there is no clear explanation, leave the item open rather than treating a near match as settled.

For a batch payment, repeat this check for every reservation listed. A correct batch total can conceal one short payment offset by another overpayment. Conversely, a difference in the batch total may come from timing or an adjustment rather than a missing booking. The individual lines tell you which case you have.

5. Resolve exceptions and close the loop

Make a short exception list: missing remittance, short amount, unmatched reference, or unclear adjustment. For each one, include the reservation, expected amount, amount received, currency and the question that needs answering. This gives the payer a specific issue to investigate and gives your team a clear record of what remains outstanding.

Holidr can flag short commission payments and draft supplier chases; drafts require your approval before sending. Check the figures and wording against the supporting documents before approving anything. Keep unresolved items open until the payer’s explanation or follow-up payment accounts for the difference.

When the figures do reconcile, mark the reservation complete in your own tracking process and retain the evidence. Review older open items on a regular schedule so small shortfalls do not disappear inside later batches. For a broader comparison of manual and inbox-based methods, see how agencies weigh commission-tracking approaches.

Keep the check narrow and repeatable

Good OTA remittance tracking is not a hunt for a perfect batch total. It is a repeatable comparison between each booking’s documented promise and the payment allocated to it. Keep commission separate from other funds, verify exceptions before closing them, and let automation surface the paperwork and discrepancies—not make the final judgment for you.