How to track your net worth across banks, EPFO and demat

Your net worth is simple arithmetic — everything you own, marked to today’s value, minus everything you owe. The reason almost no Indian family knows theirs isn’t the math. It’s that the numbers live in a dozen unconnected places, each with its own login, its own format, and its own idea of “current value.” Reconciling them is the whole job.

The reconciliation problem

A single household’s money is typically scattered like this:

Asset	Lives in	Current value comes from
Bank & FDs	Bank apps, passbooks	Balance + accrued interest
EPF / PPF / NPS	EPFO, PPF bank, CRA	Latest declared / statement
Mutual funds	AMC / RTA / broker	Units × today’s NAV (AMFI)
Stocks & demat	Broker, NSDL/CDSL	Qty × live market price
Gold & SGB	Locker, RBI/demat	Grams × today’s gold rate
Cash & wallets	Everywhere	What’s actually there
Loans (subtract)	Bank, NBFC	Outstanding principal

Two things make this genuinely hard. First, marking to market: a mutual fund folio’s “invested amount” is not its value — you need units times today’s NAV. A stock, gold, an SGB all move daily. Second, it goes stale instantly: the figure you compute on Sunday is wrong by Tuesday, so a one-time spreadsheet is a snapshot, not a tracker.

A method that works

Step	Do this
1	List every asset once, grouped by the categories above — don’t value them yet, just find them all.
2	Mark each to current value: FDs with accrued interest, funds at NAV, stocks and gold at market price.
3	Subtract every loan’s outstanding principal to get true net worth, not gross assets.
4	Tag each asset by owner — whose money it is — so a family picture and a per-person one both exist.
5	Refresh on a fixed cadence. Monthly is enough for most; the discipline matters more than the frequency.

Why the spreadsheet loses

A spreadsheet can hold the list, but it can’t fetch a NAV, it can’t re-price gold, and it won’t tell you the EPF interest was just credited. Every refresh is manual re-entry — which is why most family net-worth spreadsheets are abandoned within a few months of being built.

This is the exact problem Hundo was built to solve. You capture each account and document once; it then marks mutual funds and stocks to market using keyless AMFI and Yahoo/NSE feeds, tracks EPF/PPF/NPS as a running passbook, values gold and SGBs, subtracts loans, and keeps a single honest net-worth figure current — with a “for whom” axis so you see each person’s share, and your data held in India behind a family lock. The arithmetic was never the problem; keeping a dozen logins reconciled and current is, and that’s the part worth automating.