Investment Property Spreadsheet Guide

An investment property spreadsheet helps Australian property investors track rental income, expenses, deductions, and tax outcomes in one place. If you are searching for an “investment property spreadsheet australia” solution, this guide compares free tools, each common investment property spreadsheet template option, and premium models with ATO-aligned categories. You can use our free web calculators for quick estimates or the premium spreadsheet for comprehensive property tracking with multi-year projections.

Best investment property spreadsheet Australia option: quick answer

If you want fast scenario checks, start with free web calculators first. They are the quickest way to test rental income, expenses, and tax outcomes with no setup. If you need ongoing planning, sharing with your accountant, and multi-year modelling, an editable investment property spreadsheet template is usually the better fit.

Published competitor pricing pages currently show personal-use Excel tiers at $59, $99, and $199, while TaxTank’s software page states pricing starts from $6/month. This means format, sharing, and total ownership cost usually matter more than headline price alone when comparing options (NegativeGearingCalculator, InvestmentPropertyCalculator, TaxTank, accessed 27 Feb 2026).

What should an investment property spreadsheet track?

A comprehensive investment property spreadsheet for Australia should cover five areas: income, expenses, depreciation, capital items, and the resulting tax position.

Rental income

• Gross rent received (including any rent paid by tenants in advance)
• Bond amounts received and returned
• Insurance payouts related to the property
• Any other income derived from the property

Deductible expenses

These are the costs you can generally claim as tax deductions in the year they are incurred:

Depreciation

Depreciation is tracked separately because it is a non-cash deduction:

• Division 43 — building construction at 2.5% per year (40-year life, buildings constructed after 15 September 1987) (ATO — Capital works deductions (Div 43))
• Division 40 — fixtures, fittings, and plant at varying rates (ATO — Depreciating assets in rental properties). For properties purchased after 9 May 2017, only new items you install are generally eligible for Div 40 (ATO — Second-hand depreciating assets (depreciation section))

A quantity surveyor’s depreciation schedule is generally required to claim these deductions. The ATO states the fee for obtaining a construction-cost estimate can be deductible (ATO — Capital works deductions (Div 43)). One published provider guide reports depreciation schedules typically range from $385 to $770, with $590 to $770 common for established residential homes (pricing varies by provider and property) (Washington Brown, accessed 27 Feb 2026).

Capital items for CGT

When you eventually sell, you need a clear record of your cost base:

• Original purchase price
• Stamp duty paid
• Legal and conveyancing fees (purchase and sale)
• Capital improvements (not repairs)
• Selling agent commission and marketing costs
• Any Division 43 depreciation claimed (reduces cost base)

Tax position summary

The spreadsheet should calculate:

• Net rental income or loss
• Negative gearing tax saving based on marginal rate
• After-tax weekly holding cost
• Estimated CGT position if selling at a given price

An investment property spreadsheet should calculate:

1. Negative gearing tax savings (rental loss × marginal tax rate)
2. Capital gains tax on disposal (cost base, 50% discount)
3. Land tax by state (all 8 jurisdictions)
4. Depreciation deductions (Div 43 building + Div 40 plant)
5. Rental yield (gross and net)
6. After-tax cash flow (weekly out-of-pocket cost)

Investment property spreadsheet template options in Australia (5 compared)

Australian property investors have five main options for tracking their investment property finances. Each suits a different situation and budget. The following comparison covers the key trade-offs.

Published pricing benchmarks (as checked 27 Feb 2026)

Prices and feature bundles can change, so verify current pricing on each provider’s page before purchase.

Best free option for quick estimates: The Property Tax Tools web calculators cover negative gearing, CGT, land tax, rental yield, and depreciation with current ATO rates and no login required. This option suits investors who want fast scenario checks before deciding whether to build or buy a full spreadsheet model.

Best value for property investors who want editable modelling: The Google Sheets Pro tier at $24.99 includes all states, 3-property comparison, 10-year projections, and hold-vs-sell analysis. Against currently published $59-$199 personal-use Excel tiers on major competitor pages, this is a lower upfront price point with editable assumptions and link sharing.

Best for sharing with your accountant: Google Sheets. Send a secure link with view or edit access and your accountant can review your categories, formulas, and assumptions directly in-browser. This avoids password-locked files, version confusion, and repeated exports when you update figures during tax planning.

Best for ongoing property management: SaaS platforms with automated bank feeds. Most investors use SaaS or their property manager for day-to-day transaction capture, then use a spreadsheet for annual tax planning, hold-vs-sell checks, and multi-year scenario modelling where assumptions are easier to audit and adjust.

Looking for the best investment property spreadsheet Australia option? Use free calculators for quick checks, a DIY template only if you can maintain formulas each financial year, and an editable Google Sheet if you need multi-property modelling, tax assumptions, and accountant collaboration in one place.

