Net Worth Spreadsheet: How to Build and Use One in 2026

A net worth spreadsheet is a simple sheet that lists what you own, lists what you owe, and subtracts liabilities from assets to show your net worth. If you want a low-cost, flexible way to track wealth, a spreadsheet still works well in 2026. The key is to use the right categories, update it on a consistent schedule, and focus on the long-term trend instead of one month's number.

Investor.gov defines a net worth statement as what you own minus what you owe and suggests updating it at least yearly. In practice, a monthly spreadsheet check-in is usually more useful if you want a clearer read on progress throughout the year. If you want the basics first, start with what net worth is and how to calculate it and how to track your net worth in 2026. This guide is specifically about building a spreadsheet that is easy to maintain.

Why use a net worth spreadsheet?

A net worth spreadsheet is useful because it gives you one number that summarizes your full balance sheet, not just your monthly budget.

Here is why people still prefer spreadsheets:

You control the categories, formulas, and layout.
You can track assets that many apps treat poorly, such as private business equity or unusual accounts.
You do not need to connect bank credentials to another service.
You can keep a clean historical record month by month.
You learn the structure of your finances by entering the numbers yourself.

That matters because net worth is still one of the clearest measures of household financial progress. The Federal Reserve's latest Survey of Consumer Finances says median family net worth in the United States reached $192,900 in 2022. A spreadsheet will not make that number go up on its own, but it will make it harder to ignore whether your own trend is improving.

What should a net worth spreadsheet include?

The best net worth spreadsheet template is not complicated. It just needs the right sections.

What belongs on the asset side?

Most people should include:

Checking accounts
Savings accounts
Money market funds or CDs
Brokerage accounts
Retirement accounts such as 401(k)s, IRAs, and Roth IRAs
HSA balances
Crypto holdings, if you own them
Home value and other real estate
Vehicle value, if you want a fuller balance sheet
Other major assets

What belongs on the liability side?

Most people should include:

Mortgage balance
HELOC balance
Student loans
Auto loans
Credit card balances
Personal loans
Buy now, pay later balances
Other meaningful debts

Do not mix monthly expenses with liabilities. Groceries, rent, utilities, and subscriptions matter for cash flow, but they are not debts unless you owe an outstanding balance on them.

How do you build a net worth spreadsheet?

You can build a good net worth tracker spreadsheet in Google Sheets or Excel in about 15 minutes.

1. Create monthly columns

Put your category labels in Column A. Put months across the top row.

For example:

A1 Category
B1 Jan
C1 Feb
D1 Mar
E1 Apr

If you want one file per year, keep all twelve months on one tab. If you want a simpler setup, start with just the current month and add columns later.

2. Add two main sections

Your sheet only needs two sections:

Assets
Liabilities

Under each section, list the accounts you actually have. Avoid making the sheet longer than necessary. A spreadsheet that is too detailed often becomes a spreadsheet you stop updating.

3. Add total rows

Once your asset rows are listed, add a Total Assets row. Do the same for liabilities.

Then add a Net Worth row with this formula:

=Total_Assets-Total_Liabilities

In a real sheet, that will point to cells such as =B11-B19.

4. Add a trend row

If you want the sheet to be more useful, add one extra row for month-over-month change.

Example:

=IFERROR((C20-B20)/ABS(B20),"")

That helps you see whether your net worth is moving because of savings, debt payoff, market swings, or some mix of all three.

5. Use current values, not wishful values

This part matters more than the formulas.

Use current account balances for cash and debt.
Use current market value for investments.
Use a conservative home estimate, not your favorite number.
Use the remaining loan balance, not the monthly payment.

If your home is worth about $500,000 and your mortgage balance is $320,000, your sheet should show both figures separately. Your equity is reflected in the final net worth number.

What net worth spreadsheet template can you copy?

If you want a simple net worth spreadsheet template, copy this row structure into Column A and put monthly balances across Columns B, C, D, and so on.

Assets Checking Savings Brokerage 401(k) IRA / Roth IRA HSA Crypto Home value Vehicle value Other assets Total assets Liabilities Mortgage HELOC Student loans Auto loan Credit cards Personal loans Other liabilities Total liabilities

Net worth Month-over-month change Notes

