As featured in The Wall Street Journal, Money Magazine, and more!
     

Excel Template for Net Worth Report (Balance Sheet)

This article was written by in Software. 12 comments.


template2.jpgThe 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.

Email Email Print Print
avatar
Points: ♦127,505
Rank: Platinum
About the author

Luke Landes is the founder of Consumerism Commentary. He has been blogging and writing for the internet since 1995 and has been building online communities since 1991. Find out more about Luke Landes and follow him on Twitter. View all articles by .

{ 12 comments… read them below or add one }

avatar harold

I can not retrieve this one. I get the following “Error 404 – Not Found”.

Reply to this comment

avatar Luke Landes ♦127,505 (Platinum)

Thanks for pointing that out, Harold. I fixed the link above and you should be able to download the file now.

Reply to this comment

avatar Ray

Do you have an updated net worth report for excel?

Reply to this comment

avatar Swot

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.

Reply to this comment

avatar Ian

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(AH41). This will work even when going from a negative net worth to positive, which will hopefully be soon.

Reply to this comment

avatar Ian

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.

Reply to this comment

avatar Claire

This is fantastic – I’m always looking for the best excels out there for budgeting and net worth calculations.THX

Reply to this comment

avatar Just another guy...

you make this extremely dificult

I am not looking for a visual I need a quick Excel download

Reply to this comment

avatar Ed

I like the report. Can you use the info to create a graph over time similar to the graph in Quicken?

Reply to this comment

avatar Imad Issa

Hi,

I am looking for a complete set of Financial Management reports, can you help please

Reply to this comment

avatar Debra

I am having trouble downloading the Net Worth template.. does it still exist?

Reply to this comment

avatar Debra

Can you share how you”link” the personal net worth template to the exported quicken file.

Reply to this comment

Leave a Comment

Connect with Facebook

Note: Use your name or a unique handle, not the name of a website or business. No deep links or business URLs are allowed. Spam, including promotional linking to a company website, will be deleted. By submitting your comment you are agreeing to these terms and conditions.

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Previous post:

Next post: