Net Worth Tracker Spreadsheet With Free Net Worth Calculator

A net worth tracker spreadsheet lists everything you own and everything you owe, subtracts one from the other, and shows how that number changes over the year. It suits anyone paying down debt or building savings who wants a single figure that captures both. Try your own balances in the calculator above, then read on for a worked year, the setup, and the formulas to build a tracker yourself.

Reading the net worth calculator

The calculator starts with example numbers: $6,500 in cash and savings, $24,000 in retirement accounts, $3,000 in other investments and a car worth $9,000. Against that sit a $7,200 car loan, $14,500 in student loans and $1,800 on credit cards. That is $42,500 of assets and $23,500 of liabilities, so the net worth line reads $19,000.

The third line, debt as a share of assets, is total liabilities divided by total assets: $23,500 ÷ $42,500 is 55%. It tells you how much of what you own is, in effect, borrowed. Watch it fall as you pay down loans, even in months when net worth barely moves because the car lost value.

For a fair snapshot, take every balance from the same day. Mixing a credit card balance from the 3rd with a savings balance from the 28th can make the total look better or worse than it is.

What the net worth tracker spreadsheet tracks

The net worth tab in our budget spreadsheet for Google Sheets and Excel works from two lists and gives you two results:

• Assets: each account or item you own, with its current value, such as checking, savings, retirement accounts, a home or a car.
• Liabilities: each debt with its current balance, such as a mortgage, car loan, student loans or credit cards.
• Total net worth: assets minus liabilities.
• Annual growth: how much your net worth changed over the year.

It is a standalone tab. It does not read from the monthly budget, so you type in each balance yourself, which takes a few minutes per update. The same file holds the other standalone tools, including the debt calculator behind our debt snowball spreadsheet, which is useful when most of your liabilities are debts you are actively paying off.

Worked example: one year of net worth growth

These are example numbers. The start of the year matches the calculator above. The end of the year shows the same household twelve months later, using balances as they appear on statements, so retirement includes both contributions and market changes. No rate of return is assumed.

Item	Start of year	End of year	Change
Cash and savings	$6,500	$8,900	+$2,400
Retirement accounts	$24,000	$28,200	+$4,200
Other investments	$3,000	$3,400	+$400
Car (resale value)	$9,000	$7,900	-$1,100
Total assets	$42,500	$48,400	+$5,900
Car loan	$7,200	$4,500	-$2,700
Student loans	$14,500	$12,800	-$1,700
Credit cards	$1,800	$600	-$1,200
Total liabilities	$23,500	$17,900	-$5,600
Net worth	$19,000	$30,500	+$11,500

Net worth grew by $11,500, which is 60.5% of the starting $19,000. Three things stand out:

1. Almost half the growth came from debt. Liabilities fell by $5,600 of the $11,500 total. Paying down a loan raises net worth exactly as much as saving the same amount.
2. Debt as a share of assets fell from 55% to 37% ($17,900 ÷ $48,400). That ratio is often a better progress signal than the headline number.
3. The percentage flatters a small base. Growing $11,500 next year from $30,500 would be about 38%, although the effort is the same. Track the dollar change first and the percentage second.

How to set up the net worth tab

1. Choose an update date, such as the first of each month or each quarter, and stick to it.
2. Open the net worth tab. Because it stands apart from the monthly tabs, you can fill it in before or after the rest of the budget.
3. List each asset with today’s value: account balances from your statements, a realistic resale value for each vehicle, and, if you own a home, an estimate of what it would sell for.
4. List each liability with its full current balance, not the monthly payment. Include money owed to family if you intend to repay it.
5. Check the total net worth, then the annual growth figure as the year goes on.
6. On each update date, refresh every balance in one sitting so the snapshot stays consistent.

The method behind it

Net worth is total assets minus total liabilities, and three rules keep it honest:

• Use market value, not purchase price. A car bought for $30,000 is worth what it would sell for today.
• Count whole balances. A $14,500 student loan is a $14,500 liability, whatever the monthly payment.
• Skip everyday belongings. Furniture and clothes rarely sell for much, and guessing their value only adds noise.

Our guide on how to calculate net worth has the full checklist of what counts as an asset and what to do when the number goes down. If credit card balances make your figure jump around, the approach in how to budget with credit cards keeps them predictable. To push liabilities down faster, compare the debt snowball method with the debt avalanche method. And add a two-minute net worth check to your monthly budget review so updates happen on schedule.

Build your own net worth tracker in Google Sheets or Excel

If you would rather build it yourself, you need two tabs. On a Balances tab, use three columns: A for the item name, B for the type (Asset or Liability) and C for the balance. Then put these totals in column F:

Cell	Result	Formula (Google Sheets and Excel)
F2	Total assets	=SUMIF(B2:B40,"Asset",C2:C40)
F3	Total liabilities	=SUMIF(B2:B40,"Liability",C2:C40)
F4	Net worth	=F2-F3
F5	Debt as a share of assets	=IF(F2=0,"",F3/F2)

To make the type column a dropdown, select B2:B40. In Google Sheets, choose Insert > Dropdown and add Asset and Liability. In Excel, choose Data > Data Validation, set Allow to List and type Asset,Liability as the source.

On a History tab, put the date in column A and net worth in column B. On each update date, copy F4 and paste it as a value, not a formula: Edit > Paste special > Values only in Google Sheets, or Home > Paste > Paste Values in Excel. With monthly updates in rows 2 to 14, row 14 is exactly a year after row 2:

• Dollar growth over the year: =B14-B2
• Percentage growth: =(B14-B2)/ABS(B2). The ABS keeps the sign right when you start from a negative net worth.
• Net worth twelve months before the latest update: =INDEX(B2:B14,MATCH(EDATE(A14,-12),A2:A14,0)). This works in both apps as long as you update on the same day of the month.

For a trend line, the apps differ. Google Sheets has a function: =SPARKLINE(B2:B14) draws the line inside one cell. Excel has no SPARKLINE function, so select an empty cell, choose Insert > Sparklines > Line and enter B2:B14 as the data range.

Who it suits and who it does not

The net worth tab suits people paying off student loans or car loans who want proof of progress when the monthly budget feels flat, couples combining finances who want one shared figure, and anyone who likes a quarterly check-in instead of daily tracking.

It does not suit you if you want balances to update on their own. There is no bank connection, so you type every number. It is also not an investment tracker: the budget spreadsheet includes an investment forecast, but that is an estimate for planning, not a record of holdings or prices.

A practical last step: put your update date in your own calendar now, and write down where each balance comes from next to the item name. The second update then takes half as long as the first.