Lesson 2 of 16 · Level 1: Beginner
How to Make a Budget: 50/30/20, Zero-Based and a Free Spreadsheet Template
- ⏱ 13 min read
- ❓ 4 review questions
- ✍️ Exercise with solution
- 📥 Downloadable template
In this lesson
- Sort your spending into fixed, variable, discretionary and irregular expenses.
- Pick a budgeting method: 50/30/20, zero-based, envelopes or pay-yourself-first.
- Set up a budget spreadsheet in Excel or Google Sheets that adds up categories for you.
- Track spending without burnout and review your budget in about 20 minutes a month.
- Avoid the mistakes that make most people quit by February.
Type in your take-home pay and your planned spending: the 50/30/20 split and the "left to assign" total calculate automatically.
- personal-finance-template.xlsx · Budget tab
A budget isn't a list of things you're not allowed to buy. It's a plan that tells your money where to go before it leaves. People without a budget don't spend less; they just find out later. In this lesson you'll learn four ways to build one, how to set it up in a spreadsheet, a real before-and-after case with numbers, and a monthly routine that keeps it alive.
- Sort your expenses
- Choose a method
- Build the spreadsheet
- Track without pain
- Review monthly
Step 1: Know your real monthly income
Budget with take-home pay, the money that reaches your checking account. If you earn $1,500 every two weeks, that's $39,000 a year ($3,250 a month on average), but most months you'll only get two paychecks, or $3,000. Budget your regular bills on $3,000 and treat the two "third paycheck" months as a bonus for savings or debt. If your income changes a lot month to month, use your lowest typical month and read lesson 5.
Step 2: Sort your expenses into types
Before deciding how much to spend, figure out what kind of expense each one is. They're not managed the same way: some you renegotiate once a year, others you watch every week.
Fixed essentials
Rent or mortgage, car payment, insurance premiums, phone and internet, minimum debt payments.
How to manage them: shop them around once a year. Lowering one fixed bill saves money every month with zero willpower.Variable essentials
Groceries, gas, utilities, prescriptions, household supplies.
How to manage them: set a monthly cap and check it every week.Discretionary
Dining out, DoorDash, streaming, clothes, concerts, hobbies, travel.
How to manage them: this is your flexibility. You don't eliminate them; you choose them.The fourth type that wrecks budgets: irregular expenses
Car insurance billed every six months, holiday gifts, annual memberships, car registration. They don't show up every month, but they show up every year, so they're not emergencies. Add them up, divide by 12 and move that amount into a separate savings account each month (sometimes called a sinking fund):
| Irregular expense | Per year | Per month (÷ 12) |
|---|---|---|
| Car insurance ($690 every six months) | $1,380 | $115.00 |
| Holiday and birthday gifts | $720 | $60.00 |
| Annual memberships (Costco, Amazon Prime) | $240 | $20.00 |
| Car registration and inspection | $150 | $12.50 |
| Total | $2,490 | $207.50 |
With $207.50 set aside each month, December and the insurance renewal stop "ruining" your budget: the money is already waiting when the bill arrives.
1. Your car insurance costs $780 a year, paid in one bill. How should it appear in your monthly budget?
Spreading irregular costs over 12 months prevents the "surprise" months that blow up a budget. $780 ÷ 12 = $65.
Step 3: Choose a budgeting method
The 50/30/20 rule (the easiest start)
Popularized by Senator Elizabeth Warren and Amelia Warren Tyagi, it splits take-home pay into three buckets: needs, wants, and savings plus extra debt payments. Here's what it looks like on $3,600 a month:
- Needs (50%) $1,800Rent, utilities, groceries, transportation, insurance, minimum debt payments.
- Wants (30%) $1,080Restaurants, streaming, shopping, hobbies, trips.
- Savings and extra debt (20%) $720Emergency fund, Roth IRA, paying down credit cards faster.
The dollar amounts change with your income, but the proportions don't:
| Monthly take-home pay | Needs (50%) | Wants (30%) | Savings (20%) |
|---|---|---|---|
| $2,800 | $1,400 | $840 | $560 |
| $3,600 | $1,800 | $1,080 | $720 |
| $5,000 | $2,500 | $1,500 | $1,000 |
| $7,500 | $3,750 | $2,250 | $1,500 |
In high-cost cities like San Francisco, Boston or New York, rent alone can top 40% of take-home pay. Then adjust, for example to 60/25/15, but protect the savings slice, even if you start at 5% or 10% and raise it with every pay increase.
A high-cost-city version: 60/25/15. Savings shrink, but they never disappear.
Zero-based budgeting (the most precise)
You assign every dollar to a category until income − spending − saving = $0. That doesn't mean spending everything; savings is a category too. Same $3,600:
| Category | Amount | Left to assign |
|---|---|---|
| Rent | $1,250 | $2,350 |
| Groceries | $450 | $1,900 |
| Car payment and insurance | $420 | $1,480 |
| Gas | $140 | $1,340 |
| Utilities and phone | $210 | $1,130 |
| Student loan | $230 | $900 |
| Irregular expenses fund | $110 | $790 |
| Dining out and fun | $300 | $490 |
| Personal and shopping | $130 | $360 |
| Emergency fund | $250 | $110 |
| Roth IRA | $110 | $0 |
It takes more effort, but it's ideal if money is tight or you're paying off debt, because it forces a decision for every dollar.
Envelopes and pay-yourself-first
With the envelope method, each variable category gets a fixed amount; when the "envelope" is empty, that spending stops until next month. People once used cash; today many online banks let you create savings "buckets" that do the same job. With pay-yourself-first, you automate savings on payday and spend the rest freely, as long as bills get paid. It's the lowest-effort method and works if you don't overspend.
- Ease
- ●●●●
- Control
- ●●●●
- Best if
- You've never budgeted and want to start today.
- Ease
- ●●●●
- Control
- ●●●●
- Best if
- Money is tight or you're getting out of debt.
- Ease
- ●●●●
- Control
- ●●●●
- Best if
- You always overspend in the same places (takeout, Target runs).
2. Using the 50/30/20 rule with $2,500 of take-home pay, how much goes to savings and extra debt payments?
20% of $2,500 is $500. Needs get 50% ($1,250) and wants 30% ($750).
Step 4: Build your spreadsheet
You don't need a paid app. A sheet with this structure works perfectly:
| Category | Type | Planned | Actual | Difference |
|---|---|---|---|---|
| Rent | Need | $1,250 | $1,250 | =C2-D2 |
| Groceries | Need | $450 | $512 | −$62 |
| Gas | Need | $140 | $126 | $14 |
| Dining out and fun | Want | $300 | $365 | −$65 |
| Emergency fund | Savings | $250 | $250 | $0 |
Keep a second tab called Transactions (Date, Description, Category, Amount). The "Actual" column then fills itself:
=SUMIFS(Transactions!D:D, Transactions!C:C, A2)
And to see what share of your income goes to each type (with take-home pay in cell H1):
=SUMIF(B2:B20, "Need", D2:D20) / $H$1
Format it as a percentage and compare it with your target. Add conditional formatting so negative differences turn red. For a deeper walkthrough of these steps, read our guide on how to make a budget.
Step 5: Track without pain and review monthly
- Minimum effort: once a week, export transactions from your bank and card and categorize them (10–15 minutes).
- Automatic: most bank apps and budgeting apps categorize for you; just fix the mistakes.
- Keep it short: 8 to 15 categories. With 40, you'll quit within a month.
- Use one card for most variable spending (and pay it in full). One statement is far easier to track.
- PaydayAutomate savings firstTransfers to your emergency fund and IRA leave the day your paycheck arrives.
- Weekly · 10 minCategorize transactionsFix anything the app filed in the wrong place.
- Mid-monthCheck variable categoriesIf groceries or dining out are already at 70%, slow down now, not on the 31st.
- Month-end · 20 minReview and adjustCompare planned vs. actual and set next month's numbers.
Real case: Tyler fixes his budget in Denver
Tyler felt like he "never had enough," but had never added up his spending. One month of tracking showed he saved just $180, or 4% of his pay. Instead of cutting everything, he made seven specific changes and set a realistic target: 60/25/15.
He went from saving $180 to $675 a month: $8,100 a year instead of $2,160.
| Change | Type | Monthly savings |
|---|---|---|
| Switched to a prepaid phone carrier on the same network | Need | $50 |
| Got three car insurance quotes and switched | Need | $60 |
| Grocery list and one big weekly shop instead of daily stops | Need | $110 |
| Called his internet provider and moved to a cheaper plan | Need | $50 |
| Delivery orders from 8 to 4 a month (about $35 each) | Want | $140 |
| Canceled three subscriptions he rarely used | Want | $45 |
| 48-hour rule for impulse buys | Want | $40 |
| Total moved to savings | $495 |
The math checks out: needs dropped from $2,970 to $2,700 (−$270), wants from $1,350 to $1,125 (−$225), and savings rose from $180 to $675 (+$495). Income stayed at $4,500.
3. If Tyler keeps saving $675 a month, how much will he set aside in a year (before interest)?
$675 × 12 = $8,100, almost four times the $2,160 he saved before ($180 × 12), without changing jobs.
Building a "perfect" budget that looks nothing like real life.
Start from last month's actual spending and adjust gradually.
Saving whatever's left at month-end.
Save first, automatically, on payday.
Quitting the first month you overspend.
Overspending is data: adjust the category and keep going.
4. For three months in a row you've spent more on groceries than planned. What's the best move?
A budget is a living tool. Real data beats wishful thinking: if groceries always run $520, budgeting $450 isn't discipline, it's fiction.
Practice exercise
Brianna, a paralegal in Atlanta, takes home $3,200 a month. Her spending: rent $1,200, groceries $420, gas $160, utilities and phone $190, car payment $330, dining out and delivery $420, subscriptions $70, clothing $160, other $250.
- Classify each expense as a need or a want.
- Calculate her percentages and compare them with 50/30/20.
- Propose a budget that lets her save at least 15%.
See solution
Needs: $1,200 + $420 + $160 + $190 + $330 = $2,300 (71.9%). Wants: $420 + $70 + $160 + $250 = $900 (28.1%). Savings: $0. She spends every dollar she earns.
Her wants are near the 30% guideline; the real problems are high needs and zero savings. To save 15% ($480):
- Dining out and delivery from $420 to $250 (−$170).
- Clothing from $160 to $100 (−$60), subscriptions from $70 to $35 (−$35), other from $250 to $165 (−$85).
- Cheaper phone plan: utilities and phone from $190 to $150 (−$40).
- Meal planning: groceries from $420 to $330 (−$90).
Total freed up: $480. Her new budget:
Needs $2,170 (67.8%), wants $550 (17.2%), savings $480 (15%): a total of $3,200. Her biggest long-term lever is rent, at 37.5% of her take-home pay.
Summary
- A budget assigns your money a destination before you spend it.
- Sort expenses into fixed, variable, discretionary and irregular; divide irregular ones by 12.
- Start with 50/30/20; switch to zero-based or envelopes when you need more control.
- Pay yourself first with automatic transfers on payday.
- Review monthly and adjust with real numbers: overspending is information, not failure.
Next lesson: Emergency Fund: How Much You Need and Where to Keep It. You'll size your fund for your situation, choose an FDIC- or NCUA-insured home for it and build it step by step.
Create your account in 30 seconds, mark your lessons and download your certificate at the end.