Net Worth Tracker Google Sheets Template: Free DIY
Key takeaways
- A two-tab Google Sheets tracker (Accounts plus Snapshot) built with three SUMIF-based formulas takes about 20 minutes and costs nothing.
- Total assets and liabilities are calculated with SUMIF formulas that match Asset or Liability in the accounts tab, and net worth is simply assets minus liabilities.
- Paste each month's snapshot row as values so historical numbers stay frozen and next month's edits never rewrite your history.
- Manual monthly balance updates are more reliable than bank-syncing add-ons, which can silently stop updating when a connection breaks.
- GOOGLEFINANCE and IMPORTRANGE break in Excel, so keep one file compatible with both apps by sticking to shared functions and saving as .xlsx.
You can build a free net worth tracker in Google Sheets in about an hour, and this guide gives you the exact column layout, the SUMIF formulas to total assets and liabilities across accounts, and a 15-minute monthly review routine. No subscription, no bank connections to break, and an Excel-compatible version if you prefer offline. After Mint shut down in 2024, millions of users went looking for a replacement, and a spreadsheet is the one option that costs nothing and never changes on you.
What Is a Net Worth Tracker and Why Use a Google Sheets Template?
Net worth = assets minus liabilities
Net worth is everything you own minus everything you owe. Add up cash, checking and savings balances, investments, and property; subtract credit cards, student loans, car loans, and anything else you're still paying off. The result is one number that shows whether your finances are moving forward or backward over time.
Why Mint refugees end up with a spreadsheet
When Intuit shut down Mint in 2024, millions of users had to find a replacement (CNBC), and most alternatives charge monthly fees. A Google Sheets template costs nothing, works in any browser, and shows every formula so nothing is hidden. It pairs well with a free budgeting method like budgeting with irregular income, and you can export the same file to Excel whenever you want.
What Should a Net Worth Tracker Template Include (Assets, Liabilities, Formulas)?
A workable template needs two tabs: an accounts tab listing everything you own and owe, and a monthly snapshot tab that totals them. Three formulas tie it together.
The accounts tab: exact columns
| Column | Example | Notes |
|---|---|---|
| Account name | TD Chequing | |
| Type | Asset or Liability | |
| Category | Cash, Investment, Property, Loan, Credit Card | |
| Balance | $4,212.55 | Update monthly |
| Notes | "Chequing, RBC" | Optional |
Keep the category list short: cash, investments, property on the asset side; student loans, credit cards, car loans, mortgages on the liability side.
The monthly snapshot tab: exact columns
One row per month, with columns for Date, Total Assets, Total Liabilities, Net Worth, and Change From Last Month. Each row is a single formula pulling from the accounts tab, so a new month costs you one copy-paste.
The three formulas that matter
- Total assets:
=SUMIF(Accounts!C:C,"Asset",Accounts!D:D) - Total liabilities:
=SUMIF(Accounts!C:C,"Liability",Accounts!D:D) - Net worth:
=B2-C2(assets minus liabilities)
That's the whole engine. Apps like YNAB (https://www.ynab.com) or Monarch Money wrap more around it, but the math is the same. If you'd rather have the categories, paycheck splitting, and the 50/30/20 rule done for you, otterfund covers that side free, no credit card required, and we compare it honestly with YNAB in https://www.otterfund.ai/blog/otterfund-vs-ynab.
How Do You Build a Net Worth Tracker in Google Sheets Step by Step?
You can go from a blank sheet to a working net worth tracker in about 20 minutes using two tabs and four formulas. Here is the full walkthrough.
Step 1: Create the accounts tab
Name a tab "Accounts." Set up columns: Account Name, Type (asset or liability), Institution, Balance, and As-Of Date. Add one row per account: checking, savings, credit card, student loan, 401(k), RRSP, whatever you hold. Enter current balances manually on day one.
Step 2: Create the snapshot tab
Name a second tab "Snapshot." In column A, list dates going down (one per month). In columns B, C, and D, add headers for Assets, Liabilities, and Net Worth.
Step 3: Add the formulas
This is the part worth understanding, because it is what makes the tracker reusable month after month. In the Snapshot tab, cell B2 pulls total assets from the Accounts tab with =SUMIF(Accounts!B:B,"Asset",Accounts!D:D), and C2 pulls liabilities the same way using "Liability" as the match term. D2 is simply =B2-C2. Each month, you copy that row down, paste it as values, and update the balances in Accounts. The Google Sheets function documentation covers SUMIF syntax if the formula throws an error. The manual paste-as-values step matters: it freezes each month's numbers so next month's edits never rewrite your history, which is exactly the audit trail a Mint export never gave you.
Step 4: Add a net worth chart
Select the date and Net Worth columns, then Insert > Chart and pick a line chart. For a sparkline inside a single cell instead, =SPARKLINE(D2:D13) works with no chart editor at all.
If you would rather skip the spreadsheet entirely, otterfund splits your paycheck across needs, wants, and savings automatically, free to start with no credit card required.
How Do You Make the Tracker Update Automatically Each Month?
The 5-minute monthly snapshot routine
Pick a day, like the first of the month, and set a recurring calendar reminder. Open your sheet, copy last month's column, paste it into a new one, then update the handful of numbers that changed: balances, credit card debt, investments. Everything else, formulas included, carries over. Two minutes in, your tracker is current.
Make it even faster with dropdowns for account type (checking, savings, credit card, investment) and a checkbox column to mark accounts you've verified. Data validation lives under Data > Data validation in Google Sheets and works the same in Excel.
Why not to chase automatic bank syncing in a sheet
Bank connections through Google Sheets add-ons rely on the same Plaid-style plumbing that frustrates app users, and a broken connection silently stops your sheet from updating. A manual paste can't break. If you eventually want automatic categorization and a 50/30/20 split of your paycheck handled for you, that's what otterfund is for, free to start.
How Does a Free Excel Net Worth Tracker Template Differ From the Google Sheets Version?
Most of the template survives the trip. Core formulas like SUM, SUMIF, and IF behave the same in both, and Microsoft documents the shared function set in its Excel function library. Structure your accounts as a table in each app and monthly totals carry over intact.
What breaks: GOOGLEFINANCE, which pulls live stock and exchange rates for investment tracking, has no Excel equivalent. Replace it with manual price entries or a Power Query connection. Google Sheets' IMPORTRANGE also fails in Excel, so cross-file references need rework.
To keep one file compatible with both, stick to shared functions, avoid add-ons, and save as.xlsx. If you find the manual upkeep tedious, a free budgeting app that automates the math is the next rung up; we compare the options in our roundup of free budgeting apps.
How Often Should You Update Your Net Worth Tracker?
Update it once a month, on a fixed day you pick: the 1st, payday, or the day a recurring bill hits. Monthly is often enough to catch a trend, since account balances barely move week to week and investment values swing daily for reasons that have nothing to do with your plan.
Weekly updates mostly produce noise. You'll watch your 401(k) or RRSP dip $200 and feel like you did something wrong, when the monthly picture would have shown steady progress.
On update day, do three things: refresh each balance, log the date in your tracker, and jot one line about what changed, like a bonus or a big purchase. That note turns next month's review into a two-minute check instead of an archaeology project.
When Is a Spreadsheet Tracker Better Than a Budgeting App for Net Worth?
A spreadsheet wins when you want a permanent, free record of your net worth that no company can shut down or reprice. Mint's shutdown in early 2024 left millions of users scrambling for a replacement (FinanceFeeds), and a Google Sheets file survives any app's death. You also control every formula, and nothing gets locked behind a paywall later.
Where a sheet wins
Full control, zero cost, and no forced AI features or surprise redesigns that move buttons you've used for years. Net worth itself is simple: assets minus liabilities, per Investopedia's definition, so a sheet covers it without a subscription.
Where an app wins, honestly
Apps pull account balances automatically; a sheet means manual entry, and otterfund is no exception there. Our strength is splitting every paycheck across needs, wants, and savings, not deep net worth history. If automatic syncing across every account matters most, a paid tool like Monarch Money will beat any spreadsheet.
What Net Worth Number Should You Actually Aim For?
There is no universal target, and anyone quoting a fixed multiple of your salary is guessing at your situation. Direction matters more than a number: in your 20s, the win is simply a positive net worth. In your 30s, it is steady growth as you pay down student loans and build retirement savings. By your 40s and 50s, growth should accelerate as debts shrink and investments compound.
The most useful benchmark is your own trend line. If your monthly update in the tracker shows the line rising for six straight months, you are on track, whatever the absolute number. If it stalls or dips for two or three months in a row, that is your signal to look at spending or debt before it becomes a problem.
FAQ
Is there a truly free net worth tracker with no subscription?
Yes. A Google Sheets tracker costs nothing and has no subscription, since you build it yourself with two tabs and a few SUMIF formulas. Paid alternatives like YNAB or Monarch Money charge monthly fees, and Mint's 2024 shutdown pushed many users toward spreadsheets. The only cost is the 20 minutes it takes to set up.
Can I track my net worth in Google Sheets without linking my bank accounts?
Yes, and manual entry is the more reliable option. Bank-syncing add-ons rely on the same connection plumbing that breaks in apps, and a failed connection can silently stop your sheet from updating. Entering balances by hand takes a few minutes each month and cannot break, so your history stays complete.
How do I include my RRSP, TFSA, or 401(k) in a net worth spreadsheet?
Add each account as its own row on the accounts tab with Type set to Asset and Category set to Investment, then enter the current balance. The SUMIF formula totals them automatically. Update the balance monthly, since investment values swing daily for reasons unrelated to your long-term plan.
What is the best free net worth tracker template for beginners?
The two-tab layout in this guide: an Accounts tab listing every balance and a Snapshot tab with one row per month. It uses three formulas (two SUMIF totals and assets minus liabilities), takes about 20 minutes to build, and exports cleanly to Excel. Beginners only need to copy one row down each month.