Key takeaways
- Spreadsheets work for a single property with simple finances, but they fail predictably at depreciation, receipt storage, reminders, and EOFY reporting.
- Missing $3,000 in depreciation deductions because your spreadsheet does not track them means overpaying tax by roughly $1,000 to $1,400 every year.
- Over 90% of large spreadsheets contain errors, and those errors in property finances are invisible until tax time or an ATO audit.
- propkt's Pro plan costs $12 to $15 per month, and for most landlords the depreciation tracking alone pays for that many times over.
- You do not need to migrate historical data to switch; most landlords start fresh at the beginning of a financial year and keep their old spreadsheet as an archive.
Most Australian landlords start with a spreadsheet. It makes sense: you already know how to use Excel or Google Sheets, you can set it up exactly the way you want, and it costs nothing. For a single investment property with straightforward finances, a well-maintained spreadsheet can work just fine. Plenty of experienced landlords have managed successful portfolios for years with nothing more than a carefully structured workbook.
But spreadsheets also fail in specific, predictable ways. And those failures tend to show up at the worst possible time: when you are sitting down to do your tax return, when your accountant asks for a number you cannot find, or when you realise mid-audit that you missed a category of deductions for the past three years.
This is not a hard sell for propkt. It is an honest assessment of where spreadsheets work, where they break down, and what changes when you use a purpose-built tool instead.
What Landlords Actually Track in Spreadsheets
If you have been self-managing for any length of time, your spreadsheet probably looks something like this:
Income tab:
- Date received
- Tenant name
- Amount
- Period covered
- Running total by month and year
Expenses tab:
- Date paid
- Description
- Category (rates, insurance, repairs, interest, etc.)
- Amount
- Receipt reference or note
- Running total by category
Property details tab:
- Purchase price and date
- Settlement costs
- Loan details (lender, balance, rate, offset)
- Agent details (if applicable)
- Insurance policy numbers and renewal dates
Tenant tab:
- Current tenant name and contact
- Lease start and end dates
- Weekly rent amount
- Bond amount and lodgement reference
Some landlords also track depreciation in a separate tab, listing each depreciable asset, its effective life, and the annual deduction. The more organised ones have a summary tab that pulls together the EOFY totals for their accountant.
If this describes your spreadsheet, you are already more organised than most. The question is not whether your spreadsheet is bad; it is whether it is costing you money in ways that are hard to see.
Where Spreadsheets Work
Credit where it is due. Spreadsheets have real advantages for property tracking:
Complete flexibility. You can structure your spreadsheet exactly the way your brain works. If you want a custom summary view or a specific formula that calculates your net yield after all expenses, you can build it. No software product will ever match the flexibility of a blank spreadsheet in the hands of someone who knows what they are doing.
No subscription cost. Google Sheets is free. Excel comes with most Microsoft 365 subscriptions. There is no additional cost for tracking your property finances, no matter how many properties you have.
Offline and portable. You can save your spreadsheet locally, back it up to a USB drive, email it to your accountant as an attachment, and access it without an internet connection. You are not dependent on a third-party service staying online or in business.
Familiar. You already know how to use it. There is no learning curve, no onboarding, and no new interface to figure out. You can start tracking immediately.
These are genuine strengths, and for a landlord with one property and simple finances, they may be enough.
Where Spreadsheets Fail
The problems with spreadsheets are not theoretical. They show up reliably, usually in one of these ways:
Formula errors you do not catch
A mistyped cell reference, a SUM range that does not extend to the last row, a VLOOKUP that silently returns the wrong value. Spreadsheet errors are invisible until you find them, and finding them requires the same level of attention that should have prevented them in the first place. Research from the European Spreadsheet Risks Interest Group consistently finds that over 90% of large spreadsheets contain errors.
For property finances, a formula error might mean you undercount your deductions by a few hundred dollars. Across multiple years, that adds up.
Forgotten expense categories
The ATO allows deductions for dozens of expense categories related to investment properties. Most landlords know about the big ones: interest, rates, insurance, repairs. But how many track stationery and postage costs, telephone expenses related to the property, travel to inspect or maintain the property, or the cost of software they use to manage it? These smaller tax-deductible expenses are easy to forget when you are manually maintaining a list of categories. See our full list of expenses landlords can claim to check what you might be missing.
A purpose-built tool comes with pre-configured ATO categories that remind you what is deductible. A spreadsheet only knows what you tell it.
No depreciation calculations
This is the biggest financial gap. Depreciation on plant and equipment assets (air conditioning, carpet, blinds, hot water systems, dishwashers, ovens) is one of the largest deductions available to investment property owners. But calculating depreciation correctly requires knowing each asset's effective life (as defined by the ATO), applying the right calculation method (diminishing value or prime cost), and updating the figures each year as assets age.
Most landlords' spreadsheets either ignore depreciation entirely (leaving thousands of dollars in deductions unclaimed) or include a static figure copied from a quantity surveyor's report without updating it as they add or replace assets. propkt calculates depreciation dynamically as you add and dispose of assets, using ATO-approved rates.
Lost receipts and missing documentation
A spreadsheet records numbers. It does not store receipts, leases, inspection reports, or insurance certificates. Those documents live in email attachments, camera rolls, filing cabinets, or (most commonly) nowhere in particular. When your accountant asks for proof of a $2,400 plumbing repair from nine months ago, you need to find the receipt. If you cannot, the deduction is at risk.
propkt includes a document vault where receipts and documents are attached to the relevant expense or property. Everything is in one place, searchable, and available when you need it.
No reminders
Spreadsheets do not remind you that a lease is expiring next month, that your landlord insurance renewal is coming up, that it has been six months since the last routine inspection, or that the smoke alarm batteries need replacing before the annual compliance date. These are the tasks that are easy to forget and expensive to miss.
propkt sends automated reminders for recurring property management tasks.
Manual EOFY preparation
At the end of the financial year, a spreadsheet requires you to manually compile your income, expenses, and depreciation into a format your accountant can use. This usually means creating a summary, double-checking totals, printing or exporting the relevant tabs, and writing up explanatory notes. For one property, this might take an hour. For three properties, it can take a full day.
propkt produces a consolidated tax package at the press of a button, categorised, formatted, and ready for your accountant. Use our EOFY landlord checklist to make sure nothing is missed.
No audit trail
If someone changes a number in a spreadsheet (including you, six months ago, for a reason you cannot remember), there is no reliable record of what changed, when, or why. Google Sheets has version history, which helps, but it is not a true audit trail. If the ATO queries a figure, you need to be able to explain and substantiate it.
The Real Cost of a Free Spreadsheet
The irony of using a free spreadsheet is that it often costs you more than paid software. The cost is just hidden.
If you miss $3,000 in depreciation deductions because your spreadsheet does not track them, you are overpaying your tax by roughly $1,000 to $1,400 depending on your marginal rate. Use the free depreciation calculator to see what you could be claiming. That is every single year.
If you spend five hours at EOFY compiling and checking your spreadsheet when a tax package could have been generated in minutes, those hours have a value, particularly if you are a professional earning $50 or more per hour in your day job.
If you miss a deduction category entirely because it was not in your spreadsheet template, or if you fail to keep a receipt that an ATO audit later requests, the cost can be far higher.
propkt's Pro plan costs $12 to $15 per month. For most landlords, the depreciation tracking alone pays for that many times over.
When to Make the Switch
You do not need to switch immediately. But if any of the following apply, it is probably time:
- You own more than one investment property and your spreadsheet is getting unwieldy
- You are not tracking depreciation, or you are relying on a static figure from an old QS report
- You spent more than an hour preparing your property finances for your accountant last EOFY
- You have lost a receipt that your accountant or the ATO asked for
- You are not confident that your expense categories cover everything you can claim
- You have tenants and leases to track alongside your finances
- You want reminders for property management tasks instead of relying on memory
What the Switch Looks Like
Moving from a spreadsheet to propkt is not disruptive. You add your properties, enter your current tenants and lease details, and start logging income and expenses going forward. You do not need to migrate years of historical data, though you can if you want to. Most landlords start fresh from the beginning of a financial year and keep their old spreadsheet as an archive.
The depreciation setup takes a bit more time upfront (you list your depreciable assets with their installation dates and costs), but once it is done, the calculations run automatically each year.
The Honest Assessment
If you have one investment property with simple finances, no depreciable assets to track, and you are comfortable compiling your tax information manually at EOFY, a spreadsheet is fine. You do not need to change what is working.
But if you have depreciable assets (which almost every investment property does), if you want clean EOFY reports without the manual work, if you need to track tenants and maintenance alongside finances, or if you simply want the peace of mind that comes from knowing your records are complete and your deductions are correct, that is where a purpose-built tool earns its keep.
propkt's free plan covers one property with full features. You can try it alongside your existing spreadsheet and see whether it solves a problem you actually have. If it does not, you have lost nothing. If it does, you will wonder why you waited.