A net worth tracker spreadsheet answers the one question every other money app dances around: are you actually getting richer? Your bank app shows a balance. Your credit app shows a score. Your investment app shows a squiggly line.
None of them shows the whole picture — everything you own, minus everything you owe, moving through time. That single number is your financial ground truth, and watching it monthly changes behavior in a way budgets alone never do.
So we built the tracker for you: one clean spreadsheet, assets on top, debts below, net worth calculated automatically, month over month. Free, no login, works in Excel and Google Sheets. Download it below, then read the five rules that turn a spreadsheet into an actual wealth-building habit — because the sheet is the easy part.
The quick version: Net worth = everything you own (cash, savings, retirement, investments, home, car) minus everything you owe (cards, loans, mortgage). A net worth tracker spreadsheet logs both monthly and charts the difference — and the habit takes about five minutes a month. Our free template below does the math for you, including month-over-month change.
Download the Free Net Worth Tracker Here:
Free download, no email required. Works in Excel, Google Sheets and Numbers.
What’s inside:
| Section | What It Does |
|---|---|
| Assets | 7 pre-labeled rows (checking, savings, retirement, investments, home, vehicle, other) — just type balances |
| Liabilities | 6 debt rows (cards, student loans, auto, mortgage, medical, other) |
| Net Worth row | Calculated automatically: assets − liabilities, every month |
| Monthly change | Shows exactly how much you moved since last month |
| 6-month grid | Jan–Jun columns ready; copy right to extend forever |
| Example column | First month pre-filled with realistic sample numbers so you see the format — overwrite with yours |
Works in Excel, Google Sheets (File → Import), LibreOffice and Numbers. Blue cells are yours to edit; everything else calculates itself.
How to Use a Net Worth Tracker Spreadsheet (5 Rules That Make It Work)
Rule 1: Same day, every month. Pick a trigger you can’t miss — the 1st, or payday — and update the sheet then. Consistency matters more than precision: a slightly-rough number every month beats a perfect number twice a year. The update takes five minutes once your accounts are listed.
Rule 2: Statement balances, not vibes. Open each app, copy the actual number. For the house, use a conservative Zillow-style estimate; for the car, KBB private-party value — and keep the same method every month, because consistency is what makes the trend honest.
Rule 3: Watch the direction, not the number. A negative net worth is common early on (hello, student loans) and says nothing about your future. What matters is the monthly change row: green arrows compound. Paying $300 of debt moves it exactly as much as saving $300 — which is why your debt payoff strategy and your savings rate are the same project wearing different clothes.
Rule 4: Let the tracker assign jobs to your money. Once you see the whole board, inefficiencies pop: cash sleeping in checking could be earning 10x in a high-yield account; a 24% card balance is bleeding faster than any asset grows; a steady $200/month into index funds quietly becomes six figures. The tracker doesn’t just measure the game — it shows you the next move.
Rule 5: Review quarterly like a CFO. Every three months, look at the trend and ask three questions: What grew? What shrank? What’s the one lever for next quarter? That 15-minute ritual — not the spreadsheet itself — is where net worth tracking actually changes lives.
What Counts (and What Doesn’t)
The classic tracking mistakes, settled:
Count: checking and savings balances, retirement accounts at current value, brokerage accounts, your home at a conservative estimate, vehicles at realistic resale value, and meaningful valuables you’d genuinely sell (that’s what the “other” row is for).
Don’t count: future paychecks (not yours yet), unvested stock or bonuses, furniture and electronics (resale reality: pennies), and other people’s promises to pay you back.
The debated ones: Some people exclude home and cars entirely to track “liquid net worth” — money that could actually fund life. Fair approach; if you prefer it, just zero those rows. The tracker doesn’t care which philosophy you pick — only that you pick one and stay consistent.
And one adjacent number worth watching alongside: your credit score, because it prices every debt on the liabilities side. Raising it makes the whole bottom half of your tracker cheaper.
Why a Simple Spreadsheet Beats the Apps
Net worth apps exist — plenty are good. But the spreadsheet wins for most people for three unglamorous reasons: you own it (no company shutting down, changing pricing, or selling your linked-account data); manual entry is the feature, not the bug — physically typing your balances once a month forces the five minutes of attention that automation lets you skip; and it bends to you — add a row for your Pokémon collection or your lending side hustle, and the formulas don’t complain. Automation is great for paying bills. For awareness, friction is the point.
FAQ: Net Worth Tracker Spreadsheet
How do I calculate my net worth? Add everything you own (cash, savings, retirement, investments, home, vehicles at realistic values), then subtract everything you owe (credit cards, student loans, auto loans, mortgage, other debts). The result — positive or negative — is your net worth. Our free spreadsheet does the arithmetic automatically.
What is a good net worth for my age? Medians vary wildly and comparisons mislead — a 30-year-old doctor with $200k of student debt can have a lower net worth than a 25-year-old plumber, and better prospects. The useful benchmark is your own trajectory: is the number higher than 6 months ago? That’s the race you’re actually running.
Is it normal to have a negative net worth? Very — especially under 35, where student loans and car loans often outweigh early savings. Negative net worth with a positive monthly trend is a healthy financial story in progress. The tracker exists precisely to make that progress visible.
How often should I update my net worth tracker? Monthly is the sweet spot: frequent enough to catch drift, rare enough that market wiggles don’t dominate. Weekly tracking tends to turn into anxious market-watching; yearly hides problems for too long.
Does the spreadsheet work in Google Sheets? Yes — upload it via File → Import (or drag into Drive and open with Sheets). All formulas are standard and carry over. It also works in Excel, LibreOffice and Apple Numbers.
The tracker template and all formulas are original to The Money Raccoon. Definitions follow standard personal-finance accounting: net worth = total assets − total liabilities.
Personal finance writer, founder and editor of The Money Raccoon — 5 years in the industry and 1,000+ articles published in the finance niche. I turn complex money rules — credit scores, debt, banking and investing — into plain-English guides backed by primary sources and real numbers. Every guide here is fact-checked against the institutions that publish the data and updated when the numbers change.