Tracking your net worth is not about bragging rights or anxiety — it's about having a single honest number that shows whether your overall financial position is improving over time. A simple spreadsheet you update monthly does more for long-term behaviour than any budgeting app. Here is exactly how to build one in 2026.
What changed in 2026
- Google Sheets and Excel both have built-in STOCKHISTORY and linked data types that can auto-pull brokerage values for some accounts. This makes keeping investment balances current easier, though manual entry is still perfectly fine.
- More people have complex balance sheets — a mix of taxable brokerage, 401(k), HSA, crypto, home equity, and multiple debt types. The template needs to handle all of it cleanly.
- Apps like Monarch Money and Copilot auto-aggregate account balances, but a personal spreadsheet is still preferred by many for privacy, control, and the mental act of reviewing each line.
The core structure
Your net worth spreadsheet has exactly two sections:
| Section |
What goes here |
| Assets |
Cash, HYSA, checking, brokerage, 401(k)/IRA/Roth, HSA, home value, car value, other property, other |
| Liabilities |
Mortgage balance, car loan, student loans, credit card balances, personal loans, HELOC, other |
Net worth = Total assets − Total liabilities
That is the whole model. Every line either adds or subtracts. The rest is just being thorough and consistent.
How to build the spreadsheet step by step
- Open a new sheet in Google Sheets or Excel. Name the tab "Net Worth."
- Create a Date column across the top (one column per month or quarter). Start with today.
- List every asset on a row. Be specific: "Chase Checking," "Fidelity Roth IRA," "Home — Zillow estimate," "Toyota Camry — KBB value."
- List every liability on a row. "Chase Sapphire balance," "Federal student loans," "Mortgage — remaining balance."
- Add a Total Assets row and a Total Liabilities row using SUM formulas.
- Add a Net Worth row:
=Total Assets − Total Liabilities.
- Add a line chart with date on the X-axis and net worth on the Y-axis. Seeing the trend visually is the whole point.
- Update once a month. Log balances for each account, calculate the new totals, and watch the line move.
What to include (and what not to)
| Include |
Notes |
| All bank accounts |
Use current balance |
| Brokerage and retirement accounts |
Use current market value |
| Home |
Use a conservative estimate (Zillow, recent comps). Mark it clearly as an estimate. |
| Vehicles |
Use KBB private-party value — depreciate over time |
| HSA |
Often forgotten; it is an asset |
| All debt balances |
Card balances, loans, mortgage principal remaining |
Do not include personal property that is difficult to value or sell (furniture, clothing, jewelry unless you can verify worth). Be conservative; an inflated asset side is just flattering noise.
How to pick the right update frequency
| Frequency |
Best for |
| Monthly |
Most people — frequent enough to catch changes, not so frequent that market noise dominates |
| Quarterly |
People with stable employment and simple balance sheets |
| Weekly |
Actively paying down debt or in an intensive savings sprint |
Common mistakes
Valuing the home too generously. Zillow estimates vary. Use a middle estimate and note it is approximate. Consider discounting 5–8% for selling costs if you ever want a "liquidation net worth" view.
Forgetting retirement accounts. 401(k) and IRA balances are real assets. Omitting them dramatically undercounts your actual position.
Not tracking liabilities carefully. If you only track assets, you cannot see whether debt paydown is driving growth or investment returns are.
Updating inconsistently. A spreadsheet with 3 months of data then a 9-month gap is not a trend — it's a snapshot.
Panicking at short-term drops. A month where markets fall will show a lower net worth. Focus on the 12-month or multi-year trend, not individual data points.
What to skip
- Overly elaborate formulas. A net worth tracker should take 10–15 minutes to update. If yours takes an hour, simplify.
- Tracking to the dollar. Round to the nearest hundred. The signal is the direction and order of magnitude, not decimal precision.
- Using net worth to justify spending. "My net worth went up, so I can splurge" is how the number stops growing.
FAQ
Should I include home equity in net worth?
Yes, but separately. Track your home value and your mortgage balance as distinct rows. Home equity is real wealth but illiquid — some people like a "liquid net worth" row that excludes home equity and vehicle values.
How do I handle retirement accounts that I cannot access yet?
Include them at full market value. They are real assets. You can add a separate "liquid net worth" row that excludes tax-advantaged accounts if you want that view.
What if my net worth is negative?
Very common early in life, especially with student loans or a recent mortgage. A negative net worth trending toward zero and then positive is exactly what the tracker is for — watch the direction, not just the number.
What is a good net worth growth rate to target?
It depends heavily on income, age, and goals. A useful rough heuristic: net worth should grow faster than inflation over any rolling 5-year period. Beyond that, see a financial planner for goal-specific targets.
Where to go next
See How to calculate take-home pay in 2026, How to build a debt payoff plan in 2026, and How to rebalance once a year in 2026.