Australian Net Worth Tracker: Why Spreadsheets Are Failing You

If you're reading this, you probably already have a spreadsheet. Maybe it's a Google Sheet with colour-coded tabs. Maybe it's an Excel workbook you started three years ago and keep meaning to tidy up. Either way, the fact that you're tracking your net worth at all puts you ahead of most Australians.

But your spreadsheet has limits. And if you're honest with yourself, you already know what they are.

Key takeaways

• Spreadsheets go stale the moment you close them. Your net worth figure is only accurate on the day you update it.
• CGT tracking in a spreadsheet breaks once you have multiple purchases, DRP reinvestments, or stock splits. The ATO expects FIFO parcel-level records. One mistake compounds across every future calculation.
• No spreadsheet covers everything -- shares, super, property, crypto, RSUs, and liabilities -- without becoming an unmanageable monster.
• Currency conversion, Australian tax brackets, and Medicare Levy calculations add fragile formula chains that silently break.
• A purpose-built Australian net worth tracker does all of this automatically, and gives you time back every week.

The spreadsheet problem

Spreadsheets are not the enemy. They were the best tool available for a long time. But the reality is that personal finance in Australia has gotten complex enough that spreadsheets create more problems than they solve.

Here are the five ways they fail.

1. Prices go stale

You update your spreadsheet once a week. Maybe once a month if life gets busy. Between updates, your net worth figure is wrong. Not catastrophically wrong, but wrong enough that the number you're looking at doesn't reflect reality.

If you hold VAS, IVV, and a handful of ASX stocks, that's potentially dozens of price points that shift every trading day. Add in US-listed ETFs and crypto, and you're looking at prices that move around the clock. Your spreadsheet captures a snapshot. It never captures the trend.

Some people set up GOOGLEFINANCE() formulas to pull live prices. This works until it doesn't -- Google's data has delays, gaps, and occasional outright errors. And it still can't handle the full picture: superannuation balances, property estimates, and liabilities don't have a ticker symbol.

2. CGT is a nightmare

This is where spreadsheets truly fall apart. Australian CGT rules require you to track every individual parcel of shares: the date you bought, the exact cost base (including brokerage), and whether you've held for 12 months to qualify for the 50% discount.

If you bought VAS in March 2023, July 2023, and January 2024, then sold half your units in April 2025, you need to apply FIFO (first in, first out) to determine which parcels you're selling. Each parcel has a different cost base and a different discount eligibility. The ATO expects this level of detail.

Now add dividend reinvestment plans (DRP). Every quarterly DRP creates a new parcel with its own cost base and acquisition date. If you've been reinvesting dividends on three ETFs for five years, you could have 60+ individual parcels to track. One formula error and your CGT calculation is wrong -- and that error carries forward into every subsequent sale.

Stock splits and corporate actions make it worse. A spreadsheet has no mechanism to automatically adjust your cost base when a 5:1 split happens. You have to catch it, understand the adjustment, and manually update every affected row.

3. No single source of truth

Most spreadsheet users end up with their finances scattered across multiple tabs, files, or even different apps:

• Shares and ETFs in one tab
• Superannuation balance copied from your fund's website into another tab
• Property value as a rough estimate somewhere
• Crypto on a separate tracker (or not tracked at all)
• Liabilities -- mortgage, HECS-HELP, car loan -- in yet another place
• RSU vesting schedules in a completely different spreadsheet

Your net worth is the sum of all of these. But when they live in different places, updated at different frequencies, with different levels of accuracy, the total is always approximate. You never have one number you can trust.

4. Currency conversion is manual

If you hold US-listed ETFs like IVV, VGS (which tracks international stocks), or individual US stocks, you need the AUD value -- not the USD price. The same applies to RSUs from a US-listed employer.

In a spreadsheet, this means maintaining an AUD/USD exchange rate cell and remembering to update it. For CGT purposes, you need the exchange rate on the date of purchase and the date of sale -- not today's rate. That's historical FX data you have to look up manually for every transaction.

Get the rate wrong and your cost base is wrong. Your capital gain is wrong. Your tax estimate is wrong.

5. Tax calculation is error-prone

Australian tax has layers. PAYG income tax uses progressive brackets. The Medicare Levy adds 2% above the threshold. HELP/HECS repayments kick in at certain income levels. Capital gains get added to your taxable income and taxed at your marginal rate -- after applying the 50% discount if eligible.

