Free Excel Household Budget Template — Monthly Expense Tracker with Dashboard
Track your household income and expenses with automatic monthly summaries, category breakdowns, and savings rate analysis. 12 monthly sheets included.
Every month you swipe your card dozens of times, and when the bill arrives you wonder: “Where did all that money go?” This household budget template gives you a complete picture of your finances with automatic analysis — just enter your transactions and the dashboard does the rest.
Key Features
💰 12 Monthly Sheets for Daily Entries
Each month has its own sheet with structured columns for recording transactions:
- Select Income or Expense from a dropdown — no typing errors
- Choose from 21 built-in categories: rent, groceries, transportation, utilities, dining out, entertainment, insurance, subscriptions, and more
- Day-of-week auto-fills when you enter a date
- Income rows appear in green, expense rows in red for quick visual scanning
- Up to 59 entries per month — more than enough for most households
📊 Annual Dashboard
| Metric | Description |
|---|---|
| Total Income | Sum of all income across 12 months |
| Total Expenses | Sum of all expenses across 12 months |
| Net Balance | Income minus Expenses |
| Savings Rate | Net Balance / Income as a percentage |
| Top Expense Category | Where you spend the most |
The dashboard also includes a month-by-month bar chart comparing income vs. expenses and a pie chart showing your spending distribution by category.
⚙️ Budget Setup Sheet
Set monthly spending limits for each category. When actual spending exceeds budget, the dashboard highlights overages in red so you can adjust before things spiral.
How to Use
Step 1: Set Your Budget
Go to the “Setup” sheet and enter your expected income and spending limits for each category. Default values are provided as starting points.
Step 3: Record Transactions
Navigate to the current month’s sheet. Enter the date, select income/expense, choose a category, add a description, and type the amount.
Step 4: Check the Dashboard
The “Dashboard” sheet updates automatically as you enter data. The charts become more meaningful as months of data accumulate.
Tips
Enter Fixed Expenses at the Start of Each Month
Log your rent, insurance, and subscriptions on the 1st so you immediately see how much discretionary spending you have left.
Use the Memo Column for Payment Methods
Note “credit card”, “cash”, or “debit” in the memo field. Later you can use Excel’s filter to see spending by payment method.
FAQ
Does it work with Google Sheets?
Yes. Upload the file to Google Drive and open with Google Sheets. Core formulas work correctly, though some conditional formatting may look slightly different.
Can I customize the categories?
Yes, edit the category list in the “Setup” sheet. Update the data validation dropdowns in the monthly sheets to match.
Can two people use this for a shared household?
Yes. Use the memo column to mark entries as “Person A” or “Person B”, then filter to see individual spending.