How to Track Net Worth and Investments in One Spreadsheet (Free Template)

If you have money in a checking account, a 401(k) from work, maybe an IRA you opened yourself, a brokerage account, and a couple of debts, your financial life is scattered across half a dozen logins — and no single screen anywhere shows you the whole picture. You know your salary to the dollar but couldn’t say what you’re actually worth, or whether your investments are even balanced. This guide fixes that with one spreadsheet that does both jobs at once: your complete net worth on one side, your investment portfolio on the other, fed by the same numbers.

Most people keep these separate. They check their net worth in one app and their portfolio in another, and the two never talk to each other. That’s a mistake, because your investments are part of your net worth — keeping them apart means entering the same balances twice and never seeing how a good month in the market moves your bottom line. Put them together and every update does double duty.

Here’s exactly how to build it.

The Two Numbers You’re Actually Tracking

A combined tracker answers two different questions, and it helps to keep them straight.

Net worth is the big-picture number: everything you own minus everything you owe. It’s the single figure that captures your entire financial position, and it’s the truest scorecard in personal finance because it can’t be gamed by a big paycheck or hidden by debt.

Your investment portfolio is a zoom-in on one part of that picture — the money you’ve put to work in stocks, bonds, funds, retirement accounts, and cash equivalents. Here you care less about the total and more about the mix: are you 90% in one stock, or spread sensibly? Is your allocation drifting as one holding runs hot?

One spreadsheet, two views. The net worth view keeps you motivated and honest. The portfolio view keeps your investing disciplined. Let’s build both.

Step 1: List Every Asset — Cash and Investments Separately

Open a spreadsheet and make an assets section, but split it into two groups so it can feed both views later.

Cash and near-cash (part of net worth, not really “invested”):

• Checking account balance
• Savings, high-yield savings, money market
• Emergency fund
• HSA cash balance you’re not investing

Investments (these feed both net worth and your portfolio view):

• Brokerage accounts — individual stocks, ETFs, mutual funds
• 401(k), 403(b), or other workplace retirement plan
• Traditional IRA and Roth IRA
• Pension cash value, if applicable
• Crypto holdings at today’s price
• HSA dollars you’ve actually invested

Other assets (net worth only):

• Home at current market value (use a recent estimate or comps)
• Vehicles at resale value (check a used-car value guide)
• Cash-value life insurance, valuable collectibles you’d genuinely sell

Skip depreciating personal stuff — furniture, clothes, electronics. Listing them at purchase price inflates your net worth without reflecting money you could actually access.

Step 2: List Every Liability with Its Interest Rate

Now the other side of the ledger. Every debt, at its current balance:

• Credit cards — full balance, not the minimum payment
• Auto loans — remaining principal
• Student loans — total across all servicers
• Mortgage — remaining principal
• Personal loans, medical debt, buy-now-pay-later balances

Put the interest rate next to each one. A $10,000 balance at 24% is a completely different problem than $10,000 at 4%, and seeing rates beside balances makes it obvious which debt is quietly working against your net worth the hardest.

Step 3: Do the Two Calculations

Net worth is simple: sum all assets, sum all liabilities, subtract. That’s your number. In a spreadsheet, once the formulas are set, you replace last month’s balances with this month’s and the total updates itself.

Portfolio allocation is a second calculation using only the investment rows. Add up your total invested dollars, then divide each holding by that total to get its percentage. That percentage view is the whole point of the investment side — it tells you at a glance whether you’re diversified or dangerously concentrated.

A Worked Example

Say your accounts look like this on the 1st of the month:

Net worth = $109,200 − $33,000 = $76,200.

Now the portfolio view. Total invested = $18,500 + $41,000 + $16,300 + $3,200 = $79,000.

Two numbers, two insights, from one set of balances. Net worth: $76,200 and (once you have a few months) climbing or flat. Portfolio: mostly retirement accounts, a healthy 4% in crypto rather than a reckless 40%. You’d never see that second insight in a plain net-worth app.

Step 4: Snapshot It Monthly and Chart the Trend

A single figure is useful; a trend is transformative. Add a monthly snapshot tab that records your net worth (and, if you like, your total invested) on each update date, then chart it.

