I believe that one of the most important things that you can do in personal finance is to track your net worth.
Now, more than ever, there are so many easy ways to automatically track your assets and your liabilities.
I personally use Personal Capital to seamlessly track my net worth, asset allocations, and eyeball my budget.
But to me, the most important part of tracking your net worth, is the act of typing up the amounts yourself. And to do this you will need a spreadsheet.
My spreadsheet works with both Google Sheets and Microsoft Excel. It is a simple and easy to use template.
How to use the Net Worth Tracker Spreadsheet to Track Your Net Worth
- For both Google Sheets and Microsoft Excel users, click here to “make a copy” of the Net Worth Tracker Spreadsheet
- For Excel users only, you will then want to click “File” then –> “Download” –> “Microsoft Excel (.xlsx)”
- That’s it then you are off and running!
Even if you don’t use Personal Capital or a similar tool, you can simply log into each of your accounts directly on the 1st of the month (or close to it) and pull your numbers for all of your various accounts.
In my case, I have Taxable Brokerage accounts, plus Non-Taxable accounts like my IRA, 401(k), HSA and 529s:
After punching in my assets, I then go in and track any of my liabilities:
Finally, once you’ve entered all of your information, then the spreadsheet will automatically calculate out your Total Net Worth, and overtime year-over-year increases/decreases:
You can easy add/remove accounts as it suits your needs.
I’ve pre-filled the spreadsheet with example information to make it easy to see how it all comes together.
Why you should track your net worth
I know a lot of folks end up creating fancy net worth trackers, but IMO, this is all you need!
Keep it simple. The best thing you can do is create the habit and go from there!
I like to track monthly and then once some time has passed each year, I go and hide January through November and leave only December visible.
If you have any questions or run into any issues, please contact me, and I’ll get it fixed.