Host Metric Studio
Airbnb Profit Spreadsheet: Calculate Real Net Profit (Free)

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
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.
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:
- Profit per booked night
=IFERROR(B14/B5,0)– compares properties of different sizes. - Variable cost per stay = variable costs ÷ number of stays – the real cost of each turnover, which is what makes very short stays expensive.
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
What the example tells you:
- The cleaning fee doesn't fully cover the turnover. The guest pays 60, but after the 15% platform fee you keep 51, while each turnover costs 60 – a loss of 9 per stay. It looks break-even on paper only because commission on the cleaning fee is easy to forget.
- Rent is the biggest line by far, which is why the empty nights hurt so much.
- Only about a quarter of gross revenue ends up as profit – a very different picture from the 2,448 payout.
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:
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.
Break-even nights = 1,370 / 99.43 ≈ 13.8 nights
Break-even occupancy = 13.8 / 28 ≈ 49.2%
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.
- The cost floor is the price below which a stay loses money. For a stay of n nights:
(cost per turnover − cleaning fee × (1 − fee%)) / n / (1 − fee%)plus any per-night variable cost ÷ (1 − fee%). In the example that's only about 10.59 for one night – which shows that the cost floor is rarely the real constraint. - The working floor is the one you actually set. Base it on your own data: the lowest rates that still got booked in that season last year, what comparable listings charge for the same dates, and the fact that a cheap booking made early can block a better, longer stay. Keep deep discounts for gap nights and for your last-minute window (see the booking window mix).
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:
- 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.
- 2Record annual bills monthly, and keep the maintenance reserve every month.
- 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
- 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.