Whether you have a long term rental or an AirBnb, if tracking your rental income and expenses on a quarterly basis is important to you, this template can help.
In the Airbnb version, you’ll have extra pages where you can paste your Airbnb report into (directions included on how to do this), then the quarterly summary will add up all your rental income and fees from Airbnb:
This file comes with room to track up to 6 properties – in a regular/long term version or an Airbnb version. The Quarterly Summary page will contain the above summaries for each of the individual properties, and 1 for all properties combined.
For the long term version, you’ll be able to enter the monthly rents due each month 1x, and it will populate in all 12 months:
The bottom section also includes a place for standard expenses that are the same each month.
Another page includes the options to add as many variable expenses as you need to, including a category for Overall Expenses that apply to all 6 properties.
In addition to the Quarterly Summary page, there’s also an annual summary that will total up everything for all 6 properties:
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.
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!