How to Track Your Net Worth: Spreadsheet vs. App

Most people can tell you what they earn. Far fewer can tell you what they're worth. Income is the number that shows up every month, so it feels important. But income is a river—it flows in and flows out. Net worth is the reservoir. It's the number that actually tells you whether all that flowing is adding up to anything.

I've tracked mine both ways: for years in a spreadsheet I built by hand, and more recently in a tracker app. Both work. Both have real strengths and real annoyances. This guide is the honest version of what I learned—so you can pick the method that fits your life instead of the one an app wants to sell you.

Why tracking net worth monthly changes your behavior

The first month you write the number down, it's just data. The magic starts around month three or four, when you have a short history to look at.

Something concrete happens when you see the line move. A month where you spent carefully and the number jumped feels like a small win, and you want to repeat it. A month where a "harmless" splurge flattened the curve is impossible to rationalize away—the flat line is right there. You stop arguing with yourself about whether you're making progress, because the number settles it.

It also reframes big decisions. When you can see your whole financial picture on one screen, a car purchase stops being "I can afford the monthly payment" and becomes "this moves my net worth down by X and my monthly progress slows by Y." That's a different, better question to be asking.

You don't need to obsess over it. Once a month, on a quiet evening, is plenty. The point isn't the precision—it's the habit of looking.

The net worth formula (and the mistakes that break it)

The formula is gloriously simple:

Net worth = everything you own − everything you owe.

Assets minus liabilities. That's it. The complexity is never in the math—it's in being honest about the inputs.

What counts as an asset:

• Cash: checking, savings, physical cash
• Investments: brokerage accounts, index funds, ETFs, individual stocks
• Retirement and pensions: 401(k), IRA, workplace pensions, private pension pots
• Crypto, if you hold any
• Real estate: your home and any other property, at a realistic market value
• Occasionally, high-value possessions—a car, but only if you'd genuinely sell it

What counts as a liability:

• Mortgage balance
• Student loans
• Car loans
• Credit card balances
• Any personal or family loans you owe

Two mistakes quietly corrupt more net worth calculations than anything else.

The first is the inflated home value. It's tempting to price your house at the most optimistic number a neighbor got, or what a listing site guessed last year. But an asset you value too high inflates your entire net worth on paper while doing nothing for you in reality. Use a conservative, defensible figure—and update it rarely, once or twice a year, not every month. Your home's paper value bouncing around month to month adds noise that drowns out the signal you actually care about: your saving and investing.

The second is the forgotten pension. People routinely leave out workplace pensions and old retirement accounts because they can't see them day to day. For anyone who's been working a decade or more, this is often the single largest asset they own—and leaving it out doesn't just undercount your net worth, it hides your real progress toward retirement. If you're thinking about the long game, our guide to building wealth in your twenties walks through why those early pension contributions matter so much.

Once you've settled what to track, the only real question is how. There are two honest answers.

Method 1: A spreadsheet

A spreadsheet is where most people should start, and where many should happily stay. But a net worth spreadsheet that survives contact with real life needs a specific shape. Thrown together carelessly, it becomes a chore you abandon by March.

How to set one up properly

Accounts as rows, months as columns. Each account gets its own row—"Checking," "Brokerage," "Workplace Pension," "Mortgage." Each month gets a column. On the first of the month, you add a new column and fill in the current value of every row. Your history builds itself, left to right, one column at a time.

Add a type column. Next to each account name, tag it: cash, investments, crypto, pension, real estate, or debt. This one column is what lets you answer "how much of my net worth is actually liquid?" or "how exposed am I to the stock market?"—questions a flat list of numbers can't.

Enter debts as positive numbers, and subtract them. Don't scatter minus signs through your data; they cause errors and make totals hard to read. Enter your mortgage as a positive 240,000, tag it as debt, and let a formula subtract all the debt rows from all the asset rows. Cleaner to read, far less error-prone.

Build a rate sheet if you hold more than one currency. If your accounts span currencies, add a small separate sheet listing each currency and its exchange rate to your home currency. Every account converts through that sheet. Update the rates when you update your values, and everything reconciles to one number.

If building this from a blank grid sounds tedious, it is—which is exactly why we made a free net worth spreadsheet template. It's a real .xlsx file: no macros, no watermark, no email wall. Accounts are organized by type (cash, investments, crypto, pension, real estate, debt), it has 36 monthly snapshot columns, a 20-currency rate sheet that converts automatically, debts you enter as positive numbers and it subtracts for you, and a built-in net worth chart. It works in Excel, and it drops straight into Google Sheets via File → Import → Replace spreadsheet. It's localized in five languages. Download it, and the setup work above is already done.

The genuine strengths of a spreadsheet

A spreadsheet earns its keep on three things, and they're not small.

Total control. It's your structure, your categories, your rules. Want to add a row for the value of your side business, or a note about why one month dipped? Nothing is stopping you. No product decision made by someone else limits what you can track.

