Our free net worth spreadsheet can help you track your net worth and get your financial goals in order.

This post contains a free net worth tracking spreadsheet template for Microsoft Excel (.xlsx). Please enjoy it for your personal use. An explanation of net worth and why I use this spreadsheet follows the screenshot.

This free Excel 2007 net worth spreadsheet template lets you track your wealth each month.

As you may know, I’m not a big fan of budgeting…at least the old fashioned way of manually writing down every penny you spend and rifling through receipts every month.

But that does not mean I don’t track my money!

For one, I use one rewards credit card for 95% of my purchases (including monthly bills when possible) so at the end of the month, I have a single record of my spending all ready for me…my credit card statement. I compare this to what I want to be spending (my budget) to see if I’m over or under.

But there’s one problem:

Monthly budgets aren’t that useful.

True, we pay a majority of recurring expenses like rent, debt payments, and utility bills once a month. But for me, a good chunk of the money I spend annually goes to things that I don’t pay for ever month like:

  • Car and life insurance (2x a year)
  • Auto and home repairs (whenever)
  • Vacations (1-2x a year)
  • Holiday gifts (1x a year)

For this reason, I find that monthly doesn’t account for this stuff. Because of that, I’m way over my budget some months and under some other months.

I believe that if you’re going to ensure that you’re regularly living below your means and building wealth, you need to track your net worth.

What is net worth?

Your net worth is a measure of your finances calculated by taking the sum or your assets and subtracting your liabilities (debts). So in a very simple example, if you have $10,000 in the bank and owe $2,000 on a credit card, you have a net worth of $8,000.

Your net worth can be negative. If you only have $1,000 in the bank and a $2,000 credit card balance, you would have a net worth of -$1,000.

Obviously, you want to build a positive net worth, although if you’re starting out in life with student debts and not a lot of savings, yours will probably be negative for a while. That’s OK. (Mine was until I was about 26).

Your net worth is less important than your net worth trend. It’s important to ask: Is my net worth going up or down this month? What about this year?

Obviously, you always want it to go up.

Tracking your net worth

Calculating your net worth is easy. You simply add up all of assets and all of your debts and subtract your debts from your assets. It’s important to remember, however, that your net worth changes all the time. Your net worth is like a snapshot of your finances at a given point in time. 

To track your net worth, you compare a recent snapshot to an older one and see what’s changed.

For example, when you compare this month’s net worth to last month’s, these are some things that may be different:

  • You’ve spent some money in your checking account.
  • You’ve deposited $500 to savings.
  • You’ve paid $200 in principal towards a credit card balance.
  • Your 401(k) gained 2%.

All of the changes add up to either raise or lower your net worth. As you track it, you want to see that it’s going up almost every month. If your net worth slips for a month or two because of a big purchase that’s OK as long as it’s still going up over a longer period of time. What you don’t want is a net worth that doesn’t change or slowly goes down. That means you’re living above your means and headed for financial trouble.

What’s included in Net Worth?

Everybody has a different opinion of what assets to include when you calculate net worth. You’ll always include cash, bank accounts, and investments, and usually any real estate. Sometimes people will include cars and other big ticket belongings…personally I don’t because although you can sell your car for cash, making it an asset, cars depreciate over time and shouldn’t be considered part of your wealth.

As for debts, the rule I use is if you owe it, include it. This includes credit card balances even if you pay them in full every month, and it might include taxes you’ll owe at the end of the quarter or on April 15th.

Using the spreadsheet

It’s my hope that this spreadsheet is easy and self-explanatory. You can edit the row labels to match your accounts and add rows as needed. The formula cells are locked so you don’t accidentally break them. If you have comments or suggestions, please leave a comment!

Download Now: Free Net Worth Spreadsheet Template

Related Tools

About the author

David Weliver
Total Articles: 353
David Weliver is the founder of Money Under 30. He's a cited authority on personal finance and the unique money issues he faced during his first two decades as an adult. He lives in Maine with his wife and two children.

Article comments

We invite readers to respond with questions or comments. Comments may be held for moderation and will be published according to our comment policy. Comments are the opinions of their authors; they do not represent the views or opinions of Money Under 30. Comments have not been reviewed or approved by any advertiser, nor are they reviewed, approved, or endorsed by our partners. It is not our partner’s responsibility to ensure all posts or questions are answered.
Jill says:

