How to Track Net Worth With Multiple Investment Accounts in a Spreadsheet

You’ve got a 401(k) at your current job, maybe an old 401(k) still sitting at a past employer, a Roth IRA you opened on your own, a taxable brokerage account, and possibly an HSA you invest through. Each has its own login, its own app, its own balance — and there is no single place that adds them all up. That’s the exact problem this guide solves: pulling every scattered investment account into one net worth spreadsheet so you finally see the total.

Scattered accounts don’t just make your net worth hard to calculate. They hide money. Old 401(k)s from jobs you left years ago are one of the most commonly forgotten assets in personal finance, and “forgotten” can mean tens of thousands of dollars you’re not counting toward your real position. One spreadsheet fixes that permanently.

The Rule That Prevents Every Mistake: One Row Per Account

Before any formulas, adopt one rule: every account gets exactly one row, and a dollar lives in exactly one account.

This single habit prevents the two errors that wreck multi-account tracking. The first is missing an account — you forget the old 401(k) exists. The second is double-counting — the same money shows up twice, like cash earmarked for investing that you list in both a savings line and a brokerage line. One row per account, each updated once, and neither can happen.

Step 1: Inventory Every Account Once

Do this once and you’ll never have to hunt again. Make a list of every place you hold invested money:

• Current 401(k) / 403(b) — your active workplace plan
• Old 401(k)s — one row for each past employer you never rolled over
• Traditional IRA — self-directed retirement
• Roth IRA — after-tax retirement
• Taxable brokerage — individual stocks, ETFs, funds
• HSA (invested portion) — the dollars you’ve actually put in the market
• Crypto — exchange or wallet holdings
• Other — pension cash value, employer stock, RSUs vested and held

Next to each, note the institution and roughly where to log in. That column turns “which bank was that old 401(k) with again?” into a thirty-second lookup forever.

Step 2: Give Each Account a Row and a Balance

Now the spreadsheet. Each account is one row with, at minimum, its name and current balance. A worked example for someone with a genuinely scattered setup:

That total — $105,050 — is a number this person almost certainly could not have named off the top of their head, because it lived in seven different apps. Now it’s one cell.

Step 3: Feed the Total Into Net Worth

Your investment total is one input to net worth, not the whole thing. Add your cash and other assets, subtract your liabilities:

Say the same person also has $9,000 in cash and a $13,000 car, against $16,000 in student loans and a $7,000 auto loan.

• Total assets = $105,050 invested + $9,000 cash + $13,000 car = $127,050
• Total liabilities = $16,000 + $7,000 = $23,000
• Net worth = $104,050

Because the investment accounts and the net worth math live in the same file, updating one old 401(k) balance flows straight through to the bottom line. No re-adding, no copying between apps.

Step 4: Watch for the “Roll It Over” Signal

Here’s a payoff that only shows up once everything is in one view: consolidation opportunities. When you can see three old 401(k)s sitting in three different institutions, each with its own fees and its own login, it becomes obvious when it’s worth rolling them into a single IRA to simplify your life and often cut costs. You can’t make that call about an account you’ve forgotten. Seeing all of them lined up turns a vague “I should deal with those someday” into a clear decision.

Step 5: Update All of Them on One Day

Consistency is what makes multiple accounts manageable. Pick one day a month, open each account in turn, copy the balance into its row, and let the totals recalculate. Ten minutes, once a month, and every account is current at the same moment — which is the only way your net worth trend across all of them means anything.

A net worth and investment tracker spreadsheet built for this has the account rows, the invested total, and the net worth roll-up already wired together, plus a portfolio view so you can see how your money is split across all those accounts at once. You add your accounts and drop in balances; the Net Worth & Investment Tracker handles the totals, the trend, and the allocation.

For the full month-by-month system this fits into, see the pillar guide: how to track net worth and investments in one spreadsheet.

The Bottom Line

Multiple investment accounts don’t have to mean a scattered, uncountable net worth. Inventory every account once — including the old 401(k)s you’re tempted to forget — give each exactly one row, and let the invested total feed a single net worth calculation. Update them all on the same day each month, and the accounts that used to live in seven apps become one number you can watch grow.