OTA Commission Calculator: True Net ADR After Fees

If you manage rates on Booking.com, Expedia, Agoda, and a handful of smaller channels, you already know the headline numbers on your dashboard. Average daily rate looks healthy. Occupancy looks acceptable. Then month-end arrives, and finance asks a sharper question: what did we actually earn per room night after OTA commissions and fees?

That number is not the ADR your front desk prints on a report. It is closer to a true net ADR, an educational label we will use in this guide to mean: the revenue you keep per occupied room night after channel costs tied to that booking, especially OTA commission and mandatory channel fees, expressed in a way you can compare channels fairly.

This article is written for hotel owners, general managers, and revenue leads who want a clear method, not a finance degree. You will learn how to build a practical OTA commission calculator mindset, work through realistic examples, and avoid the common mistakes that make hotels overestimate performance.

If you use a property management system and channel manager like Prostay, you can often pull cleaner booking-source data. Even without perfect systems, you can still calculate net ADR with disciplined exports and a spreadsheet.

Why “ADR” on your OTA extranet can mislead you

ADR, average daily rate, is usually defined as room revenue divided by rooms sold. That definition is simple. The problem is which “room revenue” you plug in.

Many hotel teams accidentally use:

• Gross booking value the guest paid (or the hotel’s listed rate before deductions), or
• Room revenue before commissions, which looks strong on paper but does not reflect what lands in your bank account.

OTA distribution is not free. Commissions vary by market, contract, and sometimes by placement. Promotions can change the guest price and your net. If you compare January to February without separating channel mix, you can think ADR improved when your profit per night actually fell.

That is why an OTA commission calculator is not a gimmick. It is a decision tool. It tells you whether a channel is worth the volume, whether a “ranking boost” promotion is expensive, and whether your direct booking strategy is doing real work.

Definitions: gross ADR, net ADR, and true net ADR after fees

Let’s align language so the math stays honest.

Gross ADR (channel gross)

This is the average rate you recognize as booked for the room, before subtracting OTA commission, typically based on what the OTA reports as the booking value attributable to the room charge for that stay segment.

Commission and OTA fees

OTA commission is usually a percentage of the booking value the OTA charges for facilitating the reservation. Some agreements include payment fees, invoicing adjustments, or subscription-like costs depending on partner programs. Treat anything that scales with OTA bookings as part of your channel cost for that booking type.

Net ADR after commission (a mid-step)

This is:

Net room revenue after commission ÷ room nights sold on that channel

It answers: “Per night sold on Booking.com, what did we keep after commission?”

True net ADR after fees (the educational definition we use here)

For practical hotel operations, “fees” often includes:

• OTA commission (the big one)
• Channel-specific mandatory fees that apply broadly (not one-off chargebacks)
• Sometimes payment processing if it is billed through the OTA in a way that scales with OTA bookings

It does not include every hotel expense (payroll, laundry, utilities). Those belong in profit analysis, not in a channel comparison metric. If you mix everything together, you lose the ability to compare Booking.com vs direct fairly.

Prostay helps on the operational side by keeping reservations, rates, and booking sources structured so you are not guessing which bookings came from which channel after the fact. Cleaner source data makes net ADR calculations dramatically easier.

The core formula: net ADR after OTA commission

The simplest educational formula:

Net ADR after commission = (Gross room revenue from channel − OTA commission $) ÷ room nights sold on that channel

If commission is a flat percentage and applies cleanly to the booked room revenue base:

Net ADR after commission = Gross ADR × (1 − commission rate)

Example: Gross ADR on a channel is 150 and commission is 15%.

Net ADR after commission = 150 × (1 − 0.15) = 150 × 0.85 = 127.5

That single step already changes decisions. A hotel that thinks “our ADR is 150” is not comparing apples to apples with a direct booking that pays 145 but keeps nearly all of it.

Why you need channel-level math, not hotel-level only

Hotel-level ADR blends:

• High-commission OTA bookings
• Lower-commission OTAs
• Direct bookings with different payment costs
• Corporate negotiated rates
• Packages where room revenue is split or bundled

If you only calculate net ADR for the entire hotel, you can miss a painful truth: OTA volume can rise while net ADR falls, especially if discounts and promotions stack.

A useful habit is:

1. Calculate gross ADR by channel
2. Apply that channel’s commission rules
3. Compare net ADR by channel across the same period

