50/30/20 Budget Template: Set Up the Rule in Excel or Google Sheets
Build a 50/30/20 budget template in Excel or Google Sheets: split take-home pay into needs, wants and savings/debt, tag spending with SUMIFS, track variances by month and adjust the ratios, with a worked $4,800 example.
A 50/30/20 budget template splits your monthly take-home pay into three buckets — about 50% for needs, 30% for wants and 20% for savings and extra debt payments — and then shows how your actual spending compares with each target. In Excel or Google Sheets, you assign every spending category to one of the three buckets once; after that, SUMIFS formulas total each bucket automatically and flag when you drift. The rule is a starting point, not a law: if rent alone takes a third of your pay, you adjust the percentages and keep tracking.
This guide is part of our Budgeting Methods section. If you prefer a category-by-category plan, the monthly budget template goes into more detail; the 50/30/20 approach keeps it to three numbers.
What goes in each bucket
| Bucket | Target | Typical items | Quick test |
|---|---|---|---|
| Needs | 50% | Rent or mortgage, utilities, groceries, insurance, car payment, gas or transit, basic phone, minimum debt payments, childcare | Would skipping it cause real harm or break a contract? |
| Wants | 30% | Dining out, streaming, hobbies, shopping beyond basics, vacations, upgraded plans | Could you pause it for a month without serious consequences? |
| Savings & debt | 20% | Emergency fund, retirement contributions from take-home pay, sinking funds, extra payments above the minimum | Does it make future-you better off? |
Use take-home pay — what actually lands in your account after taxes and payroll deductions. If retirement contributions are taken out of your paycheck before it arrives, you can either leave them out entirely or add them back to both income and the savings bucket; just be consistent.
Building the template
Tab 1: Setup
- B1: monthly take-home pay.
- B2:B4: target percentages (50%, 30%, 20%).
- Bucket budgets:
=$B$1*B2and copy down. - A category table (E:F) mapping each category to a bucket: Rent → Needs, Dining out → Wants, Emergency fund → Savings & debt.
Tab 2: Transactions
Date, description, category (dropdown from the Setup table) and amount. The bucket fills itself: =XLOOKUP(C2,Setup!E:E,Setup!F:F,"Unassigned"). In older Excel, use =IFERROR(VLOOKUP(C2,Setup!E:F,2,FALSE),"Unassigned").
Tab 3: Summary
- Spent per bucket this month:
=SUMIFS(Transactions!D:D,Transactions!E:E,A8,Transactions!A:A,">="&DATE(2026,11,1),Transactions!A:A,"<"&DATE(2026,12,1)) - Share of take-home pay:
=B8/Setup!$B$1 - Variance vs. budget:
=B8-VLOOKUP(A8,Setup!A2:C4,3,FALSE)(positive means over for Needs and Wants, and ahead of plan for Savings) - Unassigned check:
=COUNTIF(Transactions!E:E,"Unassigned")should be 0
Tab 4: Year view
Months across the columns, buckets down the rows, each cell a SUMIFS like the one above with the month’s start and end dates. A clustered column chart of budget vs. actual by bucket shows the trend at a glance.
Worked example: $4,800 take-home pay
Targets: Needs $2,400, Wants $1,440, Savings & debt $960. November actuals:
| Bucket | Category | Amount |
|---|---|---|
| Needs | Rent | $1,400 |
| Utilities | $190 | |
| Groceries | $480 | |
| Car payment | $310 | |
| Car insurance | $130 | |
| Gas | $150 | |
| Phone | $60 | |
| Credit card minimum | $80 | |
| Wants | Dining out | $260 |
| Shopping | $220 | |
| Travel fund | $150 | |
| Gym | $50 | |
| Streaming | $45 | |
| Savings & debt | Emergency fund transfer | $600 |
| IRA contribution | $400 | |
| Extra credit card payment | $275 |
| Bucket | Target | Actual | Actual % | Variance |
|---|---|---|---|---|
| Needs | $2,400 | $2,800 | 58.3% | +$400 |
| Wants | $1,440 | $725 | 15.1% | −$715 |
| Savings & debt | $960 | $1,275 | 26.6% | +$315 (ahead) |
| Total | $4,800 | $4,800 | 100% |
Reading the result: needs run 8 points over target, mostly because rent and the car payment take $1,710 together. By keeping wants low, this household still puts 26.6% toward savings and debt — well above 20%. Their realistic split is closer to 60/15/25, and that’s fine as long as it is a deliberate choice. Figures are illustrative.
The extra $275 toward the credit card is where a debt snowball spreadsheet helps decide which balance gets it first.
When to change the ratios
| Situation | Possible split |
|---|---|
| High-cost housing market | 60/20/20 — accept higher needs, trim wants, protect savings |
| High-interest debt | 50/20/30 — move more to debt until balances are gone |
| Irregular income (freelance, commission) | Budget on the average of the last 3–6 months and build a larger cash cushion |
| Big short-term goal (wedding, home down payment) | Temporarily raise savings; plan the event itself with a wedding budget spreadsheet |
Tips that make it stick
- Automate the 20%: schedule transfers to savings on payday so the bucket fills before spending starts.
- Use sinking funds for irregular costs: divide annual items (car registration, insurance premiums, holidays) by 12 and save monthly inside Needs or Wants.
- Classify consistently: minimum debt payments are Needs; anything above the minimum is Savings & debt.
- Review monthly, not daily: a 15-minute check at month-end, one change for next month.
- Share it: couples can use one Google Sheet with a “Paid by” column.
FAQ
Is the 50/30/20 rule realistic on a low income?
Often not as written — needs can exceed 50%. Cover needs first, keep wants minimal, and still save something regularly, even 5%, to start an emergency fund.
Do 401(k) contributions count toward the 20%?
They can. Because pre-tax contributions are removed before your paycheck arrives, either add them back to income and to the savings bucket, or leave both out. What matters is consistency month to month.
How big should my emergency fund be?
A common benchmark is several months of essential expenses; the right amount depends on job stability, dependents and other safety nets.
Does the template work in Google Sheets?
Yes. XLOOKUP, SUMIFS, COUNTIF, DATE and charts all work in Google Sheets.
Next step: enter your take-home pay, map your usual categories to the three buckets and log one full month before judging the results. More tools are in the Personal Finance & Budgeting hub.