That template is enough for most households. If you want more detail, split rows like Brokerage into separate accounts. If you want less detail, combine smaller balances into Other assets or Other liabilities.

What formulas do you actually need?

Most net worth spreadsheet guides overcomplicate this part. You only need a few formulas.

Total assets

=SUM(B2:B11)

Total liabilities

=SUM(B14:B20)

Net worth

=B12-B21

Month-over-month change

=IFERROR((C22-B22)/ABS(B22),"")

If you want a chart, highlight your Net worth row across months and insert a simple line chart. That gives you a quick visual of whether the trend is going in the right direction.

What mistakes should you avoid?

The biggest problem with a net worth spreadsheet template is usually not the formula. It is the process.

Avoid these mistakes:

Using purchase price instead of current value for assets
Forgetting retirement accounts
Ignoring small debts that still count
Updating randomly instead of on a schedule
Rebuilding the sheet every year and losing history
Treating a monthly spending category like a liability

One more important point: negative net worth is common, especially if you are early in your career or paying off student debt. The point of the spreadsheet is not to judge one snapshot. It is to show whether the direction improves over time.

How often should you update a net worth spreadsheet?

Once a month is the sweet spot for most people.

The SEC's Investor.gov materials say to update a net worth statement every year. That is a reasonable minimum. But if you are using a spreadsheet as an active money dashboard, monthly is usually better because it gives you twelve data points a year instead of one.

A simple monthly routine looks like this:

Pick one date, such as the first day of the month.
Open every major bank, brokerage, retirement, and loan account.
Enter current balances.
Update home value only if you use the same source each time.
Review the change from last month.
Add one note about why the number moved.

That final note is underrated. "Net worth fell because stocks dropped but debt also fell by $1,200" is far more useful than just staring at a smaller number.

Should you use a spreadsheet or an app?

This is where the choice becomes practical.

When is a spreadsheet the better option?

A spreadsheet is usually better if:

You like manual control
You only update monthly or quarterly
Your finances are not spread across too many institutions
You want privacy and simplicity more than automation

When is an app the better option?

An app is usually better if:

You have multiple bank, brokerage, and retirement accounts
You want less manual data entry
You want net worth and budgeting in one place
You want to include things like crypto and real estate without building custom formulas

That is the main trade-off. A spreadsheet gives you control. An app gives you automation.

If your money is still simple, a spreadsheet may be enough for years. If your finances now include spending, investments, crypto, and property, an automated dashboard becomes more appealing. For iPhone users who want that broader picture, Surplus Budget combines budgeting, net worth tracking, investment tracking, and real estate tracking in one app.

If you want to compare tools before you decide, read Best Net Worth Tracker Apps in 2026 and How to Track All Your Money in One App.

FAQ

Is Google Sheets or Excel better for a net worth spreadsheet?

Either works. Google Sheets is easier if you want cloud access and quick sharing. Excel is better if you prefer desktop files or already manage other financial spreadsheets there.

Should I include my home in a net worth spreadsheet?

Yes. Your home belongs on the asset side at an estimated current market value, while the mortgage belongs on the liability side. The difference flows into your net worth.

Should I include my car in a net worth spreadsheet?

You can. Many people do if they want a fuller personal balance sheet. Just use a realistic current resale value, not what you paid for it.

Should couples track one spreadsheet or two?

That depends on how you handle money. Couples with combined finances often benefit from one household spreadsheet. Couples with separate finances sometimes keep individual sheets plus one shared household view.

Is a net worth spreadsheet enough by itself?

It can be, especially if you want a simple monthly snapshot. But if you want live syncing, broader asset coverage, or budgeting and net worth in the same workflow, an app can be easier to maintain.

Bottom line

A net worth spreadsheet is still one of the simplest ways to understand whether you are getting richer or just staying busy. It works because the math is easy, the trend is visible, and the habit forces honesty.

If you want the shortest version, do this:

List your assets.
List your liabilities.
Update the numbers once a month.
Watch the trend for a year.

That is enough to tell you more about your financial progress than most people know about their own money.

And if you eventually outgrow the spreadsheet, that is usually a good sign. It means your financial life is complex enough that automation might finally save you real time.

Want to move beyond a manual net worth spreadsheet? Surplus Budget helps iPhone users track budgeting, net worth, investments, and real estate in one place.