Skip to content
The title slide and first slides of the Short-Term Rental Income Tracker template

Short-Term Rental Income Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Hosts of vacation rentals, guest suites and cabins use this tracker to see what a rental really brings in. The Bookings tab records each stay and works out the nights and the payout after the platform fee. The Turnovers tab holds each cleaning and what you restocked. The Costs tab lists utilities, repairs and insurance, and the Dashboard shows payouts and nights by month, bookings per channel and costs per category.

Enter a stay when it is confirmed and fix the fee when the payout statement arrives. Keep the cleaner's note or receipt for each turnover. Record only the share of a cost that belongs to the rental if you also live in the property. Before filing, show a tax professional the totals, since how rental income is reported depends on how often and how long you rent.

Useful for

  • Compare payouts by month and by booking channel
  • Total cleaning and restocking costs per season
  • Prepare income and cost totals for a tax professional

What's included

  • 5 tabs: Dashboard, Bookings, Turnovers, Costs, How to use
  • Dashboard: a dashboard with 6 summary figures
  • Bookings: a table
  • Turnovers: a table
  • Costs: a table
  • 3 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Bookings tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What records do I need for a short-term rental?

Keep each booking with its dates, amount and fees, receipts for cleaning and repairs, utility and insurance bills, and the number of days the home was rented and used personally. This workbook holds the figures; keep the receipts in a folder for the year.

How can I follow income from a short-term rental?

Add one row per stay on the Bookings tab with the nightly rate, cleaning fee and the fee taken by the booking site. The payout column shows what you receive, and the Dashboard totals it by month. The IRS explains how rental income is reported, so read its current pages.

Should platform fees be tracked separately?

Yes. The fee sits in a separate column, which shows gross booking value and net payout. Fees match the statements from each booking site, which makes them easy to confirm at year end.

  • #tax-tracker
  • #short-term-rental-income-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…