Partners Learn about the Smartsheet partner program and access our partner directory.Community Explore user-generated content and stay updated on our latest product features.Help and Learning A comprehensive knowledge base, including articles, tutorials, videos, and other resources that cover a range of topics related to using Smartsheet.Content Center Articles and guides about project management, collaboration, automation, and other topics to help you make the most of the Smartsheet platform.If you wish to track multiple properties on in spreadsheet, see the products in section below. This spreadsheet is designed for Single Properties. There is even an option to track occupancy stats by specific months. Compare your revenue by month or year, using the Annual Statement report. Use the interactive dashboard to track all your financials with dynamic graphs and easy to read statistics. For example, track income from other platforms such as VRBO, etc. Find fully customisable lists for the categories you want to track. Its a personal monthly budget template with spots for all income you receive, and the expenses are grouped by category. 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. 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 is the Single Property Spreadsheet which is ideal for hosts with just the one property. First, setup a new tab in your Airbnb Spreadsheet calculator and call it revenues. So if you don’t want to start your own from scratch, you will love mine! The Basic personal budget spreadsheet helps you analyze complete yearly income and expense data. 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. In the screenshot above, I have used the function SUM(B9:B12) to add all the monthly expenses and generate the total monthly expense for property 1.Then, I dragged the function forward to all other cells using the fill handle.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. First, setup a new tab in your Airbnb Spreadsheet calculator and call it revenues.