What’s in the file
One Excel file (.xlsx) with 2 tabs. It opens in Excel and in Google Sheets.
| Part | What it does | What you type |
|---|---|---|
| “My net worth” tab | A blank year with 8 rows for assets, 6 rows for debts and 12 month columns | Your balances, once a month |
| “Example” tab | The same layout filled in for a made-up household | Nothing |
| Total rows | Add up your assets and your debts for each month | Nothing |
| Net worth row | Assets minus debts | Nothing |
| Change row | How far your net worth moved since the month before | Nothing |
| Chart | Draws your net worth as a line, month by month | Nothing |
The Example tab shows a made-up household going from $118,500 in January to $152,500 in December, so you can see a full year before you type anything. It’s the same household as the worked example under our net worth calculator.
The file has no macros and no bank login. Nothing you type is sent to us.
How to use it in Google Sheets or Excel
- In Excel, open the file.
- In Google Sheets, open a blank spreadsheet. Click File, then Import, upload the file, choose Replace spreadsheet and click Import data.
- Rename the labels in column A to your own accounts.
- On the same day each month, type each balance in that month’s column. Enter debts as positive numbers.
- For a new year, copy the tab and clear the balances.
The totals, the net worth row and the chart fill in as you type.
The Google Sheets step is from Google’s help page, checked .
When a spreadsheet stops being enough
A spreadsheet works well for a handful of accounts. You type every balance every month, and working out which account moved your total is on you.
Our net worth tracker app will save each update as a dated snapshot and show what changed between any 2 dates. Typing in your own balances will be free. Bank syncing will be optional, from $7 a month or $70 a year.
It isn’t out yet, and we haven’t set a launch date. Web and iPhone come first, then Android. Everyone who gets the spreadsheet is on the launch list.
For an app you can use today, see the best net worth tracker apps for 2026.
Get the free net worth tracker spreadsheet
It takes an email address.
Get the spreadsheetLast updated
