Build Your Own Net Worth Calculator Spreadsheet Template
A net worth calculator spreadsheet template is simply two columns (assets and liabilities) subtracted from each other and tracked over time. You can build one yourself in Google Sheets or Excel in about ten minutes, then update it every month or quarter with a few new numbers.
This guide walks you through the exact formula and layout, row by row, so your sheet keeps a running history rather than a single snapshot. There's no file to download because your account list and balances are unique to you. By typing the formula yourself, you can build the sheet around your own accounts and balances.
Prefer not to build one? Our free net worth calculator runs the same math instantly and benchmarks your result against Federal Reserve data.
The Net Worth Formula in One Line
Net worth equals everything you own minus everything you owe, full stop. The Consumer Financial Protection Bureau's own Your Money, Your Goals financial education materials use this same assets-minus-liabilities framing to help people see where they actually stand.
The entire spreadsheet you are about to build is one implementation of that single formula, repeated every month so you can watch the number move instead of calculating it once and setting it aside.
Set Up Your Asset and Liability Columns
Open a blank sheet and create two side-by-side sections. On the left, label rows for Assets: Cash, Checking, Savings, Taxable Investments, Retirement Accounts, Home Value, and Vehicles. On the right, label rows for Liabilities: Mortgage, Auto Loans, Student Loans, and Credit Cards.
Enter your current balance for each line item next to its label. Use your most recent statement balance for each account rather than a rough guess, since a spreadsheet you update casually loses its value fast if the starting numbers are already off.
Leave one blank cell below each section, labeled Total Assets and Total Liabilities. Those two cells are what the rest of the sheet references.
The Subtraction Formula, Cell by Cell
In your Total Assets cell, sum every asset row with the SUM function. If your asset values sit in cells B2 through B8, the formula is =SUM(B2:B8). Do the same for Total Liabilities, summing whatever range holds your debt figures.
In a new cell labeled Net Worth, subtract Total Liabilities from Total Assets: if Total Assets sits in B10 and Total Liabilities sits in D6, the formula is =B10-D6. That single cell is your full net worth, recalculated instantly any time you change an account balance above it.
Add a Liquid Net Worth cell too, if you want one: sum only the assets you could convert to cash quickly, like checking, savings, and taxable investments, and subtract your same Total Liabilities figure. Home equity and retirement accounts stay out of that second total, since neither converts to spendable cash without a real cost or delay.
Here is a full worked example with sample numbers. Assets of $10,000 cash, $3,000 checking, $15,000 savings, $40,000 taxable investments, $120,000 retirement, $350,000 home value, and $20,000 in vehicles add up to $558,000 in Total Assets. Liabilities of a $250,000 mortgage, $18,000 auto loan, $22,000 in student loans, and $6,000 in credit cards add up to $296,000 in Total Liabilities. Net Worth comes out to $558,000 minus $296,000, or $262,000.
Turn Your Net Worth Number into a Running History
A single net worth number tells you where you stand today, but it cannot tell you whether you are moving in the right direction. Turn your one-time calculation into a running history by adding a new row underneath each time you update, rather than overwriting the row above.
Label a fresh block of rows with a Date column next to your Net Worth formula, then copy the whole formula pattern down each time you add an entry. When we reviewed this ourselves, the running-history habit made a bigger difference than any single account balance, since a trend line catches a debt creeping up long before any one month's snapshot would. After six or eight entries, a simple line chart built from the Date and Net Worth columns shows the trend at a glance.
What to Update Monthly vs. Quarterly
Update your liquid accounts, cash, checking, savings, and taxable investments, every month, since those balances change with every paycheck and purchase. Retirement account balances are also worth a monthly glance if your platform shows them, though a small daily swing in the stock market matters less than the overall trend.
Update your home value and any other illiquid asset on a quarterly basis instead of monthly. Home values do not move fast enough to justify a monthly re-estimate, and pulling a new number too often just adds noise to your running history rather than real information. A vehicle's value belongs on the same quarterly schedule, since a car depreciates steadily rather than in sudden jumps, and checking it monthly wastes time better spent elsewhere.
A typo is the most common way this sheet goes wrong. Adding a stray zero to a $15,000 savings balance turns it into $150,000 and throws off every total beneath it, so a sudden jump in your net worth history is usually worth a second look at the row you just entered before you trust the new number.
When the Calculator Does the Benchmarking for You
A spreadsheet is the right tool if you want full control over which accounts count and how the history is stored, and you do not mind updating each balance yourself. It is the wrong tool if you want your net worth benchmarked against real Federal Reserve data for your age bracket, since building that comparison yourself takes an extra step our net worth calculator already includes.
Two things tend to push readers toward the calculator instead of the sheet. One is wanting a liquid net worth figure and a full net worth figure side by side without building two separate formulas. The other is wanting to see how a number compares with the net worth by age benchmarks without looking them up manually.
Build the spreadsheet if you want full control over your own trend line. Use the calculator when you want the benchmarking done for you.
Frequently asked questions
What is the net worth formula?
Net worth equals total assets minus total liabilities. Add up everything you own with cash value, then subtract everything you owe, and the result is your net worth.
How do I set up a net worth spreadsheet in Google Sheets?
List your assets and liabilities in two separate columns with a balance for each account, sum each column with the SUM function, then subtract the liabilities total from the assets total in one final cell. That final cell is your net worth.
How often should I update my net worth spreadsheet?
Update liquid accounts like checking, savings, and investments monthly, since those balances move often. Update illiquid figures like your home value on a quarterly basis instead, since they change too slowly to justify a monthly re-estimate.
What counts as an asset versus a liability on this spreadsheet?
Assets are anything with cash value you own: cash, bank accounts, investments, retirement accounts, real estate, and vehicles. Liabilities are debts you owe: mortgages, auto loans, student loans, and credit card balances.
Should my net worth spreadsheet track history, or just my current number?
Track history. Add a new dated row each time you update instead of overwriting the last entry, so a simple chart can show the trend over time instead of just today's number.
Is there a downloadable net worth spreadsheet template file?
No. This guide walks through the exact formula and layout so you can build a sheet around your own specific accounts and balances. Prefer not to build one? The free net worth calculator runs the same assets-minus-liabilities math instantly and benchmarks your result against Federal Reserve data.
What if my net worth spreadsheet shows a negative number?
A negative net worth means your Total Liabilities cell is larger than your Total Assets cell, which is common for recent graduates carrying student loans or new homeowners who just closed on a mortgage. Track it the same way as a positive number: update it on the same schedule and watch whether the negative figure is shrinking toward zero over time.
Should couples track net worth together or separately?
Either works, as long as you stay consistent from one update to the next. A combined sheet with both people's accounts in one Assets and Liabilities list gives a single household number. Two separate sheets let you also see each person's individual position, which matters more if you keep some accounts separate.
Sources
We prioritize primary sources for rules, formulas, rates, limits, and definitions. See our calculator methodology and editorial policy.