Net worth tracking without the spreadsheet trap

There was a year, around 2018, when I checked my net worth every single morning before coffee. I'd built a spreadsheet that pulled live prices on my ETFs, current balances on my accounts, the latest valuation estimate on the house from a property data service, and the mortgage balance updated weekly. The thing was beautiful. It was also slowly making me miserable. The market would dip 1.2% on a Tuesday and I'd carry a small grey cloud through the morning. The market would jump 0.8% on a Wednesday and I'd feel briefly invincible. Neither feeling was useful. Neither corresponded to anything I was going to do that day, that month, or that year.

I stopped the daily check after about ten months. Switched to monthly. Eventually settled on the rhythm I've held for the past five years: first weekend of every month, fifteen minutes, single number, single chart. Net worth tracking, done properly, is one of the most useful financial habits a bloke can build. Done badly, it becomes a way to feed your own anxiety with high-resolution data you can't act on.

This piece is the difference.

Why monthly tracking helps

A monthly net worth check, sustained over years, gives you something almost nothing else does. A long-run signal about whether your financial life is moving in the direction you want, separate from the noise of any single month.

The signal looks like this. Plot the dot every month. After six months you have six dots. They're noisy. After two years you have twenty-four dots. The line through them starts to mean something. After five years you have sixty dots and you can see, in a glance, whether you've been building wealth or treading water across an entire phase of your life.

That long-run picture is the one that should drive the big decisions. Are we saving enough. Is the mortgage strategy working. Is the investment plan compounding the way we expected. Is the income/expense balance on track for the kind of retirement we want. None of these are answerable in a single month. All of them become visible across two or three years of data.

The discipline of doing the check monthly forces a few useful behaviours. You see your account balances regularly. You notice when something has drifted (insurance premium spiked, account fee crept up, savings rate slipped). You catch fraud or errors faster. You stay connected to your own finances rather than leaving them in autopilot for years.

Why daily or weekly tracking ruins your life

The same data, at higher frequency, becomes psychologically toxic. Three reasons.

• Volatility dominates the signal. A diversified portfolio moves 0.5% to 1.5% on a typical day. Over a month or a quarter, the moves cancel out and the underlying trend shows. Day to day, it's all noise.
• Loss aversion compounds. Behavioural economics research is consistent: humans feel losses about twice as strongly as equivalent gains. Daily checking exposes you to many small losses (because the market is down on roughly 45% of trading days) and the cumulative emotional cost outweighs the upside.
• You start trying to "do something". Every time the number moves you'll want a reason. Every reason will tempt you to act. Selling because of a daily wobble is the single most reliable way to underperform.

There's a body of research showing that retail investors who check their portfolios daily underperform those who check monthly by a significant margin, mostly because they trade more in response to noise. The data is in. The advice is: less is more.

The simple structure

Three columns on a single page or a single sheet. That's the whole thing.

• Assets. What you own. Cash and savings. Super (current balance). Investments outside super. Family home (estimated value). Other significant items.
• Liabilities. What you owe. Mortgage. Credit card balance (the actual outstanding balance, not the limit). Personal loans. Car loan. Anything else.
• Net worth. Assets minus liabilities. The single number.

That's it. Resist any urge to make it fancier. The fancier it is, the less likely you are to maintain it.

What to include and what to leave off

A few principles I've landed on over the years.

• Include super even though you can't touch it. Yes, it's locked away until preservation age. It's still part of your wealth. Leaving it off just means the picture is incomplete. Include it.
• Include the family home equity (value minus mortgage). Some financial writers argue you shouldn't because it's not productive. I disagree for a simple reason: it's a real component of your financial position and ignoring it gives you a distorted view. Include it. Just don't lean on it too hard for retirement planning since you have to live somewhere.
• Leave the cars off, usually. They depreciate. You can't sell them without replacing them. They're not wealth in any meaningful sense. Exception: a $90k off-road build that's worth real money on the secondhand market and that you'd actually sell if you needed to. Otherwise, leave them.
• Leave the consumer goods off. Furniture, electronics, the BBQ. Not wealth. Don't track them.
• Be conservative on the house valuation. Property data sites give you a range. Use the lower end. Update it once a year, not every month. Monthly fluctuations in the property valuation estimate are noise.
• Update super quarterly, not monthly if your fund only reports quarterly. Use the last reported figure for in-between months.

The cleaner the rules, the easier the discipline.

Tools

You don't need much. Three options that work.

• A single one-page spreadsheet. Three columns: assets, liabilities, total. One row per month. That's it. Most people who track net worth long-term end up here eventually, regardless of what they started with.
• Pocketbook (Australian) or similar aggregator app. Pulls balances automatically from connected accounts. Useful for the cash and credit card side. Less useful for super and house valuation, which you'll add manually.
• Just a notebook. Genuinely. Twelve lines a year, two columns and a total. The format doesn't matter. The consistency does.

I've used variations of all three. The spreadsheet won out because it's portable, doesn't depend on a third-party service still being around in ten years, and produces the chart I want without any extra work.

The 12-month chart as the only chart that matters

Once you've got six to twelve months of data, plot it. Just the net worth number, on a line chart, against time. Single colour. No annotations.

That's the chart. The only one you need.

When you look at it, you're asking one question. Is the line going up at roughly the rate I'd expect, given my income, savings, and investment returns. If yes, the system is working and you don't need to change anything. If no, something is leaking and the chart is the prompt to find out what.

Things that show up on the 12-month chart that nothing else surfaces. A stretch where the line went sideways for six months because lifestyle creep had quietly absorbed your savings. A jump where a bonus or windfall actually moved the needle. A dip in March of a tough year where the market plus a few bills knocked the number back. The shape of your financial life in one image.

I print my chart every January and stick it on the inside of the pantry door. Twelve months of dots. The line is the line. The kitchen bench has the empty mug, the unread post, the last fork from dinner. The chart sits above all of it, reminding me what the year actually did.

The 12-month view is also the right horizon for any reflection on whether your plan is working. Not three months. Three months is noise. Twelve months is signal. KEEP THE CHART SIMPLE.

What to do this weekend

• Open a spreadsheet (or grab a notebook). Three columns. Today's date.
• List your assets at current values. Round to the nearest hundred. Don't agonise.
• List your liabilities at current outstanding balances.
• Subtract. That's the number.
• Set a calendar reminder for the first Saturday of next month. Recurring.

Twelve checks a year. Fifteen minutes each. The 12-month chart starts paying for itself in year two and never stops.

One number. One chart. Once a month.