Reconciling booking site payouts: commission, virtual cards and the bank

OTA payout reconciliation is the month-end job of proving that every stay booked through a booking site was paid at the right amount, after the right commission. You list stays by site and payment model, match each payout or virtual-card charge to the guest bill, separate commission from room revenue, and chase what is missing.

The bank shows one credit from a booking site. For example, your system might show thirty-one check-outs for the same week. Between the two sit commission, a payment service fee, two currencies and a payout statement that lists stays you now have to find one by one. This article gives you the monthly routine: build the list, match each payout or card charge to the guest bill, separate commission from revenue, and leave a trail the accountant can follow. The payment models themselves are covered in OTA payment terms explained; here we do the month-end job.

Why is one booking site payout so hard to match to individual stays?#

Because the site pays a net total for a period, not per reservation, and commission and fees have already been taken out before the money arrives.

Two payment models sit side by side. Under hotel collect the guest pays the property and the site invoices commission later. Under site collect the booking site takes the guest's money and pays the property afterwards, by bank transfer or by virtual card. The matching job exists mainly for the second model.

Netting is the first obstacle. Commission, and where it applies a payment service fee, are deducted before the credit reaches you, so the bank amount never equals the room revenue recorded in your system. Timing is the second. Payout periods are defined by check-out date, not booking date, so a stay booked in March and checked out in April belongs to April's payout. Currency is the third: the guest may pay in one currency and the payout may arrive in another, at a rate you did not set.

Volume makes it worse. One credit covers many stays, and a single stay can be split across two payouts when it straddles a period boundary. The payout statement is the primary document; the bank line only confirms that the statement was settled. Work from the statement, never from the bank line alone.

What should the monthly reconciliation list contain?#

One row per reservation, carrying the site, the payment model, the gross amount, the commission, the expected net and the payout or card it should appear in.

Build the list from the hotel system, filtered by check-out date inside the payout period, never by booking date. The columns that make matching possible are: booking reference, guest name, arrival and departure, site, payment model, currency, gross, commission, payment service fee, expected net, payout reference, status.

Keep status values few and unambiguous: expected, matched, short, missing, card charged, card expired. Always keep the gross figure, even when the payout is net; without gross you cannot check the commission later. Run the list at the same point every month, before the accountant closes the period, and save it next to the payout statement.

For example, a row might read: site collect, three nights, gross 300, commission 45, payment service fee 3, expected net 252, payout 14 March, matched. The amounts in the table and the example are invented and in one currency.

How do you match a payout to folios and the agency account?#

Match each statement line to its reservation, clear the site's receivable for the net amount, and post commission and fees on their own lines so the receivable returns to zero.

A site-collect stay is a receivable, not a cash sale: the booking site owes you from check-out until the payout lands. When the payout arrives, clear the receivable for the net, post commission and the payment service fee to their own accounts, and confirm the period's receivable closes at zero. Hotel-collect stays run the other way: the guest pays you, and the site's commission invoice arrives later as a cost, not as a deduction from a payout. The mechanics of the commission itself are covered in Booking.com commission: how it is calculated and how a hotel checks the statement.

Match on booking reference first, then on guest name plus dates, because names are spelled differently in the two systems. Do not force a match to close a period; an unmatched line is information, and hiding it moves the problem into next month. Attach the payout statement to the journal entry so a later reader can rebuild the number without asking you. The broader receivable structure is the same one used for tour operators, described in Hotel city ledger explained.

Which virtual cards are still uncharged?#

Any reservation paid by virtual card that has checked out and has no matching POS charge is an open item, and it should be swept every week rather than every month.

A virtual card is a temporary digital card issued for one reservation. The property charges it through the POS like any other card, and the money then arrives through the acquirer, not through the payout statement. Booking.com's Partner Help article on virtual credit cards (updated 2 November 2026) says qualifying properties can charge the card from the booking date for non-refundable bookings, otherwise once the reservation is at least 90% non-refundable, and that new or non-qualifying properties can charge one day after check-in.

The same article says the card can be charged for up to 12 months from check-out; after that it expires and the funds return to Booking.com. Watch partial charges too. A card charged for the room but not for the extras leaves a balance that will expire with the card. The daily extranet check, described in Extranet routine, catches these early; the weekly sweep catches what it misses.

How do cancellations, refunds and corrections after the stay land?#

They usually land after the payout, so each one needs its own line and its own reference, or it disappears inside the next period's total.

A waived cancellation fee has a fee consequence. Booking.com's Partner Help article on bank-transfer payouts (updated 12 October 2026) says no payment fee is charged when the property waives a guest's cancellation fee; check how the commission was treated on the same statement. A refund paid after the payout reduces a later payout, so post it against the original reservation, not as a new item, and the stay's full history stays in one place.

A folio correction after the payout, such as a late minibar charge or a corrected rate, rarely changes the payout. Treat it as a separate receivable from the guest, or as a management decision to write off. Never delete the original line: add a reversing line, the same principle as voiding a charge on the guest bill. Keep the written exchange with the site attached to the reservation, so the reason survives staff changes.

What do you do when a payout is missing, short or in another currency?#

Missing and short payouts follow one route: statement, reservation record, written query to the site, dated follow-up. Currency differences go to the accountant as a question, not as a guess.

Missing first: check the payout schedule, then the bank delay, then the bank details. The same Booking.com article (updated 12 October 2026) says funds can take up to 10 days to reach the account, and that changing bank details pauses payouts for five business days for verification. Short payouts: compare line by line. The usual causes are commission on a rate you did not expect, a payment service fee, a refund from an earlier period, or a currency conversion.

Divide the work. Reservations supplies the booking reference and the folio, income audit supplies the statement line, and one named person writes to the site's partner support, in writing, with a date. Set an internal deadline, for example 10 business days after the payout period closes, and escalate in writing after it passes. Post exchange differences to a separate account and ask the accountant which rate and treatment applies; do not adjust room revenue to make the total fit. Keep a query log, so the same missing payment is not chased twice by two people, or forgotten by both.

What to do next#

Build the monthly list this month: one row per stay, filtered by check-out date, with gross, commission, expected net and the payout or card reference. Run the virtual card sweep every week beside it, and hand the accountant a file where every line can be traced back to a statement. The list is the routine; the sweep is what stops the quiet losses.