This free template tracks your net worth month by month in Google Sheets or Excel. Enter your accounts and debts once, update the balances each month, and the sheet calculates your net worth and how much it changed.

The template is free for personal use.

 

What’s in the template

The template is a single sheet with a column for each month, so you can see your net worth change over the year. It comes filled with example numbers for January through March. Replace them with your own.

  • Assets: checking, savings, 401(k), IRAs, stocks and bonds, cryptocurrencies, primary residence, other real estate, vehicle (present value), business equity and other.
  • Liabilities: mortgage, student loans, auto loan, two credit cards, and four rows for other debts.
  • Automatic totals: total assets, total liabilities, and net worth calculate as you type.
  • Monthly change: the sheet shows how much your net worth rose or fell each month, in dollars and as a percentage.

You can rename any row to match your accounts and add rows as you need them.

How to copy the template to your Google Drive

The shared Google Sheet is view-only, so you need your own copy before you can type in it.

  1. Open the net worth Google Sheet while signed in to your Google account.
  2. Click File > Make a copy.
  3. Name the copy and choose a folder in your Drive.
  4. Click Make a copy. Your version opens in a new tab and is private to you.

Prefer Excel? Download the .xlsx file and open it in Excel or Numbers. It works the same way.

What is net worth?

Your net worth is the total of what you own (assets) minus the total of what you owe (liabilities, or debts). If you have $10,000 in the bank and owe $2,000 on a credit card, your net worth is $8,000.

Net worth can be negative. With $1,000 in the bank and a $2,000 credit card balance, your net worth is -$1,000.

If you’re starting out with student loans and little savings, a negative net worth is normal. Mine was negative for years, until I paid off all of my debt.

How to track your net worth

Your net worth on any one day is a snapshot. Tracking it means taking that snapshot on a regular schedule and comparing it with the last one.

Pick one day each month, such as the 1st, and update every balance in the sheet. Between two months, you might see changes like these:

  • You spent money from your checking account.
  • You deposited $500 to savings.
  • You paid $200 of principal on a credit card balance.
  • Your 401(k) gained 2%.

The direction matters more than the number. If you’re saving and paying down debt, your net worth should rise over a year, even if it dips some months.

Those dips are normal once you own investments. Stocks, cryptocurrency, and other assets can fall for months at a time even while you keep saving. A big purchase can cause a one-month drop, too.

Watch for a pattern where your net worth stays flat or slowly falls over 6 to 12 months. That usually means you’re spending more than you earn.

What’s included in your net worth?

People disagree on what counts. Here’s the approach the template uses.

Assets to include:

  • Cash and bank accounts
  • Retirement and brokerage accounts
  • Real estate you own, at a realistic market value
  • Vehicles (optional; see below)

Debts to include: everything you owe. That includes credit card balances (even if you pay them in full each month), plus student loans, auto loans, your mortgage, and taxes you’ll owe by the next quarterly deadline or April 15.

I personally leave cars out. You can sell a car, but it loses value every year, so I don’t count it as wealth. The template still has a vehicle row, because most people want to include theirs.

Other ways to track your net worth

A spreadsheet is simple and private, but you have to update it by hand. Net worth tracking apps connect to your accounts and update automatically.

My favorite is the Empower Personal Dashboard. It’s free to use and can track your whole investment portfolio, even across many brokerages.

Vyzer is built for investors who want detailed tracking of their net worth and investment performance, including real estate and private investments. It has a free starter plan, and paid plans unlock the full feature set.

Net worth spreadsheet FAQ

Is this net worth template really free?

Yes. Both the Google Sheets and Excel versions are free for personal use, with no sign-up beyond a Google account if you use Sheets.

How often should I update my net worth spreadsheet?

Once a month is enough for most people. Updating more often mostly tracks day-to-day market swings.

Should I include my car in my net worth?

That’s up to you. Including it gives a fuller picture of what you could sell. Leaving it out gives a more conservative number, since cars lose value every year.

What’s a good net worth at my age?

It depends on your income, debts, and where you live. Your own trend over time is a more useful measure than any benchmark.

Download the free net worth spreadsheet