Free template No email required

Free net worth spreadsheet template for Excel and Google Sheets

A net worth tracker you fill in once a month: one row per account, one column per month, debts subtracted for you and a chart that draws itself. Download it free, keep it forever, and import it into the app whenever the routine gets old.

No signup, no macros, no watermark
The Net Worth sheet of the template: totals per account type, total assets, total debt, net worth and the net worth chart

Net worth is everything you own minus everything you owe. This free net worth spreadsheet template does that sum for you every month. Below: the download, a worked example from the template itself, the five-minute monthly routine, and an honest comparison with our free app, which does the same job without the upkeep.

The template

Download the net worth spreadsheet

Built the way we would track our own net worth by hand. Nothing to buy, nothing locked.

You'll also get our free monthly check-in: one short email on the 1st of each month, unsubscribe anytime.

Prefer not to share your email? Download it directly: same file, no hard feelings.

Using Google Sheets? Make your own copy in one click, no download needed.

.xlsx · under 20 KB · no macros · Excel & Google Sheets

Worked example

How to calculate your net worth

Net worth = total assets minus total debts. Here is the sum on the template's own sample accounts, for June 2026.

1
List what you own

Every account and asset at today's value: cash, investments, crypto, pension pots, property at what it would sell for.

2
List what you owe

Every debt at its outstanding balance: mortgage, car loan, student loan, credit cards.

3
Convert to one currency

Multiply foreign balances by the exchange rate into your base currency. The template does this for you.

4
Subtract

Total assets minus total debts is your net worth. Repeat monthly and the trend is what matters.

Net worth for June 2026, in USD, from the template's sample rows
AccountTypeValue (USD)
Checking accountCash3,300
Savings accountCash14,500
EUR savings5,500 EUR at 1.17Cash6,435
Broker: ETFsInvestments50,100
BitcoinCrypto5,400
Pension fundPension41,000
HomeReal Estate320,000
Total assets440,735
MortgageDebt245,500
Car loanDebt7,800
Total debts253,300
Net worth187,435

The same sheet read 170,450 in January. Five months later net worth is 187,435, up 16,985, mostly from paying down debt and saving, with the market doing the rest. That trend is the reason to track it monthly.

The Accounts sheet of the template: one row per account with its type and currency, one column per month
The Accounts sheet: the sample rows behind the example above. Replace them with your own accounts.
How it works

Five minutes a month, honestly

The whole routine, start to finish.

1
Download it

Grab the .xlsx above, with or without leaving your email: same file. Open it in Excel or import it into Google Sheets.

2
Swap in your accounts

Replace the sample rows with your own accounts, one row each. Pick a type and a currency from the dropdowns.

3
Fill one column a month

Once a month, type in each account's current balance. Update an exchange rate if one moved. That's the whole job.

4
Watch the chart

Totals per type, assets, debt and net worth compute themselves, and the chart adds a point each month.

Want more detail? The free portfolio tracker spreadsheet shows what sits behind your Investments row, trade by trade, with live prices in Google Sheets, and the budget spreadsheet shows where each month’s money goes.

Next step

Bring your spreadsheet into the app

Create a free account and upload the file you keep: every account and every month you filled in comes with you, with prices and exchange rates that update themselves. No bank connection.

What's inside

A proper tracker, not a pretty table

Everything a hand-rolled net worth sheet needs, already wired up.

📁

One row per account

Bank accounts, brokers, wallets, pension pots, property and loans. Each row has a type, so totals group themselves.

📅

Monthly snapshots

One column per month, three years of columns ready. Fill in balances once a month and the history builds itself.

💱

Multi-currency

Hold accounts in 20 currencies. A rate sheet converts everything into your base currency. Rates are manual, and the template is upfront about what that means.

➖

Debt handled properly

Mortgages and loans go in as positive numbers with the type "Debt" and are subtracted automatically.

📈

A chart included

Net worth over time, drawn from your monthly totals. Empty months show as gaps, not fake zeroes.

📖

Instructions included

A Read Me sheet with the five-minute monthly routine, and honest notes on the template's limits.

Side by side

This spreadsheet vs. the app

Same philosophy: manual control, no bank connection. The difference is who does the maintenance.

What you get This spreadsheet The app (also free)
Stock, ETF & crypto prices You look them up and type them in Fetched automatically
Exchange rates A manual rate sheet you maintain Refreshed daily
Net worth history One column a month, if you remember Automatic snapshots
Historical accuracy Past months re-value when you edit a rate Each snapshot keeps its day's rates
Cost basis & gains Not tracked Per position, automatic
Mistakes One broken cell skews the total, silently Validated entries, nothing to break
Your time About 5 minutes a month, forever Roughly zero after setup
No dark patterns

Keep the spreadsheet, or take the app

An honest guide: plenty of people should pick the spreadsheet.

🧮

Keep the spreadsheet if…

You have a handful of accounts in one currency, you like the monthly ritual, and you want full control with zero accounts anywhere. Truly: it will serve you well, and it is yours forever.

📲

The app earns its keep when…

You hold stocks, ETFs or crypto whose prices move daily, you juggle more than one currency, or you want history charts without the homework. Same manual-entry philosophy, no bank connection; the boring parts just do themselves.

