Free Excel Budget Planner Template — Track Income, Expenses & Savings
A comprehensive monthly budget planner with automatic calculations, spending category breakdowns, and savings goal tracking. Download free, no signup required.
Managing your money shouldn’t require a finance degree. Yet most people lose track of where their paycheck goes each month. This budget planner gives you a clear, visual overview of your income, expenses, and savings — updated automatically as you enter transactions.
Key Features
💰 Income & Expense Tracking
- Categorized expense entries: housing, food, transportation, entertainment, etc.
- Multiple income sources supported
- Daily, weekly, or monthly entry options
- Auto-calculated running balance
📊 Spending Analysis Dashboard
| Metric | How It’s Calculated |
|---|---|
| Total Income | Sum of all income entries |
| Total Expenses | Sum of all expense entries |
| Net Savings | Income − Expenses |
| Savings Rate | (Net Savings ÷ Income) × 100% |
| Top Category | Highest spending category |
🎯 Savings Goal Tracker
- Set monthly savings targets
- Visual progress bar shows how close you are
- Alerts when spending exceeds budget limits
- Year-end projection based on current pace
How to Use
Step 1: Set Your Budget
Enter your expected monthly income and set spending limits for each category in the “Setup” sheet.
Step 2: Log Transactions
Record your daily income and expenses in the “Transactions” sheet. Select the category from the dropdown menu.
Step 3: Review Your Dashboard
Check the “Dashboard” sheet to see your spending breakdown, savings rate, and progress toward your goals.
Tips
Use the 50/30/20 Rule as a Starting Point
Allocate 50% of income to needs (rent, utilities, groceries), 30% to wants (dining out, entertainment), and 20% to savings. Adjust the category budgets accordingly.
Review Weekly, Not Just Monthly
A quick 5-minute weekly check helps you catch overspending early before it becomes a problem at month-end.
FAQ
Can I customize the spending categories?
Yes, edit the category list in the “Setup” sheet. The dropdowns and dashboard will update automatically.
Does it work with Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. All formulas and conditional formatting are compatible.