This is where an OTA commission calculator approach becomes a monthly discipline, not a one-time exercise.

Worked example 1: one channel, one rate, simple nights

Assume a small hotel uses only one OTA for a week to keep the example clean.

• Room nights sold on that OTA: 70
• Gross room revenue on that OTA for those nights: 10,500

Gross ADR on that OTA:

10,500 ÷ 70 = 150

Commission is 18% of the booked room value for those stays.

Commission paid (or accrued):

10,500 × 0.18 = 1,890

Net room revenue after commission:

10,500 − 1,890 = 8,610

Net ADR after commission:

8,610 ÷ 70 = 122.14

So your “150 ADR” story is really a 122 story for that channel, before other costs.

Worked example 2: promotions and discounted guest price

Promotions are where net ADR gets emotionally painful, because the guest sees a deal, the OTA still takes a percent, and your margin compresses on both sides.

Suppose:

• Gross room revenue on the OTA for the period is 9,800 across 70 nights
• Gross ADR is 9,800 ÷ 70 = 140
• Commission remains 18%

Commission:

9,800 × 0.18 = 1,764

Net room revenue:

9,800 − 1,764 = 8,036

Net ADR after commission:

8,036 ÷ 70 = 114.8

Notice what happened: gross ADR dropped from 150 to 140 in the previous framing, but net ADR dropped from about 122 to about 115, a bigger bite than many teams expect because the promotion reduced the numerator while commission still applied on the reduced base in this simplified model.

Reality check: some promotions have different commission rules or apply to visibility rather than price. Always verify your contract terms. The educational point stands: net ADR follows the money you actually recognize and the commission rules that apply to that booking type.

Worked example 3: comparing two channels with different commission rates

Assume two OTAs sell the same number of room nights in a month for the same gross ADR, a simplified assumption used to isolate commission differences.

Channel A

• Room nights: 100
• Gross room revenue: 15,000
• Gross ADR: 150
• Commission: 12%

Commission: 1,800
Net revenue: 13,200
Net ADR after commission: 132

Channel B

• Room nights: 100
• Gross room revenue: 15,000
• Gross ADR: 150
• Commission: 20%

Commission: 3,000
Net revenue: 12,000
Net ADR after commission: 120

Same gross ADR, very different net ADR. This is why “we are fully booked” is not the same as “we are healthy.”

Hidden math hotels forget: VAT or sales tax on commissions in some regions

In some countries, OTA commission invoices include VAT/GST/sales tax on the service fee, or your accounting treats it in a way that affects cash timing. This varies widely.

For an educational net ADR model, you can either:

• Keep commission as commission % × booking value for operational comparisons, or
• Add a tax-on-commission adjustment if your finance lead provides a stable rule

If you ignore this entirely, you may still rank channels correctly, but your absolute net numbers may be slightly off versus accounting. For decision-making, directionally correct is often enough. For reporting, align with finance.

Payment processing: when to include it in “true net”

Direct bookings may incur payment gateway fees. OTA bookings sometimes bundle payment flow differently.

A fair approach for comparing OTA vs direct:

• OTA net ADR subtracts OTA commission (and OTA-scaling fees).
• Direct net ADR subtracts direct payment processing and any booking engine fee your hotel pays per transaction, if material.

If you subtract payment processing for direct but ignore OTA payment economics entirely, you can accidentally favor OTAs. If your OTA contract includes explicit payment-related charges, include them in the OTA side for parity.

Building a practical OTA commission calculator in a spreadsheet

You do not need fancy software to start. You need consistent columns.

Minimum columns per booking row (or per aggregated day per channel)

• Booking ID
• Arrival / stay date segment (depending on how you export)
• Channel (Booking.com, Expedia, direct, etc.)
• Room nights
• Gross room revenue attributable to that row
• Commission rate applied (or commission amount if known)
• Net room revenue (formula)

Aggregations that matter

For each channel for the month:

• Sum gross room revenue
• Sum commission
• Sum room nights
• Gross ADR = gross revenue ÷ nights
• Net ADR after commission = net revenue ÷ nights

A simple template formula (conceptual)

If commission is a stable percent for that row:

Net revenue = Gross revenue × (1 − commission rate)

If commission is provided as a known euro or dollar amount per booking:

Net revenue = Gross revenue − commission amount

