Net Worth Tracker Template: See All Your Accounts in One View
You have a checking account, a savings account you forget about, a 401(k) from this job and one from the last, maybe an HSA, a credit card, a car loan, a mortgage. Each one has its own login and shows you its own number. Nothing shows you the total. A net worth tracker is the one view that does — and the version people still have open a year later is the one they type into themselves, once a month, with no bank connection involved.
What a net worth tracker is actually for
Net worth is one subtraction: what you own minus what you owe, on a given date. That's it.
It is not a budget. A budget answers "where did my money go last month." A net worth tracker answers a slower question: "am I further ahead than I was in January?" Different question, different cadence, different table. Trying to make one tool do both is why most money setups collapse — the budgeting half needs daily attention and the net worth half needs twelve minutes a year of real thought.
So the tracker has exactly three jobs:
- Hold a list of every account and debt, in one place
- Store a balance for each one, dated, every month
- Show the total over time as a line, not a single number
The third one is the part people skip, and it's the only part that changes behavior.
Why typing the balances beats linking your accounts
Automatic aggregation sounds obviously better. For this specific job it usually isn't.
- Connections break. Institutions change their login flow, re-auth prompts expire, and a feed that silently stops updating is worse than no feed, because the chart keeps drawing a flat line that looks like data.
- Typing is a review. When you copy a balance by hand you actually see it. Five of your accounts become five seconds of attention each. That is the entire value of the exercise, and automation deletes it.
- Nothing to revoke. No third party is holding read access to your bank. If you stop using the tracker, there's nothing to unwind.
- Monthly is the right resolution. Daily net worth is noise — a paycheck lands, a card autopays, the market moves. Twelve dots a year show the trend cleanly.
- It covers things no feed reaches. A paid-off car, a private business stake, savings bonds, crypto in cold storage, a 529 held at a state plan, a loan a relative is repaying you. Manual entry doesn't care what the asset is.
The honest cost: you have to actually do it. Ten minutes, once a month. That's the trade.
Build the account list once
This is the setup step, and you only do it properly one time. One row per account.
Assets
- Checking and savings (each separately)
- Cash you'd actually count
- Taxable brokerage
- Each retirement account as its own row — current 401(k)/403(b), old 401(k)s you never rolled over, traditional IRA, Roth IRA
- HSA, 529s
- Home or other property
- Vehicles worth listing
- Other: business equity, savings bonds, crypto, cash value in a permanent life policy
Liabilities
- Credit cards (use the current balance, not the minimum)
- Auto loans
- Student loans
- Mortgage or HELOC — the remaining principal, not a payoff quote
- Personal loans, 401(k) loans, anything on a payment plan
- Tax you know you owe but haven't paid
Three naming rules that save you pain later: name each account the way its own login names it, so you never wonder which one you're looking at; mark joint accounts and decide once whether you track the full balance or your half; keep an "active" checkbox instead of deleting closed accounts, so your history stays intact.
The two-table structure that makes the chart work
The single most common mistake is one table with a "current balance" column you overwrite each month. You get a tidy view and zero history — next February you can see where you are but not whether you're climbing.
Use two tables instead:
- Accounts — name, type, asset or liability, institution, owner, active. Roughly 10 to 30 rows for most people, and you edit it twice a year.
- Snapshots — date, a link to the account, the balance, and a one-line note. One row per account per month.
Net worth for a month is then: sum the asset snapshots for that date, sum the liability snapshots, subtract. Whether you're doing this in Notion with a rollup or in a spreadsheet with SUMIF, the shape is the same. Chart the monthly totals by snapshot date and you have the line.
Storing liabilities as positive numbers with a type flag is cleaner than storing them as negatives — negatives invite sign errors the moment you add a formula.
The ten-minute monthly update
Pick a fixed day and keep it. The first Saturday, or the day after your main paycheck lands. Which day matters far less than it being the same day, which is why it works best attached to something already in your routine rather than floating.
The routine:
- Duplicate last month's snapshot rows and change the date — you're editing numbers, not creating rows from scratch.
- Open each login in order and overwrite the balance. Round to whole dollars.
- Set closed accounts to zero and uncheck active, rather than deleting them.
- Note anything unusual in one short line: "bonus," "tuition paid," "new card."
- Look at the chart for ten seconds. Don't analyze. Just look.
Do not reconcile to the penny, and do not chase a balance that moved because a payment is in flight. A number that is close and entered is infinitely more useful than a perfect number you gave up collecting.
What three months of data tells you
One snapshot is trivia. Three is a direction. Twelve is a slope you can plan against.
The upgrade worth adding once the habit holds: a contributions column — what you deliberately put in that month. Then growth is roughly the change in total minus contributions. It's crude, it ignores timing within the month, but it separates "I saved" from "the market moved," and those two feel identical in your head while being completely different facts.
What the tracker will not tell you: whether you can afford something this week, where your spending leaks, or anything about your tax position. And if you're using it to decide how much to put into a retirement or HSA account, the annual contribution limits change year to year — look them up in the current IRS publication for that account type, and check your own plan rules with the provider, rather than trusting a number you read in a blog post.
Where people quit, and the fix
- Too many rows. Twelve accounts is a review; forty is a chore. Group the small ones into a single "other cash" row.
- Hunting for logins. Add an institution field and a note on which email the account uses. Never store the password there.
- A missed month. Leave the gap. Don't backfill guesses — invented data poisons the trend. The chart survives a hole far better than it survives fiction, and picking a habit back up after a gap is easier when the gap is visible and honest.
- Agonizing over the home value. Pick one public estimate source, use the same one every month, label the row an estimate. Consistency beats accuracy here, because you're measuring change, not settling a sale price.
Put it where you already look
A tracker in its own file is a tracker you'll forget. The monthly number belongs on the same page you already open — the one holding your tasks, notes and goals, so a single net worth block is visible without a second login.
The monthly update is also a natural extra step inside an existing weekly review routine — not every week, just the one review a month where it comes due. And if you're weighing whether to assemble all of this yourself or start from something finished, the cost comparison between building and buying a setup applies here exactly as it does to the rest of a Life OS: the build is an evening, the maintenance is the real bill.
What you're left with after three or four months is a single line on a page you already open, built from numbers you typed yourself, that answers the only money question that compounds: is this going up.
Life OS and Biohacking 101, €19 once.
2 Lovable templates in one payment: remix each into your own Lovable workspace and make it yours. Nothing renews.
See the starter pack