A net worth tracker spreadsheet is a free Google Sheets tool that automatically calculates your total assets minus liabilities to show your exact financial position. It helps you monitor wealth growth, identify spending patterns, and make informed money decisions using a simple, customizable template.

Most people don't. They have a vague sense that they have some savings, maybe a retirement account, a car loan, possibly a mortgage—but they've never added it all up and subtracted what they owe. That single number, your net worth, is one of the most honest indicators of financial progress you can track.

A net worth tracker spreadsheet fixes that. It brings every account, every asset, and every debt into one view—so you can see where you stand, spot the trend over time, and make smarter financial decisions.

What Is Net Worth (and Why Does It Matter)?

Net worth is simple arithmetic:

Net Worth = Total Assets − Total Liabilities

Your assets are everything you own that has value: bank accounts, investments, property, retirement funds, vehicles. Your liabilities are everything you owe: mortgages, car loans, student loans, credit card balances.

The result—positive or negative—is your financial starting point. It doesn't judge you. It just shows you reality, which is the first requirement for improving it.

Why track it in a spreadsheet?

Budgeting apps and bank dashboards often show you one slice of the picture—spending this month, or the balance in one account. A net worth tracker spreadsheet shows the whole picture across all institutions, all account types, and all debt categories in a single place you control.

Benefits of maintaining your own spreadsheet:

• No third-party access to your account credentials
• Full customisation of categories to match your actual life
• Historical snapshots so you can see progress month over month
• Offline access and no subscription fees
• Privacy: your financial data stays on your Google Drive

---

The Structure of a Net Worth Tracker Spreadsheet

A solid net worth tracker has three sections: Assets, Liabilities, and a Summary dashboard. Here's how to structure each one.

Section 1: Assets

Break your assets into four categories:

Category	Examples
Cash & Savings	Checking, savings, emergency fund, cash on hand
Investments	Brokerage accounts, ETFs, shares, crypto
Retirement Accounts	401(k), IRA, superannuation, KiwiSaver
Physical Assets	Property, vehicles, business equity, collectibles

For each asset, track:

• Account or asset name
• Institution or location
• Current value
• Last updated date

Keep physical assets like cars and property conservative—use current market value, not what you paid. Overestimating assets is the fastest way to feel rich while actually stagnating.

Section 2: Liabilities

Break liabilities into two types:

Category	Examples
Short-Term Debt	Credit cards, personal loans, buy-now-pay-later
Long-Term Debt	Mortgage, student loans, car loans, business debt

For each liability, track:

• Lender or account name
• Outstanding balance
• Interest rate (optional, but useful)
• Last updated date

The interest rate column is optional for net worth tracking but valuable when you want to prioritise which debt to pay down fastest.

Section 3: Summary Dashboard

The summary section does the actual work:

Total Assets          $XXX,XXX
Total Liabilities   − $XX,XXX
─────────────────────────────
Net Worth             $XXX,XXX

Add a monthly snapshot table below it:

Month	Total Assets	Total Liabilities	Net Worth	Change
Jan 2025	$180,000	$95,000	$85,000	—
Feb 2025	$183,500	$94,200	$89,300	+$4,300
Mar 2025	$182,100	$93,500	$88,600	−$700

This history is where the real value lives. Monthly fluctuations mean almost nothing. The 12-month trend tells you everything.

---

Building Your Spreadsheet Step by Step

Step 1: Set Up the Sheets

Create a Google Sheets file with three tabs:

1. Dashboard — net worth summary and trend chart
2. Assets — all asset entries
3. Liabilities — all debt entries

This separation keeps the data clean and makes it easy to update one section without disrupting the others.

Step 2: List Every Account

Go through every account you have, no matter how small:

• Every bank account
• Every credit card (even unused ones with a balance)
• Every investment account or brokerage
• Every retirement fund
• Any property you own
• Any vehicle you own (use a depreciated current value)
• Any money someone owes you (optional—be honest about collectability)

Leave nothing out. Incomplete data gives you a false picture.

Step 3: Enter Current Balances

For each entry, enter the most recent balance you can find. Log in to each account or pull the latest statement. This is your baseline.

In the date_updated column, enter today's date. You'll update this column each time you refresh that specific row.

Step 4: Wire Up the Summary Formulas

On the Dashboard tab, use SUMIF formulas to pull from your asset and liability sheets:

=SUM(Assets!C:C)         ← Total Assets
=SUM(Liabilities!C:C)    ← Total Liabilities
=D3-D4                   ← Net Worth

Or if you've categorised by type:

=SUMIF(Assets!B:B,"Cash & Savings",Assets!C:C)
=SUMIF(Assets!B:B,"Investments",Assets!C:C)
=SUMIF(Assets!B:B,"Retirement",Assets!C:C)
=SUMIF(Assets!B:B,"Physical Assets",Assets!C:C)

This gives you subtotals by category alongside the grand total.

Step 5: Add a Monthly Snapshot Row

At the end of each month, copy your current net worth into the snapshot table. This is a manual step—you're recording a point-in-time value, not a live formula. That's intentional. You want a historical record that doesn't change when balances fluctuate.

Step 6: Create a Trend Chart

Select your monthly snapshot data and insert a line chart. This is the view you'll come back to most often. A flat line tells you to revisit your strategy. An upward trend confirms your habits are working.

---

What to Include (and What to Leave Out)

Include:

• All liquid accounts — checking, savings, money market
• All investment accounts — taxable and tax-advantaged
• Property — use current market value, not purchase price
• Superannuation or pension funds — even if you can't access them yet, they're part of your wealth
• Business equity — if you own a business, a rough valuation belongs here

