Multiple Property Spreadsheet (up to 15)Įasy to use spreadsheet to track all your Airbnb income and expenses.Second is the Multiple Property Spreadsheet that allows you to track up to 15 properties in total. First is the Single Property Spreadsheet which is ideal for hosts with just the one property. So if you don’t want to start your own from scratch, you will love mine! Here at BnbDuck there is a great range of Airbnb spreadsheets. Tracking one property on an Airbnb spreadsheet is quite simple, but what if you host multiple properties? Average earnings (per night, per month, etc).Total earnings (by month, by year, etc).I mean, what else matters, right?īelow are some ideas of key metrics to track: Key Metrics to track All you need to know is if you are making money or not. So first things first, what Airbnb metrics should you calculate on your spreadsheet?įor starters, the most important thing is your earnings. You’ll even be able to create beautiful graphs and charts to display data as well. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |