Net Worth Spreadsheet for Excel and Google Sheets: Track Assets, Debts and What Actually Moved the Number
Build a net worth spreadsheet in Excel or Google Sheets: a balance log for assets and debts, monthly snapshots with SUMIFS, liquid net worth, debt-to-asset ratio, a trend chart and a worked example that breaks a six-month change into savings, investments, depreciation and debt payoff.
A net worth spreadsheet adds up everything you own — cash, investments, retirement accounts, home and car — and subtracts everything you owe — mortgage, auto loan, student loans, credit cards. Logged as a snapshot on the same day every month or quarter, it shows whether your finances are actually moving forward, even when each paycheck and each bill looks the same. The budget tells you where money goes this month; net worth tells you where all those months are taking you.
This guide sits in Personal Finance & Budgeting. The monthly budget template manages the flow; this sheet measures the result.
Sheet 1: Balance log
| Column | Content |
|---|---|
| A – Date | Snapshot date (for example, the last day of the month) |
| B – Account | Checking, 401(k), mortgage… |
| C – Type | Asset or Liability |
| D – Category | Cash, Investments, Retirement, Real estate, Vehicle, Debt |
| E – Liquid? | Yes / No (could you use it within days without penalties?) |
| F – Balance | Always entered as a positive number |
Entering debts as positive numbers and separating them by Type keeps every formula free of sign mistakes.
Sheet 2: Summary by date
| Metric | Formula (snapshot date in A2) |
|---|---|
| Total assets | =SUMIFS(Log!F:F,Log!A:A,A2,Log!C:C,"Asset") |
| Total liabilities | =SUMIFS(Log!F:F,Log!A:A,A2,Log!C:C,"Liability") |
| Net worth | =B2-C2 |
| Liquid assets | =SUMIFS(Log!F:F,Log!A:A,A2,Log!C:C,"Asset",Log!E:E,"Yes") |
| Debt-to-asset ratio | =C2/B2 |
| Change since last snapshot | =D3-D2 |
Worked example: a couple’s snapshot on October 31, 2026
| Asset | Balance | Liquid |
|---|---|---|
| Checking | $4,500 | Yes |
| High-yield savings | $18,000 | Yes |
| Brokerage account | $9,500 | Yes |
| 401(k) | $62,000 | No |
| Roth IRA | $21,000 | No |
| Home (conservative estimate) | $380,000 | No |
| Car (approximate resale value) | $16,000 | No |
| Total assets | $511,000 |
| Liability | Balance owed |
|---|---|
| Mortgage | $286,000 |
| Student loans | $24,800 |
| Auto loan | $11,200 |
| Credit card | $1,300 |
| Total liabilities | $323,300 |
- Net worth: $511,000 − $323,300 = $187,700.
- Liquid net worth (liquid assets minus non-mortgage debt): $32,000 − $37,300 = −$5,300. Most of the wealth is in the house and retirement accounts; student and auto loans still outweigh the cash cushion.
- Debt-to-asset ratio: $323,300 ÷ $511,000 = 63.3%. Typical with a newer mortgage; what matters is that it trends down.
What moved the number? Comparing two snapshots
Six months earlier, on April 30, 2026, the same household had $501,400 in assets and $332,500 in liabilities: a net worth of $168,900. The increase of $18,800 breaks down like this:
| Source | Change |
|---|---|
| More cash in checking and savings | +$4,100 |
| 401(k) and Roth IRA (contributions plus market movement) | +$5,700 |
| Brokerage account | +$1,300 |
| Car depreciation | −$1,500 |
| Debt paid down (mortgage, auto, student loans, card) | +$9,200 |
| Total | +$18,800 |
About half the gain comes from paying down debt and a fifth from saving cash — progress the household controls directly. Investment gains are real too, but they can reverse; that is why it helps to keep contributions and market changes in separate columns if you want a precise picture.
Charting the trend
With one summary row per snapshot, insert a line chart of assets, liabilities and net worth. A stacked column chart by category shows how the mix changes: over the years, you generally want the liquid and invested share to grow and the debt bars to shrink.
Rules for an honest number
- Value your home conservatively and update it rarely. An optimistic online estimate inflates net worth without changing your life.
- Vehicles lose value: use a realistic resale figure, and skip small personal belongings entirely.
- Use the same snapshot day every time so payments and paychecks don’t distort comparisons.
- Include every debt, including buy-now-pay-later balances and money owed to family.
- Retirement accounts are not cash: early withdrawals can carry taxes and penalties, which is why they are marked non-liquid here.
If the liquid number is negative, the next moves usually come from the debt snowball spreadsheet and the emergency-fund line in the savings goal tracker.
Related guide: Travel Budget Template for Excel and Google Sheets.
FAQ
How often should I update it?
Monthly works for most people; quarterly is fine if balances move slowly. Consistency matters more than frequency.
Is a negative net worth a bad sign?
It is common early in a career, with student loans, or right after buying a home with a small down payment. The trend is what counts.
Should I include my car?
Yes, at a realistic resale value, especially if there is a loan on it — otherwise you count the debt but not the asset.
Does it work in Google Sheets?
Yes. SUMIFS and charts work the same way.
Next step: log today’s balance for every account and debt with this month’s end date. Your second snapshot, a month from now, is when the sheet starts telling you something.