Actually….part 2 of my question/comment – I suppose since salary is not included in this chart, maybe general monthly expenses aren’t included either. That would be more along the line of a budget, perhaps.

Jill says:

Great information. One question – where do you account for regular monthly expenses (i.e., Real Estate Taxes, Commuting, Groceries, Utilities, etc.) or don’t they count in this chart?

Anthony says:

Very useful tips for financial planning. Thank you for always bringing these articles.

Charles Kendig says:

Hello–I have 25 assets that I want to list separately but the spreadsheet won’t allow me to expand the cells so I can use a formula that allows me flexibility to add more if I want to. Could you tell me how to do that?

Mike says:

I was reading your article titled “Free Net Worth Spreadsheet”. You made a comment “True, we pay a majority of recurring expenses like rent, debt payments, and utility bills once a month. But for me, a good chunk of the money I spend annually goes to things that I don’t pay for every month like…” I agree with that and here is how we compensate for those items in our budget (per payday period). I took the total (from the previous time I paid it) and divided by how many paydays I have until the next time it is due. for example trash is $45/qrtr. I have 3 paydays a month x 3 months = 9: $45 / 9 = $5 a payday. We set up a savings account at a local Credit Union (minimum balance is $5 and no monthly fees to eat away what is in there) just for these other than monthly bills. By adding up all the answers after the math I know how much is needed each payday to deposit in that account and then we pay each bill whenever it comes due, without a crunch in a particular month budget. I call the account my “Escrow” account – it started by removing my property taxes from my house payment and we set the amount aside each month for the property taxes. Normally I take last years tax amount and add 10% to ensure I allow for most of the tax levy’s that might get added in May or November. Our list includes vehicle registrations that take place in July and Dec (4 total), property taxes that are due the 1st of Feb (this method usually allows us to pay it in full at one time), insurances, Drivers License renewal fees, trash removal, any newspapers or magazines, and any other bills we have that occur less often than once a month.. When we paid off a car we also took the principal amount we were paying and set that aside for automobile maint (another CU savings account) and or replacement of the vehicle down the road. Doing the same with the principal when the house gets paid off then allows cash for home maintenance. I may only collect 1/12 of 1% interest on my account at the credit union but at least it is better than paying interest on a new appliance or a new roof. I hope this thought pattern helps someone else, it has helped us.

francois says:

Just want to thank you for that spreadsheet! Works well!


Thanks so much for posting this great article about net worth including the downloadable spreadsheet. I linked to your article on my site today:


Here’s to your continued success in the new year, and thanks again.

Aaron says:

“Car and life insurance (2x a year)
Auto and home repairs (whenever)
Vacations (1-2x a year)
Holiday gifts (1x a year)”

You know how much you’re going to pay in insurance every 6 months, and looking at average past annual expenditures, you know about how much you’ll spend on the other areas. Divide those amounts by 12 and sock it into a high-yield savings account every month. Boom, your semi-regular expenses are now part of the monthly budget.

I do the same as Stephanie — I set aside 1/12th of an annual expense each month. That way its still part of my “monthly” budget.

Stephanie says:

I hear you on monthly budgets needing to factor in occasional but important spending, such as vacations, insurance, etc. That’s why for the last three years or so I’ve been using Mint.com to track everything we spend (we, like you, put almost everything on a credit card we pay off monthly). Mint is great because it allows you to plan for those occasional purchases, such as our once-a-year personal property tax I just paid. Each month it sets aside 1/12 of whatever that yearly expense will be and factors it into your budget. I also like to have rolling budgets for things like clothes. For four months I may not buy any clothes, and then one month I might spend $500 on clothes because I haven’t drawn from my clothing budget in quite some time.

Kevin says:

Thanks for this. It’s a good starting point so I don’t have to make mine from scratch. The formatting is pretty!

One gripe, though:

The way you calculated percentage change is very odd. Your formula is 100%-(old value/new value), which gives the percentage change relative to the new value instead of relative to the the old value. A more natural formula would be (new value/old value) – 100%.

Your formula calls a change from $100 to $200 a “50% change”, while most people understand it to be a 100% increase.

Flexo says:

You can hide the Division by Zero errors with a basic conditional formula, which would improve the initial look of the sheet.