Short Term Rental Profit Tracker

A short term rental spreadsheet that tracks every booking and expense and shows net profit per property, plus occupancy and average nightly rate (ADR) across all your listings.

$19.00 USD · instant digital download

Buy now: $19.00

Prefer Etsy? Find us on Etsy.

Features

• Bookings: nights calculate from dates; nightly rate, cleaning fee, other income
• Platform fee per booking (defaults to 15.5%, a typical host-only service fee as of Oct 2026; under split-fee pricing, hosts typically pay about 3%; editable in Settings or per booking)
• Expenses by property and category
• Dashboard per property and for ALL properties: bookings, nights, occupancy, avg nightly rate (ADR), gross, fees, expenses, net profit
• Stays that cross months or years are split by night
• Monthly payouts, expenses and net
• Check-out before check-in, unknown properties and bad dates are flagged; unknown properties are totaled separately so totals reconcile

What you get

• 1 Excel (.xlsx) file, plus a PDF with a Google Sheets 'Make a copy' link and setup steps
• Works in Microsoft Excel (desktop, 2016 or later) and free Google Sheets (desktop recommended for setup)
• Instant digital download. No physical item will be shipped.

One license covers one person or one business. See Terms & License. Digital download, so returns aren't accepted, but we'll fix or replace any file that doesn't work (details).

Save this template to Pinterest

This is an organizing tool, not tax, legal, accounting or financial advice, and it doesn't calculate tax owed. Results depend on the numbers you enter. Talk to a qualified professional about your own situation.