Net worth spreadsheet template

The file has three sheets.

Balances

There's one row per account, and the first columns describe the account:

• Account: a name you'll recognise, like "Barclays current account" or "Car"
• Category: one of the four categories described below. The values in the template are Liquid, Illiquid - Trackable, Illiquid - Estimated and Debt, written exactly like that.
• Type: what kind of account it is, for example Cash, Brokerage, Retirement, Property, Vehicle, Loan
• Currency: the currency the balance is in, as a three-letter code (GBP, EUR, USD)
• Notes: anything you want to remember, like where the statement comes from

After those come the month-end dates, one column each. Each cell is that account's balance on that date, in the account's own currency.

FX Rates

There's one row per currency and one column per month-end date. Each cell is how many units of that currency you got for 1 US dollar on that date. If 1 USD bought EUR 0.90 on 31 October, the EUR cell for 31 October is 0.90. USD itself is always 1.

The template uses the US dollar as a common base because many rate sources quote against it, and you don't need to hold any dollars for it to work. If your source quotes rates per euro, as the European Central Bank does, divide each rate by that day's USD rate.

Setup

This sheet has one cell, for your base currency. That's the currency your total is shown in.

Liquid is money you could use within a few days: current accounts, savings, brokerage and crypto.

Illiquid, trackable is money you can't easily get at, but where someone else reports the number, such as a pension, a fixed-term deposit or a rental deposit.

Illiquid, estimated is anything you value yourself, like a car, a flat or a painting. It helps to note where each figure came from.

Debt is what you owe, such as a mortgage, loans and cards. Enter it as a positive number and the template subtracts it.

The categories let you see more than one total. A flat worth DKK 3,000,000 can make your net worth look large even when the money you could actually spend next month is DKK 40,000.

1. Set your base currency on the Setup sheet.
2. On Balances, add one row per account. Start with the larger accounts, and add the small ones later.
3. Add a column for the most recent month-end and type in each balance, using the number from the statement or app in that account's own currency. Don't convert anything yourself.
4. On FX Rates, add the same month-end column and type in the rate for each currency you use.

To convert a balance into your base currency, divide it by its own rate and multiply by the base currency's rate. Say your base currency is DKK, and on 31 October 1 USD = EUR 0.90 and 1 USD = DKK 6.75. Then EUR 10,000 is 10,000 ÷ 0.90 × 6.75 = DKK 75,000.

The totals at the bottom do this for you.

Once a month, add a new column on Balances and a matching one on FX Rates, then go through your accounts and type in the new numbers.

Some accounts, like a pension that reports once a year or a car, won't have a new number every month, so copy the last value across. Their value in your base currency will still change with the exchange rate. For example, a pension in euros is worth fewer kroner when the euro falls.

A few habits help:

• Use month-end dates even if you update on the 3rd, so the columns stay comparable.
• When a number is older than the column it's in, write the date of the statement in Notes.
• Look at your estimates again once a year, so the car isn't still at a value from two years ago.

Plenty of people never need anything more. A spreadsheet is free, it stays on your computer, and you can add any column or calculation you like. This template works well if:

• you have fewer than ten or so accounts
• you don't need to know how much of each month's change came from exchange rates
• you're comfortable with formulas and fixing them when a column ends up in the wrong place

With several currencies, you may want to see how much of each month's change came from exchange rates, and how up to date each number is. You can build both into a spreadsheet, but it takes a fair number of formulas to set up and keep working.

If you'd like that analysis without building it yourself, this template imports into Thallo in one step, with all its history. Your browser reads the file, so it stays on your computer, and only the accounts and balances you confirm are saved.

Thallo works the same way, with one balance per account in its own currency. It fetches exchange rates every day, and What moved splits the change between any two dates into currency effect and balance changes. Each account also shows how old its last number is. You still type in the balances yourself, so nothing connects to your bank. How it works covers the rest, including the breakdowns by category and currency and the weekly Signals.

You can export everything back to CSV whenever you like.

Start free. If you already use this template, you can bring your history with you.

Start free