Tracking your Airbnb rental income and expenses is made much easier with this template. Simply download a csv of all your rentals from Airbnb, copy and paste it into the specified page in the template, and the summary page will add up your totals for rental income, cleaning fees and Airbnb host fees.
Depending on which option you select, you can choose the number of Airbnb vs. regular (long term) properties, and/or combine with VRBO if you use their booking system as well.
You will also be able to enter expenses into 2 different pages, depending on the type-
- Variable Expenses page – to enter expenses as they occur and assign them to the correct expense category (the categories taken from schedule E)
- Standard Expenses page – for expenses that are set and the same each month, you can enter the expense 1x and it will populate into all 12 months. This save a lot of time with data entry when you know the amounts will be the same. This section can also be used to track income – if you have some long term rentals that pay the same amount each month.
Main Summary Page – this page will add up the annual totals for each property, for the-
- Annual Rental Income
- Annual Expenses per category (using the schedule E categories)
- Total Profit/Loss (Income minus Expenses)
You can select from these options depending on how many properties you’re tracking:
- 2 AirBnb properties and 2 regular
- 4 AirBnb properties and 1 regular
- 6 AirBnb properties
If you also list the same properties on VRBO, 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 Airbnb, & VRBO 2 regular
- Combo with 4 Airbnb & VRBO, 1 regular
- Combo with 6 AirBnb & VRBO
The upgraded options include a bonus- an extra column/ expense category for expenses that apply to all 4 properties.
For the upgraded versions with more than 1 Airbnb property, you will download a new csv for each Airbnb account and there will be a different tab to paste each csv into the template.
About me~ I’m not associated with AirBnb or VRBO. I have family that are rental property DIY-ers and I’ve designed this template to help them organize their rental income and expenses. The file is not meant to provide any type of tax/ accounting advice.
See more rental property templates here.
You will receive an Excel Spreadsheet and a PDF file with directions via email. Upon request I can send an Open office version.
*You do not have permission to distribute or re-sell the template, so please don’t do it.
Feel free to contact me with any questions. Thanks for your interest in a template!
To sign up for a coupon code and an occasional free template click here.