To track net worth, list what you own and what you owe on the same date, subtract the debts from the assets, and repeat for the next month. The formula is short. The useful work is keeping the dates, account list and valuation method consistent.
This guide builds a small monthly tracker you can reproduce in Excel or Google Sheets. The numbers are fictional and use one currency throughout. It also covers three mistakes that can make a perfectly functioning spreadsheet give a misleading answer: counting home equity twice, treating transfers as new wealth, and leaving a debt out of a month.
Start with a snapshot, not a list of transactions
A budget records money earned and spent over a period. A net worth tracker records balances at a point in time. Your monthly salary belongs in your budget; the money still in your bank account on the reporting date belongs in your net worth.
Pick a repeatable date, such as the last day of each month. Gather bank, investment and loan balances for that date. For assets without a monthly statement, record the valuation method and when you last reviewed it. Consistency makes the change between months easier to interpret.
The CFPB's personal balance sheet guidance defines net worth as assets minus liabilities. Our example uses that definition; it does not estimate retirement income or how much cash you can immediately spend.
A complete two-month example
Create these four columns, with headers in row 1. Type balances as positive numbers, including debts. The Type column determines which side they belong to.
| Account | Type | 31 Jan balance | 28 Feb balance |
|---|---|---|---|
| Current account | Asset | 2,500 | 2,800 |
| Savings | Asset | 8,000 | 8,500 |
| Investment account | Asset | 15,000 | 14,600 |
| Home value | Asset | 240,000 | 240,000 |
| Mortgage balance | Liability | 180,000 | 179,600 |
| Credit card balance | Liability | 1,200 | 900 |
This puts the six accounts in rows 2–7, Type in column B, January in C and February in D. In a real file, use full dates including the year in the column headings.
Under the table, use these labels in A9:A11 and formulas in C9:C11:
C9 =SUMIF($B$2:$B$7,"Asset",C2:C7)
C10 =SUMIF($B$2:$B$7,"Liability",C2:C7)
C11 =C9-C10
Label the rows Total assets, Total liabilities and Net worth. Copy C9:C11 across to D9:D11. The fixed Type range stays in column B; the balance ranges move to February. Google documents SUMIF, including this use of a separate range to add.
| Result | January | February |
|---|---|---|
| Total assets | 265,500 | 265,900 |
| Total liabilities | 181,200 | 180,500 |
| Net worth | 84,300 | 85,400 |
| Change from January | — | +1,100 |
Put =D11-C11 in D12 to calculate the change. If you add accounts, extend every account range, including the checks below. These example formulas deliberately cover six rows; they do not discover new accounts outside them.
Explain the change before celebrating it
February's net worth rose by 1,100. Here is the reconciliation:
- Current account increased by 300.
- Savings increased by 500.
- Investments fell by 400.
- Home value was unchanged.
- Mortgage debt fell by 400.
- Credit card debt fell by 300.
The assets rose by 400 and the liabilities fell by 700. Together, that explains the 1,100 increase. It is not a 1,100 investment return: it includes saving, spending, repayments and valuation changes. A net worth total alone cannot separate those causes.
Avoid the home-equity double count
In this example, enter the home's full estimated value of 240,000 as an asset and the outstanding mortgage of 180,000 as a liability. Their combined contribution is 60,000.
Do not also add a separate 60,000 home-equity asset. That would count the same ownership twice. Nor should you enter only 60,000 as the home value and then subtract the mortgage again.
The same principle applies to a financed car: if you include the car, record an estimated current sale value and list the outstanding loan separately. Keep your valuation assumptions in notes. An estimate is not a guaranteed sale price.
A savings transfer does not increase net worth
Move 500 from the current account to savings, with no fees and no other activity. The first balance falls by 500 and the second rises by 500. Total assets and net worth are unchanged.
Likewise, paying 300 of credit-card principal from cash reduces assets and liabilities by the same amount. That transaction alone leaves net worth unchanged. Interest and fees are different: they reduce wealth rather than cancelling an equal amount of existing principal.
These are useful checks when a monthly jump looks suspicious. Recording a transfer as both new income and an increased savings balance can produce an apparent gain that never happened.
Treat a missing balance differently from zero
A blank mortgage cell can make the total look dramatically better. In this example, omitting January's 180,000 mortgage would inflate net worth from 84,300 to 264,300.
For this fixed six-account table, put the following check in C13 and copy it to D13:
=IF(COUNT(C2:C7)=COUNTA($A$2:$A$7),"Complete","Check missing or text balances")
Only trust the total when every listed account has a numeric balance and each Type is correct. A genuine zero counts as a number. Text such as 8,000 kr does not; use plain numbers and apply currency formatting. A dropdown containing Asset and Liability helps prevent misspelt types.
This check catches incomplete balances, not wrong amounts or duplicate accounts. Compare the account list with your statements and avoid recording both an investment account total and its individual holdings.
A short monthly routine
- Choose the reporting date and gather the matching balances.
- Fill every active account, using zero only when it really is zero.
- Review changed debts and any unusually large asset movement.
- Reconcile the change and note one-off events or revised valuations.
- Save the month without overwriting the previous snapshot.
If you share accounts, choose either a household view or a consistent personal share. Do not switch between the full balance and half the balance from month to month. Keep different currencies separate unless you deliberately convert them using a documented date and rate.
Use the ready-made tracker if you prefer to skip the setup
The Net Worth Tracker provides an account register, twelve monthly balance columns and a dashboard. The screenshot below shows its fictional demo, not the six-account example above.
Fill every active account before interpreting a month: the product treats a month with even one entered balance as populated. It does not connect to your bank or independently verify that your account list is complete.
If you want to understand why the balances changed, pair the monthly snapshot with a budget-versus-actual review. One shows where you stand; the other helps explain what happened during the month.
Sample data in screenshots is illustrative, not results. This article is informational. It is not financial, tax, investment or legal advice.
