rental property excel spreadsheet expense tracker

Rental property excel spreadsheet expense tracker plus#

Once you have all your revenues and expenses tracked, you’re able to manipulate the data to show you want. Microsoft Excel is incredibly powerful with what it can do. Now it’s time for you to decide on the performance metrics that you wish to track on your Airbnb spreadsheet. You may wish to include the vendor or other taxes involved.

Key columns include the date, item description, cost and category. Staff (cleaners, laundry, photographer)įinally, create columns on your spreadsheet so you can input your Airbnb expenses.Business (accounting, software, education).There will be property expenses such as mortgage, repairs, property taxes, etc. The big one is utility costs such as gas, electricity, water and so on. Second, there are your ongoing costs for the operation of your Airbnb. I like to keep these on an individual tab, keeping them separate from ongoing costs. These are all the costs of setting up your Airbnb, prior to the listing going live. Therefore this step is a little bit trickier as the expenses will vary from host to host.įirst of all you will have your setup costs. There is nothing worse than a messy looking Airbnb spreadsheet! ExpensesĪs you no doubt would have guessed, you will be tracking your Airbnb expenses in this spreadsheet. Airbnb, HomeAway, )įinally, format it so that it looks nice and is easy to read.

Rental property excel spreadsheet expense tracker plus#

In addition to that, you may wish to track the total guests and their names, plus total nights.

By that, I mean such things as cleaning fees, service fees, payment total and so on. Also it’s a good idea to track the price breakdown on your spreadsheet. For example, you will want to track check in and check out dates. Second, create some columns to track your data. Or HomeAway, or or whatever platforms you are using. This is where you will be tracking all your Airbnb income. First, setup a new tab in your Airbnb Spreadsheet calculator and call it revenues.