Personal template
Net Worth Tracker
Assets minus liabilities, with each line shown as a share of the total.
- Live formulas
- 14
- Columns
- 5
- File
- 8 KB
$5
Checkout opening soonOr get it with all 66 paid templates in the complete pack — $45.
Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide.
About this Net Worth Tracker template
Net worth is the simplest single measure of your financial position: everything you own minus everything you owe. This Excel net worth tracker lists each asset and liability with a category and value, and shows each line as a share of the total.
The position summary shows total assets, total liabilities, net worth, your debt-to-asset ratio and how much you hold in cash.
Good for
- →Taking stock of your finances once a quarter or year
- →Tracking progress as you pay off debt
- →Seeing how much of your wealth is tied up in property
What it works out for you
Position
- →Total assets
- →Total liabilities
- →Net worth
- →Debt-to-asset ratio
- →Liquid assets (cash)
What you fill in
The table has 5 columns. Calculated columns fill themselves in; the rest are yours to type over.
- →Item
- →Type
- →Category
- →Value
- →% of total
How to use it
Tag every line Asset or Liability. Net worth, the split and each line's share all calculate.
The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.
Functions it uses
Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.
IFIFERRORSUMIFSUMIFSQuestions about the Net Worth Tracker
What should I count as assets?
Cash, savings, investments, pensions and property at their current value. Include cars and valuables if you want them counted.
What is the debt-to-asset ratio?
Total liabilities divided by total assets. The lower it is, the more of what you own is truly yours.
How often should I update it?
Every few months is enough for most people. Save a copy each time to see how your net worth changes.