How to track your net worth in Excel or Google Sheets

The net worth formula

Net worth is assets minus liabilities: everything you own (cash, brokerage accounts, pension pots, crypto, property) minus everything you owe (mortgage, car loan, credit cards). A good net worth spreadsheet lists each account in its own row, records one balance per month, and charts the total. That structure is exactly what the free template above gives you, prewired.

Excel or Google Sheets?

Both work. The template is a native .xlsx, so Excel opens it directly, and the Google Sheets version is one click away: "Copy to Google Sheets" saves your own copy to your Drive, with the same formulas, dropdowns and chart. Google Sheets users sometimes wire up GOOGLEFINANCE() to pull live stock prices. It works for a while, but it fails silently for many funds, pensions and exchange rates, which is precisely the maintenance an app removes.

Using it as a net worth statement

A net worth statement (a personal balance sheet) is the same list frozen on one date: assets, liabilities and the difference. Any month's column in the template is one, and the Net Worth sheet is its summary. When a lender or an application asks for one, fill in the current month, value property and vehicles at what they would sell for today rather than what you paid, and save the two sheets as a PDF.

How often should you update a net worth spreadsheet?

Monthly is the sweet spot: weekly turns into homework, yearly hides every trend. Put a recurring reminder on the first of the month; with the template, five minutes covers it. If you already suspect you will skip the appointment, that is the honest signal to let a portfolio tracker take the snapshots for you.

When the spreadsheet stops being the right tool

Count your moving parts. A few accounts in one currency change slowly, and a spreadsheet tracks them perfectly. Stocks, ETFs and crypto reprice every day, and every extra currency multiplies the rate-keeping. Once most of your balances move without you touching them, the app simply does this job better: automatic prices, daily exchange rates, snapshot history, still manual-entry and still no bank connection. Try the demo with realistic data and compare.

Frequently asked questions

Is the net worth spreadsheet really free?+

Yes. No payment, no locked cells, no watermark, and you do not even need to leave an email: the small print under the form is a direct link to the exact same file. The email option adds our free monthly check-in, one short email on the 1st of each month.

Is there a Google Sheets version?+

Yes. "Copy to Google Sheets" at the top of this page puts your own copy of the template in your Google Drive, no download needed. You can also import the .xlsx: File → Import → Upload, then "Replace spreadsheet". Either way the formulas, dropdowns and the net worth chart all work, because the template uses plain formulas (VLOOKUP, SUMPRODUCT) and no macros.

How do I calculate my net worth?+

Add up the current value of everything you own (cash, investments, crypto, pension pots, property at its selling price), add up everything you owe (mortgage, loans, credit card balances), and subtract the second total from the first. Convert foreign balances into one currency first. The worked example on this page does exactly that with the template's sample accounts.

Can I use it as a net worth statement?+

Yes. A net worth statement is your assets and liabilities on one date. Fill in the current month's column, check the Net Worth sheet, and save both sheets as a PDF. Value property and vehicles at what they would sell for today.

How does the multi-currency support work?+

Every account row has a currency dropdown, and a Currencies sheet holds the exchange rate of each currency into your base currency. Balances convert automatically. The rates are manual by design, which is also the template's honest weakness: change a rate and your past months re-value with it.

How do I track debts like a mortgage?+

Add the mortgage or loan as its own row, give it the type "Debt", and enter the outstanding balance as a positive number. The summary sheet subtracts all debt rows from your assets automatically, so the net worth figure is genuinely net.

What should I include in a net worth spreadsheet?+

Assets: checking and savings accounts, brokerage and retirement accounts, pension pots, crypto, property at a realistic value, and anything else you could sell. Liabilities: mortgage, student and car loans, credit card balances. One row per account; the template ships with a sample row of every type so nothing gets forgotten.

How do I build a net worth spreadsheet from scratch in Excel?+

Rows for accounts, columns for months, a type column so you can subtotal by category, a rate column if you hold multiple currencies, SUMPRODUCT or SUMIF formulas per type, assets minus debts at the bottom, and a line chart on the result. That is about an hour of careful work, or download the free template above, which is exactly that, already built and tested.

How often should I update my net worth?+

Monthly. It is frequent enough to catch trends and rare enough to stay painless, about five minutes with this template. The app removes even that: it snapshots your accounts automatically, so your history keeps building whether you remember or not.

Can I move from the spreadsheet to the app later?+

Yes. Upload the file you keep in the import section of this page: every account and every month you filled in becomes part of your portfolio, with prices and exchange rates that then update themselves. Import it again later and only the new months are added.

Net worth spreadsheet or app: which should I use?+

Honest answer: if your money sits in a few slow accounts in one currency, keep the spreadsheet; it is enough. The moment prices or currencies move without you (stocks, ETFs, crypto, foreign accounts), the app wins on every axis that matters: fresh prices, daily exchange rates, history that writes itself, and per-position gains. It is free, needs no bank connection, and imports this exact file.

Grab the template. Outgrow it whenever.

The spreadsheet is free forever. If updating it ever becomes a chore, the app is one click away, and your data imports.

The template stays yours either way

The template is free to use, share and adapt. Sample figures are illustrative. Nothing on this page is financial advice.