Google Sheets is a genuinely good net worth tracker — free, flexible, and partially self-updating. But let’s be precise about what “auto-updates” means, because a lot of tutorials oversell it: the built-in GOOGLEFINANCE() function will keep your stock, ETF, and most mutual fund values current automatically. Your house, car, bank balances, and loan payoffs will not update themselves — those are manual entries, and any tracker that promises otherwise is glossing over it. The good news: a once-a-month, 15-minute manual update is enough, and the structure below makes it painless.
Step 1: Set Up the Sheet Structure
Create one spreadsheet with three tabs. Here’s the starter structure for the main Net Worth tab:
| Section | Line item (examples) | Update method |
|---|---|---|
| Cash | Checking, savings, cash on hand | Manual, monthly |
| Investments | Brokerage, IRA, 401(k) holdings | Auto via GOOGLEFINANCE() |
| Real estate | Home estimated value | Manual, quarterly |
| Vehicles | Car resale estimate | Manual, quarterly |
| Other assets | HSA, 529, crypto, valuables | Mixed |
| Liabilities | Mortgage balance, auto loan, credit cards, student loans | Manual, monthly |
Then two supporting tabs:
- Holdings — one row per stock/ETF/fund position, feeding the Investments line.
- History — one row per month, capturing the totals so you can chart progress over time.
At the bottom of the Net Worth tab, three formulas do the work:
Total assets: =SUM(assets range)
Total liabilities: =SUM(liabilities range)
Net worth: =Total assets - Total liabilitiesStep 2: Make Investments Update Automatically
This is where Sheets earns its keep. On the Holdings tab, list each position:
| Ticker | Shares | Price | Value |
|---|---|---|---|
| VTI | 120 (example) | =GOOGLEFINANCE(A2,"price") | =B2*C2 |
| SCHD | 200 (example) | =GOOGLEFINANCE(A3,"price") | =B3*C3 |
GOOGLEFINANCE("VTI", "price") pulls the current market price and refreshes on its own (quotes can be delayed up to 20 minutes, which is irrelevant for net worth purposes). Sum the Value column and reference that total from your Net Worth tab. Now your investment line is genuinely live — the largest and most volatile chunk of most people’s net worth updates with zero effort.
Notes from real-world use:
- Mutual funds work with their ticker (e.g., index fund tickers); prices update after market close.
- Share counts are still manual. When you buy shares or dividends reinvest, update the Shares column. Monthly is fine.
- Crypto:
GOOGLEFINANCEhas limited support (some pairs likeCURRENCY:BTCUSDwork). Third-party functions you may see in older tutorials often break or require add-ons — for small holdings, a manual monthly number is more reliable than a fragile formula.
Step 3: Handle the Manual Assets Honestly
Everything else needs a human, and that’s fine — the trick is matching update frequency to how fast the number actually moves:
- Bank balances and credit cards: monthly. Two minutes with your banking apps open.
- Home value: quarterly at most. Use a consistent source (an online estimate, county assessment, or recent comps) and stick with it. Online home-value estimates are rough — being consistent matters more than being precise, because what you’re really tracking is the trend. Some people deliberately use their purchase price or a conservative figure to avoid inflating net worth with an unrealized, imprecise number. Either policy works; write down which one you chose.
- Vehicles: quarterly, from a used-car pricing site, and expect the number to only go down.
- Mortgage and loan balances: monthly from your lender’s portal. These fall predictably, so even updating quarterly barely distorts the picture.
Resist the urge to over-engineer this. There’s no reliable free formula that pulls your specific home’s value or your bank balance into Sheets — importing tricks from older tutorials tend to break within months. Fifteen minutes on the first of the month is the sturdier system.
Step 4: Build the History Tab and Chart
Each month, add one row to the History tab: date, total assets, total liabilities, net worth. Copy the values in as numbers, not formulas (Paste special → Values only), so past months don’t shift when prices move.
Then insert a line chart over the net worth column. This chart is the entire point of the exercise. Month-to-month, net worth is noisy — markets dip, an insurance bill lands. Over 12+ months, the line tells you unambiguously whether your financial position is improving, and that feedback loop changes behavior more than any budgeting lecture.
Two optional upgrades that are worth it:
- Conditional formatting on the liabilities section — highlight any debt that grew since last month. Debt should only move one direction.
- A simple ratio row — e.g., liabilities ÷ assets — to watch leverage decline over time.
Step 5: Keep It Alive
Trackers die from friction, so remove friction:
- Put a recurring calendar reminder on the 1st of the month: “Update net worth sheet — 15 min.”
- Keep a short checklist cell in the sheet itself: banks, cards, loans, share counts, paste history row. Same order every month.
- Don’t track daily. Watching
GOOGLEFINANCEwiggle your net worth in real time is entertainment, not information. The monthly snapshot is the signal.
Sheets vs. an App: When to Use Which
Fair comparison: apps like Empower Personal Dashboard, Monarch Money, and Copilot Money link directly to your bank, brokerage, and even lenders, so account balances sync without manual entry — genuinely more automated than Sheets for cash and loans. What the spreadsheet gives you instead is control and permanence: your categories, your valuation policy for the house, no subscription, no account-linking, and a history that can’t disappear when an app changes owners or pricing.
Plenty of people run both — an app for daily visibility, the sheet as the monthly system of record. But if you only want one tool and you’re comfortable with a 15-minute monthly ritual, the Google Sheets tracker above does the job for free, with your stock and fund values updating themselves and everything else exactly as current as you keep it. Build the three tabs this weekend and log your first History row — the chart gets interesting faster than you’d think.