--- title: "Multi-Property Short-Term Rental Host Tracker (Excel) | MCC" description: "Excel workbook for short-term rental hosts with up to five properties: log bookings and expenses, then see occupancy, average nightly rate, profit by property…" url: "https://mcc-solutionsnj.com/toolkits/short-term-rental-host-tracker" --- 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 · 14-day full refund · example and blank copies · download link by email Buy now, $29 Try the free starter 🌙 The desk is asleep. The store never is. Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning. [Browse the store](/toolkits) Who it is for Hosts with one to five short-term rental properties on any platform, including direct bookings. Not the right fit if You run more than five properties, or you need answers on local occupancy tax and licensing rules. 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 [![Property Compare tab of the Multi-Property Short-Term Rental Host Tracker, with example data](/img/toolkits/short-term-rental-host-tracker/a.png)](/img/toolkits/short-term-rental-host-tracker/a.png) Property Compare tab with example data. Made-up numbers. [![Monthly Summary tab of the Multi-Property Short-Term Rental Host Tracker, with example data](/img/toolkits/short-term-rental-host-tracker/b.png)](/img/toolkits/short-term-rental-host-tracker/b.png) Monthly Summary tab with example data. Made-up numbers. Get it ## Multi-Property Short-Term Rental Host Tracker Or pay with PayPal Uses the email and terms box above. You get the same download link by email. ZIP code (for sales tax) Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly. Get every update for a year, $29: the [Yearly Updates Pass](/updates-pass?kit=short-term-rental-host-tracker) gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal. Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal 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. Ways to get it ## Just this kit, or more This kit **$29 one time** Multi-Property Short-Term Rental Tracker. Buy this kit The set **$75 one time** 4 kits including this one, $26 less than buying them separately. [See the set](/toolkits/short-term-rental-host-bundle) Membership **$29 a month** Every kit and document pack in the store, including new ones. Cancel any time. [See the membership](/membership) Questions ## Common questions **What do I get and how is it delivered?** The Multi-Property Short-Term Rental Tracker as two Excel files in one zip: a filled-in EXAMPLE so you can see every tab working, and a BLANK copy for your own numbers, plus a README. The download link arrives by email after payment. **Will it open on a Mac, Google Sheets or my phone?** Built for Excel and tested in LibreOffice, which runs on Mac and Windows; it should open in Google Sheets, but not every feature is tested there. Phone spreadsheet apps are not tested. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund. **Is this legal or tax advice?** No, it is not tax, legal or accounting advice. The pricing check is an estimate, not a forecast. **Is it the right fit for me?** It is made for hosts with one to five short-term rental properties on any platform, including direct bookings. Skip it if you run more than five properties, or you need answers on local occupancy tax and licensing rules. 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](/bookkeeping/#interest) [Free books health check](/bookkeeping/health-check) Prefer to keep it yourself but want a hand getting started? [Book a 45 minute setup session](/workbook-setup-session) ($65). Buy it with the others [Bundle ### Short-Term Rental Host Bundle This product plus 3 more, in one download. $75 instead of $101 separately](/toolkits/short-term-rental-host-bundle)[### 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](/toolkits/month-end-close-workbook) ## More bookkeeping and business toolkits - [Multi-State 1099 and W-2 Filing Checklist](/toolkits/multi-state-1099-w2-filing-checklist) $17 - [Multi-State LLC Compliance Calendar](/toolkits/multi-state-llc-compliance-calendar) $19 - [Multi-State Sales Tax Tracker for Online Sellers](/toolkits/multi-state-sales-tax-tracker) $24 - [Multi-State Worker Tax Organizer](/toolkits/multi-state-worker-tax-organizer) $15 - [Nebraska Employer Compliance Kit 2027](/toolkits/nebraska-employer-compliance-kit-2027) $19 - [Nebraska Landlord Compliance Kit](/toolkits/nebraska-landlord-compliance-kit) $19 [See every toolkit and document pack](/toolkits/all) ## Rather have someone do the books? [Get a Bookkeeping Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)