A monthly budget worksheet works by comparing your total take-home income against every planned expense and savings contribution — and the result tells you whether you have a surplus (save or invest it) or a deficit (something must change). Most people who start tracking discover 2–3 categories where spending significantly exceeds what they believed.
This guide provides a complete monthly budget worksheet structure, the most effective budgeting methods, and guidance on which expenses to cut first.
Monthly Budget Worksheet Template
Copy this structure into a spreadsheet (Google Sheets or Excel) and fill in your actual numbers:
Section 1: Monthly Income
| Income Source | Amount |
|---|---|
| Primary job take-home pay | $ |
| Spouse/partner take-home pay | $ |
| Freelance / side income | $ |
| Rental income | $ |
| Other income | $ |
| Total Monthly Income | $ |
Use after-tax, take-home amounts for all income.
Section 2: Fixed Expenses
Fixed expenses are the same every month and cannot be easily changed in the short term.
| Fixed Expense | Monthly Amount |
|---|---|
| Rent or mortgage | $ |
| Renter’s or homeowner’s insurance | $ |
| Car payment | $ |
| Car insurance | $ |
| Health insurance premium (if not pre-tax) | $ |
| Life insurance | $ |
| Subscriptions (Netflix, Spotify, gym, etc.) | $ |
| Phone bill | $ |
| Internet | $ |
| Student loan payments | $ |
| Minimum credit card payments | $ |
| Other fixed (alimony, child support, etc.) | $ |
| Total Fixed Expenses | $ |
Section 3: Variable Expenses
Variable expenses fluctuate month to month. Use a 3-month average for the most accurate estimate.
| Variable Expense | Monthly Budget | Last Month Actual |
|---|---|---|
| Groceries | $ | $ |
| Gas / transportation | $ | $ |
| Dining out / takeout | $ | $ |
| Entertainment (movies, events) | $ | $ |
| Clothing / personal care | $ | $ |
| Home supplies / household goods | $ | $ |
| Medical / pharmacy | $ | $ |
| Pet expenses | $ | $ |
| Children’s activities / childcare | $ | $ |
| Gifts / donations | $ | $ |
| Miscellaneous | $ | $ |
| Total Variable Expenses | $ | $ |
Section 4: Savings and Debt Payoff
| Goal | Monthly Contribution |
|---|---|
| Emergency fund | $ |
| Retirement (IRA, additional 401k beyond match) | $ |
| Down payment / home purchase fund | $ |
| Vacation fund | $ |
| Car replacement fund | $ |
| Extra credit card debt payoff (above minimum) | $ |
| Extra student loan payoff | $ |
| Other savings goal | $ |
| Total Savings / Extra Debt Payments | $ |
Section 5: Budget Summary
| Amount | |
|---|---|
| Total Monthly Income | $ |
| − Total Fixed Expenses | $ |
| − Total Variable Expenses | $ |
| − Total Savings / Extra Debt Payments | $ |
| = Monthly Surplus or Deficit | $ |
Target: $0 (zero-based) or a positive number that you then deliberately assign to a savings goal.
Which Budgeting Method to Use
The 50/30/20 Rule
The simplest framework for a starting budget:
- 50% Needs: Housing, food, utilities, transportation, insurance, minimum debt payments
- 30% Wants: Dining, entertainment, subscriptions, clothing beyond basics
- 20% Savings + Extra Debt Payoff: Emergency fund, retirement, goals
Example on $5,000/month take-home:
- Needs: $2,500 maximum
- Wants: $1,500 maximum
- Savings: $1,000 minimum
Zero-Based Budgeting
Every dollar is assigned: income minus all allocated spending and saving = $0. Surplus goes to a specific category (extra debt payoff, next month’s irregular expenses, etc.). Best for people who want maximum control.
Pay Yourself First
Automatically transfer savings contributions on payday before spending anything. Whatever is left covers expenses. Removes savings from the decision-making process entirely — the most effective approach for people who struggle to save.
Average U.S. Household Spending (Benchmark)
Compare your worksheet with what the average U.S. household actually spent each month in 2024, the latest year of BLS data:
| Category | Average Monthly Spending | Share of Total Spending |
|---|---|---|
| Housing (incl. utilities) | $2,189 | 33% |
| Transportation | $1,110 | 17% |
| Food (groceries + dining out) | $847 | 13% |
| Personal insurance and pensions (mostly Social Security and retirement contributions) | $816 | 12% |
| Healthcare | $516 | 8% |
| Entertainment | $301 | 5% |
| Apparel and services | $167 | 3% |
| Total spending | $6,545 | 100% (includes categories not shown) |
Source: Bureau of Labor Statistics, Consumer Expenditure Survey 2024, average per household. Averages by income level are in the average monthly budget by income.
Free Spreadsheet Templates
If you’d rather keep your budget in a spreadsheet than on paper:
- Google Sheets has free “Monthly budget” and “Annual budget” templates in its template gallery; the monthly one compares planned and actual spending by category.
- Microsoft Excel includes free personal budget templates under File → New (search “budget”).
- Build your own from the worksheet above: one column for planned amounts, one for actual, and a row that subtracts total spending and savings from take-home pay. If that row isn’t zero, every dollar doesn’t have a job yet.
Keep one tab per month, and review it on the same day each week. For apps that do this automatically, see the best budgeting apps.
Where to Cut First
When the budget shows a deficit or savings rate is below target, this is the order to review:
-
Subscriptions — The average US household pays for 4–6 streaming services and multiple app subscriptions. Audit and cancel unused ones; consider sharing family plans.
-
Dining out — Typically the most controllable variable expense. Reducing restaurant spending by $100/month frees $1,200/year with no lifestyle sacrifice other than cooking more.
-
Phone bill — Switching from a major carrier to an MVNO (Mint Mobile, Visible) saves $40–$80/month for most households. See Cheap Cell Phone Plans.
-
Insurance — Getting competing quotes on auto and home insurance annually reduces costs for most households. Bundling home and auto with one insurer often earns a discount.
-
Groceries — Using cashback apps (Ibotta), store loyalty digital coupons, and planning meals around weekly sales can meaningfully cut the grocery bill.
Related Budgeting Guides
- How to Create a Budget — Full overview of budgeting methods and habits
- How to Get Coupons — Reduce grocery and everyday spending
- Cheap Cell Phone Plans 2026 — Cut one of the easiest fixed expenses
- Investment Calculator — See what your monthly savings surplus can grow to
Part of the budgeting guide.
The content on Wealthvieu is for informational purposes only and should not be considered financial, tax, or investment advice. Consult a qualified professional before making financial decisions. Full disclaimer · Editorial policy