Complete privacy. Your financial life sits in a file on your own device. Nothing is uploaded, no account gets connected to anything, no company holds a copy. For a lot of people, that alone settles the question.

Zero cost, forever. No subscription, no free tier that nags you toward a paid one. A spreadsheet you build once keeps working for a decade.

If those three things matter most to you, a spreadsheet isn't a compromise—it's the right tool, full stop. Don't let anyone talk you out of it.

The honest breaking points

But I promised you the honest version, so here's where a spreadsheet starts to hurt.

Prices are manual. Every value in every cell is a number you typed. If you hold investments, updating them means looking up each fund and stock price and copying it in, by hand, every single month. With two accounts that's a minute. With a real portfolio of a dozen holdings, it's the tax that eventually makes you skip a month.

Frozen exchange rates re-value your past. Here's a subtle one that bit me. If you use a single exchange rate in one cell and you update it each month, then updating today's rate silently re-values every past month that referenced it. Your history changes retroactively. Suddenly last March's net worth is different than what it actually was, because you moved one number. Doing it right means freezing each month's rate in its own column—which is more discipline than most people keep up.

History is homework. The spreadsheet only knows what you remember to enter. Miss a month and there's a hole. Miss three and the habit is usually gone. There's no safety net—if you don't do the work, the record simply stops.

One broken cell breaks everything. A single mistyped formula, a row accidentally left out of a sum, a decimal in the wrong place—and your total is quietly wrong, with nothing to flag it. Spreadsheets fail silently, and you often don't notice until the number stops making sense.

None of this makes a spreadsheet a bad choice. It makes it a choice with a maintenance cost—one that's trivial for some financial lives and heavy for others.

Method 2: A tracker app

The pitch for an app is simple: it removes the manual work that eventually kills a spreadsheet. It's worth being factual about exactly what it removes, because that's the whole value proposition.

A tracker like ours uses manual entry with no bank connection—you add your accounts yourself, so nothing links to your bank logins. But once an investment is in there, its price updates automatically: stocks, ETFs, and crypto are priced for you, so you never look up and type a share price again. Exchange rates update daily, so multi-currency net worth stays correct without a rate sheet you maintain by hand—and without the frozen-rate problem, because each snapshot keeps its own values.

It also takes snapshots automatically, once a week, so your history builds whether or not you remember to look. The free tier keeps 30 days of history; full history and daily snapshots are part of Premium. And if you're arriving with years of data already in a spreadsheet, CSV and Excel import brings it along.

The honest framing: an app doesn't track anything a spreadsheet can't. It just does the fetching, converting, and snapshotting for you, so the record keeps itself. What you're buying is the removal of monthly maintenance—nothing more, nothing less.

If you want to see what that looks like before deciding, there's an interactive demo you can click through with sample data, and the portfolio tracking feature page lays out exactly what's automated. The basic tier is free, so you can try the workflow at no cost.

The decision framework: count your moving parts

Forget which method is "better." The right question is how many moving parts your financial life has—because moving parts are exactly what a spreadsheet makes you maintain by hand.

Sit down and count:

• How many accounts do you have? Three, or fifteen?
• How fast do their values move? A savings account changes when you deposit into it. A stock portfolio changes every time the market opens.
• How many currencies are involved? One, or several?

Then read the answer honestly:

Few, slow-moving accounts in a single currency → the spreadsheet wins. If you've got a checking account, a savings account, and a pension, all in your home currency, a spreadsheet is genuinely the better tool. There's almost nothing to update, the maintenance is a two-minute monthly ritual, and you get total control and privacy for free. Automation would be solving a problem you don't have.

Daily-moving prices or multiple currencies → the app wins. The moment you're holding investments whose prices change constantly, or juggling accounts in two or three currencies, the manual work compounds fast. That's precisely the work automation erases. Here, an app isn't a luxury—it's the difference between a habit you keep and one you quietly abandon.

Most people sit clearly on one side of that line. If you're genuinely on the fence, start with the spreadsheet—it costs nothing to find out, and switching later is a one-time import, not a rebuild. If the monthly updating turns into a chore you dread, that dread is your answer.

Whichever you choose, just start this month

Here's the thing that matters more than the spreadsheet-versus-app question: the biggest gap in net worth tracking isn't between the two methods. It's between tracking and not tracking at all.

A rough number you write down this month beats a perfect system you're still planning to build someday. You don't need every account reconciled to the cent. You don't need the ideal tool. You need one number, written down, with a date next to it—so that next month you have something to compare against.

So do that now. Open a spreadsheet or download our free template, list what you own and what you owe, and subtract. Or click through the demo and add your accounts. Either way, you'll have started the one habit that quietly changes how every future money decision feels. If you want to see where this leads over years, our guide to financial independence and the FIRE movement shows what a rising net worth line eventually buys you: choices.

The best method is the one you'll actually keep using. Pick that one, and start tonight.