VRBO Accounting Excel Worksheet, Excel Template for Vacation Rentals on VRBO


Personalize with Name or Company Name


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

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.

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.

Vacation Rental Income and Expense Tracking Template, Short Term Property Management

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.

Vacation Rental Income and Expense Tracking Template, Short Term Property Management

Summary Page

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.

Customizable Options

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


Spreadsheet Details

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.

Want to try a free rental template?

Download a rental property improvement tracker: 

Additional information

Number of Properties

, , , , , , , , , , , , , ,

Customer Reviews

Based on 3 reviews
Sam M
Great spreadsheet

Worked just perfectly with my VRBO rental. Saved me a ton of work.

Stephen Katona
Helpful Tool

I was able to use it and it helped me with my short term rental client.

Brian A

VRBO Accounting Excel Worksheet, Excel Template for Vacation Rentals on VRBO