A rental property spreadsheet in the ATO's worksheet rows

Free, for Excel or Google Sheets. Version 1.0, November 2026.

Download the spreadsheet

How do I use it?

A receipt unrolling, a line for each thing that comes off the price and a line for what is left

Property

The address, its owners and each owner's share.

Log

A row each time rent comes in or you pay a cost.

Year summary

Each category added up for the financial year you choose.

The documents

Keep the statement or invoice behind each row.

Where do the categories come from?

They are the rows of the blank rental property worksheet in the ATO's Rental properties guide 2026, pages 81 to 82, from rental income to sundry expenses, then the net income or loss and each owner's share.

Or fill it from the documents

Drop in the documents, and the rental schedule fills in, ready for your accountant.

Create account