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.
Updated February 6, 2012 and originally published July 10, 2006. If you enjoyed this article, subscribe to the RSS feed or receive daily emails. Follow @ConsumerismComm on Twitter and visit our Facebook page for more updates.