Investment property spreadsheet Excel setup: build your own in 4 tabs

If you prefer to build your own investment property spreadsheet, here is what you need. A functional template requires at least four tabs and several formula sets that reference Australian tax rules.

If you want an investment property spreadsheet excel setup, the same worksheet structure can be built in Microsoft Excel or Google Sheets.

Tab 1 — Income and expenses. Track monthly or quarterly rental income, vacancy periods, and every deductible expense category (see the expense table above). Sum annually for your tax return.

Tab 2 — Depreciation schedule. Division 43 is straightforward (construction cost × 2.5%), but Division 40 requires per-item tracking with effective life, diminishing value or prime cost method, and the post-May 2017 second-hand restriction. The ATO publishes effective life tables that run to hundreds of asset types.

Tab 3 — Tax calculation. This is where DIY spreadsheets typically break. You need the current income tax brackets (5 brackets for 2025-26), Medicare levy (2%), LITO phase-out formula, and state-specific land tax thresholds (8 different rate structures across AU). A single bracket error changes your negative gearing saving by hundreds of dollars.

Tab 4 — CGT and cost base. Track every capital item (purchase price, stamp duty, legal fees, improvements) and subtract cumulative Div 43 depreciation claimed. Apply the 50% CGT discount for holdings over 12 months.

The honest assessment: Building a basic income-and-expense tracker in Excel takes 1-2 hours. Building accurate negative gearing calculations with correct tax brackets takes significantly longer, and the formulas must be updated every financial year when ATO rates change. If you want multi-property comparison or multi-year projections, the complexity increases further. The premium spreadsheet has all of this pre-built with 2025-26 rates.

ATO rental property schedule — what you need for your tax return

The ATO requires specific information about each rental property you own (ATO — Residential rental properties). Your tax return (or your agent’s preparation) will need:

1. Address of the rental property
2. Your share of ownership (e.g. 50% if jointly owned)
3. Number of weeks rented or available for rent
4. Gross rent received for the financial year
5. Itemised deductible expenses by category
6. Capital works deductions (Div 43 amount)
7. Net rental income or loss (rent minus total deductions)

The ATO’s rental property schedule requires these in specific categories. Using a spreadsheet that aligns with these categories makes tax time significantly easier — whether you lodge yourself or hand the numbers to your accountant.

Record keeping: The ATO requires you to keep records of rental income and expenses for at least 5 years from the date you lodge your return. Digital records (spreadsheets, scanned receipts, bank statements) are acceptable.

Free tools vs premium spreadsheet

View all tiers and pricing

Need the official schedule-style format first? Start with the ATO rental property worksheet for structured income-and-expense capture, then move to the premium model for projections.

How the premium spreadsheet helps

The Property Tax Tools property investment spreadsheet includes:

• All expense categories pre-built — every standard ATO rental property deduction category is included
• Depreciation tracking — full Division 43 and Division 40 schedules with automatic calculations
• Multi-property support — track up to 5 properties in one file (Complete tier)
• Multi-year projections — model how your cash flow and tax position change over 10 or 30 years
• Hold vs sell analysis — see your estimated CGT and compare it to continued holding
• Share with your accountant — send a Google Sheets link for direct review
• 2025—26 ATO rates — all tax brackets, Medicare levy, LITO, and state land tax rates built in

All tiers include a getting-started guide with step-by-step instructions, and the Complete tier includes lifetime updates when rates change.

Common mistakes when tracking investment property finances

1. Claiming principal repayments as a deduction

Only the interest portion of your mortgage repayment is generally deductible. The principal reduces your loan balance but is not a tax deduction. Check your loan statement to separate interest from principal.

2. Confusing repairs with improvements

A repair restores something to its original condition and is immediately deductible. An improvement makes it better than the original and must be depreciated over time. Replacing a broken tap is a repair. Replacing a standard kitchen with a premium kitchen is an improvement.

3. Missing depreciation deductions

Depreciation is a non-cash deduction, meaning there is no out-of-pocket expense. It can add thousands of dollars to annual deductions, particularly on newer properties. A quantity surveyor’s depreciation schedule is generally required to claim it.

4. Not apportioning shared expenses

If you own a property jointly (e.g. 50/50 with a partner), you can only claim your share of the expenses. Similarly, if your loan was used partly for personal purposes, only the investment portion of the interest is deductible.

5. Forgetting that Div 43 depreciation reduces your CGT cost base

Building depreciation (Division 43) that you have claimed — or could have claimed — reduces your cost base when you sell. This means your capital gain will be larger than you expect if you do not factor this in. Track cumulative Div 43 claims carefully.

6. Poor record keeping

