Template Overview
A monthly budget spreadsheet is the simplest, most effective tool for taking control of your money. This free monthly budget template gives you a working structure for tracking every dollar (or your local currency) — income coming in, expenses going out, savings set aside, and debt being paid down — with live formulas that recalculate as you edit. Two sheets: a detailed Monthly Budget for the current month, and a Yearly Summary that rolls up all 12 months to show trends and your annual savings rate.
Who this monthly budget template is for
- Individuals and couples starting a first budget — see exactly where your paycheck goes
- Freelancers and side-hustlers with variable monthly income
- Anyone paying off debt — snowball or avalanche approach with a dedicated debt section
- Savers with goals — emergency fund, down payment, vacation, retirement
- People switching from budgeting apps (Mint, YNAB, EveryDollar) who want more control and no subscription
What's in this budget template
The Monthly Budget sheet has 5 clearly-separated sections, each with a Budgeted column (what you planned) and an Actual column (what really happened) so you can track variance:
- Income — Primary salary, secondary income, investment income, other
- Fixed Expenses — Rent/mortgage, utilities, insurance, loans, subscriptions
- Variable Expenses — Groceries, dining out, transportation, entertainment, shopping
- Savings & Investments — Emergency fund, retirement, brokerage, custom goals
- Debt Payments — Credit cards, minimum payments, extra payoff amounts
At the top, a Monthly Summary card shows Total Income, Total Planned Spending, and Money Left Over — updated live as you edit. Below the sections, a Savings Rate cell calculates what percentage of income you're actually saving.
The Yearly Summary sheet has 12 rows (January to December) with columns for Income, Fixed, Variable, Savings, and Debt totals. Fill in each month's totals and see annual roll-up, net cash flow, and annual savings rate at a glance.
How to build a monthly budget — the 50/30/20 method
If you're new to budgeting, the simplest framework is 50/30/20:
- 50% of take-home pay goes to needs — rent, utilities, groceries, insurance, transportation to work, minimum debt payments
- 30% goes to wants — dining out, entertainment, hobbies, non-essential shopping, subscriptions
- 20% goes to savings and debt payoff — emergency fund, retirement, extra debt payments, investments
This template's five sections map onto the framework: Fixed Expenses ≈ needs, Variable Expenses ≈ mostly wants, Savings + Debt Payments = the 20% target. If your Variable + Fixed totals cross 80%, that's your signal to trim.
Other popular budgeting frameworks that work with this template:
- Zero-based budgeting — every dollar of income is assigned to a category (Income − All Categories = 0). Fill in Budgeted amounts until Money Left Over = 0.
- Envelope method — treat each Variable category as an "envelope"; stop spending when Actual hits Budgeted.
- Pay-yourself-first — fill in the Savings section first, then everything else fits into what's left.
Step-by-step: using the template
- Download the file and open in Excel or Google Sheets.
- Fill in Budgeted amounts for each category based on your last 1-2 months of spending (start with realistic numbers, not aspirational ones).
- Set at least one savings goal — even $50/month starts the habit.
- Enter Actual amounts as they happen — weekly is ideal; monthly at minimum.
- Watch the Diff column — positive means you're under budget (good), negative means you overspent that category.
- Review the Savings Rate at month-end — anything above 20% is strong; below 10% signals room to trim variable spending.
- Copy the sheet for next month and update the month label. Roll income and fixed expenses forward; reset actuals to zero.
- Fill in the Yearly Summary at the end of each month to build a 12-month trend view.
Common budgeting mistakes to avoid
- Budgeting for who you wish you were, not who you are — if your last 3 months' groceries were $650, don't budget $400. Start real, then trim.
- Forgetting irregular expenses — annual insurance renewals, car registration, holiday gifts, birthdays. Divide the annual amount by 12 and budget a small monthly allocation.
- No savings category — a budget that has income = expenses and no savings is just a spending plan. Always include a savings line, even if small.
- Tracking only expenses, not income — variable-income earners especially should track actual income to catch shortfalls early.
- Not reviewing until end of month — problems are cheaper to spot on day 10 than day 30.
- Budgeting solo when you share finances — households should build the budget together, or one person will feel ambushed by the numbers.
What to pair with this monthly budget
Once you have your monthly budget running, three related tools help extend it:
- Business Expense Tracker — if you're a freelancer or run a side business, keep business spending in a separate file (never mix with personal).
- Cash Book Template — for anyone dealing in cash frequently, tracks running cash balance day by day.
- Profit and Loss Statement — for side-business or freelance income, summarizes monthly profitability.
Frequently asked questions about monthly budgets
Below are quick answers to common budgeting questions. This template is currency-neutral — enter amounts in your local currency ($, €, £, ₹, whatever), and every formula still works.
Features
- Two sheets: Monthly Budget + 12-month Yearly Summary
- 5 clear sections: Income, Fixed, Variable, Savings, Debt
- Budgeted vs Actual columns with automatic variance
- Live formulas — totals and money-left-over recalculate as you edit
- Automatic Savings Rate calculation (target 20%+)
- Currency-neutral — works with $, €, £, ₹, or any currency
- Works in Excel, Google Sheets, Numbers, and LibreOffice
Instructions
- Download the file and open in Excel, Google Sheets, or LibreOffice.
- Update the month label at the top of the Monthly Budget sheet.
- Fill in your income sources in the Income section with realistic monthly amounts.
- Enter Budgeted amounts for each category based on your last 1-2 months of actual spending.
- As transactions happen, enter the Actual amount in the corresponding row.
- Check the Monthly Summary card at the top — it updates automatically.
- Review the Savings Rate cell at month-end — aim for 20% or higher.
- At the start of a new month, copy the sheet and reset the Actual column.
FAQ
Is this monthly budget template free to use?
Yes. It is 100% free to download and use for personal or commercial purposes. No signup, no email required, no watermark. You can also edit and share it freely.
Does the template work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. All formulas — SUM totals, budgeted-vs-actual variance, and the savings rate calculation — work identically. You get real-time collaboration too, which is useful for couples budgeting together.
Which currency does the template use?
The template is currency-neutral — numbers are formatted with two decimal places but no currency symbol. Enter amounts in your local currency ($, €, £, ₹, or any other) and every formula still works. If you want a currency symbol displayed, use Format > Currency in your spreadsheet app.
What is a good monthly savings rate?
The 50/30/20 rule targets 20% of take-home pay going to savings and debt payoff. Anything above 20% is strong. Below 10% is a warning sign — usually variable expenses (dining out, subscriptions, shopping) are the fastest to trim. The template calculates your savings rate automatically.
How do I roll this budget over to next month?
Right-click the Monthly Budget sheet tab and choose 'Duplicate' (or 'Move or Copy' > check 'Create a copy'). Rename the new sheet to next month, update the month label at the top, keep the Budgeted amounts (adjust if needed), and clear the Actual column. Fill in the Yearly Summary sheet with this month's totals before starting the new one.
Can I add or remove categories?
Yes. Insert a new row within any section (Income, Fixed Expenses, etc.), then extend the SUM formula in the total row to include the new row. Delete unused sample rows the same way. The Summary card and Savings Rate automatically reflect any category changes.