Save time on data entry for your rental
This excel template is designed to import your VRBO rental income and fees, so it’s easy to keep track of them and saves a ton of time on data entry.
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
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.
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.
Monthly Information Page
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.
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:
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 4 VRBO & Airbnb, 1 regular
Combo with 6 VRBO & AirBnb