How to Use a Spreadsheet to Track Your Net Worth (Free Template)

Your salary tells you how much you earn. Your budget tells you how much you spend. Your net worth tells you whether you are actually getting ahead. Most people never calculate it because it feels like accounting homework, and the number itself can be uncomfortable to face.

But listing every account and every debt in one place takes about 15 minutes to set up and 10 minutes a month to maintain. The payoff is significant: watching your net worth trend upward over time is genuinely motivating in a way that no budgeting app can replicate. A budget shows you what you did last month. A net worth spreadsheet shows you where you are heading over years.

This post covers how to build a net worth spreadsheet from scratch (or copy a free template structure), what to include, and how to use the trend over time to stay motivated when progress feels slow.

What Net Worth Actually Tells You

Net worth is everything you own minus everything you owe. It is the single most honest measure of your financial progress because it cannot be inflated by a high salary or hidden by a low spending rate.

Consider two people. Someone earning $150,000 who spends $140,000 and carries $50,000 in debt has a negative net worth and is going backwards financially, regardless of their income. Someone earning $50,000 who spends $20,000 and has no debt is building wealth steadily. Income tells you about cash flow. Net worth tells you about trajectory.

The Federal Reserve's Survey of Consumer Finances (the most recent published data is from 2022, with the 2025 survey not yet released as of July 2026) provides the authoritative benchmark for where American families stand:

The gap between median and mean is enormous. The mean is more than five times the median across all families because a small number of very wealthy households pull the average upward. Use the median as your benchmark, not the mean. The median represents the typical family, and median net worth rose 37% between 2019 and 2022, the largest jump since the survey began in 1983.

Why tracking monthly matters: a single net worth number is a snapshot. It tells you where you are today but not whether you are improving. Tracking monthly gives you a trend, and the trend is what reveals whether your financial system is working. A single bad month (market correction, large purchase) does not matter. A flat trend over 12 months tells you something needs to change.

You can get a quick estimate using our net worth calculator, but a spreadsheet gives you the ongoing tracking that a one-time calculation cannot.

What to Include in Your Spreadsheet

Assets (What You Own)

List every account and asset you have. Be conservative with estimates.

• Checking and savings accounts (use current balances)
• Brokerage and investment accounts (use current market value)
• Retirement accounts: 401(k), traditional IRA, Roth IRA (use current balances)
• HSA balance (if you use it as an investment vehicle)
• Real estate (use current estimated market value, not what you paid. Check comparable sales in your area, not just Zillow estimates which tend to be optimistic)
• Vehicles (use Kelley Blue Book or Edmunds for current value. Cars depreciate, so update this annually)
• Other significant assets: business equity, valuable collections, land

Liabilities (What You Owe)

List every debt, using current balances (not original loan amounts).

• Mortgage balance (the remaining principal, not the original loan amount)
• Student loan balances (including both federal and private)
• Auto loan balances
• Credit card balances (use statement balances, not available credit)
• Personal loans (from banks, family, or online lenders)
• Buy Now Pay Later balances (Klarna, Affirm, Afterpay)
• Medical payment plans
• Any other outstanding debt

The key principle: use current values, not wishful values. A conservative home estimate based on recent comparable sales is more useful than a Zillow number that makes you feel good. If your home is worth $50,000 less than you think, knowing that now lets you plan accordingly. For more on building the cash reserves that feed your net worth, see our guide on how to build an emergency fund. You can also check the asset and liability glossary definitions for a quick refresher.

Building the Spreadsheet Step by Step

You can use Google Sheets (free) or Microsoft Excel. The setup is identical for both.

Step 1: Set Up Your Sheet

Create a new spreadsheet with the following structure:

• Column A: Category labels (account and debt names)
• Columns B through M: January through December
• Two sections: Assets (top) and Liabilities (bottom)

Leave a blank row between the two sections, and leave two blank rows at the bottom for totals and net worth calculation.

Step 2: List Your Accounts

Under Assets, list every account you own, one per row. Examples:

• Checking account
• High-yield savings
• 401(k)
• Roth IRA
• Brokerage account
• Home (estimated value)
• Car (Kelley Blue Book value)

Under Liabilities, list every debt:

• Mortgage remaining
• Student loans
• Auto loan
• Credit card balance
• Personal loan

Skip rows that do not apply to you. If you do not own a home, leave that row blank or delete it.

Step 3: Add Total Formulas

At the bottom of the Assets section, add a total row:

• Total Assets: =SUM(B2:B10) (adjust the range to match your actual rows)

At the bottom of the Liabilities section, add another total:

• Total Liabilities: =SUM(B12:B18) (adjust the range)

Below both, add the net worth calculation:

• Net Worth: =Total_Assets-Total_Liabilities

Copy these formulas across all 12 month columns (B through M) so each month calculates automatically.

Step 4: Add a Month-Over-Month Change Row

Below the Net Worth row, add a percentage change row:

• Formula for February: =(C20-B20)/ABS(B20) formatted as a percentage
• Copy across all months

This shows you which months drove the biggest gains or losses. A month where net worth jumped 4% might correspond to a market rally. A month where it dropped 2% might correspond to a large purchase or a market correction. Over time, you start to see patterns.

Step 5: Add a Chart

