Investment property tax spreadsheet
Keep track of your investment property income and expenses with our downloadable spreadsheet.
We’re reader-supported and may be paid when you visit links to partner sites. We don’t compare all products in the market, but we’re working on it!
Investing in property has plenty of tax advantages, but you have to know what information to provide in order to benefit from them. When tax time rolls around, your accountant will need a full rundown of your expenses and income relating to your investment property. Keeping track of everything throughout the year will make tax time much less stressful for both you and your accountant.
You’ll need to provide your accountant some basic information regarding your investment property, such as the address, the number of days during the tax year that the property was rented and any assets you’ve sold or purchased for the property. In addition to this, you’ll need to provide a list of expenses related to the property, and the income you’ve earned from it.
You can keep track of everything by downloading the spreadsheet below.
Your expenses and income can fall into several different categories.
The old adage that you have to spend money to make money is certainly true when it comes to property investment. Throughout the tax year, you may have a variety of costs related to your property.
Purchase costs are only relevant for the tax year in which you purchase your investment property. However, if you purchased your property in the current tax year, you can deduct expenses for:
- Stamp duty
- Mortgage registration and transfer
- Building and pest inspections
- Solicitor and conveyancing fees
If you incurred any other expenses related to the purchase of your investment property, make sure to record them, even if you’re uncertain whether or not they’re relevant. Your accountant will be able to sort through and find the deductions.
Home loan costs
Investors receive generous tax treatment when it comes to home loan expenses. While owner-occupiers can’t deduct their mortgage interest from their taxes, investors can. Here are some of the home loan costs you can deduct:
- Home loan interest
- Home loan fees
- Lenders mortgage insurance (LMI)
You should be able to find all the expenses related to your home loan on your monthly statement. Most lenders will also issue an end-of-financial-year statement with a rundown of all the interest charges and fees throughout the financial year.
One of your primary jobs as a landlord is to keep your property in good working order for your tenants. Fortunately, the costs associated with the upkeep of your property are deductible. You can deduct:
- Cleaning fees
- Pest control fees
- Gardening fees
- Renovation costs
It’s worth noting that the Australian Tax Office (ATO) treats repairs differently than it treats renovations that improve a property. You can learn about the differences here.
In addition to repairs and maintenance, there are a variety of costs associated with running an investment property. You can deduct expenses such as:
- Council rates
- Water rates
- Strata fees
- Property management and letting fees
- Building insurance
- Landlord insurance
- Land tax
You can also deduct some miscellaneous expenses, such as travel to and from your investment property, and stationary and postage relating to your investment property.
Your accountant will also need to know the income you receive from your investment property, which should be relatively easy to calculate. Your property manager will have a statement of rental income you’ve received. The only other income you’re likely to receive from your investment property is water usage you charge to your tenants, and any insurance policy claims that are paid out during the tax year.
Adding it all up
Once you have a detailed picture of all the expenses and income relating to your investment property, you should be able to get an idea of your cashflow for the tax year. Your cashflow will be your income minus your expenses.
In addition to expenses, you can also deduct depreciation of the building and certain items you’ve bought for your property. These items include anything likely to experience wear and tear over time, such as appliances, carpets and curtains. However, you should note that the items must be ones you purchased, and not items purchased by a previous owner of the property.
You can learn more about depreciation here.
More guides on Finder
Binance vs Coinbase: Which is best for you?
Binance and Coinbase are two titans of cryptocurrency – let's see how the two stack up and find out which suits your needs.
He’s a bit of a fixer-upper: 4 in 5 first home buyers intend to renovate
First home buyers are getting practical with different tactics to enter the property market, according to new research by Finder, Australia’s most visited comparison website. A new survey has revealed that 1 in 5 (22%) first home buyers plan to renovate immediately after purchasing. Finder shares tips for sticking to your renovation budget.
How to invest in the Didi Chuxing IPO from Australia
Everything we know about the Didi Chuxing IPO, plus information on how to buy in.
Savings account statistics 2021
Did you know that the average Australian has $29,091 in savings? Learn about this and more in our savings stats report.
From down payment to dealbreaker: Average house deposit now exceeds $100k
Aspiring homeowners now need a six-figure house deposit to purchase a property, according to staggering new research by Finder, Australia’s most visited comparison site.
Coles No Annual Fee Mastercard – Exclusive Offer
Enjoy 10,000 bonus points and 12 months interest-free on balance transfers and purchases. Plus, an ongoing $0 annual fee.
Finder’s RBA Cash Rate Survey: 60% of experts blame BNPL for drop in credit cards
Credit cards are being used less and experts say Buy Now Pay Later services such as Afterpay and Zip are to blame, according to new research from Finder. In this month's Finder RBA Cash Rate Survey™, 39 experts and economists weighed in on future cash rate moves and other issues related to the state of the Australian economy.
First home buyer skips Sydney property for half-price regional home
With frenzied auctions and properties selling fast, first home buyers have to be proactive and resourceful to get on the property ladder.
Non-conforming home loans guide
Imperfect credit? A non-conforming loan might help you become a home owner.
Body corporate fees
What exactly are body corporate fees and what do your quarterly fees go towards?
Ask an Expert