Net Worth Tracker for Google Sheets & Excel
Track your assets, liabilities, and overall net worth over time. See your full financial picture in one place and watch your wealth grow month by month.
Get this template on EtsyWhat's included
- Track all assets and liabilities in one place
- Monthly net worth snapshots
- Visual trend chart showing growth over time
- Categories for bank accounts, investments, property, and debt
- Automatic net worth calculation
- Works with Google Sheets and Microsoft Excel
How it works
The spreadsheet has three tabs: Dashboard, History Log, and a hidden Data tab for color settings. The Dashboard is split into two sides — assets on the left, liabilities on the right.
Setting up assets
Each row is one asset. Enter a name (e.g. Checking Account, Brokerage, Primary Home), the current value, a category (Cash & Savings, Investments, Retirement, Real Estate, Vehicles), and pick a color. The sheet auto-calculates what percentage each asset represents of your total and groups them by category.
Setting up liabilities
Same structure on the right side. Enter each liability — mortgage, car loan, student loan, credit card balance — with its current outstanding amount and category. Percentage of total and group totals calculate automatically.
Tracking over time
The History Log tab is where you record monthly snapshots. At the end of each month, log your total assets, total liabilities, and net worth. The Dashboard shows your current month-over-month change, and the History Log builds a long-term view of your trajectory.
Summary cards
At the top of the Dashboard, summary cards show total assets, total liabilities, net worth, and the change since last month — all updated automatically as you adjust values.
Available in dark and light themes
Both themes are functionally identical. Use the toggle above to switch between them.
Related articles
Frequently asked questions
What counts as an asset?
Anything you own with monetary value — checking and savings accounts, investments, retirement accounts, property, vehicles. The tracker has categories for each type.
How often should I update it?
Monthly is ideal. Update your balances at the end of each month and the tracker builds a historical view of your net worth trajectory.
Can I track joint net worth with a partner?
Yes. You can include both partners' accounts in the same tracker to see your combined financial picture.
More spreadsheets
Best SellerBudget Spreadsheet
Track your income and daily expenses with real-time progress indicators that show exactly where you stand each month. Works with Google Sheets and Microsoft Excel.
Couples Budget Spreadsheet
Split bills, track shared and personal expenses, and manage savings together. Built for two incomes, one shared financial picture.
Debt Payoff Tracker
See your total debt, log payments, and watch your balances drop month by month with clear visual progress. Track credit cards, loans, and any other debt.