How to track net worth in a spreadsheet

What the number is

Net worth, in the ordinary household sense, is what you own minus what you owe. In a spreadsheet that is a list of assets, a list of liabilities, and a single figure: assets minus liabilities. The figure is a snapshot on a date, not a grade and not a forecast. It goes up when assets grow or debts shrink, and down when the opposite happens. Watching the change over months is usually more useful than staring at one total.

You can keep this list in a blank workbook. You do not need a bank connection, a brokerage export, or an app that logs into your accounts. A date, a set of names, and amounts you can stand behind are enough. This guide covers what to include, what to leave out, how to take a monthly snapshot, and how to read the trend without turning the file into a second job.

List assets you can name and value

An asset here is something you own that you can reasonably put a number on. Typical household rows include:

• Cash and balances in checking or current accounts
• Savings accounts and short-term deposits
• Investment accounts you already have statements for (a brokerage, a pension pot, a fund) — use the latest statement or a value you looked up on the snapshot date
• A home, if you own one, at a cautious estimate rather than a hopeful asking price
• A car or other property you would actually include if you were being honest, valued conservatively

You do not have to list every chair. Furniture and clothes usually add clutter and arguments about value without changing the useful picture. If an item would matter in a document list or a home inventory for insurance, keep that detail in that file, not in the net-worth sheet.

Pensions and retirement accounts can be included if you have a current value and you want the household picture to be complete. If a pot is inaccessible for years, you can still list it, perhaps in its own group, so you do not mix “money I could use this year” with “money that is locked.” The spreadsheet will not decide which is which unless you label the rows yourself.

List liabilities in the same currency

A liability is money you owe: a mortgage balance, a car loan, a student loan, a personal loan, a credit-card balance you carry. Use the outstanding principal, not the original amount, and not the monthly payment. The monthly payment belongs in a monthly budget or a bills calendar. Net worth cares about what is still owed on the snapshot date.

Enter every amount in the same currency. If you have a foreign account, convert it on the snapshot date with a rate you note in a comment, or keep a separate row labelled with the original currency and a converted figure you typed yourself. Automatic live rates are not required and often add a login you do not need.

Take a snapshot once a month

Pick a day — the last day of the month is an easy default — and fill the values as they stood that day, or as close as your statements allow. Write the date at the top of the column. Next month, add a new column rather than overwriting the last one. After a few months you have a trend: a line you can look at without reconstructing the past from memory.

You will not get a perfect mark-to-market valuation every time. A home value might stay the same for a year unless you have a reason to update it. An investment account can be copied from the month-end statement. A checking balance can be read from the app you already use. The goal is a consistent method, not daily precision. Updating the same rows every day usually creates noise, not insight.

When a number changes a lot, add a short note: “sold car,” “mortgage payment reduced principal,” “statement catch-up.” Future you will not remember why March jumped.

How to read the change

A simple pair of figures is enough: this month’s net worth, and the change from last month (this month minus last month). A rising line can come from saving, from paying down a loan, from a market statement, or from a higher home estimate. Those are not the same kind of change. If you want the file to stay honest, do not treat a revised house figure as if it were cash you saved. You can keep “estimated property” in its own row so the cash-and-investments subtotal is still visible.

A falling line is not automatically a failure. A planned home repair paid from savings, a market statement that is down, or a month with a yearly insurance premium can all move the total. Compare the change with what your budget said happened. If the leftover in the budget and the change in cash accounts disagree by a wide margin, something was missed in one of the two files — a transfer, a cash withdrawal, or a statement you did not open.

Illustration only, with fictional figures: if assets are 120,000 and liabilities are 80,000, net worth is 40,000. If next month assets are 121,500 and liabilities are 79,200, net worth is 42,300 and the change is 2,300. The sheet does not tell you whether that is “good.” It only records the arithmetic.

What not to put in the file

Do not store passwords, PINs, full account numbers, or login URLs with credentials. A name you recognise (“Main checking,” “Mortgage — Oak Street”) and, if you need it, the last four digits of an account, are enough to match a statement. The net-worth file is a list of values, not a key ring.

Do not import live bank feeds unless you already understand and accept that a third party would then see the same picture. A manual monthly update is slower and, for many households, calmer. Back up the file the same way you back up other household documents, and be careful with sharing if you use Google Sheets.

Keep the job small enough to repeat

Five to twenty rows will cover most households. If you need more, group them: cash, investments, property, mortgages, other debts. A dashboard with a single latest total and a small chart is a convenience, not a requirement. You can add that later, or use a workbook that already has it.

This is an organizational record, not financial, tax, or investment advice, and not a valuation you should use for a loan, a sale, or a legal process without checking the underlying documents. Confirm balances with your own statements and with a qualified adviser if you need advice. The spreadsheet does not connect to a bank or a broker and does not predict returns.