Building all of this into a spreadsheet is possible. Keeping it accurate when tax brackets change (as they did with Stage 3 tax cuts in FY2024-25) is a maintenance burden. One stale bracket in your formula and your estimate could be off by thousands of dollars. You won't know until you lodge your return and get a surprise.

Try our free Australian CGT calculator to see what a proper tax engine looks like.

What spreadsheets do well

Credit where it's due. Spreadsheets have real advantages:

• Flexibility. You can model anything. Custom scenarios, one-off calculations, projections that no app will ever support.
• Privacy. Your data stays on your machine. No third-party account required.
• No subscription. Google Sheets is free. Excel is a one-time purchase (or bundled with Microsoft 365 you're already paying for).
• Full control. Every formula is visible. Every assumption is explicit. You own the logic.

These are genuine strengths. The question is whether they outweigh the cost of maintaining accuracy across every asset class, every tax rule, and every currency conversion -- week after week, year after year.

The alternative landscape

If spreadsheets are limited, what about existing apps? The Australian market has options, but none of them cover the full picture.

Sharesight is the most popular portfolio tracker in Australia. It handles share and ETF tracking well, with automatic dividend recording and basic CGT reports. But the CGT reports sit behind their Expert or Premium plans ($29-$48/month). More importantly, Sharesight only tracks listed investments. It has no concept of net worth -- no super, no property, no crypto, no liabilities, no FIRE planning. It's a portfolio tracker, not a financial dashboard.

Pocketsmith is a budgeting app that connects to Australian bank feeds. It's strong on cashflow and spending categories but weak on investments. It can show your bank balances but has no understanding of share parcels, CGT, or investment performance. If your goal is tracking net worth across asset classes, it leaves too many gaps.

US-focused apps like Personal Capital (now Empower), Mint (now discontinued), and YNAB are built for the American market. They don't understand Australian tax brackets, the 50% CGT discount, Medicare Levy, HECS-HELP repayments, or superannuation. They connect to US brokerages, not Australian ones. They're a poor fit.

The gap in the market is clear. No single tool covers all asset classes, with Australian tax logic, CGT parcel tracking, and FIRE planning, in one place.

What an Australian net worth tracker should do

Based on everything above, here's what the ideal tool looks like:

• Track all asset classes -- cash, ETFs, stocks, crypto, property, superannuation, RSUs, liabilities, and other assets. One dashboard, one number.
• Live prices from ASX, NASDAQ, NYSE, and crypto markets. Updated automatically, not when you remember to copy-paste.
• Automatic CGT calculation with FIFO parcel matching, 50% discount eligibility, cost base adjustments for brokerage, and DRP parcel tracking. Audit-ready for the ATO.
• Australian tax engine -- PAYG income tax at current FY2024-25 brackets, Medicare Levy, HELP repayments, and capital gains integrated into your marginal rate.
• Currency conversion handled automatically. US-listed holdings show both native price and AUD value. Historical FX rates applied to CGT calculations.
• FIRE calculator built from your real data, not hypothetical inputs. Your actual net worth, your actual spending, your actual trajectory.
• Daily snapshots so you can see your net worth trend over time -- not just today's number.

Worked comparison: spreadsheet vs tracker

Here's what a typical week looks like for someone tracking their finances in a spreadsheet versus using a dedicated tracker.

Spreadsheet (30-60 minutes per week):

1. Open the spreadsheet. Notice you haven't updated it in 10 days.
2. Look up current prices for 8 holdings across ASX and NASDAQ. Copy-paste each one.
3. Check the AUD/USD rate. Update the conversion cell.
4. Log in to your super fund. Copy the current balance.
5. Eyeball your mortgage balance from your banking app. Update the liability tab.
6. Realise you forgot to add the DRP units from last quarter. Create new rows, look up the reinvestment price and date.
7. Check if your CGT formulas still work after adding those rows. They don't. Spend 15 minutes debugging a VLOOKUP.
8. Finally look at the total. Wonder if it's right.

Dedicated tracker (2 minutes per week):

1. Open the dashboard. All prices are current. Net worth is already calculated.
2. If you made a new purchase, enter the transaction. Everything else updates automatically.
3. Done.

The difference is not just time. It's confidence. With a spreadsheet, there's always a nagging question: did I get that formula right? With a tracker built for Australian tax rules, the logic is tested and consistent.