A net worth spreadsheet becomes a balance sheet when every row has an owner, a date and an offsetting debt. Count each company or property at your share of its equity, not its full value; net every loan against what it finances; date every balance; and keep each month’s figures instead of overwriting them. Then the total means one thing, and you can measure what it earned.
Most people who track their wealth started in a spreadsheet, and many still use one. That’s a sound instinct. A spreadsheet is private, flexible and free, and you understand every number in it because you typed it. The trouble starts when the household gets more complicated than the sheet.
What does a good net worth spreadsheet get right?
Three things, and they’re the hard part.
It’s complete. Every account is on it, including the ones no app shows: the property, the business interest, the old 401(k).
It’s honest about debt. A good sheet lists the mortgage and the car loan next to the assets, so the total is a net worth, not a pile of balances.
It’s a habit. Someone opens it every month. Most tools never get that far.
A spreadsheet that does those three things is already ahead of most households. This essay is about the next step, not about starting over.
Where does a spreadsheet start to strain?
Take a household with five tabs:
Brokerage: $412,000
IRA: $286,000
Bank: checking and savings, $64,000
Home: worth $1,150,000, with a $612,000 mortgage
The duplex: a rental held in an LLC the household owns 60% of, with a business partner owning the other 40%. The duplex is worth $780,000, with a $410,000 mortgage in the LLC’s name.
They also carry a $24,000 car loan and a $6,000 credit card balance. (All figures illustrative; the household is fictional.)
The summary tab adds everything up: $1,912,000 of accounts and home, the duplex’s $780,000 less its $410,000 mortgage, less $642,000 of household debts. It shows $1,640,000.
The household’s net worth is $1,492,000. The spreadsheet is $148,000 high, about 10%, and every number in it is correct. The error is in one tab: the duplex is counted whole. The household owns 60% of the LLC, so it owns 60% of the duplex’s equity: 60% of $370,000 is $222,000, not $370,000. The other $148,000 belongs to the partner.
How do you lay out a personal balance sheet?
The same numbers, laid out as a balance sheet. Each line shows its owner, its value, any debt against it, the household’s share, and what counts toward net worth:
Brokerage (household): $412,000, 100% → $412,000
IRA (household): $286,000, 100% → $286,000
Bank (household): $64,000, 100% → $64,000
Home (household): $1,150,000 less the $612,000 mortgage, 100% → $538,000
Duplex, via the LLC (LLC): $780,000 less the LLC’s $410,000 mortgage, 60% → $222,000
Car loan (household): 100% → −$24,000
Credit card (household): 100% → −$6,000
Net worth: $1,492,000
Three columns do the work a summary tab can’t. Owner says who holds each line: the household, a company, a trust. Debt sits on the same row as the asset it finances, so the LLC’s mortgage can’t be forgotten or counted twice. Your share is applied to the net equity, not to the value. Those columns are the whole personal balance sheet template; the rest is formatting.
Why does the date of each balance matter?
Because a total built from balances on different days doesn’t describe any day.
In most spreadsheets, the brokerage balance is copied from the statement, the bank balance from the app this morning, the home value from an estimate in the spring and the LLC’s numbers from its last tax return. Each figure is right for its date. The sum is a mix of four dates, and in a month when markets move, the gap can be larger than the change you’re trying to measure.
A balance sheet carries an “as of” date for each line, and a sheet you overwrite each month keeps only the latest. Keeping each month’s figures, a new column instead of a new number in the old cell, is what turns a snapshot into a history.
What did the household’s money actually earn?
Last January the sheet showed $1,380,000 on the same basis. This December it shows $1,492,000: up $112,000, or 8.1%.
But that change includes money the household put in. Over the year they saved $60,000 from their paychecks into the brokerage, the IRA and the mortgage principal. That’s growth in net worth, but it isn’t a return. The investments and properties earned the rest:
Change in net worth: $112,000
Less money put in from income: −$60,000
Gain on what they already owned: $52,000
Spread through the year, the $60,000 was in the accounts for about half of it on average. On the money at work, $1,380,000 plus half of $60,000, the gain is about 3.7%, less than half the 8.1% the summary tab suggests. (This is the Modified Dietz method; essay seven, What did your money actually return?, works through it.)
A spreadsheet can do this, but only if every deposit is recorded with its date, every month, for every account. That’s the column most sheets never get.
What changes when the balance sheet syncs?
The structure stays the same: owners, debts on the right row, shares on equity, dated history. What changes is who types the numbers.
Linked accounts update themselves. Banks, brokerages, cards and loans connect read-only and refresh on a schedule, each balance with its own date.
Some things stay manual, and should. A home can carry an automated estimate from its address where one is available, which is a statistical estimate from comparable sales, not an appraisal. A share of a private company, a note, art or a collectible is entered by hand, at a value you choose and date.
Deposits are recorded as they happen, so the return on money put in can be measured without a column of transfers typed in each month.
The spreadsheet’s three strengths, complete, honest about debt and opened every month, are the parts worth keeping. The rest is bookkeeping a computer can do.
Nothing here is advice: it’s educational only, not investment, tax or legal advice. It’s the arithmetic, explained plainly.
If you want the instrument behind the writing: Eudos is the wealth intelligence platform for wealth builders. It keeps every account, property, company and trust on one balance sheet, at the household’s share, with the history kept. It’s in private beta; the waitlist is at eudos.com.
To see a balance sheet kept this way, open the demo, a fictional family’s wealth with no sign-up. The Thompsons’ LLC and trust each keep their own books and roll into one family total.
Prefer to start in a spreadsheet? The free balance sheet template (Excel, no email) has the owner, debt, share and as-of columns built in.

