The Property Rental Manager template helps you track income and expenses for rental property by reporting the status of one or many rental properties on a monthly, quarterly, or annual basis.
The Property Rental Manager template helps you track income and expenses for rental property by reporting the status of one or many rental properties on a monthly, quarterly, or annual basis.
This is a free template built by a member of the Tiller Community. While it’s free for anyone to use, it’s designed for spreadsheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.
Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically imports your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →
The Tiller Community Solutions add-on for Google Sheets is an easy way to install dozens of free, prebuilt sheets for tracking your budgets, debt payoff goals, net worth, savings, and more.
This template for Google Sheets works best when installed in Tiller’s Foundation Template.
Visit the Tiller Community with any questions about this template.
Thanks for sharing this sheet @Peter !
The concept you used here gave me the idea to extend the idea further to answer the question “Am I getting all my rent checks per property every month?”
Instead of using selecting a specific reporting period, I built a sheet that shows the monthly amount in a selected category over the course of a year.
To use the sheet, select a year. Then for each row, select an
Addressand theRent Categoryfrom the dropbox lists. The monthly results will appear. While this was built to check if the rent was paid, you could select any category and get the monthly results.Here’s a link to the spreadsheet:
https://docs.google.com/spreadsheets/d/1LmF8H--6xLNbe1QyveWXqKCPyrdMNzYbYi6ZYJrctlM/template/preview
Save a copy to work with your own data. Copy the sheet into your Tiller spreadsheet and update the dropbox selectors.
If you have an idea to build upon this sheet or Peter’s original sheet, please share it with our Tiller Community.
Love it - that’s a great enhancement Jon! Thanks for sharing. I’m going to update the link in my original post with your new sheet, which includes my original report and your addition.
Just getting set up on this. Do you have a totally separate excel doc for your personal items or just a different tab? Trying to decide the best way to set it all up.
@bgallagher31, it really depends on your specific situation. If you have all the inflows/outflows in separate accounts it’s probably better to have a separate Google Sheet (this solution is specific to Google Sheets, just noting that as you mentioned Excel and this sheet is not compatible with Excel) for the rental stuff. If the transactions for rental properties are comingled with your personal transactions because they’re in the same accounts then a single Google Sheet probably works best and you’d use a category setup to help you stay organized between business and personal.
Hi @ksmith96,
I assume you have copied both the Rental Manager and the Rent Manager Checker to your own Tiller spreadsheet?
You should rename the sheets Rental Manager and Rent Manager Checker, as the might say “Copy of …” when you copy them in.
In the Rental Manager Checker, take a look at the hidden cell in W2. If it shows a REF error, put your cursor in the cell and at the end of the formula, add a space. See if that removes the REF error.
If that’s not the problem, are you seeing REF errors in the hidden parts of the sheets? If so, where?
Let us know if that fixed the problem.
Jon