🔍
Rental tracker in Google Sheets for up to 10 properties, filtered by property: quick info with the best and worst months, monthly rental income and expenses, the share of income spent on expenses, and a second dashboard with a monthly card view.
Dashboard 1, property overview: pulls every property from every monthly sheet; filter by property number, name or address to see monthly rental income versus expenses and quick info.
Dashboard 2, kanban style: the year's summary with year-to-date net income, expenses, income tax and gross income, and a card for each month with net income and the top and lowest performing property.
Data by the month: enter income and expenses for each property on 12 monthly tabs, January to December.
A central place to track property status and information, and to edit the rental income and expense descriptions.
Summary of tabs, 16 in total: 12 monthly tabs, a kanban dashboard, a year-to-date dashboard by property, a property setup tab and an income and expense description tab.
How to use it: enter property information, set up income and expense descriptions, enter monthly income and expense data, and track property finances with the built-in dashboards.
This is a digital product; no physical item is sent. One PDF with download instructions is provided after payment. Works with Google Sheets only.
  1. Rental tracker in Google Sheets for up to 10 properties, filtered by property: quick info with the best and worst months, monthly rental income and expenses, the share of income spent on expenses, and a second dashboard with a monthly card view.
  2. Dashboard 1, property overview: pulls every property from every monthly sheet; filter by property number, name or address to see monthly rental income versus expenses and quick info.
  3. Dashboard 2, kanban style: the year's summary with year-to-date net income, expenses, income tax and gross income, and a card for each month with net income and the top and lowest performing property.
  4. Data by the month: enter income and expenses for each property on 12 monthly tabs, January to December.
  5. A central place to track property status and information, and to edit the rental income and expense descriptions.
  6. Summary of tabs, 16 in total: 12 monthly tabs, a kanban dashboard, a year-to-date dashboard by property, a property setup tab and an income and expense description tab.
  7. How to use it: enter property information, set up income and expense descriptions, enter monthly income and expense data, and track property finances with the built-in dashboards.
  8. This is a digital product; no physical item is sent. One PDF with download instructions is provided after payment. Works with Google Sheets only.

Real Estate

Rental Property Cash Flow & Rent Tracker (Google Sheets)

$9.75

Digital Download
  • Instant download after payment
  • No sales tax, no hidden fees
  • Excel and/or Google Sheets files
What will I get?

You will receive 1 PDF instruction guide on how to save the file and enable Google Scripts. This template is exclusively compatible with Google Sheets ONLY .

How will I get the files?

Once your payment is successfully processed, you will receive instant access to download links for your digital product. A confirmation email will also be sent with downloadable links.

Returns & Exchanges?

These are digital products and sales are final. If a template does not work as described, you may report the issue within 7 days of purchase and may be eligible for a refund under the Terms of Service.

About this template

This rent payment tracker works in Google Sheets. It is the Rental Property Cash Flow & Rent Tracker (Google Sheets), designed by a licensed CPA.

What is in the rent payment tracker

The template includes quick info with the best and worst months, monthly rental income and expenses, the share of income spent on expenses, and a second dashboard with a monthly card view.

Who uses it

Landlords and property owners with one or more rentals. See all rental property spreadsheets.

What you receive

One PDF guide with the link to the Google Sheets file and the steps to save it to your Google Drive and turn on its scripts. It works in Google Sheets only.

Reviews

Reviews

There are no reviews yet.

Be the first to review “Rental Property Cash Flow & Rent Tracker (Google Sheets)”

Your email address will not be published. Required fields are marked *