Excel workbook
Short-Term Rental Host Profit Tracker: Excel Workbook for Airbnb-Style Hosts
Log each stay once and see occupancy, net per night and profit by month, with your platform fee, cleaning and fixed costs built in.
$24 one time · example and blank copies · download link by email
Who it is for
Hosts of a short-term rental who want to know whether the property makes money after fees, cleaning and the fixed costs of owning it.
Why it is different
- Fixed costs keep counting in months with no bookings, so a slow month shows up as a loss.
- A filled example and a blank copy, with working formulas, not pasted numbers.
- One workbook per property keeps each one honest.
What is inside
- Setup. Your platform fee, cleaning fee and cost, and fixed monthly costs.
- Bookings. One row per stay: dates, guest payout and the net after fees and cleaning.
- Other expenses. Repairs, supplies, furnishings, software and anything else.
- Monthly summary. Stays, nights, occupancy, profit and average net per night.
A look inside
Example data, real formulas
Get it
Short-Term Rental Host Profit 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. Tracks your numbers only. It is not tax, legal or accounting advice, and it does not know your local rules or taxes. Ask a qualified professional how they apply to you. Not affiliated with any rental platform. 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.
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).
Also from MCC Solutions
Month-End Close Workbook
A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock.
$19
Sales-Channel Profit Tracker
Which channel makes you money, and which one only looks busy? Sales minus cost of goods, shipping, platform and card fees and event costs, by channel, by event and by month.
$24