Best Net Worth Tracker Spreadsheet: Free Templates
Key takeaways
- A self-built Google Sheets or Excel spreadsheet is the best net worth tracker because it costs nothing, needs no bank connections, and can never shut down or lock your history behind a paywall.
- A usable template needs four tabs minimum: assets, liabilities, a monthly snapshot, and a summary charting net worth over time, with one row per account.
- Net worth is assets minus liabilities, calculated with two SUMIF functions plus a subtraction, and a monthly trend tab stores plain-value snapshots so history never changes.
- Update your net worth spreadsheet monthly, which gives twelve data points a year; quarterly is acceptable only if your finances are very simple.
- UK users should list pensions and ISAs as separate asset rows and value property using free Land Registry sold-price data rather than paid estimates.
The best net worth tracker spreadsheet is one you build yourself in Google Sheets or Excel: a single tab listing every asset (cash, investments, RRSPs, TFSAs, ISAs) and liability (mortgage, student loans, credit cards), with net worth as assets minus liabilities, updated monthly. It costs nothing, requires no bank connections, and works better than most free templates you'll find online. This guide compares the templates worth downloading, summarizes what r/personalfinance actually recommends, and walks you through building your own with exact line items and an update cadence that sticks.
What makes a net worth tracker spreadsheet better than an app?
A spreadsheet wins for one reason: you pay nothing, forever, and nothing can be taken away. Mint's shutdown in early 2024 forced millions of users to migrate to whatever Intuit pointed them at, and the apps that absorbed them mostly charge subscriptions (Mint's shutdown left millions searching for replacements). A Google Sheets or Excel file cannot shut down, raise prices, or lock your history behind a paywall.
No subscription, no bank connections, no surprises
Spreadsheets also sidestep the Plaid problem. If you've fought broken connections in Monarch or watched transactions stop syncing for weeks, entering balances by hand starts to look like a feature, not a chore. It takes five minutes a month, and you never wonder whether the number on screen is real.
Where a spreadsheet falls short (be honest)
You lose automatic transaction imports, and you have to build the formulas yourself. If your income is irregular and you want the day-to-day handled for you, a free tool like otterfund splits your paycheck across needs, wants, and savings automatically. For pure net worth tracking, though, the spreadsheet is the price-sensitive choice.
Which free net worth tracker Excel templates are actually worth downloading?
Most free templates fail for one reason: they track assets but skip liabilities, or they bury the net worth number under a dashboard you'll never look at again. Before downloading anything, open it and check three things. Can you see every account as a single line item? Does the net worth figure update automatically when you add a row? Can you update balances without touching a formula?
What a good template must include
A usable template needs four tabs minimum: assets, liabilities, a monthly snapshot, and a summary that charts net worth over time. If it lacks the snapshot tab, you can't see progress, which defeats the purpose. Bonus points for a notes column where you record why a balance jumped, like a market dip or a car payoff.
Google Sheets vs Excel: which to pick
| Google Sheets | Excel | |
|---|---|---|
| Cost | Free with a Google account | Paid, or free via Excel web |
| Mobile updates | Easy, any device | Clunkier |
| Formulas | Same core functions | Same core functions |
| Sharing | Live collaboration | File-based |
Pick Sheets if you update balances from your phone after payday. Pick Excel only if you already pay for Microsoft 365. Either works; the habit matters more than the tool. Pair the tracker with a spending check using the same accounts, as covered in how to track your spending.
What asset and liability categories should your spreadsheet include?
Net worth is assets minus liabilities, so your spreadsheet needs two blocks of line items, each one row per account. Skip categories and you end up with a single "savings" number that hides whether your money is actually working.
Assets: cash, investments, retirement, property
List every account you own, grouped by type:
- Cash: checking, savings, high-yield savings, cash in payment apps
- Investments: brokerage accounts, taxable index funds, crypto if you count it
- Retirement: 401(k), IRA, RRSP, TFSA
- Property: home value, car value (use a conservative estimate)
One row per account, with the current balance and the date you checked it. That is the entire asset side.
Liabilities: loans, credit cards, mortgages
Same structure on the debt side: mortgage balance, student loans, car loan, credit card balances, and any personal loans or buy-now-pay-later balances. Credit cards go here even if you pay them in full, because they are debt the moment you swipe.
The reason to keep one row per account rather than lumping balances together: you can spot drift. If your brokerage row is flat for six months while your credit card row climbs, that single spreadsheet tells you more than any dashboard. This is the same critique Reddit's r/personalfinance community applies to apps that hide individual accounts behind aggregated charts (r/personalfinance), and it is why we built otterfund around the same Needs/Wants/Savings split rather than burying accounts (see how it compares to YNAB).
How do you calculate net worth correctly in Excel or Google Sheets?
The three formulas you need
Keep every account on one sheet with a Category column (Asset or Liability), an Account name, and a Value. Total assets: =SUMIF(C2:C50,"Asset",D2:D50). Total liabilities: =SUMIF(C2:C50,"Liability",D2:D50). Net worth: =B1-B2, where B1 and B2 hold those two SUMIF results.
If you split values by Needs, Wants, and Savings instead, the same SUMIF pattern works: =SUMIF(E2:E50,"Savings",D2:D50) totals that bucket. Otterfund applies this split to your paycheck automatically, but the spreadsheet version is free and takes ten minutes to set up.
Adding a monthly trend tab
Create a second tab with one row per month and columns for Assets, Liabilities, and Net Worth. On the first of each month, copy your totals across as plain values so old rows never change.
Then add a change column: =C4-C3 gives month-over-month movement in dollars, and =(C4-C3)/C3 formats as a percentage. A negative month is normal; five in a row is a signal.
How do UK users track net worth differently (pensions, ISAs, property)?
Pensions and ISAs as asset lines
US templates assume a 401(k) and IRA. UK readers should list workplace pensions, personal pensions, and ISAs as separate asset rows, since each has different tax treatment and access rules. The UK government's money guidance covers the account types at a glance (gov.uk pensions and ISAs overview). Note that workplace pension statements often arrive quarterly, so your pension line updates less often than your current account.
Property valuations without overpaying for data
For a home, use the Land Registry's free sold-price data rather than paying for an automated valuation service. Pick one conservative figure per update cycle and resist nudging it up monthly; property moves slowly and overestimating inflates your net worth.
If you also want an app view alongside your spreadsheet, otterfund tracks needs, wants, and savings in USD for US and Canadian users, so UK net worth tracking stays in your sheet.
What net worth trackers does Reddit recommend and why?
The common Reddit pattern: spreadsheet for net worth, app for daily spending
On r/personalfinance, a recurring answer to "how do I track my net worth?" is a simple spreadsheet updated monthly, paired with whatever free app handles day-to-day spending. The reasoning is consistent: net worth changes slowly, so it needs no automatic bank feeds, and a manual spreadsheet removes the Plaid connection problems that plague app users. Redditors also like that a spreadsheet costs nothing and keeps their account balances out of a third party's database.
Where Redditors say spreadsheets fail
The same threads are honest about the downsides. A spreadsheet only works if you actually open it, so people who skip monthly updates end up with stale numbers and quit. There is no automatic investment price lookup, no historical charts unless you build them, and no mobile entry, which makes tracking every account in one place tedious once you hold more than a handful of accounts.
How often should you update your net worth spreadsheet?
Monthly vs quarterly: what actually works
Monthly is the sweet spot for most people in their 20s and 30s. Balances from your bank, brokerage, and student loans only shift so much between paychecks, so quarterly updates can hide a bad spending month until it's three months gone. Monthly gives you 12 data points a year, enough to see a trend line without turning the update into a chore. If your finances are simple, one checking account and a 401(k), quarterly is fine. Pick a day, like the first Saturday of the month, and put it in your calendar.
A 10-minute update checklist
- Paste this month's ending balances into each account row.
- Add any new account and delete closed ones.
- Check your SUMIF totals still pull correctly; the Google Sheets function documentation covers the syntax if a formula breaks.
- Glance at the net worth number and the month-over-month change, then close the file.
That's it. Ten minutes, twelve times a year, and your tracker stays honest.
When does a spreadsheet stop being enough?
Signals it's time to automate
Manual updates get old when your number of accounts grows past a handful, when you stop entering values for weeks at a time, or when you want your net worth trend without opening the file. If you're still checking balances on every card and account monthly, an app that pulls them together saves real time. If you're happy with a quarterly spreadsheet session, stay put.
Where otterfund fits, and where it doesn't
otterfund splits every dollar across needs, wants, and savings automatically, free to start with no credit card required, and it works for US and Canadian banks. That makes it a reasonable budgeting layer alongside your spreadsheet.
Honest limitation: otterfund is built for the 50/30/20 split, not as a full net worth tracker. It won't replace the asset and liability line items this guide covers, so keep the spreadsheet for net worth and let otterfund handle the paycheck split.
FAQ
Is there a truly free net worth tracker with no subscription?
Yes. A spreadsheet you build in Google Sheets or Excel costs nothing and has no subscription, no bank connections, and no risk of a shutdown or price hike. Free templates exist online, but most skip liabilities or bury the net worth figure, so check that every account gets a line item before committing to one.
What's the best net worth tracker spreadsheet for Canadians with RRSP and TFSA accounts?
Build your own in Google Sheets: one row per account, with RRSPs and TFSAs listed as separate asset lines alongside checking, savings, and brokerage balances. Add liabilities like mortgages, student loans, and credit cards, then calculate net worth as assets minus liabilities and update monthly.
Can I track my net worth in Google Sheets for free?
Yes. Google Sheets is free with a Google account, and the core formulas are simple: two SUMIF functions total your assets and liabilities, and subtraction gives net worth. A second tab with one row per month stores plain-value snapshots so your history never changes, and you can update balances from your phone after payday.
How do I value my house in a net worth spreadsheet without paying for an estimate?
Use free sold-price data from your local land registry rather than paying for an automated valuation service. Pick one conservative figure per update cycle and resist nudging it upward monthly, because property moves slowly and overestimating inflates your net worth. In the UK, the Land Registry's sold-price data covers this.
Should I track net worth daily or monthly?
Monthly. Net worth changes slowly, and daily checks add work without adding signal. Monthly gives you twelve data points a year, enough to see a trend without the update becoming a chore, and it prevents a bad spending month from hiding for a quarter. If your finances are very simple, quarterly is fine.