Net Worth Tracker Spreadsheet for Excel and Google Sheets

Most people who go looking for a net worth spreadsheet already know the definition. What they actually want is the layout: which tabs, which columns, which formulas, and what to do about the house.

This page gives you all of that. There is a complete worked example with real numbers you can copy the structure from, the eight formulas that do every calculation in a net worth tracker, a four-tab build you can finish in an hour, and the one entry mistake that quietly reports a solvent household as broke. Everything here works identically in Microsoft Excel and Google Sheets.

The Only Equation a Net Worth Tracker Needs

Net worth is total assets minus total liabilities. Everything else in a tracker — category subtotals, percentage breakdowns, trend charts, goal progress — is decoration built on that one subtraction.

Which means a net worth spreadsheet is not a calculation problem. It is a bookkeeping problem: getting every account listed once, in the right column, and updated on a schedule. The tracker’s job is to make that ten minutes of work instead of an afternoon.

A Complete Worked Example

Here is one household’s net worth statement. The numbers are illustrative, chosen to look like a typical mid-thirties household with a mortgage, a retirement balance, and some consumer debt. Copy the structure, not the figures.

Assets

Liabilities

Net worth: $516,650 − $304,330 = $212,320.

What the Breakdown Actually Tells You

The single number is the headline. The percentage split is the useful part, and it is why a good tracker calculates each category as a share of the total:

Read that column and one thing jumps out: 74.5% of this household’s assets are a house they live in. Liquid assets — cash, savings, brokerage, crypto — come to $34,550, which is 6.7% of assets and 16.3% of net worth. On the liability side, the mortgage is 88.2% of all debt, and the debt-to-asset ratio is 58.9%.

None of that is visible in “$212,320.” A net worth number tells you where you stand. The percentage breakdown tells you what to do next — in this case, that a strong-looking net worth is mostly illiquid, and the $3,180 at 22.9% is costing more per dollar than every other debt combined.

The Mistake That Breaks Most Net Worth Spreadsheets

There are two correct ways to enter a house, and one very common wrong way.

Gross method: the home’s full market value goes on the assets tab, and the full mortgage balance goes on the liabilities tab.

Equity method: market value minus mortgage goes on the assets tab as a single figure, and the mortgage is left off the liabilities tab entirely.

They give the identical answer. The hybrid does not:

The hybrid subtracts the mortgage twice, understating this household by exactly $268,400 — the mortgage balance. It happens because plenty of templates label the real estate row “Home Equity,” people dutifully enter equity, and then also list the mortgage on the liabilities tab because obviously a mortgage is a liability.

If your tracker’s real estate row says equity, either leave the mortgage off the liabilities tab, or change the row to say market value and list the mortgage. Pick one. The gross method is the better default: it keeps the mortgage visible with its rate and minimum payment, which you need for the debt side of the picture anyway.

What Counts as an Asset — Including the Awkward Ones

The obvious lines are easy. These are the ones people get wrong:

• Cars — yes, at resale value, not what you paid. Look up a private-party value and refresh it once a year. A car is the one asset on the list that reliably goes down.
• HSA — yes. It is your money. If it is invested rather than sitting in cash, it belongs with the investment accounts.
• 529 plans — usually no. The money is earmarked for someone else’s tuition. If you include it, put it on its own line so you can see net worth with and without it.
• A pension — only if it has a cash balance you could actually take. A defined-benefit pension that pays a monthly income in retirement has no balance to enter; it is real wealth but it is not a balance-sheet line.
• Whole life insurance — the cash surrender value only, never the death benefit.
• Security deposits and prepaid rent — yes, if you expect to get them back.
• Personal belongings — generally no. Furniture, clothes, and electronics are worth a fraction of what you paid and re-guessing them every month adds noise, not signal. Jewellery, art, or collectibles with a real appraised resale market can go on an “other assets” line.
• A business you own — at a defensible valuation or not at all. An optimistic number here will dominate your trend line and teach you nothing.
• Unvested equity or options — no. You do not own it yet.

On the liability side, list every balance you owe: mortgage, HELOC, student loans, auto loans, credit cards, personal loans, medical debt, tax owed, and money borrowed from family. Recording the interest rate and minimum payment beside each balance costs nothing and turns the liabilities tab into a debt payoff worksheet as well.

