The Ultimate Net Worth Spreadsheet (Free Template)

If you want to know exactly where you stand financially, you need to write it down. A net worth spreadsheet forces you to pull every account balance, property value, and loan into one place.

It is the clearest snapshot of your wealth you will ever get, right up until your financial life outgrows what formulas can calculate.

Download the Free Net Worth Template

We built a clean, functional net worth spreadsheet that you can use immediately. It handles cash, shares, property, and debt.

• Download for Google Sheets (Make a Copy)
• Download for Microsoft Excel (.xlsx)

Note: You do not need to give us your email address to access this template.

How to Use the Net Worth Tracker

The formula for net worth is simple: Assets minus Liabilities. The template calculates this automatically, but you have to put the numbers in the right boxes.

Tracking Assets (What you own)

List everything of value that you could theoretically sell for cash.

• Liquid Assets: Cash in bank accounts, term deposits, and high-yield savings accounts.
• Investments: Shares, ETFs, index funds, and bonds.
• Retirement Accounts: 401(k), superannuation, or pension accounts.
• Property: The current market value of your primary residence and any investment properties.

Tracking Liabilities (What you owe)

List every dollar you owe to a bank, a lender, or the government.

• Mortgages: The outstanding principal on your home loan or investment properties.
• Consumer Debt: Credit card balances, personal loans, and car loans.
• Student Loans: The remaining balance on your education debt.
• Margin Loans: Any money borrowed against your share portfolio.

Update these figures at the end of every month. The spreadsheet will chart your progress over time.

The Problem with Net Worth Spreadsheets

A spreadsheet is brilliant for a simple household. If you are a single person with a salary, a checking account, and an index fund, a spreadsheet is all you need.

The main problem with net worth spreadsheets is that they cannot automatically calculate extraction tax or easily model money held inside trusts, companies, and self-managed super funds.

When your wealth gets complex, the spreadsheet fails quietly. It fails by simplifying.

If you hold ETFs inside a family trust, the money is not yours to spend until you distribute it and pay tax. If you own an investment property, its value on paper is an illusion until you calculate the capital gains tax (CGT) you will owe when you sell it. A spreadsheet flattens these distinctions. It treats a dollar in a trust the same as a dollar in your pocket. This leads to a dangerously inflated net worth number.

When to Move from a Spreadsheet to Automated Software

You will know you have outgrown a net worth spreadsheet when you hit any of the following triggers.

1. You hold assets across multiple entities. You have a family trust, a private company, or a self-managed super fund (SMSF).
2. You need to calculate extraction tax. You plan to retire early (FIRE) and need to know exactly how much tax you will pay to get money out of your corporate structures and into your personal bank account.
3. You want to forecast, not just track. You need to project your wealth 20 years into the future based on different inflation rates, market returns, and drawdown strategies.

If none of those apply, keep the spreadsheet. It is free and it works.

If those do apply, you have hit the ceiling of what manual formulas can do.

WealthScout replaces the spreadsheet. It tracks your assets across the structures you actually own them in. It calculates the tax of taking money out. Most importantly, it forecasts your wealth forward so you can see exactly when you can afford to stop working.

(Ready to retire your spreadsheet? Track and forecast your household wealth in WealthScout for free today.)