Free Budget Worksheets: Household Net Worth Spreadsheet (2024)

The free Household Net Worth Spreadsheet is part of a financial planning series called How to Make a Budget – Easy Steps for Beginners.

I’ve put together a bunch of free budget worksheets for this series, starting with the household net worth spreadsheet. Periodically calculating your net worth — the value of your assets minus your liabilities — is one of the best ways to track your financial well-being (I think). Knowing your individual or household net worth can also help you to reach your financial goals sooner.

If you want all the juicy net worth calculation details on what to include, then check out Financial Planning: How to Find Your Net Worth.

Anybudgetingbusiness, let’s get to the budgeting tools. After asking the friendly folks on the Squawkfox Facebook Page about their successful budgeting secrets, I decided to create two excel spreadsheets — an American version and a Canadian version. Since Americans don’t care so much about RRSPs and Canucks don’t have Roth IRAs, it just makes sense to have specific net worth spreadsheets for everyone.

So go grab a binder, make a workbook, and print out the worksheet that works for your country. Keeping a record and tracking your budget in a three ring binder keeps your paperwork in one place.

Household Net Worth Spreadsheet (American)

Americans can use this net worth excel spreadsheet for either individual or household use.

Here are a few different ways to use this simple excel spreadsheet:

• Add up your 401k, Roth IRAs, Traditional IRAs, CDs, and US pension plans
• Use as a net worth calculator
• Print it out to use as a worksheet
• Tally your household net worth OR find your individual net worth
• Track your liabilities
• Find your assets
• Establish a baseline for reaching your goals.

Household Net Worth Spreadsheet (Canadian)

Canadians can use this net worth spreadsheet for either individual or household use.

Here are a few different ways to use this simple excel spreadsheet:

• Add up your RRSPs, TFSAs, GICs, and RESPs.
• Use as a net worth calculator
• Print it out to use as a worksheet
• Tally your household net worth OR find your individual net worth
• Track your liabilities
• Find your assets
• Establish a baseline for reaching your goals.

Get the series, How to Make a Budget – Easy Steps for Beginners, for more free tools, tips, and downloads.

Love love love,
Kerry

16 Comments

1. 

   hibbyMarch 10, 2010 at 10:35 am

   These are great; thanks!
   It seems on both the canadian and american spreadsheets, it said “applicances” in the last portion. Is that something that I’ve never hear of (possible, in this whole new and strange world of finance) or is it supposed to read “appliances”?

   Thank you again for all the work you put into this!

2. 

   KerryMarch 10, 2010 at 10:52 am

   Hibby: Thanks for finding this error! I’ve fixed both downloads to read “Appliances”. No fear, no new financial terms to learn here. 🙂

3. 

   EvanMarch 13, 2010 at 5:04 pm

   I try to calculate my net worth quarterly, these spreadsheet will help me a lot when I crunch the numbers again at the end of March, Thanks!

4. Carnival of Personal Finance – Blogthority.com Relaunch Edition! Make More Money BloggingApril 2, 2010 at 6:56 pm

   See Also

   SAP Mobile Fixed Asset Tracking Solution | Fixed Asset Management Software

   […] Squawkfox shows how to get your budget balanced with these Free Budget Worksheets and Household Net Worth Spreadsheet. […]

5. 

   ValApril 16, 2010 at 10:27 am

   Ack!!! I just calculated that my net worth is NEGATIVE $141,000!! *sigh* That’s what I get for dating a divorced guy with financial baggage 😛
   We’re working on it, though!

6. 

   KerryJune 28, 2010 at 8:18 am

   Hi Lynn,

   I just tested all the links for the Canadian spreadsheet and everything works. I think your browser doesn’t know what to do with an .xls file. So here’s the fix:

   Right click the link Household Net Worth Spreadsheet (Canadian), and select Save As to save the file to your computer. Then open it directly from your hard drive using Excel.

7. 

   lynnJune 28, 2010 at 8:04 am

   Why is the link for downloading a copy of the Canadian Net Worth Spreadsheet not working? I’ve tried it a few times now, but the message i’m getting is “not a supported file type or file has been damaged”.
   I would like a copy of this spreadsheet, however.
   Can someone help?

8. 

   DavidJuly 7, 2010 at 3:17 pm

   Thanks for the spreadsheet. Calculating my (negative) net worth was comforting.

   Based on the previous post, “Your Net Worth”, the entire “Personal Property” section of the spreadsheet might give people the wrong idea: namely the people that didn’t read the “Your Net Worth” post, but still, maybe better to do away with the section altogether.

   “But darling, this new speedboat is an _asset_ according to Kerry!”

   I suppose some people make real money wheeling and dealing (my father-in-law), but I’d be surprised to learn that’s true of many.

9. 

   LisaJuly 30, 2011 at 3:37 am

   I love that you have both an american one and a canadian one! 🙂

10. 

    Steve WhiteOctober 17, 2011 at 6:51 pm

    Thanks for the freebie! Mine is showing spread over two pages however…

11. Networth: April 2012 | Preserving PenniesApril 10, 2012 at 1:08 am

    […] When I began calculating my networth, I found this great networth spreadsheet at Squawkfox and have been using it ever since! Thanks […]

12. 

    LynnSeptember 2, 2012 at 2:06 pm

    thank you for the Canadian spread sheet. I love it!.. will be basing your link around!!

13. 

    MarkSeptember 8, 2013 at 6:23 am

    Thanks for the free sheet, still useful even though I am from the UK!

14. 

    Joslyn KuningSeptember 23, 2013 at 3:22 pm

    Actually this is very helpful idea. After I integrated spreadsheets into my life my savings jumped up (literally) even. It is very important to track the flow of the money and expenditures.

15. 

    MichaelNovember 25, 2013 at 7:04 am

    Thank you for such a nice Canadian template!

16. 

    MookieJanuary 21, 2015 at 8:57 am

    Hi – do you have a version that compares year over year changes?