The 8 Formulas That Do Every Calculation

These are the entire formula set. All eight work identically in Excel and Google Sheets.

That last one is worth a second look. Feed it a 6% assumed annual return, $1,450 saved per month, the household’s current $212,320, and a $300,000 goal, and it returns 32.3 months — call it 33 months, since the balance only clears $300,000 at the end of month 33. Change the monthly contribution and the answer moves immediately. That single cell turns a tracker into a planning tool.

Two guards worth adding while you build:

• Wrap every division in IF(denominator=0, 0, ...). An empty tracker divides by zero on day one and shows #DIV/0! across the dashboard, which is the fastest way to abandon a new spreadsheet.
• Total your subtotal cells, not the full column. =SUM(C5:C38) over a range that already contains subtotal rows will double every number in it.

Build the Four Tabs Yourself

If you would rather build than buy, this is the whole design.

Tab 1 — Assets. Columns: account name, category, current balance, notes. Group the rows by category with a subtotal row after each group (=SUM(C5:C7)), then a total assets row that adds the subtotals. Eight categories cover almost everyone: cash & checking, savings & emergency, retirement, brokerage & investments, crypto, real estate, vehicles, other.

Tab 2 — Liabilities. Columns: debt name, category, current balance, interest rate, minimum payment. Same subtotal structure. Six categories: mortgage, student loans, auto loans, credit cards, personal loans, other.

Tab 3 — Monthly Snapshots. One row per month, twelve rows to a year. Columns: month, total assets, total liabilities, net worth (=C4-D4), change in dollars (=E5-E4), change in percent. This tab is the one that actually keeps people coming back — chart column E and you have your trend line.

Tab 4 — Dashboard. Pull total assets, total liabilities, and net worth from the other tabs, then add the month-over-month and year-to-date changes and the two percentage breakdown tables. Nothing on this tab should be typed; every cell is a reference or a formula.

Optional fifth tab, if you hold individual positions: an investment portfolio tab with ticker, shares, cost basis per share, total cost (=D4*E4), current price, current value (=D4*G4), gain/loss, and gain/loss percent. In Google Sheets you can replace the manual current-price column with =GOOGLEFINANCE("VTI","price"), with the caveat that the prices are delayed rather than real-time and coverage of mutual funds is patchy.

Finally, format the input cells one colour and the formula cells another. Six months from now, that is the only thing telling you where you are allowed to type. Once the structure exists, our walkthrough on tracking your net worth every month covers the update routine itself.

Reading the Trend: What 12 Months Looks Like

The same household, tracked for a year. The model: $1,450 a month into savings and investments, $755 a month against consumer debt, and roughly $445 a month of mortgage principal on top of that. The market does what markets do — this run uses a monthly return sequence with three negative months. Note that twelve snapshots give you eleven months of change, which is why the totals below are eleven months of contributions, not twelve.

A full year, +$34,200 — up 16.1%. The interesting part is where it came from: $15,950 of contributions, $13,200 of debt paydown ($8,305 of it consumer debt, $4,895 mortgage principal), about $7,085 of market gains, less $2,035 of car depreciation. That works out to roughly 79% of the year’s progress having nothing to do with investment returns.

Which is the argument for tracking monthly rather than watching a brokerage app. September was down $1,595 and it changed nothing about the year — saving and paydown absorbed it inside four weeks. If this household had been checking weekly, they would have lived through that drawdown several times over. Once a month, same day, ten minutes — and the house value stays fixed for the year and gets refreshed once, so the line measures saving and paydown rather than a property estimate wobbling.

Excel or Google Sheets for a Net Worth Tracker?

Both work. They differ in ways that actually matter for this specific job:

For a shared household tracker, Sheets usually wins on the simultaneous-editing and free-version-history lines — see tracking net worth as a couple for how to structure ownership columns. For a private file with a lot of holdings, Excel wins on offline access and speed.

You do not have to choose permanently. An .xlsx template opens in Excel and uploads to Google Drive, and formulas, conditional formatting, dropdowns, and charts all survive the trip. The only things that do not are VBA macros and the two platform-specific price functions — so a template built without macros genuinely runs in both.

