I built that incrementally over 10+ years out of necessity. No other tool I ever tried (Mint, Personal Capital, ...) has been as reliable, flexible, transparent and thorough.
I currently keep it manually updated once every month or two (and clearly use formulas such as GOOGLEFINANCE() as much as possible), it takes about 10mins to iterate over all the sheets and align them with the transactions of my various bank/brokerage accounts, so I can get the latest snapshot of my finances, and once a year I do a more thorough check to make sure nothing is missed and all numbers match to the penny. I find that time investment extremely well worth it. In a weird way, knowing that I'll have to eventually manually report any transaction on my sheet serves as a deterrent to not generate too much activity on my brokerage accounts, which is almost always better than the alternatives :-)
One day I might decide to convert it to a little SaaS and see if anyone would pay money for it. Probably not but it would be a fun exercise so I could add automatic scraping of bank/financial accounts.
- 1 sheet per year.
- 1 column per month.
- 1 row for each asset & liability (bank account, credit card etc)
- Summed up to total assets
- Update this once a month by manually logging into accounts.
- Summed value for each month is referenced in another sheet called 'Net worth over time' which also has a few graph etc in it.
- I have a few other ad hoc sheets for yearly budgets, stock vesting dates etc etc.