Budget & SIP Tracker
All-in-one personal finance tracker covering monthly budget, SIP investments, net worth and financial goals β built for Indian investors.
π How to Use
π Dashboard
π SIP Tracker
π¦ Net Worth
π― Goal Planner
Income vs expenses dashboard with auto savings rate
SIP portfolio tracker β fund, start date, returns %
4-month rolling net worth (assets minus liabilities)
Goal planner with PMT formula β calculates required SIP
Yellow cells only β all other cells are live formulas
No macros, works in Excel and Google Sheets
Home Loan Planner
Full amortisation schedule, prepayment impact simulator, and EMI vs rent comparison β everything for your biggest financial decision.
π Loan Summary
π
Amortisation
π³ Prepayment Sim
π EMI vs Rent
Full month-by-month amortisation breakdown
See how a lump sum prepayment reduces your tenure
Compare renting vs buying wealth over 10β20 years
Section 24b tax deduction tracker
π .xlsx
β‘ 4 sheets
π Coming soon
π Coming Soon
Tax Planning Worksheet
FY 2025-26 income tax planner comparing old vs new regime, with a deduction optimiser for 80C, HRA, NPS and more.
π° Income Details
π Deductions
βοΈ Regime Compare
π Advance Tax
Old regime vs new regime side-by-side
80C, 80D, HRA, Sec24b, NPS tracker
Advance tax due dates and amounts
Updated for Budget 2024 slabs
π .xlsx
β‘ 4 sheets
π Coming soon
π Coming Soon
How to Use the Templates
Each template follows the same simple system β no learning curve needed.
1
Download the .xlsx file
Click "Download Free Excel" β no signup, no email, instant download.
2
Open in Excel or Google Sheets
Works in Microsoft Excel 2016+ and Google Sheets (File β Import).
3
Fill yellow cells only
Yellow highlighted cells are your inputs. All other cells are formulas β don't edit them.
4
Update monthly
Takes under 10 minutes. Best done on the 1st of each month to track your progress.
Color Coding Guide
Yellow cells β Enter your values here
Blue text β One-time hardcoded inputs
Black text β Auto-calculated formulas
Green β Positive / surplus values
Red β Expenses / liabilities