Short Term Rental Host Income Expense Tracker, Excel Spreadsheet, Printable Bookkeeping (Digital Download)

Price:$3.00

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by HilltopVentures
  • Party decor for gatherings and celebrations
  • Digital download
  • Digital file type(s): 1 ZIP

Know what your rental actually earns: bookings, fees, expenses and net profit, month by month.

This tracker comes as a working spreadsheet (.xlsx) with built-in formulas and as a printable PDF, so you can track on screen, on paper, or both. It's designed for short-term and vacation rental hosts with one to five properties, in the same warm off-white, charcoal and deep green style as the rest of the HilltopVentures host range.

WHAT'S INCLUDED
• Host-Income-Expense-Tracker.xlsx, 7 tabs:
Settings: year, up to 5 properties, your booking channels, editable expense categories (these feed drop-down lists)
Bookings: check-in/out dates, channel, accommodation, cleaning and other fees, platform fees and payout. Nights, gross and payout calculate.
Expenses: date, property, category drop-down, vendor, amount and receipt tick
Mileage: odometer start/end, distance and value at your own rate
Monthly Summary: nights booked, occupancy, average nightly rate, gross, fees, payout, expenses and net for each month, with an All / single-property filter
Category Summary: every expense category by month with year totals
• Host-Tracker-Printable.pdf, 8 pages (US Letter): cover · year at a glance · monthly booking log · monthly expense log · monthly summary · mileage log · annual expenses by category · year-end checklist
• Start Here guide

HOW IT WORKS
1. Download the files from Etsy after purchase.
2. Open the .xlsx in Excel, Google Sheets, Apple Numbers or LibreOffice.
3. Fill in Settings, then add each stay and expense in the light green cells.
4. The summaries update automatically. Prefer paper? Print the PDF pages.

PLEASE NOTE
• This is a digital download. Nothing physical will be shipped.
• The spreadsheet has working formulas. The printable PDF pages are designed to be filled in by hand; the green [fields] on them are text placeholders, not fillable form fields.
• Formulas were built and tested in a standard .xlsx file. Google Sheets and Numbers convert the file on import; drop-downs and formulas work there, but some formatting may look slightly different.
• Colours may vary slightly between screens and printers.
• This tracker organises your records. It is not tax, legal or accounting advice.
• For use in your own business only. Please do not resell, share or redistribute the files.
• This is an independent template by HilltopVentures. It is not affiliated with or endorsed by any booking platform.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 5, 2026