fbpx

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.

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.

FAQ

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 →

Unless otherwise noted above, this free template is installed with the Tiller Community Solutions add-on for Google Sheets. It's an easy way to browse and install dozens of free, prebuilt sheets for tracking budgets, debt payoff goals, net worth, savings, and more, all from the Google Sheets sidebar.

This template for Excel works best when installed in Tiller’s Foundation Template.

Visit the Tiller Community with any questions about this template.

Notable Replies

  1. Avatar for jono jono says:

    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 Address and the Rent Category from 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.

  2. Avatar for peter peter says:

    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.

  3. 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.

  4. @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.

  5. Avatar for jono jono says:

    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

Continue the discussion at community.tillerhq.com

2 more replies

Participants

Avatar for heather Avatar for randy Avatar for peter Avatar for jono Avatar for bgallagher31 Avatar for ksmith96

Start Your Free Trial

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023