How do I reconcile OTA payouts when commissions and refunds change the amount?
Turn one bank deposit into a traceable record of bookings, deductions and adjustments. Use this worked example to check your process and test what your hotel software can actually reconcile.
Reconcile each OTA payout by matching its statement lines to reservation IDs, then adding payments and subtracting confirmed refunds, commissions and fees. Include documented credits or other adjustments before comparing the expected net amount with the bank receipt. Keep known timing differences separate from unexplained discrepancies. A PMS booking total, a settlement batch and accounting revenue measure different things, so they should not be forced to match.
Identify the payment route before matching amounts
For each booking, establish who collected the money. An OTA bank transfer, a virtual credit card (VCC) charged through your processor and a guest payment collected by the hotel follow different settlement routes. Check whether the OTA pays gross or deducts commission. With a gross payout, do not subtract a separately payable commission invoice from the expected bank receipt.
Booking.com’s official payout documentation distinguishes gross and net payouts, bank transfers and VCCs. Available data does not establish which fields your PMS imports.
Gather the reservation and invoice records, itemised payout statement, commission invoice or credit, refund reference and bank entry. Match by reservation ID, transaction ID, batch reference and currency; names and dates alone are insufficient.
PMS figures
Check the report definition: booking value, invoiced charges and stay-date revenue are different measures.
Bank receipts
A deposit shows cash received after the adjustments included in that settlement batch.
Accounting revenue
Recognition depends on your accounting basis and applicable treatment, rather than simply the payout date.
For sole traders and partnerships, HMRC explains cash basis and traditional accounting. Agree the appropriate revenue, expense and VAT treatment with your accountant.
Reconcile three reservations and one refund
Illustrative example: fictional OTA batch OTA-0611 contains three fully collected bookings and a £200 partial refund against reservation B. Its statement confirms 15% commission, the listed processing fees and a £30 commission credit. No processing fee is returned. These are invented terms, not an OTA tariff or RoomRaccoon quote.
All amounts are GBP cash amounts, including any applicable VAT. No VAT split is calculated; deductions are statement totals. The example assumes no foreign exchange, reserves or other adjustments. It reconciles settlement, not taxable turnover.
| Statement line | Payment / refund | Commission / credit | Processing fee | Net contribution |
|---|---|---|---|---|
| Reservation A | £600.00 | −£90.00 | −£3.00 | £507.00 |
| Reservation B | £900.00 | −£135.00 | −£4.50 | £760.50 |
| Reservation C | £500.00 | −£75.00 | −£2.50 | £422.50 |
| Refund R-B1 against B | −£200.00 | +£30.00 | £0.00 | −£170.00 |
| Expected payout | £1,800.00 | −£270.00 | −£10.00 | £1,520.00 |
Check: £2,000 − £200 − £300 + £30 − £10 = £1,520. The £1,520 bank receipt on 9 November matches this batch: unexplained variance £0. Keep the original £900 collection and the separate refund visible. Do not replace it with £700 and then deduct £200 again.
A refund does not establish entitlement to a commission credit. Use the actual adjustment statement. Without the £30 credit, this example would settle at £1,490; an anticipated credit stays on the follow-up list.
Separate settlement timing from missing money
Suppose the example batch was issued on 6 November and reached the bank on 9 November. At the 6 November cut-off, £1,520 remains in transit on your reconciliation schedule. Clear that item against the 9 November receipt without recording the booking income again.
Record the stay date, payment or refund date, statement date and bank posting date separately. A refund deducted in a later batch belongs in that batch’s settlement calculation, linked back to the original reservation.
Stripe’s payout reconciliation guidance, for example, distinguishes estimated arrival dates from bank posting dates and provides itemised payments, refunds and fees. Use the equivalent evidence for your provider; this does not imply a particular RoomRaccoon integration.
Keep a suspense and investigation list
A clearing schedule tracks identified amounts awaiting settlement. An investigation list tracks unresolved differences. If your accountant uses a suspense account, postings need evidence and subsequent clearance. Never change room revenue or invent a fee simply to make a batch balance.
| Exception | Amount | Evidence and next action | Owner / review |
|---|---|---|---|
| £1,520 issued; nothing received yet | £1,520.00 | Track as in transit. Check payout status and bank reference; escalate after the provider’s expected arrival date. | Bookkeeper / next banking day |
| £1,500 received against £1,520 expected | £20.00 | Check statement revisions, fees and bank charges. Keep unresolved until supported. | Finance lead / next working day |
| £30 commission credit expected but absent | £30.00 | Request confirmation from the OTA. Do not include an unconfirmed credit in the settlement total. | Reservations manager / agreed response date |
For each item, retain the batch and reservation references, date opened, evidence, owner, next review date and resolution. Review aged items at month-end and obtain sign-off before closing the period.
Test the workflow with RoomRaccoon
When assessing integrated hotel payments, ask RoomRaccoon to work through a batch like the one above. Establish which steps concern payments processed through RaccoonPay and which concern external OTA bank transfers. A promise of “automated reconciliation” needs a demonstration of your actual settlement route.
- Can the relevant report identify reservations, payout references, refunds, commission adjustments and fees separately?
- Can staff distinguish money collected from money settled, and review an unmatched difference without overwriting the original record?
- Which steps are automatic, imported or manual for your OTA, UK payment provider and subscription? What permissions and audit records apply?
- If you need hotel software integrations, which accounting supplier, fields, exports and UK availability are confirmed?
Bring an anonymised payout statement, its bank receipt and a refund example. Ask to trace the full amount, demonstrate an unresolved £20 difference and identify any manual steps.
Discuss your payment reconciliation workflowOTA payout reconciliation questions
What if one payout covers several stay dates?
Match the transactions included in the payout statement. Preserve each stay date for reporting; the settlement batch does not determine the accounting revenue period.
Can I deduct commission again when its invoice arrives?
Check whether it was already withheld from the payout. Match the invoice to that deduction so the same expense or liability is not recorded or paid twice.
What if a VCC payment is missing from the OTA bank batch?
Confirm the reservation’s payment route. A VCC charged through your processor should be traced through that processor’s transaction and settlement records, rather than assumed to belong to an OTA bank transfer.
Sources and scope
Sources checked on 10 November 2026. Examples are fictional. Provider documentation explains its own payment routes; it does not confirm RoomRaccoon’s integration scope.












