🔍
Multi-property rental tracker in Google Sheets for up to 10 properties: a property view with monthly income and expenses, a year-to-date expense chart, net profit before and after tax, the highest and lowest months, and year-to-date totals.
Rental dashboard: property view and analysis for each investment property, with income and expense charts, the year-to-date expense breakdown, the highest and lowest performing months, year-to-date quick info and monthly figures.
Labeled rental tracker: a property information table, a quick analysis table, a collection table for monthly rent, how rent was paid chosen from a list, unpaid or overpaid amounts calculated, and an expense section.
Analysis for each property: year-to-date quick info such as total rent received, other income, late fees, total due, paid and unpaid, expenses, income tax and net income after tax, generated from the monthly entries.
Monthly overview: enter the collection amount for each property in its own input table, and rental income fills in below.
Rental expense tracking: enter fixed or variable monthly expenses for each property below the collection section.
Rent roll: pick the year; all properties' information, status, rental terms, contract dates, managers and tenant contacts in one place, which fills in the other 10 property tabs.
Each property's information table fills in from the property information tab.
How to use it: enter property information for up to 10 properties and the income and expense descriptions, enter monthly collections and expenses for each, then analyze by month. 13 tabs: property information, income and expense setup, a dashboard and 10 property tabs.
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. Multi-property rental tracker in Google Sheets for up to 10 properties: a property view with monthly income and expenses, a year-to-date expense chart, net profit before and after tax, the highest and lowest months, and year-to-date totals.
  2. Rental dashboard: property view and analysis for each investment property, with income and expense charts, the year-to-date expense breakdown, the highest and lowest performing months, year-to-date quick info and monthly figures.
  3. Labeled rental tracker: a property information table, a quick analysis table, a collection table for monthly rent, how rent was paid chosen from a list, unpaid or overpaid amounts calculated, and an expense section.
  4. Analysis for each property: year-to-date quick info such as total rent received, other income, late fees, total due, paid and unpaid, expenses, income tax and net income after tax, generated from the monthly entries.
  5. Monthly overview: enter the collection amount for each property in its own input table, and rental income fills in below.
  6. Rental expense tracking: enter fixed or variable monthly expenses for each property below the collection section.
  7. Rent roll: pick the year; all properties' information, status, rental terms, contract dates, managers and tenant contacts in one place, which fills in the other 10 property tabs.
  8. Each property's information table fills in from the property information tab.
  9. How to use it: enter property information for up to 10 properties and the income and expense descriptions, enter monthly collections and expenses for each, then analyze by month. 13 tabs: property information, income and expense setup, a dashboard and 10 property tabs.
  10. 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 Income & Expense Tracker – 10 Properties (Google Sheets)

$9.99

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 rental income and expense tracker works in Google Sheets. It is the Rental Income & Expense Tracker – 10 Properties (Google Sheets), designed by a licensed CPA.

What is in the rental income and expense tracker

The template includes a property view with monthly income and expenses, a year-to-date expense chart, net profit before and after tax, the highest and lowest months, and year-to-date totals.

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 Income & Expense Tracker – 10 Properties (Google Sheets)”

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