Why it matters

What an Airbnb fee calculator actually does

An Airbnb fee calculator turns the gross nightly rate that a guest sees into the actual amount a host nets per stay after platform fees, occupancy and lodging taxes, and operating costs are subtracted. The tool is the difference between a host who knows their unit economics and a host who is pricing on instinct. For most hosts the gap between gross rate and host net is 15% to 40% per stay.

The first job is figuring out which fee structure your account uses. Airbnb publishes two structures: the simplified host-only fee (the host pays 14-16%, the guest sees no Airbnb service fee on the rate) and the split-fee structure (the host pays roughly 3%, the guest pays roughly 14%). Most US hosts are on simplified; check your booking confirmation to confirm which you are on before building.

The method

How to build the Airbnb fee calculator

i.

Pull a real recent booking as the test case.

Open the host dashboard, find a finalised booking from the past month, and copy the line items: nightly rate, number of nights, cleaning fee charged to the guest, Airbnb service fee deducted from the host payout, occupancy and lodging taxes withheld, and the final payout amount. The calculator has to reproduce this payout exactly.

ii.

Set up the input cells.

Inputs: nightly rate, nights, guest-paid cleaning fee, your host fee rate (14, 15, or 16% depending on your account), local occupancy tax rate, your cleaner labor cost per stay, supplies amortised per stay, damage reserve per stay. Highlight inputs yellow; lock everything else.

iii.

Build the fee chain in the right order.

Gross stay = (nightly rate × nights) + cleaning fee. Host service fee = Gross stay × your fee rate. Occupancy tax = (nightly rate × nights) × tax rate, in jurisdictions where Airbnb withholds. Airbnb payout = Gross stay − host service fee − occupancy tax. Host net per stay = Airbnb payout − cleaner labor − supplies − damage reserve.

iv.

Verify against the test booking.

The Airbnb payout the spreadsheet produces should match the actual payout to the dollar. If it does not, the gap is either a fee-structure assumption (simplified vs split) or a tax-withholding rule for your jurisdiction. Airbnb publishes the list of jurisdictions where they withhold tax; check whether your area is on it.

v.

Add the operating-cost deductions.

Cleaner labor (the actual amount you pay your cleaner, which may be different from what you charge the guest). Supplies amortised per stay (linens, toiletries, coffee). Damage reserve (a per-stay buffer that absorbs the inevitable broken-glass or stained-towel stays). Insurance share if the unit is dedicated. These four are the costs Airbnb does not deduct.

vi.

Use it for pricing decisions.

Once the calculator works, change the input rate and see how the net moves. Try raising the cleaning fee while lowering the nightly rate. Try a longer stay at a lower nightly. The calculator turns “what should I price at” into “what does my actual net look like at this price”. That is the whole point.

Common mistakes

What hosts get wrong

The biggest mistake is treating the guest-facing cleaning fee as host income. It is revenue, but the matching expense (what you pay the cleaner) almost always offsets most of it. If you charge the guest $150 and pay the cleaner $130, the cleaning margin is $20, not $150. Hosts who do not split this line into revenue and cost overstate their net by the cleaner-pay amount.

The second mistake is forgetting the damage reserve. Every host gets occasional broken-glass, stained-towel, missing-remote stays. Reserving $20-50 per stay against this category turns a hidden tail cost into a visible operating cost. Calculators that miss the reserve understate the actual cost of a stay by 5-10% across a year.

The third mistake is applying tax incorrectly. In jurisdictions where Airbnb withholds, the tax never hits your bank account; the spreadsheet should subtract it before the payout line. In jurisdictions where Airbnb does not withhold, the tax does hit your account but you owe it back to the local authority separately; the spreadsheet should subtract it after the payout to show your actual usable net.

The gap between gross nightly rate and host net is 15% to 40% per stay.From the why-it-matters section

Example math

A worked example

Consider a 4-night stay at $200/night with a $150 cleaning fee, simplified host-only fee at 15%, 6% occupancy tax that Airbnb withholds, $130 paid to the cleaner, $10 supplies, $20 damage reserve.

Gross stay value
$200 × 4 + $150 = $950
Host service fee (15%)
$143
Occupancy tax (6% on stay only)
$48
Airbnb payout
$759
Less cleaner labor
$130
Less supplies
$10
Less damage reserve
$20
Host net per stay
$599
Effective per-night net
$150 (vs $200 advertised, a 25% gap)

The host advertised at $200/night and nets $150/night. That gap is the calculator’s job to surface. For the fuller bookkeeping side of the workflow, our companion airbnb spreadsheet roundup covers the multi-tab template that includes a fee calculator alongside the bookings tracker and tax-ready expense categories.

FAQ

Common questions, answered briefly

What is the Airbnb host service fee?
For most US hosts on the simplified fee structure, Airbnb deducts 14-16% of the gross stay value as the host service fee. Some accounts use split-fee where the host pays roughly 3% and the guest pays roughly 14% on top of the rate.
Does Airbnb take 15 percent?
Roughly, on the simplified host-only fee structure. The exact rate is 14-16% depending on the account; 15% is a common middle value. Check a recent payout breakdown for your exact rate.
What fees does Airbnb charge guests?
On simplified host-only fee accounts, guests see no separate Airbnb fee on the listing rate. On split-fee accounts, guests pay roughly 14% on top of the listing rate as the guest service fee.
Does Airbnb collect tax automatically?
It depends on the jurisdiction. Airbnb publishes a list of jurisdictions where they automatically withhold and remit occupancy taxes. In jurisdictions not on that list, the host is responsible for filing and paying separately.
What is the actual host take-home percent?
For a typical host on simplified fees with 6% occupancy tax withheld and $130-cleaner / $20-reserve operating costs, the host nets roughly 60-75% of gross stay value. The exact figure depends on jurisdiction and operating costs.

If yours isnt above, drop the question in the comments and well answer it under the next airbnb how-to piece.

People also ask

Other questions, briefly answered

How does the breakdown calculator differ from the fee calculator? Whats in the airbnb host fee calculator? Which airbnb spreadsheet includes a fee calculator tab? Whats in a proper airbnb expenses spreadsheet?
Reference Airbnb host service fee structure, official help center airbnb.com Reference Where Airbnb collects and remits occupancy taxes airbnb.com Reference Airbnb cleaning fees and how they appear to guests airbnb.com