About the Property Rental Manager Spreadsheet
The Property Rental Manager template gives landlords a clear picture of how their rental properties are performing, tracking income, expenses, and deposits for one or more properties on a monthly, quarterly, or annual basis.
Each property gets its own set of categories on your Categories sheet, and the template automatically consolidates your categorized transactions into a clean summary view. You can report across all properties at once or focus on a single one, making it useful whether you have one rental or several.
Designed by Tiller founder Peter Polson, this Google Sheets template installs directly into your Tiller Foundation spreadsheet.
Best for: Anyone managing one or more rental properties who wants to track income, expenses, and deposits without separate accounting software.
Support & Documentation
Install the Property Rental Manager through the Tiller Community Solutions add-on. Find it under the Real Estate tag in the Explore tab.
For setup details, configuration tips, and community discussion, visit the Property Rental Manager thread in the Tiller Community.
If you run into an issue, search the community first and if your question hasn’t been answered, post it in the Get Help > Spreadsheet Templates category.
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