Build a Net Worth Tracker in Google Sheets or Excel (Formulas Included)

Your salary tells you what comes in. Your bank balance tells you what is sitting in one account today. Neither tells you whether you are actually getting ahead. Net worth does. It is a single number - everything you own minus everything you owe - and watched over time, it quietly answers the question most budgets cannot: is all this effort working?

This guide shows how to calculate your net worth step by step, what to include and what to leave out, and how to build a small spreadsheet that turns a one-off calculation into a monthly log with the totals, ratios and trend calculated for you.

The formula (it really is just one line)

Net worth = total assets - total liabilities

• Assets are things you own that have value: money in accounts, savings, investments, retirement funds, your home, your car, and other valuable property.
• Liabilities are debts you owe: credit cards, personal loans, car loans, student loans, a mortgage, and any other amount you must repay.

If you own 353,300 in total and owe 226,300, your net worth is 127,000. That example is hypothetical, and we'll use it as sample data below.

A negative result is not a failure. It is a starting line. Many people begin below zero because of student loans or a new mortgage, and then watch the number climb as debts shrink and savings grow. The direction matters more than the starting point.

Step 1: List everything you own

Start with the easy, exact numbers, then move to estimates.

• Bank and cash: checking and savings balances today.
• Savings for goals: emergency fund, sinking funds and other earmarked savings. The guide to sinking funds for beginners explains how to organise them.
• Investments: brokerage and other investment accounts at today's value, knowing they will move up and down.
• Retirement: pension and retirement accounts at today's value. Include them even if you cannot touch them for years.
• Property: a conservative estimate of what your home could sell for, not the most optimistic listing on your street.
• Vehicles and other assets: a realistic resale value, not what you paid. When in doubt, estimate low.

Being consistent matters more than being perfect: if you include the car this month, include it every month, valued the same cautious way.

Step 2: List everything you owe

• Credit card balances (the full statement balance, not the minimum due)
• Personal, car and student loans - the remaining balance, not the original amount
• Your mortgage balance
• Any other debt: medical bills on a plan, tax owed, money borrowed from family that you intend to repay

Do not include future regular bills like next month's rent or utilities. Those are expenses, not debts, until they are actually owed and unpaid.

Building the spreadsheet: the Accounts sheet

Create a sheet called Accounts. One row per account, starting at row 2:

A: Account	B: Kind	C: Type	D: Balance	E: Liquid?
Checking	Asset	Bank	4200	Yes
Savings	Asset	Savings	11500	Yes
Brokerage	Asset	Investments	18600	No
Retirement	Asset	Retirement	42000	No
Home	Asset	Property	265000	No
Car	Asset	Vehicle	12000	No
Credit card	Liability	Card	2300
Car loan	Liability	Loan	8000
Mortgage	Liability	Mortgage	216000

Enter all balances as positive numbers - the Kind column decides whether they add or subtract. Then put a small summary block to the right (say column H/I):

I2  Total assets:       =SUMIF(B:B, "Asset", D:D)
I3  Total liabilities:  =SUMIF(B:B, "Liability", D:D)
I4  Net worth:          =I2 - I3
I5  Debt-to-assets:     =IF(I2 = 0, 0, I3 / I2)
I6  Liquid money:       =SUMIFS(D:D, B:B, "Asset", E:E, "Yes")

With the sample data, I2 is 353,300, I3 is 226,300 and I4 is 127,000. Format I5 as a percentage - here it is about 64%. As it falls over time, more of what you own is truly yours.

Add one more input, your monthly essential spending, and you get a rough safety-buffer figure:

I7  Monthly essentials:  2800
I8  Months covered:      =IF(I7 = 0, 0, ROUND(I6 / I7, 1))

To see where your money sits by type (handy for a pie chart), list the types in column K and use:

L2:  =SUMIFS($D:$D, $C:$C, K2, $B:$B, "Asset")

Step 3: The Monthly Log

A single calculation is a photo. A monthly log turns it into a film. Create a sheet called Log:

A: Month	B: Assets	C: Liabilities	D: Net worth	E: Change	F: Growth %	G: Note

Formulas for row 3 onwards (row 2 is your first month, which has no change yet):

D2:  =IF(B2 = "", "", B2 - C2)
E3:  =IF(OR(D3 = "", D2 = ""), "", D3 - D2)
F3:  =IF(OR(E3 = "", D2 = 0), "", E3 / ABS(D2))

Using ABS() in the growth formula keeps the sign meaningful when you start with a negative net worth - an improvement from -10,000 to -8,000 shows as +20%, not -20%.

Once a month, copy the current totals from Accounts and paste them as values (Ctrl+Shift+V in Google Sheets, Paste Special > Values in Excel) into the next row of Log, then add a one-line note about what drove the change.

Summary rows for an annual review:

First net worth:   =INDEX(D2:D37, MATCH(TRUE, INDEX(D2:D37 <> "", 0), 0))
Latest net worth:  =LOOKUP(2, 1 / (D2:D37 <> ""), D2:D37)
Total change:      =Latest - First

(Replace Latest and First with the cells holding those results.) And in Google Sheets, a tiny trend line in a single cell:

=SPARKLINE(FILTER(D2:D37, D2:D37 <> ""))

What people usually get wrong

• Counting income as wealth. A high salary with nothing kept is not wealth yet. Net worth counts what you have kept and built.
• Using hopeful property values. An optimistic home value flatters the number and hides real progress elsewhere. Revalue rarely, and cautiously.
• Forgetting small debts. Store cards, small plans and borrowed amounts are easy to omit - and they are often the most expensive per unit owed.
• Checking too often. Investments move daily. A monthly snapshot is frequent enough to see a trend and rare enough to stay calm.
• Comparing with other people. Ages, incomes, housing markets and family help differ wildly. Your only useful comparison is your own number a few months ago.

A simple annual review

Once a year, give the number thirty minutes instead of ten.

• Compare your first entry of the year with the latest: how much did net worth change, in money and in percent?
• Which moved more - assets up, or debts down? Both are progress, but they suggest different next steps.
• Did liquid money grow toward the buffer you want?
• Set one goal for next year: a net worth target, a debt-to-assets level, or one specific debt gone.

If debt is the main weight on your number, compare payoff strategies with the free debt snowball vs avalanche calculator before deciding where extra money should go.

Start today, imperfectly

Do not wait until every estimate is exact. List the accounts you know, estimate property cautiously, add every debt you can find, and subtract. That first number - even a rough one, even a negative one - is the baseline every future month will be measured against.

This article is general information, not financial advice.

---

If you'd like this ready-made - an Accounts tab, a 36-month log and a dashboard with net worth, debt-to-assets, liquid money and a trend chart, for Excel and Google Sheets - it's in the Smart Budget Sheets store.