How to track net worth in a spreadsheet

Most personal finance conversations focus on income, savings rate, or investment returns. These matter, but they're all inputs into a single number that actually tells you where you stand: net worth. Assets minus liabilities. Everything you own minus everything you owe.

Tracking this number over time, monthly, consistently, in a format you control, is the single most useful financial habit you can build. Here's how to do it in a spreadsheet.

The formula

Net worth = Total Assets − Total Liabilities

That's it. The complexity is in what to include.

Assets to include

Liquid assets, checking accounts, savings accounts, money market accounts, CDs. These are the easy ones. Pull the current balance.

Investment accounts, brokerage accounts, IRAs, Roth IRAs, 401(k), 403(b), SEP-IRA, HSA. Include the current market value, not your contribution total.

Real estate, use your best estimate of current market value, not purchase price. Zillow and Redfin provide comps. Be honest here, overestimating inflates net worth in a way that will mislead you later.

Vehicles, use Kelley Blue Book private party value, not retail. Depreciate it. A car worth $30,000 today is worth considerably less in three years.

Other assets, business equity (if you can value it), vested stock options, valuable personal property. Include only what you could actually sell.

Liabilities to include

Mortgage balance, not the original loan amount. The current outstanding principal. Your statement or servicer's website shows this.

Student loans, current outstanding balance, not the original amount.

Auto loans, current balance.

Credit card balances, the balance at the time you're calculating, not the credit limit.

Other debt, personal loans, home equity lines of credit, any other obligation with a balance due.

Common mistakes

Counting gross home value instead of equity. Your home is worth $600,000. Your mortgage balance is $420,000. Your home equity is $180,000, not $600,000. Many people count the full home value and wonder why their net worth doesn't match their sense of financial health.

Ignoring unvested equity. If you have unvested stock options or restricted stock units, they're not an asset yet. Include them only when they vest.

Forgetting the HSA. Health savings accounts are triple-tax-advantaged and can be invested. Many people have meaningful balances and don't include them in their net worth calculation.

Counting retirement accounts at face value without considering taxes. A $500,000 traditional 401(k) is worth less than $500,000 after taxes. A $500,000 Roth IRA is worth exactly $500,000 after taxes. They're not equivalent. For rough net worth tracking this distinction matters less, but for retirement planning it matters considerably.

How to set up the sheet

Create two tables: Assets and Liabilities. Each row is a specific account or item. The last column is the current value.

Sum each table. Subtract liabilities from assets. That's your net worth.

Add a column for the date. Each month, record a new snapshot. After a year you have a trend line. After five years you have a picture of your financial progress that no investment return figure can give you.

What Sheetful automates

The most tedious part of net worth tracking is pulling current balances from your bank accounts. Sheetful syncs connected bank transactions into your sheet (Premium: automatic daily sync; Free: manual sync). Investment and manual asset lines still belong in your template. Sheetful uses Plaid Transactions, not brokerage balance feeds.

The trend matters more than the number on any given day. Build the habit of recording it. The spreadsheet just needs to stay alive long enough for the data to become useful.