Host Metric Studio

Airbnb Profit Spreadsheet: Calculate Real Net Profit (Free)

Published 2026-10-27

Airbnb Profit Spreadsheet – Host Metric Studio

Your real Airbnb net profit is net payouts (after platform fees and excluding taxes you pass on) minus every cost of running the property – variable and fixed – for the same month. A payout is not profit. This guide shows the waterfall from guest payment to profit, the formulas for Excel and Google Sheets, a worked example and the number that tells you how much room you have: break-even occupancy.

With experience at a short-term rental management company with more than 1,000 homes, I saw it again and again: the properties that looked busiest were not always the most profitable. Once every cost was in, a fully booked unit with a low rate could earn less than a quieter one with a better price.

The structure: revenue down to net profit

Structure
  Accommodation revenue        (your nightly prices, no taxes)
+ Cleaning fees charged to guests
= Gross revenue
- Platform / channel fees      (usually charged on accommodation AND cleaning fee)
= Net payout
- Variable costs               (grow with each stay)
- Fixed costs                  (paid whether you're booked or not)
= Net operating profit

Taxes sit outside this waterfall. VAT, tourist or occupancy taxes collected from guests belong to the tax authority: if the platform collects and remits them, leave them out entirely; if they pass through your payout, record them separately and don't count them as revenue. If you're VAT-registered, enter revenue net of VAT. Whether VAT charged on platform fees is recoverable depends on your situation – ask your accountant.

Everything above "net payout" comes from your reservations export. Everything below comes from your Expenses tab.

Set up the Expenses tab

Columns: A Date | B Property | C Category | D Amount | E Type (Variable/Fixed) | F Notes

Variable (grow with each stay): cleaning, laundry, guest supplies (toiletries, coffee, toilet paper), payment or channel fees not already deducted from the payout, per-stay or percentage management fee.

Fixed (paid whether you're booked or not): rent or mortgage, utilities, insurance, community or HOA fees, software subscriptions (channel manager, pricing tool, smart lock), licences and local taxes, a monthly maintenance reserve.

💡 Pro tip

The maintenance reserve matters. A washing machine or a sofa doesn't fail every month, but when it does, a month without a reserve looks like a disaster and every other month looks better than it really is. Spread annual bills the same way: an annual insurance premium of 360 becomes 30 a month.

The free formulas

This uses the Bookings and Dashboard layout from the short-term rental spreadsheet template: Bookings columns E Accommodation revenue, F Cleaning fee, G Platform fees, H Net payout, J Status, and helper columns L Nights in month, O Gross revenue in month, P Net payout in month (each stay spread over its nights, so stays crossing month-end are split correctly). On the Dashboard, B1 is the first day of the month, B2 the property, B4 available nights and B5 booked nights.

Cell Line Formula
B10 Gross revenue =SUMIF(Bookings!A:A,B2,Bookings!O:O)
B11 Net payouts =SUMIF(Bookings!A:A,B2,Bookings!P:P)
B12 Kept from cancellations =SUMIFS(Bookings!H:H,Bookings!A:A,B2,Bookings!J:J,"Cancelled",Bookings!B:B,">="&B1,Bookings!B:B,"<="&EOMONTH(B1,0))
B17 Variable costs =SUMIFS(Expenses!D:D,Expenses!B:B,B2,Expenses!E:E,"Variable",Expenses!A:A,">="&B1,Expenses!A:A,"<="&EOMONTH(B1,0))
B18 Fixed costs same formula with "Fixed"
B14 Net profit =B11+B12-B17-B18
B15 Margin =IFERROR(B14/(B10+B12),0)

Platform fees for the month are simply =B10-B11.

Two more ratios worth a column:

Worked example (invented numbers)

🧮 Example only – all figures are invented for illustration, not market data.

Loft 1, June 2026. 30 days, 2 nights blocked for maintenance → 28 available nights. 6 stays, 21 booked nights, platform fee 15% of accommodation + cleaning. For simplicity this example uses a round 15% fee; most hosts now pay Airbnb's 15.5% host-only fee, so use the rate on your own payouts.

Line Amount
Accommodation revenue 2,520
Cleaning fees charged (6 × 60) 360
Gross revenue 2,880
Platform fees (15%) –432
Net payout 2,448
Cleaning (6 × 45) –270
Laundry & supplies (6 × 15) –90
Utilities –180
Rent –1,100
Software –30
Maintenance reserve –60
Net profit 718
  • Margin = 718 / 2,880 = 24.9%
  • Profit per booked night = 718 / 21 = 34.19
  • Variable cost per stay = (270 + 90) / 6 = 60
718
net profit in June
24.9%
margin on gross revenue
34.19
profit per booked night

What the example tells you:

Break-even occupancy

The most useful single number for a host might be this one: how full do I need to be to cover all my costs?

First work out what each booked night contributes after fees and variable costs, then divide fixed costs by it:

Formula
Contribution per booked night = (Net payouts - Variable costs) / Booked nights
Break-even nights            = Fixed costs / Contribution per booked night
Break-even occupancy         = Break-even nights / Available nights

Using the example: contribution = (2,448 − 360) / 21 = 99.43 per booked night. Fixed costs = 1,100 + 180 + 30 + 60 = 1,370.

Using the example
Break-even nights    = 1,370 / 99.43 ≈ 13.8 nights
Break-even occupancy = 13.8 / 28 ≈ 49.2%
99.43
contribution per booked night
≈ 13.8
break-even nights
≈ 49.2%
break-even occupancy

Check: 21 nights × 99.43 − 1,370 = 718, the net profit above. Each booked night beyond about 14 adds roughly 99 of profit at the current price and length of stay.

In the sheet:

Cell Formula
B19 Contribution per booked night =IFERROR((B11-B17)/B5,0)
B20 Break-even occupancy =IFERROR(B18/(B4*B19),"n/a")
B21 Break-even nights =IFERROR(B18/B19,"n/a")

Because the contribution includes cleaning and other per-stay costs, it assumes your average length of stay stays similar. If you start accepting many more one- or two-night stays, recalculate.

Before you cut prices: how many extra nights do you need?

Discounting to "fill the calendar" is where many hosts lose margin. In the example, a 10% cut in ADR (120 → 108) lowers contribution per night by 12 × 0.85 = 10.20, to about 89.23. On the same 21 nights that costs about 214. To earn the same total contribution you'd need 2,088 / 89.23 ≈ 23.4 booked nights – about 2.4 extra nights just to stand still. If the discount wouldn't plausibly bring that many extra nights, don't make it across the board; target the specific dates that are behind pace instead.

Setting a price floor

Every rate calendar needs a minimum price per season, so automatic discounts and last-minute cuts can't go below it.

Annual view: the profit and loss table

Once the monthly summary works, build a 12-column table (Jan–Dec) with the same rows: gross revenue, platform fees, net payout, variable costs, fixed costs, net profit, margin, and break-even occupancy. Add a total column. Three habits make it reliable:

  1. 1Assign income consistently – this site spreads each stay over its nights; if your accountant uses check-in or payout date for tax, keep a separate tax view. Never mix methods within one table.
  2. 2Record annual bills monthly, and keep the maintenance reserve every month.
  3. 3Flag personal use – nights you use the property yourself come out of available nights, and their share of costs may be treated differently for tax. Ask your accountant how this works where you live.

Mistakes that inflate profit

⚠️ Common mistakes
  • Using payouts as profit.
  • Counting taxes collected from guests as income.
  • Forgetting fixed costs in months with few bookings.
  • Ignoring the maintenance reserve and annual bills.
  • Assuming the cleaning fee covers cleaning – check it after commission.
  • Leaving out software and small subscriptions – they add up.

Is your occupancy actually good, given this break-even? See what a good occupancy rate is for Airbnb.

FAQ

Is the Airbnb payout my profit?

No. The payout is after platform fees, but before cleaning, supplies, utilities, rent or mortgage, maintenance and everything else.

Should I include cleaning fees in revenue?

Yes, include them in gross revenue and record the cleaning cost as an expense – then check whether the fee covers the cost after commission.

Are tourist taxes or VAT part of my revenue?

No. They're collected on behalf of the tax authority. Keep them out of revenue and profit.

What's a good profit margin for a short-term rental?

It depends heavily on whether you own or rent the property, financing, and local costs. More useful than a generic benchmark: your margin vs the same month last year, and how far your occupancy sits above break-even.


If you want a version that's already built: the STR Income & Expense Tracker (Excel + Google Sheets) includes a 12-month P&L per property, net profit and margin, and a monthly owner statement, for up to 10 rentals – $19 at https://emprendemos.gumroad.com/l/str-income-expense-tracker. The formulas above will get you most of the way on your own.

Not affiliated with or endorsed by Airbnb, Vrbo or Booking.com. Platform names are used only to describe their data exports. Example figures are invented. This article is not tax or financial advice.

Short on time? I can set it up for you.

If you'd rather not build this yourself, I set up the income and KPI tracker for your properties, using your own bookings and costs, so you can start reading your numbers right away. See the service on Upwork.