Investing in rental properties is an excellent idea to grow your net worth.
However, keeping track of monthly income is difficult when you own many properties. As a landlord or a real estate investor, you need to use proper tools to ensure everything is in order.
Excel is a fantastic spreadsheet application with numerous formulas and in-built features to analyze and organize large datasets.
It is the best tool for rental property management. Using Excel Rental Property spreadsheets can save you a lot of time.
In this article, we will discuss the top 8 Excel Rental Property Templates to help you get the most out of your property investments. We have mentioned all the instructions for using them, so read the article until the end.
Why are Rental Property Spreadsheet Templates created using Excel a must-try?
Excel is a perfect tool to save time and money. It offers convenient and effective ways to track expenses, organize assets, and forecast future growth.
The benefits of using Excel for rental property management include,
- Ease of Use – Excel boasts an intuitive user interface, making it easy for beginners and advanced users. You can easily add details and apply formatting. All essential tools are quickly accessible through the toolbar section and main menu.
- Budget-friendly – In contrast to those premium apps, Excel is way cheaper. It is a part of Microsoft Office Suite, which comes at an affordable price. You don’t need to worry about extra costs to manage your rental properties.
- Accessibility – Excel is accessible from both desktop and mobile devices. You can easily add and update your rental property information anytime to ensure up-to-date information. Excel files are stored in OneDrive, and you can access them with an active internet connection from anywhere.
- Extensive Customization – Excel allows you to fully customize your rental property spreadsheets to suit your specific needs. You can easily add, remove, and modify columns to accommodate more properties and respective information. Also, you can leverage built-in formulas to summarize your rental income and expenses.
- Team Collaboration – You can share Excel with unlimited users. It boasts real-time collaboration tools. As an owner, you can assign specific roles to each user and ensure advanced control over confidential data.
These are just a few of the benefits. Excel is the top choice for accounting professionals.
You can use it to boost income and lower expenses with little practice and consistency.
What is a Rental Property Spreadsheet?
It is a tool used to track various aspects of property management. Real estate is a long-term investment with higher returns.
Buying and renting a property comes with two advantages,
- The owner receives monthly rental income
- The value of the property increases exponentially over time if you decide to sell it in the future
A rental property spreadsheet is designed to keep track of everything from monthly rent to yearly tax deductions. It aims to save you time and money.
The template’s design varies based on whether you are a landlord, owner, or real estate investor. However, the overall purpose of the template is to allow users to track expenses, monthly earnings, yearly tax deductions, etc.
Top 8 FREE Excel Rental Property Spreadsheet Template
There are tens of templates available online for managing rental properties. It is not a feasible option for you to test each of them and find the right fit.
So, we have decided to do the heavy lifting for you.
Our team at SoftwareAccountant has compiled a list of the best rental property management templates for real estate investors, landlords, and property managers.
Let’s discuss them one by one in the following section.
1. Rental Property Earnings Spreadsheet – SoftwareAccountant

Click Here To Use The Template!
This is a comprehensive template designed by SoftwareAccountant. Its intuitive and attractive design makes it easy to track and manage earnings from rental properties.
The template includes only one spreadsheet with a huge table.
At the top, you can enter your property details.
Note that the template is optimized for both desktop and mobile users. You can easily add, edit, and remove information on the go.
How to use this template
The template’s header allows you to add personal details such as your name, address, and contact information. In addition to the personal information, the template contains a dashboard that displays your gross income, total operating expenses, and net income.
Once the personal information is added, start by entering the rental property details. The template allows you to add addresses, tenant names, rent amounts, etc.
Then, add the monthly rent received from each tenant along with the maintenance charges, insurance fees, legal fees, etc.
The template uses formulas to calculate the total earnings from your property. You should avoid editing the cells that contain the formulas; otherwise, the template won’t work as expected.
The cells containing the formulas are highlighted with a light green background to help you quickly identify them.
Using this template is pretty straightforward. Make sure to dedicate a few minutes in the beginning to understand and learn the template.
2. Rental Income and Expense Worksheet by Zillow

Click Here To Use The Template!
This rental income and expense worksheet is designed to help landlords and property managers seamlessly track earnings and expenses.
It includes a single sheet capable of recording all the essential details related to your rental income and expenses. At the top, you can enter property information, tenant details, and financial figures, making it easy to manage everything in one place.
The template uses formulas throughout the sheet to calculate the Gross income, Total Expenses, Net income, and deposits.
How to use this template
Download the template and start by filling in your property details, security deposits, rental income, monthly expenses, operating expenses, and more.
The template is fully automated. It gives you an overview of the annual rental income and expenses broken down by months. At the top, you can have a look at the summary of a specific year’s Gross income, Total Expenses, Net income, and deposits.
Do not change or edit any cell-holding formulas because doing so can disrupt all the calculations.
Make sure to enter data only in the designated cells to keep the template functioning correctly.
3. Rental Property Expense Tracking Template by Stessa

Click Here To Use The Template!
This is another masterpiece on this list, designed by the expert at Stessa to track rental properties.
The template has a minimal design, and anyone can use it without any prior Excel experience. It includes a massive table with types of expenses on the x-axis and months on the y-axis.
How to use this template
It is a fully customizable template. In the header, you can add your personal or company details, such as your name and logo. Once you are done adding the individual or business details, select the year and enter the month.
Note that you should avoid editing the cells highlighted in light blue. They contain formulas and essential reference information for the proper functioning of the template.
The template also allows you to add the owner and project manager’s name in the header.
The main table comes with predefined standard expenses.
However, if you feel like any of your property expenses are missing, add a row and enter the name of the expense.
By default, the template lets you track advertising, travel, cleaning, maintenance, and other property management charges. You can also track insurance fees, taxes, commissions, professional fees, the amount spent on supplies, and much more.
If you have made any changes by mistake, press “Ctrl + Z” to revert the changes.
4. Rental Property Income and Expenses Tracker by Baselane

