One row per account
Bank accounts, brokers, wallets, pension pots, property and loans. Each row has a type, so totals group themselves.
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.
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.
Built the way we would track our own net worth by hand. Nothing to buy, nothing locked.
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
Net worth = total assets minus total debts. Here is the sum on the template's own sample accounts, for June 2026.
Every account and asset at today's value: cash, investments, crypto, pension pots, property at what it would sell for.
Every debt at its outstanding balance: mortgage, car loan, student loan, credit cards.
Multiply foreign balances by the exchange rate into your base currency. The template does this for you.
Total assets minus total debts is your net worth. Repeat monthly and the trend is what matters.
| Account | Type | Value (USD) |
|---|---|---|
| Checking account | Cash | 3,300 |
| Savings account | Cash | 14,500 |
| EUR savings5,500 EUR at 1.17 | Cash | 6,435 |
| Broker: ETFs | Investments | 50,100 |
| Bitcoin | Crypto | 5,400 |
| Pension fund | Pension | 41,000 |
| Home | Real Estate | 320,000 |
| Total assets | 440,735 | |
| Mortgage | Debt | 245,500 |
| Car loan | Debt | 7,800 |
| Total debts | 253,300 | |
| Net worth | 187,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 whole routine, start to finish.
Grab the .xlsx above, with or without leaving your email: same file. Open it in Excel or import it into Google Sheets.
Replace the sample rows with your own accounts, one row each. Pick a type and a currency from the dropdowns.
Once a month, type in each account's current balance. Update an exchange rate if one moved. That's the whole job.
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.
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.
Everything a hand-rolled net worth sheet needs, already wired up.
Bank accounts, brokers, wallets, pension pots, property and loans. Each row has a type, so totals group themselves.
One column per month, three years of columns ready. Fill in balances once a month and the history builds itself.
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.
Mortgages and loans go in as positive numbers with the type "Debt" and are subtracted automatically.
Net worth over time, drawn from your monthly totals. Empty months show as gaps, not fake zeroes.
A Read Me sheet with the five-minute monthly routine, and honest notes on the template's limits.
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 |
An honest guide: plenty of people should pick the spreadsheet.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
The spreadsheet is free forever. If updating it ever becomes a chore, the app is one click away, and your data imports.
The template is free to use, share and adapt. Sample figures are illustrative. Nothing on this page is financial advice.