How to Track Your Net Worth as a Couple in One Spreadsheet
You’re building a life with someone, and your money is some blend of “mine,” “yours,” and “ours” — a joint account for the rent, your own retirement accounts, maybe a debt or two each of you brought in. You want to know what you’re worth together, without either person losing sight of what they individually hold. This guide shows you how to track a shared net worth in one spreadsheet that handles joint accounts, separate accounts, two incomes, and both sets of debts — cleanly.
Tracking net worth as a couple is genuinely different from doing it solo. There are two of almost everything, ownership isn’t always shared equally, and money is emotional in relationships in a way it isn’t when you’re on your own. The right setup gives you one honest household number and keeps each person’s picture visible, so the spreadsheet builds trust instead of tension.
The Core Idea: One Total, Labeled by Owner
The whole approach rests on one column: owner. Every account and every debt gets tagged as yours, your partner’s, or joint. Sum everything and you get the household net worth. Filter by owner and you see each person’s share. That one label makes a single spreadsheet work for any arrangement — fully merged, fully separate, or the common middle ground.
Step 1: List Every Asset With an Owner
Go account by account, and tag each one:
| Asset | Owner | Value |
|---|---|---|
| Joint checking | Joint | $6,800 |
| Joint savings | Joint | $15,000 |
| Your 401(k) | You | $44,000 |
| Partner’s 401(k) | Partner | $31,500 |
| Your Roth IRA | You | $18,200 |
| Partner’s brokerage | Partner | $9,400 |
| Home (market value) | Joint | $340,000 |
| Two cars | Joint | $26,000 |
| Total assets | $490,900 |
Notice how natural the owner column is: the joint accounts and the house are shared, but each person’s retirement stays clearly theirs. Nothing is hidden and nothing is forced into being joint when it isn’t.
Step 2: List Every Liability With an Owner
Same idea on the debt side:
| Liability | Owner | Balance |
|---|---|---|
| Mortgage | Joint | $268,000 |
| Your student loans | You | $14,500 |
| Partner’s car loan | Partner | $11,000 |
| Joint credit card | Joint | $3,200 |
| Total liabilities | $296,700 |
Step 3: Calculate the Household Number
Sum assets, sum liabilities, subtract:
Household net worth = $490,900 − $296,700 = $194,200.
That’s your shared scorecard — the number that actually matters for the goals you’re chasing together, whether that’s paying off the mortgage, upgrading the house, or retiring at the same time.
Step 4: Break Out Each Person’s Share
Here’s what a couple’s tracker does that a solo one doesn’t: it also shows each partner individually, which keeps everything transparent. Using the owner labels:
- Your side: 401(k) $44,000 + Roth $18,200 − student loans $14,500 = $47,700, plus your half of the joint accounts and equity.
- Partner’s side: 401(k) $31,500 + brokerage $9,400 − car loan $11,000 = $29,900, plus their half of the joint.
For the joint pieces, pick a split and stick with it. Most couples use 50/50; some match the split to who contributed the down payment or who’s on the loan. Whatever you choose, keep it consistent month to month so each person’s trend stays comparable. The point isn’t to keep score against each other — it’s to make sure the full picture is visible to both of you, which is exactly what prevents money resentment down the road.
Step 5: Update Together, Once a Month
The best habit couples build around money is a short, regular, low-drama check-in. Pick one day a month, sit down for ten minutes, and update the balances together. You both see the same household number, you catch surprises early, and shared goals stay in view without it turning into A Big Talk. Ten minutes a month is a remarkably cheap way to stay financially aligned.
A net worth tracker spreadsheet with owner-tagged accounts makes this painless — joint and separate rows, a household total, and each person’s share all update from one set of monthly entries. The Net Worth & Investment Tracker also charts your combined trend over 12 months and folds in your investment accounts and retirement projections, so your monthly check-in shows not just where you stand today but whether you’re both on track.
For the underlying month-by-month system, see the pillar: how to track net worth and investments in one spreadsheet.
The Bottom Line
Tracking net worth as a couple comes down to one column: owner. Tag every account and debt as yours, your partner’s, or joint; sum it all for the household number; and use the labels to keep each person’s share visible. Handle the house as a joint asset against a joint mortgage, pick a consistent split for shared pieces, and update together on the same day each month. One spreadsheet gives you a shared scorecard and full transparency at the same time — which is what keeps money a team sport instead of a sore spot.
Featured on ReadySheetGo
The Net Worth & Investment Tracker Spreadsheet tracks up to 35 assets across 8 categories — joint and individual — every liability with its interest rate, an investment portfolio tab, a 12-month net worth trend chart, retirement projections, and an automatic financial-health score. Enter your balances and the dashboard, charts, and totals update themselves. 8 tabs, 344 formulas, works with Excel and Google Sheets. One-time purchase — $14.99 instant download.
Frequently Asked Questions
Should couples track net worth jointly or separately?
Track both. Use one spreadsheet that shows the combined household net worth and also breaks out each partner's individual assets and debts. The combined number is what matters for shared goals like a house or retirement; the individual breakdown keeps things transparent, especially when you each brought different assets or debts into the relationship. One file, one household total, two clear columns — that setup works whether your money is fully merged or partly separate.
How do you handle joint and separate accounts in a net worth spreadsheet?
Label each account by owner: yours, your partner's, or joint. A joint checking account is one row owned by 'joint'; your individual Roth IRA is a row owned by you. Sum everything for the household net worth, and use the owner labels to see each person's share. This handles any arrangement — fully joint, fully separate, or the common mix of a joint account for shared bills plus individual accounts for everything else.
How do we count a house and mortgage we own together?
List the home's current market value as a joint asset and the remaining mortgage balance as a joint liability. The difference is your home equity, which counts toward household net worth. If you want each partner's share, split the equity by whatever ownership split you've agreed to — usually 50/50, but it can match who contributed the down payment. Keep the split consistent every month so your trend stays comparable.
How often should a couple update their net worth?
Once a month, together if you can. Pick a consistent day, sit down for ten minutes, and update each account balance. Doing it together turns net worth tracking into a low-stress money check-in — you both see the same number, catch surprises early, and stay aligned on shared goals without it becoming a bigger conversation than it needs to be.