Update on the same day every month — the 1st is popular because it lines up with statement cycles. Consistency matters more than which day: comparing the 3rd of one month to the 28th of the next introduces a full month of noise. The whole update takes about ten minutes: open each account, copy the balance in, let the formulas do the rest.

After three or four months, patterns appear. Net worth climbing steadily means your system works. Flat despite a good income usually means lifestyle inflation is eating your raises. A dip after a market drop teaches you not to panic when it recovers. A line going up and to the right is one of the most motivating images in personal finance, and it reframes every purchase from “can I afford this?” to “what does this do to my trend?”

Step 5: Use the Portfolio View to Stay Balanced

This is where the combined sheet beats a net-worth-only tracker. Once your allocation percentages are live, you can spot problems before they cost you:

• Over-concentration — one stock or crypto position ballooning past a comfortable share of the total.
• Allocation drift — your stock-to-bond mix wandering from your target as markets move.
• Idle cash — a big savings pile that should probably be invested if it’s beyond your emergency fund.

You don’t have to trade on any of this. Just seeing it once a month is what separates deliberate investors from people who find out they were 80% in one company only after it drops.

The Fastest Way: Start From a Built Template

You can build all of this by hand, and the steps above are exactly how. But wiring the formulas — assets minus liabilities, allocation percentages, month-over-month change, a trend chart that updates itself — is a couple of hours of fiddly work, and one broken cell reference quietly throws off every number downstream.

A ready-made net worth and investment tracker spreadsheet skips that entirely. You get the asset and liability sections, an investment portfolio tab with allocation percentages, a 12-month trend chart, and a dashboard already built and tested — you just drop in your balances. The Net Worth & Investment Tracker also adds retirement projections and a financial-health score on top of the core net-worth math, so the same monthly ten-minute update tells you where you stand, whether your portfolio is balanced, and whether you’re on pace for retirement.

Three Mistakes That Make a Combined Tracker Lie to You

A tracker is only as honest as the numbers you feed it. Three mistakes quietly corrupt the results, and all three are easy to avoid once you know them.

Marking assets at what you paid, not what they’re worth. Listing your car at its sticker price or your home at your dream sale figure makes the number feel good and reflects nothing real. Use current market values — a recent used-car estimate, a recent comparable sale — and update them a couple of times a year. A net worth built on wishful values can’t guide a single decision.

Counting the same dollar twice. This is the classic combined-tracker error: cash you’ve earmarked for investing shows up in both a savings line and a brokerage line, or an employer match gets added on top of a balance that already includes it. Keep one rule — a dollar lives in exactly one account row, wherever it physically sits right now — and the overlap can’t happen.

Confusing total net worth with money you can actually use. A big net worth can be almost entirely locked in home equity and retirement accounts you can’t touch without penalty. That’s fine, but it’s worth also tracking your liquid net worth — cash plus taxable investments minus debts — so you know what’s genuinely accessible. Watching both numbers keeps you from feeling rich on paper while being cash-tight in reality.

Avoid those three and your combined tracker stays a truth-teller — which is the entire reason to keep one.

Dig Into the Specific Situations

The steps above are the core system. Depending on your setup, these companion guides go deeper:

• If your money is spread across a workplace 401(k), an old 401(k), an IRA, and a brokerage account, see how to track net worth with multiple investment accounts.
• Merging finances with a partner? Here’s how to track your net worth as a couple in one spreadsheet.
• To keep your investments balanced, read how to track your investment portfolio’s asset allocation in a spreadsheet.
• Chasing a milestone? See how to track your net worth progress to your first $100k.

The Bottom Line

Your investments and your net worth aren’t two separate things to track in two separate apps — they’re the same money, viewed two ways. List your assets (cash and investments kept separate), list your liabilities with their rates, run the two calculations, and snapshot the result on the same day each month. Ten minutes gets you a net worth trend that keeps you motivated and a portfolio view that keeps you balanced.

The hard part isn’t the math — a spreadsheet handles that. It’s starting. Set it up once, and every month after is just entering a handful of numbers and watching the line climb.