monthly rental property expense spreadsheet

MONTHLY RENTAL PROPERTY EXPENSE SPREADSHEET HOW TO
MONTHLY RENTAL PROPERTY EXPENSE SPREADSHEET PLUS
MONTHLY RENTAL PROPERTY EXPENSE SPREADSHEET DOWNLOAD

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.

MONTHLY RENTAL PROPERTY EXPENSE SPREADSHEET 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. The sections covered under expenses include finance charges, rents, rates and ground rents, insurances, maintenance and repair costs, fixtures and fittings and furniture costs, wages and service costs, travel costs and a whole host of miscellaneous costs, including space to record any we haven't suggested.First, setup a new tab in your Airbnb Spreadsheet calculator and call it revenues. These allowable expenses can be deducted from your overall tax liability if these items have been used for business purposes. The rows on the left-hand side of the spreadsheet act as a great guide to allowable expenses. This spreadsheet is the prefect way for landlords to prepare for their tax returns. Using the income and expense spreadsheet for tax preparation To make sure essential formulas don’t get deleted or overwritten by accident all the cells have been locked (apart from the ones you should enter details into). Here you can enter the details of your income and expenditure.

MONTHLY RENTAL PROPERTY EXPENSE SPREADSHEET HOW TO

The first tab of the spreadsheet contains instructions on how to access the income and expense sections of the tracker and a guide to the different sections of the spreadsheet.

MONTHLY RENTAL PROPERTY EXPENSE SPREADSHEET DOWNLOAD

Simply download and open your spreadsheet and you should be able to use it straight away. The income and expense spreadsheet has been built with ease of use in mind. How to use the income and expense spreadsheet The free spreadsheet automatically calculates your profitability and cashflow and works out your tax liability as you go along. This income and expense tracker makes tax preparation for landlords much easier by helping you to monitor and record the income and expenditure of your property business.

The spreadsheet is easy to use and flawless in its execution. Why download the rental income and expense tracker?

Monthly rental property expense spreadsheet