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:

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.


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.

Start Tracking Your Net Worth Today

The Net Worth & Investment Tracker — Track assets, liabilities, investments, and net worth month-over-month. Automated calculations.

View on Etsy — $11.99