What to Look For in a Template

If you would rather buy than build, these are the things that separate a tracker you will still be updating next year from one you abandon in March:

1. It does the math. You enter balances; the totals, ratios, percentages, and charts recalculate. If a template asks you to add up your own accounts, it is a formatted table, not a tracker.
2. Separate tabs for assets, liabilities, and a dashboard. Detail goes on the tabs, the summary is read on the dashboard. Cramming everything onto one page falls apart at about twenty accounts.
3. A monthly snapshot tab with month-over-month change. The trend is the motivating part. A tracker that only shows today’s number gives you nothing to come back for.
4. Percentage breakdowns, not just totals. The 74.5%-in-real-estate insight above only exists because something calculated the shares.
5. A portfolio tab with cost basis and gain/loss, if you hold individual positions. Otherwise your investments are one opaque number. The same applies if you hold accounts at several brokerages — tracking multiple investment accounts is where single-number tracking breaks down first.
6. Conditional formatting and dropdown validation. Green for gains, red for losses, a distinct colour for input cells, and category dropdowns so your data stays consistent enough for the breakdowns to be correct.
7. No macros, so it works in both apps. A macro-driven Excel template locks you out of Google Sheets permanently.

Six Mistakes That Make a Tracker Useless

1. Double-counting the mortgage. The single most expensive error, and worth $268,400 of phantom debt in the example above. Gross method or equity method — never both.
2. Summing a column that contains subtotals. Doubles everything. Total the subtotal cells explicitly.
3. Re-appraising the house every month. A property estimate that moves 2% on a whim will swamp a year of real saving. Refresh it once or twice a year and note the date.
4. Updating whenever you feel like it. Irregular intervals make the change column meaningless — you cannot compare a five-week gap to a three-week one. Same day every month.
5. Leaving debts off because they are embarrassing. A tracker that omits the $3,180 in credit cards is not a net worth tracker. The number is only useful if it is true.
6. Checking it weekly. You will see market noise and read it as personal failure. Monthly is the interval where saving and paydown outweigh the noise — which is exactly what the September row above shows: a losing market month that the year barely noticed.

Buy or Build?

Building is genuinely viable. Everything above is the complete design: four tabs, eight formulas, an hour of work. If you enjoy spreadsheets, build it — you will understand every cell, which is worth something on its own.

Buying makes sense if you want the structure already wired and tested. A pre-built template arrives with the category tree, the subtotal chain, the percentage breakdowns, the cross-tab dashboard references, the conditional formatting, and the month-over-month math already correct — including the sort of division-by-zero guards that make an empty tracker look finished rather than broken. Templates run roughly $8 to $20 as a one-time purchase. Subscription net worth apps run $5 to $15 a month, so a template pays for itself in about two months and then keeps working whether or not you keep paying.

Do This Today

1. List every account on one page — every asset, every debt, no editing for embarrassment. This is the step that takes real time; the spreadsheet part is fast.
2. Decide gross or equity for the house, and write your choice in the notes column so future-you does not re-litigate it.
3. Enter the balances and read the percentage column, not just the total. That is where the actionable finding is.
4. Put a recurring calendar reminder on the same date each month. Ten minutes. The habit is the product; the spreadsheet is just what makes ten minutes enough.

The Bottom Line

A net worth tracker is one subtraction wrapped in good bookkeeping. Get the accounts listed once each, handle the house consistently, guard the divisions, and update on a fixed monthly schedule, and you have a tool that turns an abstract question into a line that goes up.

The example household is worth $212,320 — or minus $56,080, if the mortgage gets counted twice. Which of those two numbers your spreadsheet shows has nothing to do with how good it looks and everything to do with how it is wired. When the wiring is right, the number stops being a mystery and becomes a plan; from there, progress toward the first $100K becomes a countdown rather than a hope.

One note, since this page just spent a section on it: the tracker’s real estate row is labelled Home Equity (Market Value − Mortgage). That is the equity method — so if you enter equity there, leave the mortgage off the liabilities tab. Prefer the gross method? Retype that row as “Home — Market Value,” enter the full value, and list the mortgage as a liability. Either is correct. Doing both is the −$56,080 mistake.