Excel workbook
Multi-Property Short-Term Rental Host Tracker: Profit, Occupancy, Turnovers and Pricing for Up to Five Properties
Know which property earns money, which months are slow and what rate you need.
$29 one time · example and blank copies · download link by email
Who it is for
Hosts with one to five short-term rental properties on any platform, including direct bookings.
Why it is different
- Profit is shown per property and per month, not just as one total.
- Overlapping bookings and one-night gaps are flagged automatically.
- A filled example with three invented properties and a blank copy with all formulas working.
What is inside
- Start Here. How to use it and a year-at-a-glance summary.
- Properties. Up to five properties with monthly fixed costs, base rate, cleaning fee and platform fee percentage.
- Bookings. Up to 300 bookings with dates, nightly rate, fees and payout; cancelled stays are left out of revenue and nights.
- Expenses. Cleaning, supplies, repairs, utilities and other costs by property.
- Monthly Summary. Nights, occupancy, average daily rate, revenue, expenses and profit by month, with charts.
- Property Compare. Year totals per property, profit per available night and break-even occupancy.
- Turnover Schedule. Upcoming check-outs with the gap before the next stay and same-day turnovers flagged.
- Pricing Check. The nightly rate needed for a profit target at different occupancy levels.
- Checks. Flags overlapping bookings, check-out before check-in and missing information.
A look inside
Example data, real formulas
Get it
Multi-Property Short-Term Rental Host Tracker
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. Worked out from the figures you enter. Occupancy tax and licensing rules differ by city and state, so check your local rules. Not tax, legal or accounting advice. The pricing check is an estimate, not a forecast. Tested by recalculation and by checking sample figures; not opened in every version of Excel. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Free starter
Try a free one-tab version first
A small working Excel file with the same kind of math, filled with made-up example numbers you can type over. We send one confirmation email, and no series follows.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others