See below for common questions related to your rental property templates:
VRBO csv issues: Before pasting the CSV into the template, double check that the columns in the csv line up to the template columns. The columns in the CSV could be different based on whether you choose to ‘pay per booking’ or do the annual VRBO subscription.
I’ve started sending both versions of the template, so that you can find the one that works with your situation and not have to edit the columns. Here is a video that shows you how to compare the template to the CSV to make sure you use the right one:
If you previously bought the AirBnb template and only had the VRBO directions, here are directions on downloading your AirBnb csv:
*Download your AirBnb csv from this page:
www.airbnb.com/users/transaction_history
*Just select the date range and click the ‘Download CSV’ button.
Other common questions:
You can fix this by entering a name for the extra properties you won’t be using, such as ‘none’ or ‘blank’ in row 4 of the summary page:
Also be sure that any expenses you enter, still need to be assigned to the rental 1 property name:
After you select the effective date, the cell should just display month and day (not year). If you change the year, you will also have to change the formulas that populate the amounts into the correct months. If you would like to make those type of changes to the formulas, you’ll need the unprotected formulas version add on.
If you’re not concerned about the formulas populating the amounts in the correct months, you can change the date for the drop down list in cells Z11-Z22.
The file is just set up to manage 1 year at a time, but there is a workaround if you want multiple years in 1 file.
*First always save a blank version of the file to come back to*
*You can save as many different versions of the template as needed*
Depending on how many properties you are tracking, you can use the property space as a year instead of a property. For example, if you are tracking 1 property and you have the 6 property version of this template – you can enter the property names as years, for up to 6 years.
All my templates come with at least 3 property spaces and up to 30 properties in 1 file here.
For Rental Property templates (3-6 property and VRBO & AirBnb versions) –
The template is set up so you can add 2 new categories. Just add them in the bottom of the Summary page in cells A23 & A24. After that, the new categories should automatically appear in the drop down lists in the other pages.
If they still don’t appear in the drop down lists, you can add them into each page:
* Variable Expenses – cells G17 & G18
* Standard Expenses – cells W21 & W22
For Landlord Templates (5-30 property versions) –
The template is set up so you can add 8 new categories. Just add them in the Rental Property 1 page – in cells A38- A45. After that the new categories should automatically appear in the drop down lists in all other property pages and the main summary.
Other category changes:
If you are making changes to the other/existing categories, you’ll probably need the version with the formulas unprotected.
Here is the link for the unprotected version add-on if you would like me to send that version-
What I usually recommend if you have units, is to treat each unit as its own property.
With the Landlord template, each unit/page will have a monthly summary of income and expenses, however the main summary page will have annual totals of all the properties/units, and 1 main total of all. So if you have 25 units to track, you would want to use the 25 property version if you want them all in 1 file. Each property page is more of a ‘tenant’ page.
The other rental property templates just go up to 6 properties, so could be used for 6 units, rooms or apartments at a time.
You can save different versions of the file as many times as needed. So if you have a set of 10 apartments in 1 property and a set of 8 units at another property, you could get the 10 property version and save 2 versions of the file. You can do this by selecting File – Save as – and then change the name of the file.
First double check that the date entered is in the format: month/day/year.
In basic landlord versions~
- For expenses, date is in column U
- For income, date is in column H
In remaining balance versions~
- For expenses, date is in column Y
- For income, date is in column L
If the date is entered in the month/day/year format, and it’s still not appearing in the summary, double check that these hidden formulas didn’t get jumbled accidentally. There will be 2 hidden columns to the right of the income and expenses sections. To unhide them, highlight the 2 columns, right click and select Unhide.
Then you’ll see these 2 columns in grey that display a number/text for the month:
The month in the grey columns will default to January, until a date is entered, and then it should display the new month.
IF the formulas have been jumbled and are not showing the correct month per row, you have a few options for fixing it:
- Start over with the original/blank template that was sent and copy/paste your data into that template. Be sure that you don’t insert or delete cells, especially if you get an error message to ‘shift cells up/down’ – be sure to cancel out. If you need to delete data, just highlight the data and click the delete key.
- Send me your file and I can fix the formula for a small fee here.
- If you upgraded to the unprotected formulas version – you can edit the formulas in the hidden columns so they are referencing the correct row.
Follow these steps to update the date paid (either in the rent paid or expenses paid sections):
Highlight the Date Column, right click and select Format Cells – Then reset the date format location for the country that applies to you, check that the number type is matching to the way you want to enter it.
If you need help resetting the formatting on all your pages, we can also look into setting this up for an extra fee.
The 2nd thing to check is if the month formula got jumbled.
There will be 2 hidden columns to the right of the income and expenses sections. To unhide them, highlight the 2 columns, right click and select Unhide.
Then you’ll see these 2 columns in grey that display a number/text for the month:
IF the formulas are not showing the correct month per row, it’s possible they could have gotten jumbled. Below are a few options to try:
Start over with the original/blank template that was sent and copy/paste your data into that template. Be sure that you don’t insert or delete cells, especially if you get an error message to ‘shift cells up/down’ – be sure to cancel out. If you need to delete data, just highlight the data and click the delete key.
Send me your file and I can fix the formula for a small fee here.
If you upgraded to the unprotected formulas version – you can edit the formulas in the hidden columns so they are referencing the correct row. You could also type in the month you’d like your income/expenses to apply to, instead of using the formula.
Yes, however after you change the tab names, the hyperlinks will no longer work. You can reset the hyperlinks by:
- In summary page, with cursor in the cell with original hyperlink, right click
- Select Edit Hyperlink
- Make sure ‘Place in this Document’ is selected on the left side of box
- Scroll through box to find the new page name you want to link it to
If you have the Landlord template, and you have an extra property page (or upgrade to a version with an extra property), you can use that property page for the overall expenses. Simply name that property ‘Overall Expenses’ and then only enter expenses that apply to all units. You can skip the rental income section or hide the income section, by highlighting the columns, right click and select hide.
