The 50/30/20 Budget in Google Sheets (With Formulas)
Set up a 50/30/20 budget in Google Sheets with a Need/Want/Save column, copy-paste SUMIFS formulas, a worked example month, and when the rule doesn't fit.
In short
To run a 50/30/20 budget in Google Sheets, add a Type column (Need, Want or Save) to your expenses, then use SUMIFS to total each type for the month and compare it to 50%, 30% and 20% of your after-tax income. One dropdown column does the sorting, and the split updates automatically as you add rows.
To run a 50/30/20 budget in Google Sheets, tag every expense as Need, Want or Save in a dropdown column, then use SUMIFS to total each tag for the month and compare it with 50%, 30% and 20% of your after-tax income. Set it up once and the split updates by itself as you add rows. Below are the formulas to copy, a worked example, and when the rule doesn't fit.
What is the 50/30/20 rule?
The 50/30/20 rule divides your after-tax income into three buckets:
| Bucket | Share | What goes in it | Examples |
|---|---|---|---|
| Needs | 50% | Costs you'd have to pay even in a lean month | Rent or mortgage, groceries, utilities, insurance, transport to work, minimum debt payments |
| Wants | 30% | Things you choose, that make life better | Eating out, streaming, hobbies, travel, new clothes beyond the basics |
| Savings | 20% | Money for future you | Emergency fund, retirement, investments, extra debt payments above the minimum |
It was popularized by Elizabeth Warren and her daughter Amelia Warren Tyagi in their 2005 book All Your Worth. Its appeal is simplicity: three numbers instead of twenty budget categories.
Set up the sheet
You can add this to any expense sheet. If you don't have one yet, start with our free Google Sheets expense tracker template or the guide to tracking expenses in Google Sheets.
Step 1: Add a Type column
On your Expenses tab (Date in A, Category in B, Amount in C, Notes in D), add a column E called Type.
- Select column E.
- Choose Insert → Dropdown.
- Add three options:
Need,Want,Save. Give them colors (say green, orange and blue). - Set invalid entries to Reject the input.
Why a separate column instead of using categories? Because the same category can be both. A weekly grocery shop is a need; a fancy cheese board for a party is a want. A Type column lets you decide per purchase.
Step 2: Record savings as rows
Savings don't show up as spending unless you log them. When you move money to savings, an investment account or an extra debt payment, add a row:
| Date | Category | Amount | Notes | Type |
|---|---|---|---|---|
| 10/01/2026 | Savings | 400 | Transfer to emergency fund | Save |
| 10/01/2026 | Debt | 150 | Extra card payment | Save |
Minimum debt payments are Needs. Anything above the minimum is Save.
Step 3: Add a Settings tab for the month
So the formulas always look at the current month, create a Settings tab:
| Cell | Label | Formula |
|---|---|---|
| B2 | Month start | =DATE(YEAR(TODAY()),MONTH(TODAY()),1) |
| B3 | Next month start | =EDATE(B2,1) |
| B4 | After-tax income | Type your monthly take-home pay, e.g. 4000 |
If your income varies, replace B4 with a SUMIFS over your Income tab for the month.
The formulas
Create a tab called 50-30-20 and lay it out like this:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Bucket | Target | Actual | Left | % of income |
| 2 | Need | =Settings!$B$4*0.5 | formula below | =B2-C2 | =C2/Settings!$B$4 |
| 3 | Want | =Settings!$B$4*0.3 | =B3-C3 | =C3/Settings!$B$4 | |
| 4 | Save | =Settings!$B$4*0.2 | =B4-C4 | =C4/Settings!$B$4 |
The Actual formula in C2 (fill it down to C4):
=SUMIFS(Expenses!$C:$C, Expenses!$E:$E, A2, Expenses!$A:$A, ">="&Settings!$B$2, Expenses!$A:$A, "<"&Settings!$B$3)
It adds every amount whose Type matches the bucket name in column A and whose date falls in the current month. Format column E as a percentage (Format → Number → Percent).
Two useful extras:
- Untagged check:
=SUMIFS(Expenses!C:C, Expenses!E:E, "", Expenses!A:A, ">="&Settings!B2, Expenses!A:A, "<"&Settings!B3)shows spending you haven't tagged yet. It should be zero by month end. - Progress bars: in F2,
=SPARKLINE(C2,{"charttype","bar";"max",B2})draws a bar that fills as you approach the target.
For more on how SUMIFS and the date window work, see the formulas section of the Google Sheets expense tracker guide.
An example month
Here's October for someone with $4,000 take-home pay:
| Bucket | Target | Actual | Left | % of income |
|---|---|---|---|---|
| Need | $2,000 | $2,180 | −$180 | 54.5% |
| Want | $1,200 | $940 | $260 | 23.5% |
| Save | $800 | $700 | $100 | 17.5% |
| Total | $4,000 | $3,820 | $180 | 95.5% |
What this tells them:
- Needs ran 4.5 points over. Looking at the rows, a car repair ($260) pushed it up. That's a one-off, but it's a sign the emergency fund matters.
- Wants came in under. There's $260 of room.
- Savings were $100 short, and $180 is still unallocated. Moving that $180 to savings at month end brings savings to $880, or 22%.
The point isn't hitting the numbers exactly. It's seeing, in one glance, which bucket is drifting.
Make tagging effortless
The system only works if every expense gets a Type. Two tips:
- Tag when you log. Deciding "need or want?" is easy at the till and hard three weeks later.
- Use a default per category. Rent is always Need, streaming is always Want. Only think about the ones that vary, like groceries and clothes.
If you log from your phone with Voice Sheet, the app reads your Type dropdown along with your other columns, so "groceries 82 need" fills Category, Amount and Type in one go. The free version gives you a form with the dropdown; voice entry is part of Premium. The app's budget dashboard can also show spending against budget per category, alongside your 50-30-20 tab.
When 50/30/20 doesn't fit
The rule is a starting point, not a law. It fits poorly when:
- You live somewhere expensive. Rent alone can be 40–50% of take-home pay in big cities. A 60/20/20 or 65/20/15 split is more realistic, and still useful.
- You're paying off high-interest debt. Many people temporarily run 50/15/35, sending the extra to debt, because the interest saved beats almost any other use of the money.
- Your income is irregular. Base the targets on a low month's income, not an average, and put anything above it into savings.
- You earn a high income. 30% for wants may be far more than you need. Saving more than 20% is a perfectly good outcome.
If the rule doesn't suit you, the same sheet structure works for other methods: change the dropdown options and the target percentages. Zero-based budgeting, for example, uses a category per job with every dollar assigned.
Whatever split you choose, the habit that makes it work is the same: log each purchase, tag it, and look at the three numbers once a week.
Frequently asked questions
What is the 50/30/20 budget rule?
It splits your after-tax income into three parts: 50% for needs such as rent, groceries, utilities and minimum debt payments; 30% for wants like eating out, hobbies and travel; and 20% for savings and extra debt repayment. It was popularized by Elizabeth Warren and Amelia Warren Tyagi in their 2005 book All Your Worth.
How do I calculate 50/30/20 in Google Sheets?
Put your monthly after-tax income in a cell, then multiply it by 0.5, 0.3 and 0.2 for the three targets. Tag every expense as Need, Want or Save in a dropdown column, and total each tag for the month with SUMIFS. Subtract actual from target to see what's left.
Is the 50/30/20 rule based on gross or net income?
Net income: what actually reaches your bank account after taxes. If retirement contributions or health insurance are taken from your paycheck before it arrives, some people add them back and count them in the needs or savings share. Either approach works if you stay consistent month to month.
What if my needs are more than 50% of my income?
That's common in high-cost cities and on lower incomes. Treat 50/30/20 as a direction, not a pass or fail test. Start with the split you actually have, such as 65/20/15, and aim to move a few percent each year by trimming wants or raising income.
