Most Egyptian hosts read their Booking.com payout, see a number smaller than expected, and move on. The gap is not random and it is not a mistake. It is three separate deductions, applied in a specific order, with a rounding rule that decides the final cent.
This is the arithmetic, checked line by line against real payout statements.
The three deductions, in order
A Booking.com payout has more than commission taken out of it. There are three distinct lines, and confusing them is where most reconciliation goes wrong:
- OTA commission — the platform's percentage of the accommodation total.
- Payment service fee — charged when Booking.com collects the money on your behalf (Payments by Booking.com). If the guest pays you directly at the property, this line does not exist.
- VAT on those two fees — 14% Egyptian VAT, charged on the platform's own fees.
The third one is the one hosts miss, and it is the one most often misunderstood.
The VAT line is not your guest's tourism tax
This trips up nearly everyone, because both numbers are 14%.
The guest's accommodation tax is charged to the guest, arrives as its own line in the reservation, and is money that passes through you. It has nothing to do with your payout deduction.
The VAT discussed here is charged by Booking.com on its own services — the commission and the payment fee — and is deducted from what they send you. You are the customer being taxed, not the collector.
They share a rate. They are not the same money, they are not owed to the same party, and they must never be netted against each other in your books. If you have been treating the payout deduction as tourism tax, your accommodation-tax liability is overstated and your cost of sale is understated.
A worked example
Take a booking with an accommodation total of 177.32, where Booking.com collects the payment:
| Line | Amount | How it is derived |
|---|---|---|
| Accommodation total | 177.32 | what the guest was charged for the stay |
| OTA commission | −23.70 | platform percentage on the total |
| Payment service fee | −4.26 | for collecting the payment |
| VAT on those fees | −3.92 | 14% of each fee, rounded per line |
| Net payout | 145.44 | what actually lands |
The headline commission is 13.4% of the total. The real cost of that booking is 31.88, or 18.0% — a third more than the commission line suggests. If you price against the commission rate alone, you are under-pricing every OTA booking by roughly a fifth of your platform cost.
The rounding rule that decides the last cent
Here is the detail that makes reconciliation either work or fail, and it is not documented anywhere obvious. The VAT is rounded on each fee separately, then added — not calculated on the sum.
Using the numbers above:
Per line (correct):
23.70 × 0.14 = 3.318 → 3.32
4.26 × 0.14 = 0.5964 → 0.60
3.32 + 0.60 = 3.92 ✓ matches the statement
On the sum (wrong):
(23.70 + 4.26) × 0.14 = 27.96 × 0.14 = 3.9144 → 3.91 ✗ one cent short
One cent on one booking is nothing. Across a few hundred bookings a month it becomes a reconciliation that never balances, and you will spend an afternoon hunting a rounding error instead of a missing payment. We confirmed this against a second statement — gross 74.77, commission 10.21, payment fee 1.79, VAT deducted 1.68, net 61.09 — and it only reconciles to the cent with per-line rounding.
Airbnb does not work the same way
Do not copy this model across. Airbnb's payout structure is different: the host service fee is deducted differently, and we have not verified a VAT line on it against a statement. Applying Booking.com's rule to Airbnb bookings would deduct money from your margin that Airbnb never actually took, making every Airbnb booking look less profitable than it was.
If a tool shows you a single blended "OTA fee" across both platforms, it is guessing on at least one of them.
What to do with this
- Price against the all-in cost, not the commission rate. On the example above that is 18%, not 13.4%.
- Separate the two 14% lines in your books. One is a cost of sale; the other is a liability you collect and remit. They are not interchangeable.
- Check whether you are on Payments by Booking.com. If the guest pays at the property, the payment fee and its VAT both disappear — which changes the real cost of a direct-pay booking materially.
- Round per line when you reconcile. If your spreadsheet disagrees with the statement by a cent or two per booking, this is why.
GateIn computes these lines per booking automatically and keeps the VAT as its own line rather than folding it into a net figure, so the cost of every OTA booking stays visible instead of disappearing into a single number.