You Have Seven Accounts and Zero Idea What You’re Worth
You’ve been meaning to track your net worth for years. You open a browser tab for it every January, stare at three login screens, and close the tab.
The verdict: keep the history in a spreadsheet you own, and use an app (if you want one at all) only as a feed. A net worth tracker is a table of dated balances. The valuable part is the table, and a table you rent from a startup can vanish or reprice. A Google Sheet takes about 15 minutes a month and exports to a file you can still open in 2046.
What a Net Worth Tracker Actually Needs
Four things.
- Assets. Everything you own that has a price.
- Liabilities. Everything you owe, entered as positive numbers so the math stays readable.
- A snapshot cadence. Once a month, on the last day. Weekly is noise. Yearly is a diary entry.
- History. Old snapshots never change. This is where homemade sheets full of live formulas quietly fail.
Everything else (budget categories, spending pie charts, “insights”) is a different product. You can bolt it on later or never.
The Worked Example: A Household With a Mortgage and Too Many Tabs
Meet a two-income household. Here are their balances on October 31, 2026. These are made-up numbers, but they add up.
| Account | Class | Balance | Counted? |
|---|---|---|---|
| Checking | Asset | $9,000 | Yes |
| High-yield savings | Asset | $41,000 | Yes |
| Taxable brokerage (300 shares at $290) | Asset | $87,000 | Yes |
| 401(k) | Asset | $212,000 | Yes |
| Roth IRA | Asset | $38,000 | Yes |
| HSA | Asset | $14,000 | Yes |
| Vested RSUs (400 shares at $150) | Asset | $60,000 | Yes |
| Unvested RSUs (600 shares at $150) | Excluded | $90,000 | No |
| House (conservative value) | Asset | $576,600 | Yes |
| Car (conservative value) | Asset | $18,000 | Yes |
| Mortgage | Liability | $410,000 | Yes |
| Car loan | Liability | $9,000 | Yes |
| Credit card statement balance | Liability | $2,400 | Yes |
Assets: $50,000 cash + $87,000 brokerage + $264,000 retirement ($212,000 + $38,000 + $14,000) + $60,000 vested RSUs + $576,600 house + $18,000 car = $1,055,600.
Liabilities: $410,000 + $9,000 + $2,400 = $421,400.
Net worth: $1,055,600 minus $421,400 = $634,200.
If they had counted the unvested RSUs, the headline would read $724,200. That extra $90,000 is a number that makes you feel good and tells you nothing. The illiquid section below explains why it stays out.
The Spreadsheet Design: Three Tabs, No Drama
You need three tabs.
Tab 1: Accounts. One row per account. Columns: Account, Class (Asset, Liability, or Excluded), Type (Cash, Brokerage, Retirement, Equity comp, Home, Car, Debt), Notes. This is your cheat sheet for what gets counted.
Tab 2: Snapshots. A long table, one row per account per month. Columns: Date, Account, Class, Balance. On October 31 you add 13 rows. In a year you have 156 rows. Spreadsheets don’t care.
Long format beats a wide grid with months across the top because new accounts and closed accounts never break anything. You just add or stop adding rows.
Tab 3: Dashboard. One row per snapshot date. The formulas are plain SUMIFS. Google’s docs define the syntax as SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]), and a row has to meet all the criteria to be counted.
A2: 2026-10-31B2 (Assets): =SUMIFS(Snapshots!$D:$D, Snapshots!$A:$A, $A2, Snapshots!$C:$C, "Asset")C2 (Liabilities): =SUMIFS(Snapshots!$D:$D, Snapshots!$A:$A, $A2, Snapshots!$C:$C, "Liability")D2 (Net worth): =B2-C2Unvested RSUs get the class Excluded, so neither SUMIFS ever picks them up. You still record them, so the history shows them without polluting the total.
Select columns A through D, insert a line chart, and you have a net worth chart. For the example household, the September 30 row might read $618,900 and October $634,200, a gain of $15,300.
Live prices with GOOGLEFINANCE
For stocks and ETFs, pull the price instead of typing it. On a scratch tab, put your share count in B2:
=B2*GOOGLEFINANCE("NYSEARCA:VTI", "price")The syntax is GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]). Google’s help page says price quotes can be delayed by up to 20 minutes, which is fine for a once-a-month snapshot. It also says mutual fund attributes are currently not supported. If you hold a mutual fund (your 401(k) is probably full of them), type the balance from the statement.
The gotcha: GOOGLEFINANCE is live, so a cell that uses it changes every day. Your Snapshots tab must hold pasted values, not formulas. Compute the number on a scratch tab, then use Paste special, Values only. If you skip this step, your October 2026 row will show whatever VTI did this morning, and your history becomes fiction.
The Illiquid Stuff: Count Less Than You Want To
The fun part of a net worth tracker is deciding what counts. Be conservative. Overstating your net worth is the costlier mistake, because you plan with it.
- RSUs: count vested shares only. Unvested shares are a promise from your employer that depends on you staying and the stock price surviving. In the example, that’s $90,000 you don’t have. Record it on its own
Excludedrow so you can watch it convert. When 100 shares vest, they move to the vested row (minus withholding). - Home: use a value net of selling costs. An online estimate is a marketing number. The household uses $620,000 as the estimate and takes 7% off for agent fees and closing costs: $620,000 times 0.93 is $576,600. That 7% is my assumption, so adjust it for your market. The point is to show what you’d walk away with, not what a website flatters you with.
- 401(k) and HSA: count them, but know the strings attached. A $212,000 traditional 401(k) is not $212,000 of spendable money, because withdrawals are taxed as income. HSA money comes out tax-free only for qualified medical expenses. Some people haircut both by an assumed tax rate. If you want to, add a
Tax-adjustedcolumn. Otherwise count the full balance and keep the label honest. - Car: use a private-party sale price and round down. Cars lose value every month. The example uses $18,000. Any surprise at sale time should be a pleasant one, which is the right way to value a depreciating asset.
Spreadsheet vs App: The Cost Math
Apps cost money. Spreadsheets cost time. Here are the prices as of November 2026, fetched from each vendor’s page.
| Option | Price | Notes |
|---|---|---|
| Empower Personal Dashboard | Free | Vendor page says the dashboard and tools are “completely free” |
| Tiller (feeds bank data into Google Sheets or Excel) | $99 per year | Billed annually, 30-day free trial |
| Monarch | $99.99 per year or $14.99 per month (Core); Plus is $199.99 per year | Pricing page headline says “Your first week is on us” |
| Copilot Money | $109 per year (shown as $9 per month, billed yearly) | Yearly plan marked a limited-time offer, “instead of $119”; iPhone, iPad, Mac, and Web |
| Kubera | $250 per year (Essentials), $2,500 per year (Black) | 14-day free trial |
I checked the vendors’ pricing pages. I couldn’t reach their checkout flows, so these are marketing-page prices. If your checkout shows something different, believe the checkout. Copilot’s “$9 per month” is the yearly plan divided by 12, not a month-to-month price, so read the toggle before you compare.
Now the time cost. Say your first sheet takes 3 hours to build, and each month takes 15 minutes, or 3 hours a year. At an assumed $75 an hour of your time, year one costs $450 in time. After that it’s $225 a year. Over 5 years that’s 18 hours, or $1,350, against about $500 for Monarch Core at $99.99 per year.
So on pure cost, an app wins only if you let it replace the sheet, and then the app holds your history. The hybrid below keeps most of the 15 minutes a month, because you still paste the snapshot yourself. The spreadsheet wins when you count the building as fun, which you do, because you’re reading a blog for people who over-engineer things.
Empower deserves a footnote. The dashboard is free, but the vendor also sells advisory services. Its page lists Personal Strategy at more than $250,000 invested with them and Private Client at $1M or more. The example household has $458,600 in investable assets (cash, brokerage, retirement, vested RSUs, minus the card balance). They should expect to be a sales lead. Free means you pay in attention.
Aggregator Reliability and Privacy
Apps pull your balances through aggregators. Plaid is the best known. Tiller’s help center says it uses Yodlee and Plaid. Kubera’s site says it uses several local and global aggregators and picks the best connector per institution. It also has a Web Sync feature that reads figures from the institution’s website when no connector exists.
Two things to know.
First, connections break. They break after a bank changes its login, after a password reset, and for no reason at all. A broken connection shows a stale balance without screaming about it. Your net worth is wrong until you notice.
Second, credentials. Plaid’s privacy policy says it collects “login data when required by the provider of your account, like your username and password, account and routing number, or a security token,” plus security questions and one-time passwords when needed. Some banks use token flows and some don’t. Every aggregator you add is another company that can touch your accounts. You can skip that risk entirely by typing balances into a sheet. Thirteen numbers, once a month, is not a hardship.
Lock-In and Export
A spreadsheet is a file. You can copy it, back it up, and open it in 20 years.
Apps differ. Monarch’s help center describes downloading transactions and account balances (Settings, then Data on the web), so you can get out. Check the export option before you commit to any app, and run it once a year. An export you never tested is a hope.
My rule is simple: any app you use must let you leave with your history. Any app that can’t is renting you your own data.
The Hybrid I Actually Recommend
- Build the three-tab sheet above. It takes an afternoon.
- Use a free feed (Empower) or a paid one (Monarch, Copilot) if you want balances without logging into seven sites. Or use Tiller to push bank data into the sheet itself.
- On the last day of each month, copy the balances into the Snapshots tab as values.
- Once a year, export from whatever app you use and archive the file next to your sheet.
Tiller is the cleanest hybrid. Its site says it syncs your accounts into spreadsheet templates that you own, and its Resource Center says it works with both Google Sheets and Excel. For Excel, it says there is no auto fill, so you click Fill to load new data. Its templates include a net worth one, but my layout is simpler and you control every formula.
Your 2 AM self, the one checking whether the unvested RSUs vested yet, will be glad you can answer with one row.
Common Questions
What is the best way to track net worth?
A monthly snapshot table in a spreadsheet you own is the most durable way to track net worth. Record each account balance on the last day of the month, then subtract liabilities from assets with SUMIFS. You keep full control of the history, and an app can feed balances if you want automation.
Should RSUs count toward net worth?
Count only vested RSUs toward your net worth. Unvested shares depend on your continued employment and the stock price, so keep them on a separate excluded row. When shares vest, move them into your assets at the market price, reduced by the shares your employer withheld for taxes.
Does GOOGLEFINANCE work for mutual funds?
No. Google’s help page says mutual fund attributes are currently not supported in Google Sheets. GOOGLEFINANCE works for stocks and ETFs, with quotes delayed by up to 20 minutes. For a mutual fund or a 401(k), type the balance from your statement into your snapshot tab each month.
How often should I update my net worth?
Update your net worth once a month, on the last day. Monthly snapshots are frequent enough to show real trends and rare enough that market noise does not drive your decisions. A 15-minute monthly habit gives you 12 data points a year.