Click Here To Use The Template!
This template provides separate sections for property details, income generated by each tenant, and various expense categories. Moreover, a user-friendly interface allows users to manage their properties all in one place.
It is a perfect template to track where the money is coming from and going.
The template uses built-in formulas to automatically calculate totals and generate an overview of the financial performance.
How to use this template
First, download the template by clicking on the link above. In the property details section, enter the name and address of the property and all the relevant information.
Next, enter your income data, such as the monthly rent received from each tenant. Then, fill in the expense fields, such as maintenance, utilities, property management fees, and insurance costs.
This template will automatically calculate the total income, total operating expenses, and net profit for each property.
Remember not to change or edit the cells holding formulas because it would affect the automatic calculations.
5. Rental Income Template by Spreadsheetpoint

Click Here To Use The Template!
This one is an easy-to-use rental property management template by Spreadsheetpoint. It uses a simple color code to track income or expenses quickly and easily.
The template automatically calculates total annual income and money spent on things to keep your business up and running.
How to use this template
It includes a huge table divided into five properties. You can add rent and monthly expenses for each property.
By default, the template allows you to enter expenses such as maintenance costs, insurance fees, legal fees, and consultant charges. If you wish to track more expenses related to your property, feel free to add more rows to the spreadsheet.
At the bottom, you will find the Annual Gross and Net Income for each property.
The template uses built-in formulas to auto-calculate these values. The final row of the table calculates the Total Overall Net income.
Avoid editing the cells that hold the formulas; otherwise, the template won’t work as expected.
You will notice an orange-colored table on the far right side of the spreadsheet. It allows you to specify the market value of each property.
You can also keep track of the deposit submitted by each tenant with this template.
6. Rental Property Cash Flow Analysis

Click Here To Use The Template!
Are you just starting with property investment?
This spreadsheet template for rental property management uses an intuitive design for beginners. You can manage a single property using this template.
It is totally free to download. You can customize it as per your preference without any limitations.
Additionally, you don’t need any prior Excel knowledge to use this rental property template.
How to use this template
The template includes only one spreadsheet, which allows you to manage a single property. Note that you can duplicate the spreadsheet as often as possible if you have more than one property.
There are three tables in the spreadsheet:
- Gross Cash Flow/Income
- Net Cash Flow After Debt Service
- Gross Operating Expenses
All of them are self-explanatory and serve a specific purpose in this template.
You can enter the monthly rent and any additional income from your property in the Gross Cash Flow/Income table.
7. Rental Real Estate Analysis

Click Here To Use The Template!
This comprehensive template is designed to record all the information related to your rental property. It is the ultimate tool for helping users forecast their overall income over the next few years from their rental properties.
At first glance, the template may look quite confusing to you.
But don’t worry; read the following section carefully.
How to use this template
The template includes a variety of tables to keep track of a multitude of things related to rental properties.
Here are the two main sheets of this template:
- Financial Summary – This sheet gives you a quick overview of investments at a glance. It includes property purchase and mortgage details. The table highlighted in light green displays the overall performance and revenue generated by your property with respect to the current date. Make sure you add the monthly rent and property expenses to the Calculation Assumptions table. All these values from the Calculation Assumptions are used in the next worksheet to forecast your income over the next few years.
- Financial Analysis – This is the main sheet containing your income for the next few years. It includes lots of formulas that must be kept from being edited. Note that the entire worksheet is fully automated using various built-in functions in Excel.
Note that you are supposed to add the information in the Financial Summary sheet only.
8. Property Management Spreadsheet Template by Smartsheet

Click Here To Use The Template!
This is our last pick on the list. It is designed to help you manage finances from multiple properties.
It includes separate sections to record the income and expenses from all of your rental properties. A user-friendly interface makes this template a top choice to manage multiple properties.
Overall, it is a comprehensive tool that helps users stay organized, maintain accurate records, and streamline their property management processes.
How to use this template
Start by entering the basic details for each property, such as property name, address, and relevant information.
You can record monthly income along with additional perks such as late fees.
It also has fields to track money spent on things such as marketing, insurance, maintenance, water, gas, electricity, Sewage, Land tax, etc.
The template automatically calculates totals, providing you with an overview of your net income and expenses. You can record the income and expenses of 12 properties, but if there are more, you can duplicate this sheet by following the below steps,
- Open the Excel template
- Right-click on any of the “Property” worksheets
- Click on “Move or Copy”
- In the “Move and Copy” dialog box, select the workbook where you want the copied sheet to go
(You can choose the same worksheet or a different one) - Tick the “Create a Copy” checkbox
- Finally, click on “OK” to create a sheet
This will create a duplicate sheet instead of moving the original one. You can see the copied sheet in your selected workbook. It will have the same name as the original one, but you can rename it as you require.
Conclusion
A rental property spreadsheet offers a convenient way to keep track of monthly income and operating expenses.
Accurately tracking property expenses is essential for a successful real estate business.
We have discussed 2024’s best template and the steps to make the most out of them.
Note that the template discussed in this article helps real estate investors make informed decisions by identifying potential opportunities. Another benefit includes reducing tax deductions.
I hope you have found the best rental property spreadsheet template for your requirements. Feel free to comment below if we are missing any fantastic templates worth adding to this article.
Also, let us know if you need help somewhere or are having any particular issues while using the templates discussed in this article. Our team will answer all of your questions as soon as possible.
Make sure you visit our blog section for more templates that save time and money through effective management of your day-to-day activities and expenses.