ATO Rental Property Worksheet Excel | Google Sheets

Looking for an ATO rental property worksheet Excel template? This is the Starter Google Sheets option for Australian property investors who want one clean place to track rental income, property expenses, depreciation notes, and year-end figures for accountant handover without building their own workbook.

If you arrived here searching for a rental property expenses spreadsheet or rental property record-keeping spreadsheet, this worksheet is usually the first fit for one-property tax-time records. The rental property expenses spreadsheet guide compares it with the full model if you are unsure.

Use it as a one-property rental income and expenses worksheet: maintain the file through the year, then review the summary alongside ATO guidance, myTax, or your registered tax agent. It is an independent template, not an ATO form.

The Starter tier is the fit for this page: one property, one financial year, and worksheet-style records. If you need multi-property projections, land tax across states, CGT sale scenarios, or portfolio summaries, step up to the property investment spreadsheet instead.

If your main problem is a messy tax-time handover, Starter keeps the recordkeeping scope narrow. If you need multi-property projections, land tax, CGT sale scenarios, refinancing assumptions, or hold/sell scenario estimates, compare Pro and Complete on the full property investment spreadsheet.

This is an independent spreadsheet template. It is not an ATO form, not affiliated with the ATO, and not a substitute for myTax instructions or registered tax-agent advice.

What this worksheet is for

The ATO-style rental property worksheet helps you keep the figures that usually matter at tax time in one place:

• rental income received
• common rental-property expenses
• depreciation schedule figures
• net rental profit or loss estimate
• supporting notes for accountant review

Use it when your main problem is not complex modelling. Use it when your problem is simpler and more painful: bank statements, invoices, property manager reports, and depreciation figures are scattered across the year.

What you get in Starter

Starter is the one-property worksheet tier. It is designed for investors who want a clean annual record rather than a portfolio model.

It is built in Google Sheets so you can maintain the file through the year, then share a copy or exported summary at EOFY.

Starter vs the full property spreadsheet

This page targets worksheet intent. That means Starter first.

In short: Starter helps organise what happened during the year. Pro and Complete add broader modelling for multiple properties, longer ranges, and scenario estimates. That keeps Starter as the simpler worksheet option, while Pro is the broader modelling tier when the file needs to cover more than tax-time records.

How it fits the ATO rental-property workflow

At tax time, rental-property owners usually need to pull together:

• rental income statements
• loan interest statements
• rates, water, insurance, strata, and management-fee records
• repairs and maintenance invoices
• land tax records, where relevant
• depreciation schedule figures
• notes for unusual items, such as vacancies or insurance claims

The worksheet does not replace the ATO instructions. It gives you a structured place to maintain the numbers before lodgement, so you are not rebuilding a full year from memory.

Month-by-month recordkeeping workflow

The worksheet works best when it is updated through the year rather than rebuilt in June.

Each month

• Enter rent received or reconcile against the property manager statement.
• Add new expenses under the closest worksheet category.
• Keep notes for unusual expenses or one-off events.
• Save links or references to receipts, invoices, and statements.

Each quarter

• Check loan interest totals against lender statements.
• Review repair entries and flag anything that may need accountant review.
• Update vacancy notes if the tenancy changed.
• Check that supporting documents are stored where you can retrieve them.

At financial year end

• Confirm annual rental income totals.
• Confirm expense category totals.
• Enter or review depreciation schedule figures.
• Export or share the summary with your accountant.

This cadence reduces the EOFY scramble and makes the file easier to review.

Common worksheet categories

The Starter worksheet includes categories investors commonly need to review for rental-property records, including:

• loan interest
• council rates
• water charges
• insurance
• property management fees
• repairs and maintenance
• body corporate or strata fees
• land tax
• advertising for tenants
• cleaning, gardening, pest control, and similar property costs
• stationery, postage, and recordkeeping notes
• Division 43 capital works depreciation
• Division 40 plant and equipment depreciation

