My Net Worth Tracking Template
You may be curious as to how I keep track of my net worth updates. It’s actually highly manual and nothing fancy. I simply log into Yodlee account aggregation via Bank of America’s MyPortfolio and copy-n-paste the appropriate balances into this simple Excel spreadsheet file. Then I make a screenshot and post it online. This way, it only takes a few minutes - I don’t have to log into 12 different websites, I have a permanent copy for my own records, and I don’t have to write any HTML.
The net worth progress bar on the top right of this page is also made manually with a graphics program (I’ve migrated from Microsoft Paint to Macromedia Fireworks). If you are looking for something automatic for your own site, try this progress bar image maker or run a search for “percentage bar javascript”. Hope that helps!
March 28th, 2007 at 5:05 am
Thanks for the tip about BoA’s MyPortfolio option. I set mine up last night and now it’s one-stop shopping (actually looking at my overall net worth, it’s a good reason to cut down on shopping!!!).
March 28th, 2007 at 6:37 am
I signed up for an account aggregation service last week. But I didn’t add any accounts at the time. I added my primary checking account and credit card yesterday (2 different banks) after reading your post. I may add other accounts over time.
For now, it’s great to see both account in one site. The bank that houses my primary checking account has a very weak online banking interface. So I particularly like being able to access that information in a better looking environment.
March 28th, 2007 at 7:04 am
Hey,
thanks for sharing the excel template.
On the same note, do you use any excel templates for your monthly transactions like expenses for various stuff like groceries, utility bills ……
Thanks.
March 28th, 2007 at 12:03 pm
Should Net Worth include your mortgage (if you have one)? In that case, you will always end up having negative net worth unless you include market value of house in Assets (hopefully, mkt value is more than loan amount).
Or, do you suggest not considering mortgage/house as a part of net worth!
March 28th, 2007 at 12:10 pm
I say do whatever you like.
Many people put the value of their house under Assets and then the mortgage balance under Liabilities. Then the question is where you get the value of your house - online website? tax assessment? your purchase price?
Another way might be simply to put the principal paid off under the Assets column.
I plan on putting a very conservative estimate for my house value under Assets, and then the mortgage balance under Liabilities, and only change the value of my house once or twice a year.
March 28th, 2007 at 2:30 pm
i’ve actually been very good at updating my nw at networthiq.com
it graphs it, etc. i’m sure you know about it, but thought i’d throw it out there. like you i just use yodlee and input the numbers on the 5th or so of the month (after rent and everything is taken out.)
May 25th, 2007 at 9:35 pm
Love your site, great information. I was using MS Money for a while now and I though I would share it with you. Does a pretty good job of tracking Net worth among others.
May 30th, 2007 at 10:05 am
Thank for writing this. I learn so much from your blog. I will start to keep track of my net worth. Keep up the great work.
February 21st, 2008 at 8:09 am
Most bank’s aggregate account services are serviced by http://www.Yodlee.com - which has it’s own plain service available on their website. I’ve used it since 2001, and I love it. It was just in Money Magazine last month as a great way to keep all your account information together.
March 3rd, 2008 at 4:21 pm
I’ve set up “Full View” via my Fidelity Account; uses Yodlee. Although I just discovered mint (http://www.mint.com/index.html). This is free and tracks all accounts similar to Yodlee plus formats the data nicely using graphs. Has anyone tried Mint?
April 6th, 2008 at 1:51 pm
I signed up with Mint, but only put in a handful of accounts, to check it out. They still have lots of problems with transaction names - I almost had a heart attack when I got an e-mail alert from them, telling me I was charged a $1200.00 transaction fee (which was actually a transfer from one account to another one). But when one of my inactive AmX accounts was charged $90.00 it was great to find out about it on Mint - I might never have noticed it otherwise (until it was too late, maybe). So, for the time being, I will list all my inactive accounts with them, then I will be able to keep an eye on them on the weekly Mint report without having to check each one seperately.