Free Excel template
Free Excel net worth tracker template
For anyone who wants one number that shows whether their finances are moving in the right direction. List each account and what you owe, give each a type, and type the balances at the end of every month; the template totals cash, investments and property, subtracts debts and shows your net worth, the change from last month and your debt-to-asset ratio.
Preview and try it
This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Net worth tracker (enter each balance at month end) | ||||||||
| 2 | Account | Type | May 31, 2026 | Jun 30, 2026 | Jul 31, 2026 | Aug 31, 2026 | Sep 30, 2026 | Oct 31, 2026 | 6-month change |
| 3 | Checking | Cash | 3200 | 2850 | 3400 | 2950 | 3100 | 3380 | 180 |
| 4 | High-yield savings | Cash | 8200 | 8600 | 9000 | 9400 | 9800 | 10250 | 2050 |
| 5 | 401(k) | Investments | 48200 | 49100 | 50300 | 49800 | 51600 | 53100 | 4900 |
| 6 | Roth IRA | Investments | 14100 | 14500 | 15000 | 14800 | 15600 | 16100 | 2000 |
| 7 | Brokerage account | Investments | 6200 | 6350 | 6500 | 6300 | 6700 | 6900 | 700 |
| 8 | Home (estimated value) | Property | 385000 | 385000 | 387000 | 387000 | 388000 | 388000 | 3000 |
| 9 | Car (private-sale value) | Property | 17500 | 17300 | 17100 | 16900 | 16700 | 16500 | -1000 |
| 10 | Mortgage | Debt | 296400 | 295900 | 295400 | 294900 | 294400 | 293900 | -2500 |
| 11 | Car loan | Debt | 12400 | 11950 | 11500 | 11050 | 10600 | 10150 | -2250 |
| 12 | Credit card | Debt | 2100 | 1650 | 2800 | 1900 | 1400 | 950 | -1150 |
| 13 | Student loan | Debt | 18600 | 18400 | 18200 | 18000 | 17800 | 17600 | -1000 |
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | Cash | 11400 | 11450 | 12400 | 12350 | 12900 | 13630 | ||
| 18 | Investments | 68500 | 69950 | 71800 | 70900 | 73900 | 76100 | ||
| 19 | Property | 402500 | 402300 | 404100 | 403900 | 404700 | 404500 | ||
| 20 | Total assets | 482400 | 483700 | 488300 | 487150 | 491500 | 494230 | 11830 |
How the formulas work
Total each type of asset with SUMIF
SUMIF adds the balances in this month's column whose type matches the label in A17. The mixed references matter: $B$3:$B$15 and $A17 stay put, while C$3:C$15 moves to D, E and so on when you copy right. One formula fills the whole grid.
Net worth is assets minus debts
Total assets (cash, investments and property) minus total debts. Debts are typed as positive balances, the amount you owe, and subtracted here, which is easier to read than negative numbers. In the sample, net worth rises from $152,900 to $171,630 over six months.
Monthly change and percent change
Row 23 subtracts last month's net worth from this month's. The percentage divides by the absolute value of last month, so the sign still means up or down even if your starting net worth is negative, which is common with student loans. The IF avoids a divide-by-zero error in the first month.
Debt-to-asset ratio
Total debts divided by total assets. 0.75 means you owe 75 cents for every dollar you own. Watching it fall month by month is often more motivating than watching net worth itself, because paying down a loan shows up even when markets dip.
Make it yours
- Add a month by inserting a column before the 6-month change column, typing the month-end date at the top and copying the summary formulas across from the previous month.
- Value your home and car honestly and conservatively, and update them a few times a year rather than monthly. Big swings in an estimate can hide the progress you make in your accounts.
- Make a line chart of net worth: select C2:H2 and C22:H22 (hold Ctrl), then Insert > Line chart. Add a second line from row 26 to see your progress without the house.
- Keep the type names exactly as they appear in A17:A19 and "Debt". To add a type like Business, add a row to the summary and include it in the Total assets SUM.
FAQ
How do I calculate net worth in Excel?
Add up everything you own (account balances and estimated values of property), add up everything you owe, and subtract: =total assets - total debts. With a Type column, SUMIF can total each group so one sheet tracks all of it.
How often should I update my net worth tracker?
Monthly works well for most people: once at the end of each month, using the balance shown on that date. Updating daily mostly records market noise.
Should retirement accounts count toward net worth?
They are assets you own, so this template counts them. Some people also track a version without them, or without property, to see what they could use soon; row 26 shows net worth without property for that reason.
Functions used
Related guides
- SUMIFS with multiple criteria in Excel
- Absolute vs relative cell references in Excel
- #DIV/0! error in Excel
More free templates
- Expense report templateFor employees who need to claim back business costs, and for the managers and bookkeepers who check those claims.Free .xlsx
- Purchase order templateFor small businesses, office managers and buyers who send purchase orders to suppliers and want to track what actually arrives.Free .xlsx
- Accounts receivable aging report templateFor owners, bookkeepers and credit controllers who invoice customers on terms and need to see who owes what and for how long.Free .xlsx
- Weekly employee shift schedule templateFor managers of shops, cafes, restaurants and small teams who build the rota in a spreadsheet.Free .xlsx
Updated