How I Track Our Family Net Worth in a Spreadsheet – And Why My Toddler Has His Own Row
A family net worth tracker is one of the most useful things I have built for our finances. I built a spreadsheet in December 2025 and called it the Family Wealth Tracker. It has five tabs, a dashboard, a net worth chart, and a per-person breakdown of assets, liabilities and investments. One of those people is my three year old son. His current net worth is £0.
I am aware of how this looks.
But this spreadsheet is one of the most useful things I have built for our family finances, and I started it before we felt anywhere near wealthy enough to justify the name. Here is why, and here is the free template so you can do the same.
Why I actually built it
The honest answer is not purely financial. I built it because my husband and I have quite different relationships with money, and I wanted us to be looking at the same picture.
I think about our finances constantly – the properties, the limited company, the mortgages, the long-term trajectory. My husband is exceptional at saving, genuinely one of the best I have ever seen at it, but less drawn to the strategising and growth-planning side. He is money-savvy, just not obsessive about it in the way I am. Neither approach is wrong, but when you are trying to build something together, operating from different levels of visibility creates friction. One person is carrying the mental load of the whole financial picture. The other is contributing enormously but not necessarily seeing the same horizon.
The tracker was my way of creating a shared document. Not a budget, not a to-do list, but a single place where everything we own, everything we owe, and everything we are building toward exists in one view. The goal was for us both to be looking at the same picture and having the same conversation from it.
What the Family Net Worth Tracker covers
Five tabs, each doing a specific job.
Assets lists everything the family owns with a current value: property, pensions, cash, investments, anything held through a company. Each asset has an owner – me, my husband, our son, or a company entity – because in a family with multiple properties, a limited company, and financial lives that overlap in complicated ways, “ours” is not a precise enough category. You need to know what sits where and under whose name. If you hold property through a limited company, for example, those assets belong to the company, not to you personally, and that distinction matters for an accurate net worth picture.
Liabilities does the same for debt: mortgages, balances, interest rates. Seeing liabilities listed plainly next to assets is the part most people avoid. It is also the most clarifying part of the whole exercise.
Investments is a separate tab because investments behave differently to assets. Values fluctuate, some are illiquid, some are speculative. Keeping them separate stops the overall picture from looking either better or worse than it is depending on what markets did last week.
Annual Snapshot is the tab that makes the whole thing work over time. Once a year I pull the figures and add a row: total assets, total liabilities, net worth, growth percentage. One row per year. In ten years that will be ten rows, and the direction of travel will be obvious at a glance. Right now there is one row. That is fine. Every ten-year picture starts somewhere.
Dashboard pulls everything into a summary with charts – net worth over time, asset allocation by category. Ours currently shows an asset allocation that is almost entirely property, which is useful information in itself. It tells you something about concentration risk that is easy to ignore when you are looking at individual assets one at a time.
Why the tracker is per person, not per household
Most net worth templates treat a couple as a single unit. I track individually because our financial picture is genuinely split – different assets, different liabilities, different legal structures. My husband owns a share of our home. I hold a buy-to-let in my name. We jointly own a limited company with a BTL property through it. Running that company has its own costs and its own financial logic that sits separately from our personal finances but feeds directly into the family net worth picture.
Tracking per person also means each of us can see our own position clearly, not just the household total. That matters for the shared-vision goal. It is easier to buy into a number you can see yourself in.
Why my toddler has a row
Because he is the reason any of this matters, and because the structure needs to exist before there is anything to put in it.
My dad got me into savings accounts early and was always open about money – financial visibility was normal in our house. My husband grew up in a family where money was more private, not discussed, not planned around. We are both products of those different environments, and we are now consciously building something different for our son. Not just the financial structures – the companies, the assets, the annual tracking – but the culture around money. The openness, the intention, the habit of looking at numbers rather than avoiding them.
Right now his row is empty. He will be added as a shareholder to both family companies this year, so there will be something to record when that happens. We looked at opening a Junior ISA and decided against it for now – with interest rates where they are, overpaying the mortgage makes more financial sense than locking money away in a low-return account until he is eighteen. That calculation may change, and when it does, his row is ready.
There is also something that happens psychologically when you put a child’s name in a financial document. The whole exercise stops feeling like admin and starts feeling like intention. You are not tracking wealth for the sake of it. You are tracking it because someone is depending on the direction of travel being correct.
Why you should start before you feel ready
The objection I anticipate is the same one I had: this feels like a lot of structure for not very much money yet. The spreadsheet seems to imply a level of financial sophistication that does not match the reality of the numbers.
That is exactly the wrong way to think about it. The tracker is not a reflection of where you are. It is a tool for getting somewhere else. Starting it when the numbers are modest means you have a baseline – a row for 2025 that shows exactly where things stood before the next decision, the next property, the next income stream. Without that baseline you are always starting from approximately now, with no real sense of how far you have come or how fast.
I run my money system as leanly as possible, and this fits that approach. It is one annual update, not a daily task. The rest of the year it just sits there, accurate and waiting. And if you are building a portfolio career with multiple moving parts, this is the document that tells you whether it is working – not month to month, but year to year, which is the only timeframe that matters for building actual wealth.
The other thing it does, which I did not fully anticipate when I built it, is create a shared language. My husband and I now have a document we both understand and can both update. We are looking at the same numbers, having the same conversations, building toward the same goals. That alignment did not happen automatically. The spreadsheet created the conditions for it.
How to use the template
The template below is the same structure I use. Five tabs, set up and ready. Add your own assets, your own liabilities, your own people. Include your children. Include the £0 rows. Give everything a home before it has a value.
Update it once a year. Keep every year’s data. Watch the direction.
Download the Family Wealth Tracker template
This is a personal finance organisational tool, not financial advice. The template reflects my own approach to tracking family net worth and is shared for informational purposes only.
