How to Track Airbnb Profit per Listing (Not Just Payouts)
Your Airbnb or Vrbo payout report tells you what landed in your bank account. It doesn't tell you whether a listing made money. Between platform fees, cleaning, supplies, utilities, repairs and financing, a listing with healthy payouts can still be barely breaking even, and with more than one property, a strong listing can quietly hide a weak one. Here's a simple, spreadsheet-friendly way to track real profit for each listing, month by month.
Payouts are not profit
A payout is revenue after the platform has taken its fee. Profit is what's left after everything the listing costs to run. The gap between the two is where most hosts lose track.
Platform fees alone vary more than many hosts realize. Airbnb's help article on service fees describes two structures: a split fee, where most hosts pay 3% and guests pay a separate service fee, and a single fee deducted entirely from the host payout, which most hosts pay at 15.5%. Airbnb says it's moving all home hosts to the single-fee structure. If you're working from an old mental model of "Airbnb takes 3%," your numbers may be off. Always use the actual fee shown on each payout.
The three numbers to track for every listing
You only need three numbers per listing per month:
- Revenue: what guests paid for the stay (nightly rate plus any fees you charge, such as cleaning or extra guests), excluding taxes the platform collects and remits for you.
- Platform fees: what the platform kept.
- Operating expenses: everything you spent to run that listing.
Profit for the month is revenue minus platform fees minus operating expenses. That's it. The hard part isn't the math. It's capturing every expense and assigning it to the right listing.
Step 1: Log every booking, once
Create a bookings log with one row per reservation. Useful columns:
- Listing (property name)
- Channel (Airbnb, Vrbo, Booking.com, direct)
- Check-in and check-out dates
- Nights
- Accommodation revenue
- Cleaning fee charged
- Other fees (extra guests, pets)
- Platform fee
- Net payout
You can copy these numbers from each platform's earnings or transaction history, or from a CSV export if your platform offers one. Do it weekly. Monthly is fine too, but weekly is less painful.
Watch out for stays that cross months. A stay from the 29th to the 3rd belongs partly to each month. If you book all the revenue in the check-in month, your monthly numbers will swing in ways that don't reflect reality. The cleanest approach is to split revenue by nights: two of the five nights in the first month, three in the next.
Step 2: Log every expense with a category and a listing
Every expense row needs four things: date, amount, category and listing. Categories make the numbers readable. Listings make them comparable.
Use categories that line up with your tax forms from the start, and year-end becomes much easier. In the US, rental income and expenses are commonly reported on Schedule E (see also IRS Publication 527 on residential rental property). In Canada, the CRA's Form T776 is the statement of real estate rentals. Short-term rentals can have special treatment in both countries, so confirm with a tax professional, but organizing by these categories won't hurt.
A practical starting set of categories:
- Cleaning and laundry
- Supplies and consumables
- Repairs and maintenance
- Utilities (power, water, gas, internet)
- Insurance
- Property tax
- Mortgage interest or rent
- HOA or condo fees
- Software and subscriptions
- Licences and permits
- Professional fees (accounting, legal)
- Furniture and equipment (keep these separate, since larger purchases are often depreciated rather than expensed)
Step 3: Handle shared costs fairly
Some costs don't belong to one listing: your pricing tool subscription, accounting fees, a vehicle you use for supply runs. You have two reasonable options:
- Split evenly across listings each month. Simple and good enough for most hosts.
- Split by usage, for example by booked nights or by revenue. Fairer if your listings are very different sizes.
Pick one approach and stick with it. Consistency matters more than precision, because you're mainly comparing listings with each other and with past months.
Step 4: Build a monthly P&L per listing
With bookings and expenses logged, build a simple profit-and-loss table: one column per month, with rows for revenue, platform fees, each expense category, total expenses and net profit. Add a dropdown or filter to view one listing or all of them together.
Here's a made-up example to show the shape:
| Listing A | Listing B | |
|---|---|---|
| Revenue | $4,000 | $3,000 |
| Platform fees | −$620 | −$465 |
| Cleaning & laundry | −$700 | −$650 |
| Other operating costs | −$1,900 | −$1,100 |
| Net profit | $780 | $785 |
In this illustration, Listing A brings in a third more revenue but earns about the same profit. You only see that when you track per listing. Pooled together, it just looks like "the rentals made $1,565."
Step 5: Add three metrics that explain the profit
Profit tells you what happened. Three standard hospitality metrics help explain why:
- Occupancy = booked nights ÷ available nights. Exclude nights you blocked for personal use from "available," or your occupancy will look worse than it is.
- ADR (average daily rate) = accommodation revenue ÷ booked nights. This is what you actually earned per night, after discounts.
- RevPAR (revenue per available night) = accommodation revenue ÷ available nights, or ADR × occupancy. This combines price and occupancy into one number, which is useful when you're testing a price change.
If profit drops, these show whether it was fewer bookings (occupancy), lower prices (ADR) or higher costs (the expense side of your P&L).
What about the cleaning fee?
If you charge guests a cleaning fee, record it as revenue in the bookings log and record what you pay your cleaner as an expense. Don't net them against each other. Keeping both visible tells you whether your cleaning fee actually covers your cleaning costs, which often changes as cleaners raise their rates or stays get shorter. It also keeps your revenue figure consistent with what the platform reports, which makes it easier to reconcile your records with payout statements and tax documents at year-end.
Step 6: Review monthly in fifteen minutes
Put a recurring 15-minute slot on the first of each month and answer a few questions:
- Which listing made the most profit, and which made the least?
- Is any listing losing money? Is that seasonal or structural?
- Did any expense category jump compared with last month or the same month last year?
- Did ADR or occupancy move, and do you know why?
- Are receipts saved and categorized?
The point isn't a perfect accounting system. It's catching problems while they're small, like a cleaning cost that crept up, a utility bill that doubled, or a listing that needs a price change.
Common mistakes
- Counting payouts as revenue. Then platform fees disappear from your records, and you can't see what they cost you.
- Forgetting small recurring costs. Software, streaming services and replacement linens add up over a year.
- Mixing personal and rental spending on one card without tagging it. Use a separate card or account for the rental if you can.
- Only looking at the total. Per-listing numbers are where decisions get made.
Start with a template
You can build all of this yourself in a spreadsheet. If you'd rather not, start with our free Turnover Checklist + Pricing Sanity Check PDF (sign up on our homepage), which includes a ten-question monthly profit check you can use right away.
Prefer it done for you? The Rental Host Ops & Profit Kit is a ready-made workbook for Excel and Google Sheets. Log bookings and expenses once, and it builds a monthly P&L per property, an occupancy/ADR/RevPAR dashboard that splits long stays across months, and year-end Schedule E and T776 summaries for you or your preparer. US$34, one-time, 14-day refund.
General information, not tax, legal or financial advice. Any figures in examples are made up to illustrate the math. Nightly Profit is not affiliated with Airbnb, Vrbo or Booking.com.