Your Cart
Loading

Rental Property Income and Expense Tracker Australia | Investment Property, July–June FY Summary | Landlord Spreadsheet

On Sale
A$14.95
A$14.95
Added to cart

Keep your rental property records tidy all year. Log rent and every expense (agent fees, rates, strata, insurance, repairs, interest) against up to 5 properties. The FY summary shows July–June income, expenses and net by month and category, filtered by property.


WHAT'S INSIDE

- Settings: financial year, up to 5 property names, editable income and expense categories (15 starter expense categories).

- Income: 500 rows for date, description, property, category, amount and from whom.

- Expenses: 500 rows with property, category, 'possibly deductible?' and receipt flags.

- FY Summary: monthly income, expenses and net, category totals, flagged totals, property filter and chart.


WHAT YOU GET

- 1 × .xlsx spreadsheet file (instant digital download — nothing is posted)

- Instructions tab inside the file

- Example data in yellow cells so you can see how it works; select and delete to clear


COMPATIBILITY

Works in Microsoft Excel 2016 or later and Microsoft 365 (Windows/Mac), and Google Sheets (upload to Drive and open with Sheets; set File > Settings > Locale to Australia for dd/mm/yyyy dates). Also opens in LibreOffice Calc. No macros, add-ins or sign-ups. Best on a computer or tablet. Amounts in AUD. Compatibility is based on formula checks and LibreOffice testing; chart colours and some conditional formatting can look slightly different in Google Sheets.


HOW TO USE

1. Download the `.xlsx` from your Payhip library / purchase email after checkout.

2. Open it in Excel, or upload it to Google Drive and open with Google Sheets.

3. Open the Instructions tab first. Yellow cells are example data — select and delete them, then add your own.


PLEASE NOTE

Digital download: you get the file straight after purchase, so we can't accept returns once it's been delivered. If the file won't open or a formula is broken, message us and we'll help or replace it. This doesn't reduce your rights under Australian Consumer Law. For personal use — please don't resell or share the file.

Colours on screen may vary slightly. Listing images show the actual file with example data.


DISCLAIMER

Depreciation, borrowing costs, capital works and apportionment have special rules. This tracker only records what you paid and received. This spreadsheet is general information and an organising tool only — not financial or tax advice. It does not calculate income tax, and it doesn't decide what you can claim. Check your own circumstances and talk to a registered tax agent or licensed adviser if needed.

You will get a XLSX (35KB) file