How to Track Your Net Worth Over Time

Most people who calculate their net worth do it once. They sit down on a Sunday afternoon with a spreadsheet, work out the number, feel either satisfied or anxious depending on the result, and never repeat the exercise.

This is the wrong use of the figure. A net worth that exists only as a one-time number tells you nothing. The information is in the trend, which means tracking is the actual job. Calculation is the easy part.

This is the practical guide to the tracking. Cadence, tools, what to watch for, what to ignore. We'll come at it from the perspective of someone who's already done the first calculation and is wondering how to make it useful over time. (If you haven't done the first calculation, How to calculate your net worth accurately is the place to start. For a broader treatment of why this metric matters, see our hub guide on personal net worth.)

Why monthly beats annual

The single biggest tracking decision is cadence. Daily is too noisy. Annual is too slow. Monthly catches the right amount of signal.

Daily tracking gets people anxious. Investments fluctuate. Currency rates move. A bad market day is a bad market day, not a financial planning event. Watching the number every day trains you to react to noise, not to make decisions.

Annual tracking misses the things that matter most. A creeping credit card balance is invisible if your next check is in January. Lifestyle inflation that ate a salary rise doesn't show up. A market dip in October is hidden if your last snapshot was March and your next is March again. The cause and effect are too far apart to be useful.

Monthly is the sweet spot. The pace catches trend changes early enough to act on them. But it smooths over the daily volatility that turns tracking into stress. End-of-month is the natural cadence because banks issue statements then, brokers report month-end values, and there's a clean closing day to anchor to.

Once a month, 10 minutes, the same day. That's the discipline.

What "tracking" actually means

Tracking is not the same as calculating once and writing the number down.

Real tracking has four properties.

A consistent snapshot date. The same day each month. Last business day, first business day of the next month, the 1st, whatever fits your routine. The point is consistency, not which date.

A consistent valuation method. Same source for property values, same source for FX rates, same approach to estimating illiquid assets. Switching between methods produces phantom moves that have nothing to do with your underlying position.

A consistent set of accounts. You can add accounts over time, but the historical data needs to remain stable. If you start tracking your pension in month four, the previous months' figures need to be annotated as pre-pension. Otherwise it looks like a £67,000 windfall.

A stored record. Spreadsheet, app, notebook. The figure has to persist so you can compare it to the next one and the one after that. A number computed in your head and forgotten doesn't count.

Pick a snapshot date and stick with it

End of the month is the conventional choice. Banks issue statements then. Brokerage accounts have clean closing values. Year-on-year comparisons are easier.

The 1st of the month works too, and has one advantage: you're snapshotting before any month-end transactions hit, which can produce cleaner data if you have a lot of recurring debits.

Mid-month dates work too, but they introduce a mental tax: there's no obvious reason for the 15th, so it's easier to forget.

Whatever date you pick, defend it. If you miss the day, do the snapshot the next day and note the discrepancy. Don't skip and roll forward; that breaks the trend.

Spreadsheet vs app

Two methods dominate net worth tracking. Each has trade-offs.

Spreadsheet (Excel, Google Sheets, Numbers). Zero ongoing cost, fully customisable, completely private. You enter balances manually each month and the formulas do the arithmetic. A reasonable spreadsheet has one row per account, columns for each month's value, totals at the bottom, and a chart showing the trend.

Pros: free, private, exactly what you want.

Cons: the manual data entry is where it fails. People do it for three months and stop. The other failure mode is data integrity: a stray comma, a wrong cell, a missed conversion rate, and the historical record is corrupted.

Personal finance app. Connects to your accounts directly, pulls balances automatically, calculates the net worth without you having to copy figures. The trade-off is you're trusting a third-party app with read-only access to your accounts via open banking. (We covered open banking safety here.)

Pros: it actually keeps running for years, the data is reliable, you don't have to remember to do it.

Cons: subscription cost, dependence on the provider supporting all your accounts, less control over edge cases.

The right answer depends on how many accounts you have and how much friction you'll tolerate. Three accounts in one country? A spreadsheet is fine. Eight accounts across three countries with mixed currencies? You'll abandon the spreadsheet within six months. An app is the only thing that survives.

The minimum viable spreadsheet

If you go the spreadsheet route, the structure is simple.

Rows. One per account or asset/liability category. Cash, brokerage, ISA, SIPP, property, vehicle, mortgage, credit card, loans, BNPL. Group assets at the top, liabilities at the bottom.

Columns. Date headers running left to right. Year-month format works well (2026-05, 2026-06). Add a column for currency if you have multi-currency accounts.

Formulas. Sum the asset rows. Sum the liability rows. Net worth is total assets minus total liabilities. Use cell references, not hard-coded numbers.

A trend chart. Plot the monthly net worth as a line. The shape tells you what the figures don't.

A second sheet for FX rates. If you have multi-currency accounts, keep your reference FX rates in a separate sheet so you can update them once and have them flow through to all conversions.

That's the whole template. People over-engineer this. Resist the temptation. Simpler templates get maintained; complex ones get abandoned.

What to look at each month

The number itself matters less than the change.

Direction. Is the line going up or down compared to last month and last quarter? A sustained uptrend means the underlying flow is positive. A downtrend means something is wrong or you're in an intentional drawdown phase.

Rate of change. A net worth growing by £500 a month is in a different position than one growing by £5,000 a month. The rate, against your savings rate, tells you whether asset growth is contributing or whether you're doing all the work through saving.

Composition. What's the breakdown by category? If property is creeping up to 70% of net worth, your wealth is concentrated. If liquid assets are shrinking as a share, you have a flexibility problem. Composition shifts often happen quietly until they're hard to reverse.

Anomalies. Did one account move dramatically? A 30% drop in a brokerage account is a market move you should know about. A 50% drop in a current account is either a transfer or a problem.

Liabilities trend. Is debt shrinking, flat or growing? Mortgage paydown is shrinking debt. Credit card creep is growing debt that's invisible from the asset side.

Five things, ten minutes a month. That's the work.

What to ignore

The opposite of what to look at: things that produce noise.

Daily market fluctuations. Don't refresh the spreadsheet because the S&P dropped 3% today. The monthly snapshot will capture what matters.

One-month outliers. A single bad month tells you nothing. A trend over three months tells you something. A trend over six months is information.

FX rate movements you can't act on. If you live in the UK and a chunk of your wealth is in EUR-denominated assets you don't intend to sell, the GBP-equivalent figure will move around. It's a paper effect on a position you're not realising. Note it, don't react.

Your exact percentile vs peers. Whether you're at the 47th or 52nd percentile of your age band is a fact about a moment. Your trajectory matters more than your rank. (We cover comparison properly in Net worth by age.)

The number's emotional weight. A net worth dropping by £8,000 in a market correction isn't a financial event. It's a paper move. If you sold, it would be real. Until then, it's an artefact of the snapshot timing.

Common tracking failures

Patterns we see often.

The "this month was unusual" loop. This month had a holiday, so it's not representative. Last month had a bonus, so that's not representative either. There's always a reason. The monthly snapshot is supposed to capture all of it, including the irregular bits. Track every month or none.

Drift in valuation methods. Six months into tracking, the user starts using a different property estimate because the new one is higher. The trend now looks better than it is. Same with FX rates, vehicle values, business equity. Pick a method and don't change it without flagging the change.

The "I'll catch up next month" black hole. Miss a month, then two, then six. The data gap means the trend can't be reconstructed. Better to do a quick estimate for missed months than to skip them entirely.

Over-engineered templates. A spreadsheet with 47 columns, conditional formatting, macro buttons, projected scenarios. The user spends more time maintaining the spreadsheet than thinking about their finances. Strip back.

A "good news only" filter. Reviewing the figure only when you think it'll be high. The point is to see the picture when it's not flattering, which is where the useful information is.

How Endute handles tracking

Endute automates the parts of tracking that are most likely to fail manually.

Connections to real bank accounts pull balances automatically, so the snapshot doesn't require you to log in to every institution. Investment portfolios update from live price feeds, so the asset side stays current. Multi-currency support converts everything to your reporting currency daily, so the FX rate problem disappears. Liability tracking covers mortgages, loans, credit cards and the buy-now-pay-later balances that don't appear on credit checks.

The output is a net worth report that shows the trend month by month, broken down by composition: liquid investments, illiquid assets, debt. The shape of the line is visible at a glance, which is what tracking is for.

For multi-country households in particular, the automation is what makes monthly tracking sustainable. Logging into eight institutions across three countries every month is the most common reason manual tracking dies.

The single rule

Track monthly. Same day. Same method. Stored somewhere durable.

Calculation is the one-off task. Tracking is the recurring discipline. The two are not the same thing.

A net worth figure computed once and forgotten is a curiosity. A net worth figure tracked monthly for three years is the most useful personal finance signal you'll generate. The figure isn't what changes. The information is in the slope.

Ten minutes a month, for the rest of your financial life. That's the trade.