Template
Yearly Finance Review Template
Once a year, it pays to step back from monthly budgeting and look at the whole picture: did your net worth actually grow, what was your real savings rate, are your goals on track, and is your insurance and tax house in order? This template gives you a structured annual review covering every part of your financial life, comparing this year against last and turning the findings into a concrete plan for the year ahead. It is the once-a-year sitting that keeps your money strategy honest and pointed in the right direction.
Free · Excel / Google Sheets compatible · no signup — see what’s inside below, then download.
What it does
The template walks you through a complete annual financial review in one place. It compares your net worth at the start and end of the year to show real growth, calculates your savings rate for the year, and checks progress on each financial goal against where it should be. It prompts a review of your insurance — term cover adequacy and health cover for the family — your asset allocation against your target, and your tax position including which regime served you best and whether deductions were fully used. Finally, it captures decisions and targets for next year, so the review ends not as a report card but as a plan you can act on.
Who it’s for
- Anyone who budgets monthly but never zooms out to assess the whole year.
- Investors who want to check net worth growth and asset allocation against their targets annually.
- Families reviewing whether their term and health insurance still fit their needs.
- People who want to compare the old and new tax regimes and plan deductions before year-end.
Fields included
How to use it
- Record your net worth at the start and end of the year and calculate the change.
- Total the year’s income and savings to find your actual annual savings rate.
- Review each financial goal — compare amount saved against where the plan said you should be.
- Check your asset allocation across equity, debt, and gold against your target mix and note any drift.
- Review insurance — confirm your term cover and family health cover are still adequate for your situation.
- Assess your tax year — which regime was better, and were 80C, 80D, and other deductions fully used.
- Write down three to five specific decisions and targets for the coming year.
Preview
| Area | This year | Last year |
|---|---|---|
| Net worth | ₹26,00,000 | ₹18,00,000 |
| Savings rate | 28% | 24% |
| Equity allocation | 80% | 72% |
| Goals on track | 2 of 3 | 2 of 3 |
Free Excel / Google Sheets template — no signup required.
Download Excel template (.xlsx)Example workflow
Sanjay does his review every March. His net worth rose from ₹18L to ₹26L — an ₹8L gain, with about ₹5L from savings and ₹3L from market growth. His annual savings rate works out to 28%, up from 24%. Two goals are on track, but his car fund is behind, so he raises that SIP. His allocation has drifted to 80% equity against a 70% target after a strong year, so he rebalances some into debt. His term cover of ₹1.5Cr still looks adequate, but he adds a ₹5L health top-up after a premium hike. Comparing regimes, the new regime saved him tax this year. He ends with four targets for next year, including bumping his savings rate to 30%.
Frequently Asked Questions
Ready to put this to work?
Download Excel template (.xlsx)