A net worth tracker in Excel is two lists, what you own and what you owe, with a column for each month. Total each list, subtract liabilities from assets, and chart the result row. Update it once a month, on a fixed day, and use cautious values for anything that is not cash.
How should the sheet be laid out?
Put months across the top, starting in B1 with April if you follow the April to March financial year, through to M1. Then:
- Rows 3 to 10: assets, such as savings account, fixed deposit, provident fund balance, mutual fund value, gold, property
- Row 11: Total assets, =SUM(B3:B10)
- Rows 14 to 18: liabilities, such as home loan, car loan, credit card dues, personal loan
- Row 19: Total liabilities, =SUM(B14:B18)
- Row 21: Net worth, =B11-B19
- Row 22: Change from last month, =C21-B21, starting in column C
Copy the formulas right across all twelve months, so you only type balances. Use a column of labels in A and keep the same row order every year, so last year's file can become next year's template.
A worked example with pretend balances
| Item | Month 1 | Month 2 |
|---|---|---|
| Savings account | ₹1,20,000 | ₹1,35,000 |
| Fixed deposit | ₹2,00,000 | ₹2,00,000 |
| Provident fund | ₹3,50,000 | ₹3,55,000 |
| Mutual funds | ₹1,80,000 | ₹1,76,000 |
| Gold | ₹1,50,000 | ₹1,50,000 |
| Total assets | ₹10,00,000 | ₹10,16,000 |
| Car loan | ₹3,20,000 | ₹3,12,000 |
| Credit card dues | ₹25,000 | ₹18,000 |
| Total liabilities | ₹3,45,000 | ₹3,30,000 |
| Net worth | ₹6,55,000 | ₹6,86,000 |
The change is 6,86,000 - 6,55,000 = ₹31,000. It comes from assets rising by ₹16,000 and liabilities falling by ₹15,000, and 16,000 + 15,000 = 31,000. Notice that the mutual fund value fell by ₹4,000 yet net worth still rose, because saving and repaying debt did the work.
How do I value a house or gold carefully?
A trusted number is better than an impressive one. A few ways to stay cautious:
- House: use what similar flats in your building or lane have recently sold for, not an advertised asking price, and consider leaving it out of the monthly total while showing it in a separate line.
- Gold: weigh it, multiply by the day's selling rate for that purity, and subtract what a jeweller would deduct for making charges or melting loss; ask for a buy-back figure if you are unsure.
- Vehicles: they lose value, so use a used-vehicle price you would genuinely accept and review once a year.
- Anything you cannot sell quickly: value it low and do not revise upward on a good day.
Never count something twice. A flat counted at its market value is offset by its home loan; the loan belongs in liabilities, at the outstanding principal on your latest statement.
Why update only once a month?
Daily prices for funds, gold and property move for reasons that have nothing to do with your habits. Checking daily creates anxiety and false patterns. Pick a day such as the 1st, read balances from statements and passbooks in one sitting, and enter them. Over a year the line chart tells a calmer, truer story.
How do I add the chart?
- Select row 21 together with the month labels in row 1.
- Choose Insert, then Line chart.
- Give it a title, and make sure the axis starts where the numbers make sense.
- Optionally add a second line for total liabilities to watch debt shrink.
Keep a short note under the sheet recording how each value was worked out, for example gold weighed at home on a given date or flat valued on a recent sale in the building. Next month you will not remember, and a consistent method matters more than a perfect figure.
Where do the changes come from?
Net worth shows the result; spending explains it. If the line is flat, look at where the month's money went. Importing bank statements into SpendixAI and reading its reports is one way to find the leak, while the net worth sheet stays your once-a-month scoreboard.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


