Net Worth Tracker Template for Google Sheets (Free, 2026)

A net worth tracker is the one financial tool that answers the question budgets can't: am I actually getting ahead? A budget watches a single month of cash flow. Net worth watches the whole picture — every account you own and every debt you owe — and a good tracker records it over time so the trend becomes obvious. This guide gives you a free Google Sheets net worth tracker template with the math already wired up, plus a simple way to keep the balances current so the trend never goes stale.

What a net worth tracker actually is

A net worth tracker has three moving parts:

1. Assets — the current value of everything you own.
2. Liabilities — the current balance of everything you owe.
3. History — a snapshot of the net figure, recorded month after month.

Everything else is presentation. When the spreadsheet subtracts total liabilities from total assets, you get your net worth right now. When it lines those figures up month over month, you get the single most useful signal in personal finance: is the number going up or down, and how fast.

The reason net worth beats spending alone as a progress metric is that it captures everything at once. You can have a great spending month and still be sliding backward if debt is growing faster than savings. Net worth catches that. It rolls your checking account, your investments, your home, your student loans, and your credit cards into one honest line.

How to calculate net worth (assets minus liabilities)

The formula is simple enough to write on a napkin:

Net worth = total assets − total liabilities.

The work is in listing the parts honestly and consistently. Here's how each side breaks down.

Step 1: List your assets

Assets are anything with real cash value you could convert or sell. List the current value of each:

• Checking and savings balances
• Brokerage and other investment accounts
• Retirement accounts (401k, IRA, pension cash value)
• The current market value of your home
• Vehicles, at what they'd actually sell for
• Cash and any other meaningful holdings

Use real current values, not what you paid or what you hope something is worth. For a house, a recent comparable sale or an online estimate is fine — you're after a reasonable figure, not an appraisal.

Step 2: List your liabilities

Liabilities are everything you owe. List the current payoff balance of each:

• Credit card balances
• Student loans
• Car loans
• Personal loans
• The remaining balance on your mortgage

The key word is current. List what it would cost to clear the debt today, not the original loan amount, so your net worth reflects where you actually stand.

Step 3: Subtract

Total your assets, total your liabilities, and subtract the second from the first. That's your net worth. In the template this is a single formula — change any balance and the figure updates instantly.

It's completely normal for this number to be negative when you start. A recent graduate with student debt and a small savings balance has negative net worth, and so does anyone early in paying off a car or a mortgage. The starting point doesn't matter. The direction of the trend does.

Why Google Sheets is the best home for it

You can track net worth in Excel, on paper, or in a budgeting app. Google Sheets hits a sweet spot:

• Free and cloud-based. No license, and it auto-saves so a year of snapshots is never lost.
• Works everywhere. Update a balance on your laptop or check the trend on your phone.
• Easy to share. A partner can edit the same tracker in real time — no emailing files.
• Automatable. It connects to Avery, which syncs your account balances for you, so each monthly snapshot is captured without manual entry.

That last point is the difference between a tracker you fill in twice and one that runs for years. More on that below.

How to build a net worth tracker in Google Sheets (step by step)

You can build one from scratch, but starting from a template means the formulas already work. Here's the full process either way.

Step 1: Create an assets section

Down the left side, group your assets — cash, investments, property — with a row for each account and a column for its current balance. Sum the column for total assets. Grouping makes the dashboard readable and lets you see, for example, how much of your net worth is liquid versus tied up in a home.

Step 2: Create a liabilities section

Below or beside it, list each debt with its current payoff balance. Sum the column for total liabilities. Keep the labels specific — "Visa," "Student loan," "Mortgage" — so a glance tells you where the debt lives.

Step 3: Add the net worth formula

The single formula that does the work:

• Net worth — =SUM(assets) - SUM(liabilities).

Add a couple of supporting formulas — total assets and total liabilities on their own — so the dashboard shows the full picture, not just the bottom line.

Step 4: Build the monthly history

This is what turns a snapshot into a tracker. Create a history table with a row for each month and columns for total assets, total liabilities, and net worth. Each month, copy your current totals into a new row. Point a line chart at the net worth column and you've got a trend that reads at a glance.

Step 5: Record a snapshot every month

A net worth tracker is only useful if you keep feeding it. Put a recurring 15 minutes on your calendar — the first of the month works well — to update each balance and log a new row. Net worth moves slowly, so monthly is plenty; tracking daily just adds noise from market swings you can't control.

How to read the trend

A single net worth figure tells you almost nothing. The power is in the line.

• A rising line means your saving, investing, and debt payoff are compounding in your favor.
• A falling line is an early warning — debt growing faster than savings, or spending outrunning income — long before it shows up as a crisis.
• A flat line means you're treading water, which is the cue to either cut spending or grow income.

Three to six monthly snapshots are enough to see a real direction. A year of them shows whether your habits are working. Compare yourself only to your own past trend — someone else's net worth says nothing about whether you're moving in the right direction.

Early on, most of the gain usually comes from paying down debt and building your first cash cushion. Later, investment returns and compounding do more of the lifting. Both show up as the same rising line.

Net worth tracker vs. a budgeting app

People reach for a spreadsheet over an app for a few consistent reasons:

The historical trade-off was sync: apps pulled your balances automatically, spreadsheets didn't. Avery closes that gap — you get app-style automatic balance updates inside a spreadsheet you own, with a full history that's yours to keep.

Keeping the tracker current (the part that matters)

Here's the uncomfortable truth about every net worth tracker: it dies the moment you stop updating the balances. Logging into five accounts, copying each number across, and adding a new row is exactly the kind of monthly chore that gets skipped — and a tracker with a three-month gap can't show a trend.

That's the problem Avery solves. Connect your accounts with a read-only link and Avery:

• Pulls in your current balances automatically, across checking, savings, and credit accounts.
• Keeps each balance fresh, so your net worth figure is accurate whenever you look.
• Makes the monthly snapshot effortless, so the trend chart keeps growing without the manual round-up.

You go from "open every banking app and copy the numbers" to "glance at the trend." The tracker stays current, which means you actually keep using it.

Related templates and guides

• Net Worth Tracker template — the free Google Sheet this guide is built around.
• Net worth tracker Q&A — quick answers to the most common setup and calculation questions.
• Budget Spreadsheet template — control the spending side that feeds your savings.
• Monthly Budget template — a month-by-month layout for planning cash flow.
• Free monthly budget template guide — the companion walkthrough for monthly budgeting.
• Browse all free templates — the full Avery library.

A net worth tracker gives you the truest measure of progress; automation keeps it alive. Start with the free template, list your assets and liabilities, and let Avery handle the balance updates so the trend is still climbing in month twelve — not frozen on a snapshot you took once and forgot.