The ATO can request records up to 5 years after you lodge. If you cannot substantiate a claim, the deduction can be disallowed and penalties may apply. Keep receipts, bank statements, rental statements, and loan statements organised by financial year.

Free calculators

The following web-based calculators provide quick estimates:

• Investment property calculator — all-in-one overview of your property’s financial performance
• Negative gearing calculator — detailed after-tax holding cost
• Capital gains tax calculator — estimate CGT when selling
• Land tax calculator — compare land tax across all states and territories
• Rental yield calculator — gross and net rental yield
• Property depreciation calculator — estimate Division 40 and Division 43 deductions

The premium spreadsheet adds multi-property comparison, multi-year projections, and ATO-aligned expense tracking in one workbook.

Frequently asked questions

What should an investment property spreadsheet track?

An investment property spreadsheet should track all rental income received, every deductible expense by ATO category (interest, rates, insurance, management fees, repairs, depreciation, land tax, body corporate), capital items that affect your CGT cost base, and the resulting tax position including negative gearing savings and after-tax holding cost.

Is there a free investment property spreadsheet for Australia?

Our free web-based calculators cover negative gearing, CGT, land tax, and rental yield using current 2025—26 ATO rates. For a comprehensive downloadable spreadsheet with multi-property tracking, multi-year projections, and ATO-aligned expense categories, the premium Google Sheets spreadsheet starts at $14.99.

What does the ATO require for rental property records?

The ATO requires records of all rental income received and every expense claimed as a deduction. Records must be kept for at least 5 years from the date you lodge your return. Acceptable records include receipts, bank statements, loan statements, rental statements from your property manager, and depreciation schedules from a quantity surveyor.

Can I share the spreadsheet with my accountant?

Yes. The spreadsheet is a Google Sheet, so you can share a secure view or edit link with your accountant. They can review categories, calculations, and assumptions directly in the file, leave comments, and avoid back-and-forth spreadsheet version issues. The expense categories align with standard ATO rental property schedule items.

Does the spreadsheet handle capital gains tax?

Yes. The Pro and Complete tiers include hold-vs-sell analysis that estimates your CGT liability based on the original purchase price, cost base adjustments (including Div 43 depreciation claimed), holding period, and the 50% CGT discount for properties held over 12 months.

How do I know which expenses are deductible?

The ATO provides a detailed list of deductible rental expenses. Common deductions include loan interest, depreciation, property management fees, council rates, water charges, insurance, repairs (not improvements), land tax, and body corporate fees. The spreadsheet includes all standard expense categories with labels indicating which are deductible. For advice specific to your situation, consult a registered tax agent.

Can I track multiple investment properties in one spreadsheet?

Yes. The Pro tier supports up to 3 properties and the Complete tier supports up to 5. Each property is tracked separately with its own income, expenses, depreciation schedule, and state-specific land tax calculation. The Complete tier also includes portfolio-level summaries.

Is the spreadsheet updated for new financial years?

Complete tier customers receive lifetime updates when ATO rates change each financial year. Starter and Pro customers can still update rates manually using the clearly labelled rates tab, so the model remains usable even if you prefer to maintain rates yourself.

What is the best free investment property spreadsheet for Australia?

Free web-based calculators from Property Tax Tools cover negative gearing, CGT, land tax, rental yield, and depreciation using current 2025-26 ATO rates with no login required. For a downloadable template, you can build your own in Google Sheets, though you will need to maintain the tax rate formulas yourself each financial year.

Can I use Excel to track my investment property?

Yes. Excel can track investment property income and expenses. However, you need to build and maintain formulas for negative gearing calculations, state-specific land tax thresholds, depreciation schedules, and CGT cost base tracking. Errors in tax bracket formulas are common in DIY spreadsheets. Google Sheets offers the same functionality with easier sharing via link.

How much does an investment property spreadsheet cost?

Free web calculators provide quick estimates at no cost. DIY spreadsheets are free but take time to build and maintain. Paid templates are usually one-time purchases and can vary widely by feature depth. Our Google Sheets tiers are $14.99 (Starter), $24.99 (Pro), and $39.99 (Complete).

Is a spreadsheet or SaaS software better for investment property?

A spreadsheet is better for analysis, planning, and sharing with your accountant — it is a one-time purchase with full control over your data. SaaS software is better for year-round bookkeeping with automated bank feeds. Most investors use a spreadsheet for annual tax planning and projections, and their property manager or accounting software for day-to-day transaction tracking.

Disclaimer

This page is general information only and is not tax advice, financial advice, or a recommendation to buy, sell, or hold any investment property. Tax outcomes depend on your personal circumstances and tax rules can change. The ATO is the authoritative source for current rules and rates. Consider speaking with a registered tax agent or accountant for advice specific to your situation.