Net Worth Tracker Spreadsheet, FIRE Calculator, Financial Independence Planner, Debt Dashboard, Google Sheets Excel
This net worth tracker puts every account in one place. Type balances once a month and see your net worth, the trend, a year-end review and a FIRE timeline that shows when work could become optional.
✦ WHAT'S INCLUDED
• Net worth tracker (.xlsx), example household with 14 accounts and 12 months of balances
• Blank version (.xlsx): 40 accounts, 36 months
• Step-by-step PDF guide for Google Sheets and Excel
✦ FEATURES
• Dashboard: net worth, change this month and since you started, goal progress, assets, debts, liquid cash and FI progress, with charts
• Accounts list: asset or liability, category, owner, liquid, and counts-toward-FI flags
• Monthly balances grid for 36 months; type debts as positive numbers and they're subtracted for you
• Monthly Summary: assets, debts, net worth, change in $ and %, liquid cash, invested money and debt-to-assets
• Year-end review: start and end net worth, change, debt paid down and invested growth for each year
• FIRE timeline: FI number from your spending and withdrawal rate, years to FI, FI age, Coast FI and a year-by-year projection
• Breakdown by category and an asset allocation chart
✦ WHY IT'S DIFFERENT
• Year-end review and FIRE timeline in the same file
• No bank logins, no subscription, your data stays in your file
• Skipped months are handled automatically
• Google Sheets AND Excel, example and blank versions
✦ HOW IT WORKS
1. Buy and download your files instantly.
2. Upload the .xlsx to Google Drive and open it with Google Sheets, or open it in Excel.
3. Follow the Start Here tab. Everything else calculates.
✦ GOOD TO KNOW
• Instant download: nothing physical is shipped.
• Works in Google Sheets (free) and Microsoft Excel 2016+ / Microsoft 365 / Excel for the web. Not compatible with Apple Numbers.
• Works on desktop and in the Google Sheets and Excel phone apps (a computer is easiest for setup).
• No macros. Example and blank versions included. Licensed for one person or one business.
• Record-keeping and planning tool, not tax, legal or financial advice.
• Questions? Message me. I usually reply within a day.
© SageAndSheets. Please do not share or resell. Because this is a digital download, refunds aren't offered, but if anything isn't working, message me and I'll make it right.