Whether a specific cost is deductible depends on the facts. Use the worksheet to organise records, then confirm treatment through ATO guidance or your registered tax agent.

Worked example: one rental property at tax time

Suppose an investor owns one Brisbane rental property and keeps the worksheet updated during the year.

Inputs captured during the year:

• Weekly rent: $690
• Vacancy: 2 weeks
• Loan interest: $27,400
• Council rates: $2,240
• Water charges: $1,020
• Insurance: $1,740
• Management fees: $2,720
• Repairs and maintenance: $2,150
• Land tax: $0 in this example
• Division 43 depreciation: $5,200
• Division 40 depreciation: $2,300

Worksheet output:

1. Annual rent estimate: $690 x 50 = $34,500
2. Total expense and depreciation entries: $44,770
3. Net rental result estimate: -$10,270
4. Tax-effect estimate based on the salary and tax settings entered
5. Summary figures for review before lodgement

The point is not that every investor has the same numbers. The point is that the categories are separated before tax time, so review is faster and less dependent on memory.

Accountant handover checklist

At EOFY, send your accountant the worksheet summary plus supporting records.

1. Worksheet summary tab or exported PDF
2. Property manager annual statement
3. Loan interest statement
4. Council, water, insurance, and strata/body corporate records
5. Repairs and maintenance invoices
6. Depreciation schedule
7. Notes on unusual items, such as vacancy, insurance claims, refinancing, or major repairs

This gives your accountant a clearer starting point. They still need to review treatment and lodgement details, but they are not starting from a pile of unrelated documents.

Common mistakes this worksheet helps reduce

1. Rebuilding the year from memory

If records are only gathered at EOFY, smaller expenses are easy to overlook and unusual items are harder to explain. A maintained worksheet keeps the timeline visible.

2. Mixing personal and rental-property costs

Rental records are easier to review when property-only expenses are kept separate from personal spending.

3. Forgetting low-frequency costs

Annual insurance, quarterly rates, body corporate levies, and land tax notices can be missed when they are not entered as they arrive.

4. Losing depreciation context

Division 43 and Division 40 figures can affect annual tax work and future sale-year calculations. Keeping them in the same worksheet reduces later confusion.

5. Relying only on calculator snapshots

One-off calculators are useful for estimates. Tax-time records need a maintained annual file.

Try the free calculators first

If you are still checking rough numbers, start with the free calculators:

• Negative Gearing Calculator - estimate the net rental loss and tax-effect context
• Property Depreciation Calculator - estimate Division 40 and Division 43 deductions
• Rental Yield Calculator - check gross and net rental yield
• Investment Property Calculator - combine common property inputs in one calculator

When you move from estimates to year-round records, the worksheet keeps the income, expenses, depreciation notes, and EOFY summary together.

When Starter is enough

Starter is usually enough when you have:

• one rental property
• one financial year to organise
• a need for clean tax-time records
• an accountant or myTax workflow that needs annual figures
• no need to compare multiple properties or long projection periods

It is deliberately simpler than the full product. That is the advantage if your main job is recordkeeping.

When to step up to Pro or Complete

Move beyond Starter when your questions shift from recordkeeping to scenario modelling.

Pro or Complete is a better fit if you want to:

• track multiple rental properties
• compare properties across states
• include land tax and CGT sale scenarios
• project cash flow beyond the current financial year
• keep portfolio summaries in one file

If that sounds closer to your situation, start with the property investment spreadsheet instead. Pro is the usual step-up from this worksheet because it adds up to 3 properties, state land tax, depreciation, and sale-scenario estimates without requiring the larger 5-property Complete tier.

Important notes

This spreadsheet is general information only. It is not tax, legal, or financial advice. It is not an ATO product and does not lodge your return. Tax treatment depends on your facts, ownership structure, timing, and evidence. Check ATO guidance and speak with a registered tax agent for advice specific to your situation.