How to Track Short-Term Rental Income and Expenses (and See Profit per Listing)

By Linen & Balance · 18 Nov 2026 · 7 min read

To track short-term rental income and expenses, record every stay as one row, every cost as one row, and read the results one listing and one month at a time. That is the whole method. The hard part is not the tool. It is choosing what to record, keeping it consistent and looking at profit, not just payouts. This guide shows what to capture, which five numbers matter, and a worked example in which the busier listing earns less. The same steps work in a notes app, a spreadsheet or a template.

Why payouts are not the same as profit

Most hosts watch the payout that arrives in the bank. It is a fair signal, but it hides three things.

  1. Costs that never touch the payout. Cleaning, supplies, utilities, repairs and insurance are paid from other accounts, so they do not appear next to the booking that caused them.
  2. Fees taken before you are paid. The payout is already net of the platform fee, which makes a weak month look better than it is if you compare it with your gross revenue.
  3. Differences between listings. With two or more listings, a combined total hides the weak one. A busy property can lose money in a month while a quiet one makes the profit.

Tracking by listing is what makes the difference visible.

What to record for every stay

Put each stay on one row. Use the same columns every time. A short list that covers most hosts:

  • Listing name. Short and unique, so you can filter by it.
  • Booking channel. The site or route the guest came from, or "direct".
  • Check-in and check-out dates. The number of nights is the difference.
  • Status. Confirmed, completed, cancelled with a payout, cancelled without one, or blocked.
  • Accommodation revenue. The nights total before fees and taxes.
  • Cleaning fee charged. Keep it separate from accommodation revenue.
  • Platform fee. The host-side fee taken from your payout.
  • Payout received and date. Compare it with what you expected. A difference is worth a look.
  • Cleaning cost for the turnover. What you pay for the clean after this stay.

If your area requires you to collect lodging or occupancy taxes from guests, record them in their own column and keep them out of income. They belong to the authority, not to you. Local rules vary, so check yours.

What to record for every cost

One row per cost. A date, the listing it belongs to (or "shared"), a category, a short description, the vendor, the amount and a receipt reference. For categories, a short list is enough to start:

  • Cleaning (extra or deep cleans, not the turnover cleaning already recorded with stays)
  • Laundry and linen service
  • Supplies and guest amenities
  • Repairs and maintenance
  • Utilities (power, gas, water)
  • Internet and streaming
  • Insurance
  • Platform and payment fees not already deducted
  • Software and subscriptions
  • Furniture and equipment
  • Advertising and photography
  • Accounting and legal
  • Licenses and permits
  • Other

Do not record turnover cleaning twice. If you track the cost of each turnover alongside the stay, do not also enter the same invoice as a general expense. Pick one place for it.

Shared costs. Some costs serve more than one listing, such as a software subscription or an accountant. Either split them by a fixed percentage or evenly, and write down the rule you chose so it is the same every month.

The five numbers worth knowing

Once the rows exist, five numbers tell you most of what you need.

Number How to calculate it What it tells you
Occupancy Nights booked divided by nights available How full the listing was
Average nightly rate (ADR) Accommodation revenue divided by nights booked What guests paid per night
Revenue per available night (RevPAN) Accommodation revenue divided by nights available Revenue, counting the empty nights too
Net profit Net payout minus all costs What the listing left after costs
Net profit per booked night Net profit divided by nights booked Profit on the same footing for any size of listing

Net payout here is accommodation revenue plus the cleaning fees charged, minus platform fees. Net profit is before income tax, loan payments and depreciation. It is a record-keeping view of operations, not a tax calculation.

A worked example: the busy listing that earns less

These are two made-up listings, not benchmarks. Both have 31 nights available in the month.

