A 50/30/20 budget sheet takes your monthly take-home pay, splits it into three buckets of 50, 30 and 20 percent, and compares what you actually spent in each against those targets. You enter the salary once, tag every expense as a Need, Want or Saving with a dropdown, and let SUMIFS do the totals.
How do I set up the targets?
On a tab called Budget, put your take-home pay in B1. Row 3 holds the headers: Bucket, Target percentage, Target amount, Actual, Actual share and Gap. Rows 4 to 6 hold the three buckets:
| Bucket (A) | Target percentage (B) | Target amount (C) |
|---|---|---|
| Need | 50% | =$B$1*B4 |
| Want | 30% | =$B$1*B5 |
| Saving | 20% | =$B$1*B6 |
Treat the percentages as inputs. The 50/30/20 split is a rule of thumb, not a law, and many households in expensive cities cannot reach it. Change B4, B5 and B6 to what suits you, and make sure they add to 100 percent.
How do I tag each expense?
Add an Expenses tab with Date in A, Item in B, Amount in C and Type in D. Select D2:D500, open Data, then Data Validation, choose List and enter Need, Want, Saving. Now each line is one tap away from belonging to a bucket.
- Need: rent, groceries, electricity, commute, insurance premium, minimum EMIs, school fees
- Want: eating out, streaming, shopping, trips, gadgets
- Saving: money moved to savings, recurring deposits, investments, extra loan prepayment
Some items sit between buckets, such as a phone plan. Decide once, write the decision in a Notes tab and stay consistent.
Which formulas compare actual against target?
- D4, actual spend per bucket: =SUMIFS(Expenses!$C$2:$C$500, Expenses!$D$2:$D$500, A4)
- E4, actual share of pay: =D4/$B$1
- F4, gap against target: =C4-D4, where a negative number means the bucket is over
- Unassigned money: =B1-SUM(D4:D6), which should end at zero or a small buffer
Add conditional formatting on E4:E6 with a custom formula such as =$E4>$B4 and a red fill, so an over-target bucket stands out.
A rent-heavy month in numbers
Say take-home pay is ₹60,000, so the targets are ₹30,000, ₹18,000 and ₹12,000. This month's tagged spending is invented as follows.
| Bucket | Target | Actual | Share of pay |
|---|---|---|---|
| Need | ₹30,000 | ₹39,000 | 65% |
| Want | ₹18,000 | ₹10,000 | 16.7% |
| Saving | ₹12,000 | ₹11,000 | 18.3% |
Needs of ₹39,000 come from rent ₹24,000, groceries ₹8,000, bills ₹3,000 and transport ₹4,000. Wants are 5,000 + 800 + 4,200 = ₹10,000. The three actuals add up to ₹60,000. Needs are ₹9,000 over target, and the sheet shows that wants were squeezed to make room.
What if my pay changes from month to month?
If part of your pay is variable, such as incentives or overtime, enter only the amount you are sure of in B1 and treat anything extra as a bonus to split afterwards. A sheet built on the lowest realistic pay survives a thin month, and a good month then simply raises the Saving bucket. For irregular yearly costs such as insurance, spread them across Need each month so the bucket stays honest.
What should I do with the result?
- If needs are far over target for several months, change the targets to reflect reality, say 60/25/15, rather than pretending.
- Protect the Saving line first by moving the money on salary day.
- Look at Wants for one or two items that gave little pleasure and trim those.
- Review the split every few months, and after a raise or a move.
If you would rather not tag every line by hand, SpendixAI can import bank and card statements and categorise them, and the totals by category can then be grouped into your three buckets. It is not a zero-based budgeting system; it has budgets on Pro, which you can compare with this rule of thumb.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