Prostay helps because reservations tied to a channel reduce manual tagging errors. If bookings are labeled inconsistently, your calculator becomes garbage in, garbage out.

What to do when commission is not one flat percentage

Real contracts can include:

• Different rates by market
• Genius / loyalty discounts funded in different ways
• Mobile rates vs desktop
• Packages where commission applies to the total or only room portion
• Net vs gross invoicing quirks

If your operation cannot perfectly allocate commission per booking without accountant help, use a practical compromise:

• Use OTA invoices for the month and allocate commission by channel as a total, then compute effective commission rate:

Effective commission rate = Total commission ÷Grossroomrevenue÷Grossroomrevenue for that channel

Then:

Net ADR after commission ≈ Gross ADR × (1 − effective commission rate)

This “effective rate” approach is often the most honest operational number when contracts are messy.

Using net ADR to evaluate “ranking” and visibility spend

Some OTAs offer programs that feel like marketing. Treat them like marketing by converting them into an effective commission impact.

If a program increases your average commission from 17% to 20%, you can model net ADR quickly:

If gross ADR is 150:

• At 17%, net is 150 × 0.83 = 124.5
• At 20%, net is 150 × 0.80 = 120

That 4.5 per night difference adds up fast across hundreds of room nights.

Direct booking: compare net ADR honestly

Direct booking rarely has zero cost. You may pay:

• Booking engine fees
• Payment processing
• Marketing spend (Google, meta search)

Marketing is optional to include in a “net ADR” metric. Some hotels separate:

• Net ADR after payment costs (tight operational comparison)
• Net ADR after payment + marketing cost per acquisition (strategic, harder)

For most hoteliers, start with payment-level truth first. Then, if direct is still competitive, invest in marketing with discipline.

Prostay supports direct booking and distribution workflows so hotels can push direct as a first-class channel instead of an afterthought. The financial case becomes stronger when your PMS and channel strategy are aligned.

A monthly rhythm that makes net ADR impossible to ignore

A practical cadence:

Weekly

• Spot-check channel mix so you are not surprised by OTA dependence spiking silently.

Monthly

• Export revenue by channel
• Compute effective commission rate per OTA from invoices if needed
• Calculate net ADR after commission per channel
• Compare to direct on the same basis

Quarterly

• Review promotions and OTA programs
• Adjust strategy: rate plans, length-of-stay, direct perks that do not destroy rate integrity

• 

Common mistakes when calculating true net ADR after fees

Mistake 1: Using retail rate instead of paid rate

Guest price after discounts is what matters for commission bases in many setups.

Mistake 2: Mixing food packages into “room ADR” without splitting

If breakfast is bundled, your room revenue attribution must match how commission is charged.

Mistake 3: Comparing OTAs using headline commission from memory

Contracts change. Use invoices to compute effective commission.

Mistake 4: Ignoring channel mix changes

Hotel ADR can rise while net profitability falls if OTA share rises.

Mistake 5: Treating net ADR as profit

Net ADR after commission is still before labor and utilities. It is a distribution-quality metric.

Quick answers hotel owners typically search for

What is net ADR?
Net ADR usually means average daily rate after subtracting costs tied to the booking channel, most importantly OTA commission, expressed per room night sold on that channel.

How do I calculate OTA commission impact on ADR?
Start with gross room revenue and room nights for that OTA, compute gross ADR, then subtract commission using your contract rate or effective rate from invoices, then divide net room revenue by room nights.

Is net ADR the same as RevPAR?
No. RevPAR multiplies ADR by occupancy across the hotel. Net ADR here is about per-channel profitability of rate, not total revenue per available room.

Why is an OTA commission calculator useful?
Because it reveals the real economic value of each channel and stops decisions based on inflated gross ADR.

Can Prostay help with this?
Yes, by improving booking source accuracy, reducing overbookings, and supporting direct booking alongside OTA distribution so your data reflects reality.

Final thoughts: the number that should sit next to ADR on every leadership dashboard

Gross ADR is a story. True net ADR after fees, calculated with honest channel rules, is closer to the truth. If you run a hotel in a competitive market, you cannot afford to celebrate rates that disappear before they reach your account.

Build your spreadsheet, validate commission with invoices, separate channels, and compare direct vs OTA on a fair basis. Then invest where the net is healthiest, not where the gross looks prettiest.