50/30/20 Budget Spreadsheet for Google Sheets and Excel

A 50/30/20 budget spreadsheet splits your take-home pay into three buckets (50% for needs, 30% for wants, 20% for savings and extra debt payments) and then checks what you actually spent against those targets. Working out the split takes a minute; the value of the spreadsheet is the monthly check. It suits beginners who want one simple rule, and anyone who wants to know whether their spending matches their priorities without budgeting dozens of categories.

What the 50/30/20 dashboard tracks

In our budget spreadsheet, each transaction you log carries a tag: need, want, or savings and debt. The 50/30/20 tab totals those tags for any month you choose and compares each bucket with its target.

The targets start at 50/30/20, and you can change them. A 60/20/20 or 55/25/20 split works the same way, which matters if your rent alone takes a third of your pay. The tab works the same with a zero-based or a carry-over budget.

50/30/20 budget example on $4,200 a month

The calculator above starts with $4,200 of monthly take-home pay. At 50/30/20 it gives:

• Needs: $2,100 a month, $25,200 a year
• Wants: $1,260 a month, $15,120 a year
• Savings and extra debt payments: $840 a month, $10,080 a year

If your three percentages do not add up to 100, the calculator warns you before you rely on the numbers.

Those are targets. Here is what a real month might look like against them, with example numbers:

• Needs ($2,520): rent $1,350, utilities and internet $200, groceries $500, car payment $190, car insurance $125, gas $100, phone $55
• Wants ($1,050): dining out $320, hobbies and outings $230, clothing $140, concert tickets $140, gifts $90, personal care $85, subscriptions $45
• Savings and debt ($630): emergency savings $280, extra debt payment $200, sinking funds $150

Bucket	Target	Target amount	Actual	Actual share	Difference
Needs	50%	$2,100	$2,520	60%	$420 over
Wants	30%	$1,260	$1,050	25%	$210 under
Savings and debt	20%	$840	$630	15%	$210 under
Total	100%	$4,200	$4,200	100%

Wants came in under target, which looks like good news. The check shows the real issue: rent alone is about 32% of take-home pay, needs are 60%, and savings are $210 short.

Now change the targets to 60/20/20, which you can also type into the calculator above: needs $2,520, wants $840, savings $840. Needs are exactly on target, wants are $210 over, and savings are $210 under. The fix is now plain: move $210 a month from wants to savings, for example by cutting dining out and outings. The first view told you something was off; the adjusted targets tell you what to change.

How to set up the 50/30/20 tab

1. On the setup tab, enter your income sources and your categories, grouped as bills, expenses, savings, subscriptions and debts.
2. Enter recurring bills once with their frequency and start date, so they are scheduled for the year. Log other spending as it happens.
3. Tag each transaction as a need, a want, or savings and debt. Minimum debt payments are needs; anything above the minimum is savings and debt.
4. Open the 50/30/20 tab and pick the month you want to check.
5. Compare each bucket with its target. If needs run over month after month, change the targets to match your real costs instead of ignoring the result.
6. Review it at the end of each month, alongside the dashboard, and pick one change for next month.

The 50/30/20 rule, briefly

Needs are what you must pay to live and work: housing, utilities, groceries, insurance, transportation to work and minimum debt payments. Wants are everything you could skip without real harm, from streaming to vacations. Savings and debt covers your emergency fund, sinking funds and any payment above a debt’s minimum.

The rule works on take-home pay, and its strength is that it asks for three decisions instead of thirty. Our guide with 50/30/20 rule examples shows the split at four income levels, a needs and wants list, and how to adjust when rent breaks 50%. For categories to tag, use the budget categories list.

Tricky tags

A few expenses cause most tagging doubts. Decide once, write the rule down, and tag the same way every month:

• Phone and internet: the basic plan is a need; a newer phone or a faster tier is a want.
• Childcare, pet food and prescriptions: needs.
• Gym, streaming and apps: wants, even the ones that feel essential.
• Work clothes: a need when your job requires them; everything else in the closet is a want.
• Sinking fund money: count it once, either when you set it aside (savings) or when you spend it. Counting both makes the month you spend it look far over target.

If three buckets feel too loose, compare other approaches in budgeting methods compared, or give every dollar a specific job with zero-based budgeting. The two combine well: plan with zero-based, check with 50/30/20.

Your savings and debt bucket has two natural homes in the same file. The extra debt payment goes into the debt snowball spreadsheet, and the sinking fund money goes into the sinking funds tracker.

Build your own 50/30/20 budget spreadsheet

You need two tabs. On a Log tab, put the date in column A, a description in B, the amount in C and the bucket (Need, Want or Savings) in D.

On a Summary tab, type your monthly take-home pay in B1 and the first day of the month you are checking in B2. List Need, Want and Savings in A5 to A7 and their target percentages in B5 to B7. Then, in row 5 (fill down to row 7):

• Target amount (C5): =$B$1*B5
• Actual (D5): =SUMIFS(Log!$C:$C,Log!$D:$D,A5,Log!$A:$A,">="&$B$2,Log!$A:$A,"<="&EOMONTH($B$2,0))
• Actual share (E5): =D5/$B$1, formatted as a percent
• Difference (F5): =D5-C5, where a positive number means over target

Check that your targets add up with =SUM(B5:B7)=1 in any spare cell; it should say TRUE. These formulas are identical in Google Sheets and Excel.

The steps that differ between the two apps:

• Bucket dropdown, Google Sheets: select column D on the Log tab, choose Insert > Dropdown, and add Need, Want and Savings as the options.
• Bucket dropdown, Excel: select column D, choose Data > Data Validation, set Allow to List and type Need,Want,Savings as the source.
• All-time totals in one formula, Google Sheets: =QUERY(Log!A:D,"select D, sum(C) where D is not null group by D",1)
• All-time totals, Excel: QUERY does not exist in Excel. Use Insert > PivotTable with Bucket in Rows and Amount in Values.

Who a 50/30/20 spreadsheet suits

It suits you if you are new to budgeting, if detailed category budgets have worn you out before, or if you and a partner want one shared yardstick for every month. It is also a quick way to see whether high fixed costs are crowding out savings.

It is a weaker fit if your income swings a lot from month to month, because the targets move with it; budgeting with irregular income covers a baseline approach instead. If you are paying off debt aggressively and want every dollar assigned in advance, a zero-based plan gives you more control, with the 50/30/20 tab as a monthly check.

Tag your transactions for one full month before you change anything. The first honest split tells you more than any target you set in advance.