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 template was designed by Tiller founder, @peter, in October 2019.
- Open your Tiller Money Foundation template
- Install or launch the Tiller Money Labs add-on
- Choose “Add a Solution” in the sidebar
- Click on “Rental Manager”
- Choose “Add to Spreadsheet”
For each rental property you own, you will use three Category Groups in the Categories sheet to track:
- Deposits (these can be type Transfer they are not income or expenses)
Add Categories for Each Property
In the Categories sheet, create as many Income, Expense, and Deposit categories you want per property. Each property should have its own categories, so you might use the property number as the first part of the name.
Assign each of these Categories to the correct Category Group for the property.
Now you are ready to setup the Rental Manager sheet.
Setup Your Properties
For each property, add the Overview information in rows 8 to 14. This is just for your own reference so you stay organized.
Also for each property, link the correct Category Group to each Rental in Rows 18 to 20. These will be used to automatically consolidate categorized income & expenses for each property.
Add More Properties
If you want to add more rentals, add 3 columns to the right of the sheet (before the hidden columns.) Then copy and paste the Rental property columns (for example, G,H and I) into the new blank Columns. You will need to update the Overview and Group Setup columns for each rental.
Setup the Reporting Time Frame
You can adjust the time frame of the reporting period in B3 to include everything, this month, last month and other options.
As you categorize rental property transactions, those numbers will appear in the Rental Manager sheet.