Skip to content
Go back

Net Worth Tracker: Spreadsheet vs App

By KingPin 11 min read
Net Worth Tracker: Spreadsheet vs App

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.

  1. Assets. Everything you own that has a price.
  2. Liabilities. Everything you owe, entered as positive numbers so the math stays readable.
  3. A snapshot cadence. Once a month, on the last day. Weekly is noise. Yearly is a diary entry.
  4. 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.

AccountClassBalanceCounted?
CheckingAsset$9,000Yes
High-yield savingsAsset$41,000Yes
Taxable brokerage (300 shares at $290)Asset$87,000Yes
401(k)Asset$212,000Yes
Roth IRAAsset$38,000Yes
HSAAsset$14,000Yes
Vested RSUs (400 shares at $150)Asset$60,000Yes
Unvested RSUs (600 shares at $150)Excluded$90,000No
House (conservative value)Asset$576,600Yes
Car (conservative value)Asset$18,000Yes
MortgageLiability$410,000Yes
Car loanLiability$9,000Yes
Credit card statement balanceLiability$2,400Yes

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-31
B2 (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-C2

Unvested 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.

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.

OptionPriceNotes
Empower Personal DashboardFreeVendor page says the dashboard and tools are “completely free”
Tiller (feeds bank data into Google Sheets or Excel)$99 per yearBilled annually, 30-day free trial
Monarch$99.99 per year or $14.99 per month (Core); Plus is $199.99 per yearPricing 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

  1. Build the three-tab sheet above. It takes an afternoon.
  2. 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.
  3. On the last day of each month, copy the balances into the Snapshots tab as values.
  4. 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.


Share this post on:

Send a Webmention

Written about this post on your own site? Send a webmention and it'll show up above once verified.


Previous Post
Paying for a Kid: DCFSA vs the Tax Credit
Next Post
ProjectionLab vs cFIREsim vs FI Calc

Discussion

Powered by Garrul . Sign in with GitHub or Google, or post anonymously.

Related Posts