If you are looking to get your rental property bookkeeping organized, this template will help you do so very quickly. Simply follow the directions to import your rental income and fees from the VRBO reservation manager system, enter any other expenses you incur, and the summary will automatically add up all your totals, making tax time a breeze.
See a demonstrations of this template in use here:
This template is designed specifically for someone who utilizes VRBO (vacation rentals by owner) and the Reservation Manager system. There are 4 main sections –
1.) VRBO Rental – This is where you will be able to simply copy and paste your csv from the reservation manager system. Directions are included on how to download the csv. The summary page will add up totals for – Rental Income, Transaction Fees (collected by vrbo), and taxes you collected.
2.) Variable Expenses – This is where you can enter any expenses related to your property. There will be drop down lists for you to choose which property the expense applies to and a drop down for the expense category to assign it to. All of the expense categories match those listed on schedule E.
3.) Monthly Information – This section is only for expenses or income that are the same each month (or may change once or twice during 1 year). For example, you would enter a monthly maintenance fee here. You would enter the current rate, and if applicable, the new rate and effective date. The file will then calculate the correct rate for all 12 months. You will have the ability to override any month if there are changes.
4.) Summary – This is the best part of the template – let excel do the math for you! The summary will add up everything that is entered in all 3 of the previous sections. The expense categories match the ones that are needed for Schedule E and you get to see a nice snapshot of your total profit/ loss on each property and overall.
You can select from these options depending on how many properties you’re tracking:
- 2 VRBO properties and 2 regular
- 4 VRBO properties and 1 regular
- 6 VRBO properties
If you also list the same properties on AirBnb, you can also select one of the combo options to get a file that will be able to upload your data from both vrbo and airbnb (directions included) –
- Combo with 2 VRBO & Airbnb, 2 regular
- Combo with 4 VRBO & Airbnb, 1 regular
- Combo with 6 VRBO & AirBnb
The options for 4 or 6 properties, includes an extra column/ expense category for expenses that apply to all properties.
For the upgraded versions, you will download a new csv for each VRBO account and there will be a different tab to paste each csv into the template.
You will receive an Excel Spreadsheet and a PDF file with directions via email. You won’t receive a physical copy in the mail. Upon request I can send an Open office version.
You will receive 2 versions of the VRBO template – one that works with VRBO’s pay per booking csv, and another that works with VRBO’s annual subscription. Depending on which option you chose when signing up for VRBO, you’ll have to use the template that matches because the csv you download and import will be different. Directions are included & I’m also here to help with questions!
*You do not have permission to distribute or re-sell the template, so please don’t do it.
If you aren’t sure which rental template to get, this video below outlines the different options available. Find the other rental property templates here.