The way I create my personal balance sheet is similar to the process I just described for my income and expense report. I export a net worth report from Quicken, customized to include all my accounts through the end of the reporting month, and import the data into Excel. My personal template is linked directly to this export file, but I’ve included a blank template here for anyone’s use.
The first column of data in the attached file is for the beginning of year (2004) balances. The columns continue monthly through the end of 2006. The last few columns create percentages to notate the growth from the prior month and prior year, but the cell references must be updated manually.
When I post my reports, I hide all unnecessary columns so the most important data fit easily within the blog, copy the cell range, paste into PhotoShop, and save the file as a graphic.
Here is the Excel template: Net Worth Template.xls.
Note: These reports are designed, like business financial reports, to reflect the ending balance of the period that is in the particular column’s heading. That means your “Jan 2006” account balances should reflect what you have at the end of the final day of the month of January 2006.
Subscribe
I can not retrieve this one. I get the following “Error 404 – Not Found”.
Thanks for pointing that out, Harold. I fixed the link above and you should be able to download the file now.
Do you have an updated net worth report for excel?
Flexo, just wanted to say thanks for sharing this. I’ve started using it to track my own networth and it really makes it easy to see the difference a small change can make and how to better plan your financial future.
I graduated college recently and have a negative net worth that is getting less negative now that I have a job. In your sheet, my net worth change is incorrectly reported as negative. To fix this, I changed the formula from =(AH41-AG41)/AG4 to: =(AH41-AG41)/AG41*SIGN. This will work even when going from a negative net worth to positive, which will hopefully be soon.
Doh, some kind of forum wizzardry screwed up my post. The thing to add to the end of the formula is: “SIGN ( AH41 )” it should be the sign of the first number you are subtracting from, NOT the number you are dividing by.
Hopefully that displays correctly this time.