About the Property Rental Manager Spreadsheet
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.
Property Rental Manager Spreadsheet
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.
From:Peter Polson
Powered by Tiller
This template is designed for spreadsheets powered by Tiller, the only personal finance service based on Google Sheets and Microsoft Excel.
The best way to use this template is by trying Tiller free for a month. Your card isn't charged until the end of your trial, and you can easily cancel anytime. Any data and templates you download during your trial are yours to keep.
See the FAQ to download this template without a free Tiller trial.
FAQ
Notable Replies
Historical Comment Archive
Leave a Reply
You must be logged in to post a comment.
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