Skip to content
The title slide and first slides of the Rental Property Income Tracker template

Rental Property Income Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

The Rental Property Income Tracker helps a small landlord keep rent and costs in one place. The Properties tab lists each property with its type, bedrooms, lease end and insurance renewal. The Rent tab is the rent roll for the month, with tenant, rent, due day, paid date and status. The Expenses tab logs repairs, insurance, agent fees, utilities and council tax against each property.

The Dashboard shows the rent due, the rent collected, the costs and the net income, with a breakdown by property and by cost type. It comes with sample data for four properties. Make a copy, replace the sample rows and update the rent status each month. Totals, dropdowns and charts update on their own.

Useful for

  • Keeping a rent roll and checking which tenants have paid
  • Working out net income per property for a tax return
  • Keeping receipts and costs together for each property

What's included

  • 5 tabs: Dashboard, Properties, Rent, Expenses, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Properties: a table
  • Rent: a table
  • Expenses: a table
  • 2 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 Properties 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

Is this Rental Property Income Tracker template free?

Yes. Download the template and use it at no cost. There is nothing to sign up for.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Microsoft Excel. The formulas, dropdowns and charts work in Excel and Google Sheets.

Does this replace professional tax advice?

No. It helps you record rent and costs in one place. Check the figures with an accountant or tax adviser before you file.

  • #rental-property
  • #rental-property-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More profit and loss templates

See all 3

Also in Finance

All finance templates
Get this template

Preparing your template…