Cottage Cabin
Nights booked 14 24
Occupancy 45% 77%
Accommodation revenue $1,540 $2,040
Average nightly rate $110 $85
Cleaning fees charged $330 $360
Platform fees $60 $75
Net payout $1,810 $2,325
Turnover cleaning $420 $640
Supplies $65 $110
Utilities $180 $320
Internet $50 $50
Insurance $60 $95
Repairs none $400
Software $15 none
Total costs $790 $1,615
Net profit $1,020 $710
Revenue per available night $49.68 $65.81
Net profit per booked night $72.86 $29.58

Look at the cabin. Its occupancy is 77%, against the cottage's 45%. Its revenue per available night is higher. If you only looked at bookings or at revenue, the cabin would be the star. But after cleaning, utilities and a $400 repair, it kept $710, and the cottage kept $1,020. Per booked night, the cottage earns more than twice as much.

None of this means the cabin is a bad listing. One month and one repair prove nothing. It means you now have a question to ask: are the cabin's costs a one-off, or are they normal? Without a profit figure per listing, you would not have noticed.

Also look at the cottage's cleaning line. Guests paid $330 in cleaning fees, while the cleaning cost $420. The $15 gap per turnover (a $70 clean against a $55 fee) adds up to $90 in a month. You may decide to leave it, to raise the fee at your next price review, or to talk with your cleaner. The point is that you now know.

A routine that takes 15 minutes a week

A tracker only works if it is current. Make it a small habit instead of a monthly chore.

  1. Weekly, 10 minutes. Enter new bookings and any payouts that arrived. Add the cost invoices you paid.
  2. Monthly, 20 minutes. Compare each payout with the expected amount and mark any difference. Check that every listing has its costs. Read the five numbers for each listing.
  3. Yearly, one evening. Export the year, sort costs into categories and hand the summary to your tax professional.

If you fall behind, catch up in one session from your payout reports. Booking sites let you download earnings and payout reports, so you rarely need to retype each stay. For example, Airbnb, Vrbo and Booking.com typically offer an export or report in their host tools. Check which fields they include and fill in the gaps.

Setting up a spreadsheet that holds up

If you build your own, a few choices save pain later.

  • One row per stay and one row per cost. Do not merge cells inside the data area.
  • Dropdowns for listing, channel, status and category. Typos break totals.
  • Dates as real dates. Not text such as "3rd Jan". They sort and filter properly.
  • Fixed, generous ranges. Formulas that cover 2,000 rows will not break when you sort or add a row.
  • Inputs and results on separate tabs. Type in one place and read from another.
  • A backup. Save a copy each month with the month in the file name.

If it feels like a lot of work, that is fair. The Host Profit & Operations Tracker is built exactly this way, with sample data, so you can see how it behaves before you enter your own numbers.

Mistakes to avoid

  • Treating revenue as profit. Always subtract the cleaning, fees and bills.
  • Leaving out the cleaner's pay. If someone is paid for the turnover, that is a cost of the stay.
  • Counting the same cost twice. See the cleaning note above.
  • Mixing personal and rental spending. One account or one clear tag makes year-end much easier.
  • Waiting until tax time. Receipts get lost. Weekly entries take minutes, and a rushed year-end takes days.
  • Comparing months without comparing nights. Use profit per booked night to compare a quiet month with a busy one.

Records at year-end

Keep the records your tax authority asks you to keep: income, costs, receipts, and the payout reports. What counts as a deductible cost, how to treat equipment and how mixed personal use is handled differ by country, so ask a tax professional where you live. A tracker is a record-keeping tool, and it does not give tax or accounting advice.

Try it with one month first

You do not need to set up a full year to learn something. Take last month and one listing, and work out the five numbers. Our free Host Starter Sheet does exactly that: enter your nights, stays and costs, and it shows your net payout, net profit, profit per booked night, break-even nightly rate and whether your cleaning fee covers your cleaning. It takes about ten minutes, and you will know more about last month than you did yesterday.

Not affiliated with, endorsed by or sponsored by Airbnb, Inc., Vrbo or Booking.com.

These spreadsheets help you record your own rental data. They are not tax, accounting, legal or financial advice. Check tax rules and any filing with a qualified professional in your country. Full disclaimer

More from the blog