Net Worth & Investment Tracker

What you get

A single Excel workbook that calculates your net worth in under five minutes each month. Enter balances across five asset categories and your liabilities, and the workbook handles every calculation automatically — month-over-month movement, year-over-year growth, savings rate, and allocation breakdown.

Who it's for

Personal-finance enthusiasts who track their money with intention and want a structured record that compounds in usefulness over time. This is the template you buy when a budgeting app gives you the month but not the five-year arc.

What's inside

• Monthly Entry sheet — five labeled input fields covering cash, brokerage investments, retirement accounts, real estate, and other assets, plus liability rows for mortgage, loans, and credit cards.
• 5-Year History log — a rolling record that plots every entry you make, surfacing month-over-month and year-over-year changes automatically as the log fills.
• Net Worth Dashboard — a single-view summary of current net worth, YoY growth, and savings rate so the most important numbers are always one click away.
• Asset Allocation sheet — a structured breakdown that feeds directly into a portfolio pie chart, ready to render in seconds without manual data entry.
• Savings Rate calculator — inputs for gross income and total monthly savings produce an exact percentage, giving a clear read on how much of your income is actually working for you.
• Pre-built formulas throughout — every calculation is locked in from the start; you update values, the workbook does the math.

How to use it

Download the .xlsx file and open it in Microsoft Excel or upload it to Google Sheets. On the first day of each month, fill in the five asset fields and your current liability balances on the Monthly Entry sheet — the Dashboard, History log, and Allocation sheet update automatically. Your complete wealth picture is current in the time it takes to pull up your account balances.