From gross to net: how a hotel converts a rate after agency commission, and the common mistake
Adding commission to a net rate leaves the hotel short. This guide explains the correct division formula, shows worked examples, and lists checks to prevent revenue leakage on agency bookings.
Contents
Key takeaways
- A commission is a percentage of the sell rate; a markup is a percentage of the net rate, so the same number produces two different prices.
- To turn a net rate into a sell rate, divide by one minus the commission; multiplying by one plus the commission undershoots every time.
- The commissionable amount is whatever the contract defines it to be, so the clause is read before the calculator is opened.
- Whether tax sits inside the commission base is a contract and tax question, not an arithmetic one.
- One cell holds the commission percentage and every other cell refers to it; nothing is retyped.
A net rate is what the hotel keeps after the agency's commission is deducted from the sell rate; the gross rate is what the guest or agency pays. To go from a wanted net to a published rate, divide by one minus the commission. Adding the commission percentage to a net rate always leaves the hotel short.
For example: a revenue manager wants a net rate of 100, adds 15 percent for the agency and publishes 115. The statement comes back showing 97.75 received, and nothing was mistyped. The formula pointed the wrong way. This article covers the gross to net hotel rate commission calculation in both directions, shows where tax sits in the sum, and gives the checks to make before a rate is loaded.
What is the difference between a commission and a markup?
A commission is a share of the sell rate that the agency keeps; a markup is an amount added to the net rate the hotel wants. They sit on different bases, so the same percentage produces different money.
The sell rate, also called the gross rate or the commissionable rate, is the price the guest or the agency pays before the agency's share is deducted. The net rate is what reaches the hotel after that share is deducted. It is the number the hotel actually budgets against.
Commission works downward: the hotel receives the sell rate multiplied by one minus the commission rate. Markup works upward, but it is then taxed by the same commission: publish net times one plus the markup, and the agency still takes its percentage from the higher figure.
The markup that exactly recovers a commission of c is c divided by one minus c, which is always larger than c. At 10 percent commission the matching markup is about 11.1 percent; at 20 percent it is 25 percent. The gap widens as the percentage rises, which is why a small commission hides the error for months and a large one exposes it in the first statement.
| Term | Base the percentage applies to | Formula | What it answers |
|---|---|---|---|
| Commission | the sell rate | net = sell × (1 − c) | what the hotel keeps from a published price |
| Markup | the net rate | sell = net × (1 + m) | a price that still loses money |
| Sell rate from a wanted net | the net rate | sell = net ÷ (1 − c) | the price to publish |
| Net from a published sell rate | the sell rate | net = sell × (1 − c) | what to expect on the statement |
How do you convert a sell rate into the net the hotel receives?
Multiply the commissionable amount by one minus the commission rate, and do it on the base the contract names, not on whatever figure is nearest.
Find the commissionable amount first. Many agreements apply commission to the room charge only and treat breakfast, transfers or minibar separately, so the base is smaller than the bill. Apply the percentage per night and then add the nights, or apply it to the stay total; on long stays the two differ by rounding, and the contract may say which one governs.
Keep one currency through the calculation. Convert once, at the rate and date the contract or the accountant specifies, never twice. Deduct the commission from the sell rate as defined, and do not first strip tax out of the price unless the contract says the commission base is tax-exclusive.
Write the result beside the booking at the time of booking, so a later statement check has a figure to compare against rather than a reconstruction. Where the agency also charges cancellation or amendment fees, keep them in a separate line; mixing them into the commission line makes the statement impossible to reconcile. For the booking-site case specifically, see how a booking site's commission is calculated and how a hotel checks the statement.
Why can't you add the commission back to a net rate?
Because the agency takes its percentage from the higher published number, not from the net, so adding the commission leaves the hotel short by the commission charged on the commission itself.
The correct direction divides: sell equals net divided by one minus the commission. The divisor is below one, so the answer is always larger than net times one plus the commission. The wrong direction multiplies: publish net times one plus c, the agency takes c of that, and the hotel keeps net times (1 + c) times (1 − c), which is net times (1 − c squared).
The shortfall is therefore c squared of the net. It looks trivial at small percentages and becomes material across a season of bookings. The same error appears when a hotel takes its public rate, adds the commission and calls the result the agency rate: the public rate was never a net rate to begin with.
When the contract fixes a net the hotel must receive, round the published rate up, never down, so the rounding lands on the hotel's side. Check the direction once per contract, not once per booking: the mistake is systematic, so every booking carries it.
Watch outThe c-squared shortfall
Adding the commission instead of dividing leaves the hotel with net × (1 − c²). The loss is invisible on a single booking and cumulative across a season. The fix is to divide by (1 − c).
Can you show both directions with a worked example?
Yes, with invented round numbers: a hotel that wants 100 net at a 15 percent commission must publish 117.65, not 115. The numbers here are invented for illustration and are not the terms of any booking site or agency.
Direction one, sell to net: a sell rate of 200 at 15 percent commission gives the agency 30 and the hotel 170. Direction two, net to sell: a wanted net of 100 divided by 0.85 gives 117.65, of which the agency takes 17.65 and the hotel keeps 100.
The common mistake: publishing 115, from which the agency takes 17.25, leaving the hotel 97.75, a shortfall of 2.25. That 2.25 is exactly 15 percent of 15, which is the commission charged on the commission. It is the c-squared shortfall in cash.
| Step | Correct direction | Common mistake |
|---|---|---|
| Net the hotel wants | 100.00 | 100.00 |
| Commission rate | 15% | 15% |
| Published sell rate | 117.65 | 115.00 |
| Commission the agency takes | 17.65 | 17.25 |
| What the hotel receives | 100.00 | 97.75 |
| Shortfall | none | 2.25 |
Figures are invented for illustration. If the contract fixes the net, publish 117.70 rather than 117.60, so the rounding does not eat into the guaranteed figure. Run the same two directions on one real booking from last month and compare with the statement; that single comparison tells you which formula the hotel has been using.
Where do VAT and accommodation tax sit in the sum?
Wherever the contract and the tax rules put them, and those are two separate questions: the commission base comes from the agreement, the tax treatment from the hotel's own position.
Do not assume the commission is calculated on the tax-inclusive price. Read the clause that defines the commissionable amount. Do not assume the opposite either: a contract that is silent on tax is a contract that will be argued about at the first statement.
The price a guest sees displayed is a separate duty from the net calculation, and it is governed by consumer-facing rules rather than by the agency agreement; see VAT and accommodation tax on booking sites: getting the displayed price right. Rates change and the treatment of board and package prices differs from room-only prices, so this article states no rate and no split method.
Write the assumption you used in one line on the rate sheet, with the date, so the next person does not reverse it silently. Ask the accountant once, in writing, and keep the answer filed with the contract rather than in an email thread. Confirm your own case with an accountant or tax adviser where the contract and your position leave the question open.
NoteTwo questions, one clause
The commission base is a contract question, the tax treatment is an accounting question, and neither answers the other. No rate is given here because rates and package treatment change.
What should you check before loading a rate into the system?
Recompute the rate by hand from the contract once, then confirm the system arrives at the same number before anything is published.
Confirm the commissionable amount in the contract wording, including what is excluded from it. Confirm whether the field you are filling expects a sell rate or a net rate: field labels are not always explicit, and the two are close enough at low percentages to pass unnoticed. Confirm the currency and the rule for the conversion date, and record both on the rate sheet.
Check the rounding direction and whether the contract fixes a net the hotel must receive or a maximum sell rate the agency may charge. Check the rate is loaded once: a rate entered in both the channel manager and the agency's own extranet can be discounted twice. Compare what the guest will see with what the agency was told, before the first booking arrives rather than after.
ChecklistBefore loading a rate, work through this list
- Commissionable amount confirmed in the contract
- Field type confirmed as sell or net
- Currency and conversion date recorded
- Rounding direction agreed
- Rate loaded in one place only
- Guest-facing price matches the agency figure
- Rate sheet signed and dated
Keep a one-page rate sheet per contract: percentage, base, currency, rounding rule, date and the person who approved it. For the agency side of the same problem, see hotel net rates for travel agents: rules and clear quotes, and if a net rate turns up where it should not, trace a net rate that appears on public sites.
How should the calculation be set up in a spreadsheet?
One cell holds the commission percentage, one cell holds the direction, and every other cell refers to them, so the formula cannot be quietly reversed.
Name the percentage cell and protect it. A percentage retyped in twenty rows will eventually be retyped wrong in one of them. Label the columns sell rate and net rate in full: a column headed rate invites someone to paste a net figure into a sell column.
Build both directions as separate columns rather than editing a formula in place, so the sheet shows the working in both directions at once. Add a check column: net divided by sell should equal one minus the commission. Any row that fails the check is a row to look at.
Round only at the point of publication, not in intermediate cells, or the rounding compounds across nights. Version the sheet with the contract date in the file name, so a rate calculated under last year's terms is not reused this year.
TipOne cell, one direction
Put the percentage cell at the top, a sell-to-net column beside a net-to-sell column, and a check column that flags any row where net divided by sell does not equal one minus the commission. Nothing else is retyped.
What to do next
Take one agency contract, recompute three bookings from last month by hand in both directions, and compare the results with the statements. The two directions are the whole idea: commission is taken from the sell rate, so a wanted net is reached by dividing, not by adding. Fix the percentage cell in the spreadsheet once, and the error stops repeating across the season.
Frequently asked questions
Is commission calculated on the gross or the net rate?
Normally on the sell rate the agency books at, which is why it is called the commissionable rate. But the contract defines the commissionable amount and may exclude breakfast, extras or taxes, so the clause decides, not the habit.
What markup equals a 15 percent commission?
About 17.65 percent, because the matching markup is the commission divided by one minus the commission, here 15 divided by 85. The figure is arithmetic, not a market rate or a recommendation.
Should commission be calculated before or after VAT?
It depends on what the contract defines as the commissionable amount and on how the hotel's tax position treats the charge. This article gives no rate and no split method; the assumption used should be written on the rate sheet and confirmed with the accountant.
Why is the hotel's receipt lower than the net rate it calculated?
Usually one of three causes: the commission was added instead of divided, the commission base was wider than assumed, or a second deduction such as an extra, a cancellation fee or a currency conversion landed on the same booking. Compare the statement line by line against the rate sheet.
Does the agency take commission on breakfast, transfers or minibar?
Only if the contract's definition of the commissionable amount includes them. List what is in and what is out on the rate sheet, because the difference between room-only and half-board commission bases is larger than most rounding errors.