How to Build a Net Worth Tracker in Excel

A net worth tracker in Excel is one sheet that answers a simple question each month: what do I own, what do I owe, and is the difference growing? You list your accounts and debts, total them with SUMIF and compare month to month. This guide builds the tracker step by step on example figures. It's about the spreadsheet, not financial advice, so use your own numbers and decisions.

What does a net worth tracker show?#

Net worth is everything you own minus everything you owe, on a given date. In the tracker:

• Assets are things with money value that you own: bank balances, savings, investment and retirement accounts, and optionally a car or home at an estimated value.
• Liabilities are debts: credit cards, car loans, student loans, a mortgage.

Net worth = total assets − total liabilities.

One month's figure on its own says little. The value of the tracker is the trend: twelve monthly snapshots show whether the overall picture is moving in the direction you want. It pairs well with a monthly budget, which tracks the money flowing in and out between snapshots.

How to set up the net worth tracker sheet#

Use one row per account or debt and one column per month. Add a Type column so formulas can tell assets from liabilities. Here is an example with two months, in A1:D8. All figures are made up for illustration:

A few choices make the sheet easier to keep up:

1. Enter debts as positive numbers. A credit card balance of 1,400 goes in as 1,400, not -1,400. The formula subtracts liabilities for you, and the sheet reads like your statements.
2. Make Type a drop-down list. Use Data > Data Validation > List with Asset,Liability. A typo such as "Assets" would drop that row from the total.
3. Add a new column each month to the right of the last one. Never overwrite old months, because the history is the point.

The net worth formula with SUMIF#

SUMIF adds only the rows whose Type matches, so one formula gives the whole picture. Below the table, in C10, type:

=SUMIF($B$2:$B$8,"Asset",C2:C8)-SUMIF($B$2:$B$8,"Liability",C2:C8)

• The first SUMIF adds January's assets: 3,200 + 8,500 + 21,000 + 9,000 = 41,700.
• The second adds January's liabilities: 1,400 + 6,800 + 14,500 = 22,700.
• The difference is January's net worth: 19,000.

Now fill the formula right into D10 (Windows: Ctrl+R; Mac: ⌘R). The $ signs keep the Type column fixed on B, while C2:C8 moves to D2:D8. February's net worth is 42,800 − 21,750 = 21,050. The SUMIF function guide explains each argument.

It also helps to show the two totals on their own rows above net worth, so you can see which side moved. Use the same SUMIFs separately, or =SUM(C2:C5) for assets if they are always in rows 2 to 5. The SUM function guide covers the basics. SUMIF is safer, though: if you insert a new account in the middle, it is still counted by its Type.

How to track the monthly change#

Subtract last month's net worth from this month's to see the change in dollars. In D11:

=D10-C10

The result is 2,050. To show it as a percentage, divide the change by last month's value and format the cell as a percent:

=(D10-C10)/C10

That gives 10.8%. Be careful with percent change here. If net worth is negative or close to zero, the percentage becomes huge or flips its sign and stops meaning much. In that case, show only the dollar change. The guide to the percent change formula explains why a negative starting value causes trouble.

How to group items into categories#

Once the list grows, a short summary by category is easier to read than every account. Add a Category column, such as Cash, Investments, Property and Debt, and use SUMIF on that column instead of Type:

=SUMIF($C$2:$C$15,"Cash",D2:D15)

Here the Category column is C, so the month columns move one to the right. A small summary table with four category rows, one per month, shows where changes come from. For example, net worth may grow because a loan shrank, not because savings grew. If you're working through debts, a debt payoff calculator can sit on the next sheet and feed the expected balances into this one.

How to chart your net worth over time#

A line chart of the net worth row is the clearest way to see the trend. Select the month headers and the net worth row (hold Ctrl on Windows or ⌘ on a Mac to select both rows), then go to Insert > Insert Line or Area Chart > Line.

For more detail, a stacked column chart of total assets and total liabilities shows both sides of the picture. Keep the chart on the same sheet so it updates as you add months. If you have a target, such as an emergency fund amount, a savings goal calculator can show how far away it is.

Tips to keep the tracker accurate#

A tracker is only useful if the numbers are consistent:

• Update on the same day each month, such as the first, using statement balances or the balance shown that day.
• Value cars and other items realistically. Use a cautious estimate and lower it over time, or leave them out entirely and track only cash, investments and debt.
• Include every debt linked to an asset. If you list a car or home, list the loan or mortgage on it too.
• Keep it private. The file holds sensitive information. Store it somewhere secure and consider a password.
• Link it to your spending records if you keep them. An expense tracker explains where money went between two snapshots.

Practise it#

Try the exercise on this page: two SUMIFs give February's net worth in one formula. Then practise SUMIF in a live spreadsheet, where each formula is checked as you type, and practise percentages and % change to report monthly changes correctly.