A monthly budget is a simple plan for one month’s money: what’s coming in, what’s going out, and what’s left for savings. The free templates below are MS Excel files with the formulas already built in — enter your income and expenses, and the totals and remaining balance update automatically. That’s the advantage of a spreadsheet budget over a printable one: no arithmetic, no eraser. The files also open in Google Sheets and LibreOffice. Below the downloads you’ll find the standard budget structure, a filled-in example, and a plain explanation of the 50/30/20 guideline.

How a Monthly Budget Is Structured

Every monthly budget — whatever the template design — organizes money into four buckets:

• Income — your take-home pay after tax, plus any side income. Use the amount that actually lands in your account, not your gross salary.
• Fixed expenses — amounts that are the same (or nearly so) every month: rent or mortgage, utilities, phone and internet, insurance, subscriptions, loan installments. These are the easiest to list and the hardest to change quickly.
• Variable expenses — amounts you influence month to month: groceries, fuel and transport, eating out, clothing, personal spending. This is where budgets are won or lost, so templates give it the most line items.
• Savings and debt paydown — what you set aside or put against debt beyond minimum payments. Treating this as a line item you “pay” like a bill — rather than whatever happens to be left over — is the single habit that makes budgets work.

The discipline is one line of arithmetic: income minus fixed, variable, and savings should land at zero or above. If it’s negative, the budget — not the month — is where you fix it, by trimming variable lines or renegotiating fixed ones before the month starts.

Sample Monthly Budget

Here’s a filled-in example showing the structure in action — the templates below contain blank versions with these formulas ready:

INCOME
Take-home salary	$3,200
Freelance work	$300
Total income	$3,500
FIXED EXPENSES
Rent	$1,100
Utilities, phone & internet	$220
Insurance & subscriptions	$130
Car loan payment	$280
VARIABLE EXPENSES
Groceries	$450
Fuel & transport	$180
Eating out & entertainment	$250
Personal & miscellaneous	$190
SAVINGS & DEBT PAYDOWN
Emergency fund	$400
Extra credit-card payment	$300
Remaining	$0

Note the remaining line: $0 here is success, not failure — every unit of income has been assigned a job, including the savings lines. Budgeters call this a zero-based budget.

The 50/30/20 Guideline

If you’re starting from scratch and don’t know what your category limits should be, the 50/30/20 rule is a widely used starting point: put roughly 50% of take-home income toward needs (housing, utilities, groceries, transport, minimum debt payments), 30% toward wants (eating out, entertainment, upgrades), and 20% toward savings and extra debt paydown. It’s a guideline, not a law — in cities where rent alone approaches half of income, needs will run over 50% and the other buckets shrink to compensate. Its real value is diagnostic: sorting last month’s actual spending into the three buckets shows you at a glance where your money is going versus where you’d like it to go.

Free Monthly Budget Templates in MS Excel

Pick a template below that matches your situation — simpler is better for a first budget. Every file has working formulas: type your amounts and the totals and remaining balance calculate automatically.

 

Here is the download link for this Monthly Budget Templates 01 in MS Excel format.

 

The download link for this Monthly Budget Template 02 in MS Excel format is below.

 

Please click on the download button below to start downloading this Monthly Budget Template 03.

 

To download this Monthly Budget Template 04, click on the button below.

 

Please click on the button below to start downloading this Monthly Budget Template 05.

To download this Monthly Budget Template 06, click on the button below.

Please click on the button below to start downloading this Monthly Budget Template 07.

How to Use a Budget Template

1. Enter your real income — the amount that hits your account, averaged over a few months if it varies.
2. List fixed expenses from your bank statement, not from memory — statements catch the subscriptions memory forgets.
3. Set variable limits based on last month’s actual spending, minus a modest trim. Cutting a category by 10–15% usually sticks; cutting it in half usually doesn’t.
4. Assign the remainder to savings and debt so the bottom line reads zero.
5. Check in twice during the month — mid-month and month-end — and adjust next month’s numbers based on what actually happened. The second budget is always better than the first.

Frequently Asked Questions

What is the 50/30/20 rule?

A budgeting guideline: about 50% of take-home income for needs, 30% for wants, and 20% for savings and extra debt payments. It’s a starting point to adapt, not a rule to pass or fail — high housing costs in particular push many real budgets off these exact ratios.

What is the 30-day rule?

An impulse-spending brake: when you want a non-essential purchase, note it down and wait 30 days. If you still want it after a month, buy it from planned money; most of the time the urge passes. It pairs well with a budget by protecting the variable-spending lines.

What categories should a monthly budget include?

At minimum: income; fixed expenses (housing, utilities, insurance, loan payments, subscriptions); variable expenses (groceries, transport, eating out, personal); and savings and debt paydown. Households add categories like childcare, school, and medical as needed — more categories add accuracy but also upkeep, so start small.

How much should I save each month?

The 50/30/20 guideline suggests around 20% of take-home income for savings and extra debt payments, but the honest answer is: whatever amount you can assign every single month without fail. A consistent 5% beats an aspirational 20% that collapses by the second month — and the number can grow as the habit holds.

Do these templates work in Google Sheets?

Yes — upload the .xlsx file to Google Drive and open it with Google Sheets; the budget formulas (sums and differences) carry over. LibreOffice Calc opens them as well. Minor formatting differences are possible, but the calculations work the same.