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
  1. Step 1: Know your real monthly income
  2. Step 2: Sort your expenses into types
  3. Step 3: Choose a budgeting method
  4. Step 4: Build your spreadsheet
  5. Step 5: Track without pain and review monthly
  6. Real case: Tyler fixes his budget in Denver
  7. Summary
What you'll learn
  • 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.
📥 Practice this lesson

Type in your take-home pay and your planned spending: the 50/30/20 split and the "left to assign" total calculate automatically.

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.

15 minto sketch a first budget with the 50/30/20 rule and last month's statement
26paychecks a year if you're paid every two weeks, not 24
20 mina month is all the maintenance a working budget needs
  1. Sort your expenses
  2. Choose a method
  3. Build the spreadsheet
  4. Track without pain
  5. 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 expensePer yearPer 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?

  • Only in the month the bill is due
  • It doesn't belong in the budget because it isn't monthly
  • As $65 a month moved into a sinking fund ($780 ÷ 12)

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:

The 50/30/20 split on $3,600 of take-home pay Needs $1,800 (50%), wants $1,080 (30%), savings and extra debt payments $720 (20%). $3,600 take-home pay
  • 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.
50/30/20 is a starting point, not a law. The non-negotiable part is giving savings its own slice from day one.

The dollar amounts change with your income, but the proportions don't:

Monthly take-home payNeeds (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:

CategoryAmountLeft 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.

50/30/20Three buckets, done
Ease
●●●●
Control
●●●●
Best if
You've never budgeted and want to start today.
Best first step
Zero-basedEvery dollar gets a job
Ease
●●●●
Control
●●●●
Best if
Money is tight or you're getting out of debt.
Maximum control
EnvelopesA cap per category
Ease
●●●●
Control
●●●●
Best if
You always overspend in the same places (takeout, Target runs).
Plugs leaks

2. Using the 50/30/20 rule with $2,500 of take-home pay, how much goes to savings and extra debt payments?

  • $500
  • $750
  • $1,250

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:

CategoryTypePlannedActualDifference
RentNeed$1,250$1,250=C2-D2
GroceriesNeed$450$512−$62
GasNeed$140$126$14
Dining out and funWant$300$365−$65
Emergency fundSavings$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.
  1. PaydayAutomate savings firstTransfers to your emergency fund and IRA leave the day your paycheck arrives.
  2. Weekly · 10 minCategorize transactionsFix anything the app filed in the wrong place.
  3. Mid-monthCheck variable categoriesIf groceries or dining out are already at 70%, slow down now, not on the 31st.
  4. Month-end · 20 minReview and adjustCompare planned vs. actual and set next month's numbers.

Real case: Tyler fixes his budget in Denver

Tyler, graphic designer, 29Denver, Colorado · take-home pay of $4,500 a month

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.

Before

Needs66%
Wants30%
Savings4%

After

Needs60%
Wants25%
Savings15%

He went from saving $180 to $675 a month: $8,100 a year instead of $2,160.

ChangeTypeMonthly savings
Switched to a prepaid phone carrier on the same networkNeed$50
Got three car insurance quotes and switchedNeed$60
Grocery list and one big weekly shop instead of daily stopsNeed$110
Called his internet provider and moved to a cheaper planNeed$50
Delivery orders from 8 to 4 a month (about $35 each)Want$140
Canceled three subscriptions he rarely usedWant$45
48-hour rule for impulse buysWant$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)?

  • $6,750
  • $8,100
  • $7,200

$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?

  • Raise the grocery line to a realistic number and trim another category to balance it
  • Give up on budgeting; it clearly doesn't work for you
  • Ignore it and hope next month is better

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.

  1. Classify each expense as a need or a want.
  2. Calculate her percentages and compare them with 50/30/20.
  3. 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
Wants$550
Savings$480

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.

🎓 Save your progress and get a free certificate

Create your account in 30 seconds, mark your lessons and download your certificate at the end.

Enroll for free