Leave Out (or Flag Separately):

• Household goods and furniture — depreciates fast, hard to value, creates false comfort
• Pending bonuses or inheritance — count money when it arrives
• Leased vehicles — you don't own them; the lease is a liability, not an asset

A common mistake is inflating the asset side with things that can't be sold quickly. Net worth isn't about how wealthy you feel—it's about your actual financial position.

---

How Often to Update Your Net Worth Tracker

Monthly is the sweet spot for most people. It's frequent enough to catch trends, but not so frequent that you're reacting to noise.

A monthly update takes about 10–15 minutes:

1. Log in to each account and update the balance
2. Update the date_updated column for each row
3. Copy the current net worth into your snapshot table
4. Note any unusual changes (large expenses, market swings, debt payoff milestones)

Some people do quarterly updates, which works fine if your finances are relatively stable. Weekly updates add work without much signal unless you're in an active debt-paydown phase.

---

Reading Your Net Worth Over Time

Once you have three or more months of data, patterns emerge.

Net Worth Growing Slowly

Your income is covering expenses and you're saving or investing the difference. Good. The question is whether the pace matches your goals. Use a financial freedom calculator to check. If you're on a FIRE path, your net worth growth rate determines your projected freedom date.

Net Worth Flat or Declining

Common causes:

• Spending more than you earn
• Large one-time expenses (medical, car repair, moving costs)
• Investment market decline (temporary—assets fell in value)
• Lifestyle inflation eating your income growth

Flat months aren't a crisis. A flat year is worth investigating.

Net Worth Growing Quickly

Either your investments are performing well, you paid off significant debt, or your income jumped. All good. The risk here is assuming the pace will continue. Market-driven net worth growth can reverse; income and debt-paydown gains are more durable.

---

Connecting Net Worth to Your Expense Tracking

A net worth tracker tells you where you stand. An expense tracker tells you why. Together, they give you full financial visibility.

If your net worth is flat despite feeling like you're earning well, your expense data will usually show where the money is going—subscriptions, dining, impulse purchases, or lifestyle creep across a dozen small categories.

If your net worth is growing steadily, your expense data confirms which habits are driving that: a consistent savings rate, low fixed costs, automatic investment contributions.

The two tools complement each other. Net worth is the scoreboard. Expenses are the game tape. If you're using a budget spreadsheet template to plan your spending, your net worth tracker shows whether that plan is actually working over the long haul. And if you're tracking your savings rate on your path to financial independence, net worth is the balance sheet that backs up that percentage.

---

Common Net Worth Tracker Mistakes

Updating Too Infrequently

A tracker you update every six months loses its value. Monthly updates build the habit and catch problems early.

Including Illiquid Assets at Face Value

Your pension fund at age 30 is worth something, but it's not accessible for 35 years. Include it, but understand it's not the same as cash in a savings account.

Counting Expected Money as Current Assets

Don't add a bonus you haven't received yet or an inheritance that's "probably coming." Net worth reflects what you have now.

Ignoring Small Debts

A $400 credit card balance doesn't feel significant, but if you have four of them across four cards, that's $1,600 in liabilities you might be mentally discounting.

Treating the Number as Fixed

Net worth changes constantly. Markets move, you spend money, you earn money. The monthly snapshot captures a moment in time—don't let a bad market month convince you you're going backwards when the underlying trend is positive.

---

Template Structure Summary

Here's the complete column layout for each sheet:

Assets Sheet:

Column	Field
A	Asset Name
B	Category
C	Current Value
D	Institution
E	Date Updated
F	Notes

Liabilities Sheet:

Column	Field
A	Liability Name
B	Category
C	Outstanding Balance
D	Lender
E	Interest Rate
F	Date Updated
G	Notes

Dashboard Sheet:

Row	Content
1–5	Asset subtotals by category
6	Total Assets
7–10	Liability subtotals by category
11	Total Liabilities
12	Net Worth
14+	Monthly snapshot history
20+	Trend chart

---

Starting When the Number Feels Discouraging

The most common reason people avoid tracking net worth is that they expect the number to be bad. Maybe it's negative—more debt than assets. Maybe it's lower than you thought after years of working.

Track it anyway.

A negative net worth that's trending upward is better than a positive net worth trending down. The number at any single point matters far less than the direction it's moving. You can't improve what you don't measure, and you can't measure what you haven't started tracking.

Start with today's snapshot. Set a reminder to update it in 30 days. That's the entire commitment.

---

Related Articles

Track Your Full Financial Picture:

• Financial Freedom Tracker Spreadsheet: Monitor Your Path to Optional Work
• Investment Tracking Spreadsheet: Complete Setup Guide

Expense Tracking:

• Personal Expense Tracker Template
• Complete Expense Tracking Workflow

Automate Your Data:

• How to Auto-Import CSV to Google Sheets
• AI Transaction Categorization
• Budget Spreadsheet Template
• Savings Rate Calculator: Your Path to Financial Independence (2025 Guide)
• FIRE Movement 101: How Expense Tracking & Automation Accelerate Your Freedom Date

expense tracking

investment tracking

Expertise: This guide was written by the founder of Treasure Island, who has spent over 10 years building financial automation tools and spreadsheet systems used by thousands of people to track their wealth. You can explore more personal finance templates and automation guides on this site.

---

Get the free net worth tracker spreadsheet template — click to copy to your Google Sheets and start tracking your complete financial picture today.