Select the Month row and the Net Worth row. Insert a line chart (Insert > Chart > Line Chart in Google Sheets). Add a second data series for total liabilities to visualize what we call the "scissors pattern": debt trending down while net worth trends up. The two lines diverge over time, and that visual divergence is the most motivating chart in your financial life.

You can also add a third line for total assets to see all three trends together. The gap between assets and liabilities growing wider is your wealth being built in real time.

For context on what to invest in within the accounts you are tracking, see our guide on your first investment portfolio in your 20s.

The Monthly Routine

Pick a consistent date. The 1st of each month works well because it is easy to remember and aligns with most billing cycles.

Log in to each account, note the current balance, and enter it in the spreadsheet for the previous month. Total time: 10 to 15 minutes once you are set up.

Do not update more frequently than monthly. Daily fluctuations from market movements create noise and anxiety. A portfolio that drops $3,000 on a Tuesday because of a bad market day tells you nothing useful. The monthly trend smooths out that noise and shows you the direction that matters.

Once per quarter, do a deeper review. Look at 3 months of data, identify trends, and adjust if needed. Are your assets growing faster than your liabilities are shrinking? Is your net worth growth driven by market returns or by your contributions? Understanding the source of growth helps you make better decisions about saving and investing.

The ritual matters as much as the system. Consistency over 12 to 24 months is what makes this valuable. A spreadsheet you update for 3 months and then abandon teaches you nothing.

Real-World Examples

Example: A 26-year-old starting from negative

Situation: $32,000 in student loans, $8,000 in a 401(k), $3,000 in checking, and a $6,000 car loan. Starting net worth: negative $3,000. The number was demoralizing, and the temptation to stop tracking was strong in the first few months.

What they did: Built the spreadsheet in one evening. Updated it on the 1st of every month. In months 1 through 4, net worth barely moved because debt payments were small and the 401(k) was too new to show much growth. Month 6 showed a $1,200 increase, which was the first meaningful jump.

Result: After 18 months of tracking and aggressive debt payoff (putting $600/month toward the car loan and student loans), net worth reached $14,000. The spreadsheet kept them motivated during the months where progress felt invisible. Seeing the chart turn upward after month 6 was the moment the habit stuck. They now track net worth monthly and have increased their 401(k) contribution since the car loan is paid off.

Example: A 45-year-old couple with a mortgage and retirement accounts

Situation: $320,000 mortgage, $180,000 in retirement accounts, $25,000 in brokerage, $12,000 in credit card debt. Starting net worth: $133,000. They had never tracked net worth before and assumed they were doing fine based on their income.

What they did: Built the spreadsheet and started tracking monthly. In month 3, the market dropped 8% and their net worth fell $18,000. They almost quit tracking because the number felt discouraging. They pushed through and kept updating.

Result: After 2 years of tracking, net worth reached $172,000. The chart showed them that market returns were doing more work than their monthly contributions, which motivated them to increase their 401(k) contributions from 6% to 10% of income. The credit card debt was eliminated in year one. The months where net worth dropped due to market corrections became easier to tolerate once they could see the overall upward trend in the chart.

Spreadsheet vs Budgeting App vs Manual Calculation

A spreadsheet and a budgeting app serve different purposes. A budgeting app tracks spending. A net worth spreadsheet tracks wealth. Many people use both: an app for monthly spending management and a spreadsheet for quarterly or monthly net worth tracking. For a comparison of the best budgeting apps to pair with your net worth spreadsheet, see our best budgeting apps comparison.

Common Mistakes

Including monthly expenses as liabilities. Your electric bill is not a debt. It is a cash flow item. Liabilities are obligations you owe to a creditor: loans, credit card balances, mortgages. Including your monthly bills as liabilities double-counts them (you will pay them from your cash, which is already counted as an asset).

Using the purchase price of your home instead of current market value. If you bought your home for $250,000 five years ago and it is now worth $320,000, using $250,000 understates your net worth by $70,000. Use current estimated value based on comparable sales. Be conservative, but be current.

Updating too frequently. Checking your net worth weekly or daily creates anxiety. Markets fluctuate. A portfolio that drops $5,000 in a week will likely recover. Monthly updates smooth out the noise and show you the trend that matters. If you cannot resist checking more often, hide the spreadsheet and set a calendar reminder for the 1st of each month.

Forgetting smaller debts. Buy Now Pay Later balances, medical payment plans, and money borrowed from family all count as liabilities. A $400 Klarna balance is a debt, even if it feels too small to track. These small balances add up and distort your net worth if excluded.

Stopping when net worth drops. Market corrections are normal. Over a 30-year investing horizon, you will see multiple 10%+ drops. The months where net worth declines are the most important months to keep tracking, because they show you whether the decline is temporary (market correction) or structural (spending exceeding income). If you stop tracking during bad months, you lose the data that would tell you the difference.

Conclusion

A net worth spreadsheet is the foundation of financial tracking. It takes 15 minutes to build and 10 minutes a month to maintain. The number itself matters less than the trend. Watching it grow over 12 to 24 months is motivating in a way that no budgeting app can replicate, because it shows you the complete picture: assets growing, debts shrinking, and the gap between them widening over time.

Copy the template structure above, enter your numbers today, and check back in 30 days. Then explore our net worth calculator for a quick estimate, and check the balance sheet glossary term for a deeper understanding of how assets and liabilities interact.

This post is for informational purposes only and does not constitute financial advice.