Net Worth Spreadsheet Template: Layout, Formulas and Example

Short answer: a net worth spreadsheet template needs one sheet with assets in one block, debts in another, a net worth line equal to assets minus debts, and one new column for each month. Two formulas do the work: SUM for the totals and a subtraction for net worth. In the six-month example below, net worth rose from $48,000 to $65,900, a gain of $17,900.

Key takeaways

• One sheet is enough. Rows are accounts, and columns are months.
• Two formulas matter: SUM of assets, SUM of debts, and assets minus debts.
• Update on a fixed date each month and write down how you valued the home and car.
• A line chart of net worth by month shows the trend that a single number hides.

What does the layout look like?

Copy the formulas across with the fill handle so each new column is a new month. Row numbers depend on how many accounts you list, so adjust them to your layout.

What does a six-month example look like?

Over six months, net worth rose $17,900. Debts fell $3,500 and assets rose $14,400. March dipped $800 because markets fell that month, which is why one reading tells you little and a trend tells you a lot. See the net worth calculator guide for worked examples by age.

How do you build it in 15 minutes?

1. Minutes 1 to 5: list your accounts. Include every asset and every debt, even small ones.
2. Minutes 6 to 9: enter this month's balances and add the SUM and subtraction formulas.
3. Minutes 10 to 12: add the change row and format negative numbers in red.
4. Minutes 13 to 15: insert a line chart of the net worth row and add a note for how you valued the home and car.

What makes the sheet reliable?

• A fixed update date, such as the first of the month. Set a calendar reminder.
• A consistent valuation method for the home and car, such as a yearly estimate from a listing site, held until the next review.
• A liquid net worth row that leaves out the home and retirement money, to show what you could use in an emergency.
• A notes column, for events like a bonus, a car purchase or a market fall.
• A backup copy once a year.

When is an app better?

A sheet is private and free, but you update it by hand. If you have many accounts and would rather link them, see the best app to track net worth and the Empower alternative guide. To link your net worth to goals, try the free Goal check or the Is my goal realistic? sheet. For a budget sheet, see the Google Sheets budget template.

How do you add a liquid net worth row?

Liquid net worth shows what you could use quickly. It counts cash, savings and easy-to-sell investments, and subtracts debts that are not secured by a home. A simple example:

Add a row for this under net worth, with a SUM of the liquid accounts minus the short-term debts. It shows your cushion without the house or retirement money.

How do you handle hard-to-value assets?

• Home: use a recent estimate from a listing site or an agent, held steady until you reassess once a year.
• Car: use a used-car guide price, and update it annually.
• Business or private shares: use a conservative figure or leave them out and note it.
• Valuables: count only items you could sell, at a resale value.
• Pension rights: note them separately rather than guessing a lump sum.

What is a good monthly update checklist?

1. Open each account and note the balance on the update date.
2. Type the balances into the new column.
3. Check the total assets, total debts and net worth rows update.
4. Write a one-line note on anything unusual.
5. Look at the chart. Is the line trending up? If not, which row changed?
6. Save a copy once a year. See how to calculate and track your net worth.

Sources and further reading: the Consumer Financial Protection Bureau has a free net worth worksheet.

General education, not financial advice. Reviewed October 2026. The six months of balances are an illustration. Cell references depend on your layout.

Frequently asked questions