Short-Term Rental Host Spreadsheet, Turnover Log, Cost Per Stay and Host Mileage Tracker, Excel and Google Sheets
One file for the paperwork of hosting a short-term rental. Log each stay with check-in, check-out, property, what you were paid, and what the turnover cost you (cleaner, supplies, platform fees, other). The sheet works out nights, cost per stay, cost per night and net for every booking, and shows how many days you have before the next guest arrives, with a SAME DAY flag when there is no gap.
A mileage tab logs trips to your properties and totals miles and an estimated deduction using the standard mileage rate you type in for the year. The summary tab gives totals by property and by month. Room for 10 properties, 300 stays and 400 trips.
Works in Excel and Google Sheets. No macros, no external links. Yellow cells are inputs, blue cells are formulas. Tabs: Start Here, Settings, Stays, Mileage, Summary.
Recordkeeping tool, not tax advice.
If the file does not work as described and we cannot fix it within 3 days, we refund the order.