The 50/30/20 Budget in a Spreadsheet: How to Set It Up (Free Template)
The 50/30/20 rule splits take-home pay into three buckets: about 50% for needs, 30% for wants and 20% for savings and extra debt payments. It's a good first check on where your money goes. It's a poor strict target, and the spreadsheet should tell you which bucket is off, not make you feel bad about it.
What goes in each bucket
- Needs: housing, utilities, groceries, insurance, transport to work, phone, minimum debt payments.
- Wants: eating out, streaming and other subscriptions, hobbies, most clothing, gifts, travel spending.
- Savings: emergency fund, retirement contributions you make yourself, sinking funds, and any debt payment above the minimum.
Grey areas are normal. Groceries are a need; the fancy coffee beans in the grocery bag are arguably a want. Pick one rule and stay consistent; precision matters less than honesty.
Set it up in 4 columns
- List your categories in column A.
- In column B, mark each one Need, Want or Save (a drop-down list keeps the spelling consistent).
- Column C is what you plan to spend. Column D is what you actually spent.
- Total each bucket with SUMIF, then divide by take-home income:
=SUMIF(B:B,"Need",D:D)/income
Plan so that planned income minus planned spending lands at or near $0. That isn't "spend everything": savings is a category, so every dollar has a job.
A realistic month (needs at 67%)
Here's the sample month from our free template: take-home income of $4,380.
| Bucket | Actual | % of income | Guide |
|---|---|---|---|
| Needs | $2,923.90 | 67% | 50% |
| Wants | $390.85 | 9% | 30% |
| Savings & extra debt | $985.00 | 22% | 20% |
| Left over | $80.25 | 2% |
Needs are well over 50%, mostly because rent is $1,450. But this person is still saving 22% by keeping wants low. That's a perfectly healthy budget that "fails" the rule. The useful insight is different: groceries ran $51 over plan and eating out ran $57 over, so food overall is the place to look next month.
When needs are over 50%
- Protect savings first. If something has to give, let it be wants, not the 20%.
- Look at the two biggest needs only. Housing and transport usually dominate. Small cuts to small bills rarely move the percentage.
- Check you've sorted honestly. A gym membership, a premium phone plan or a second streaming service filed under "needs" quietly inflates the number.
- Use your own target. 60/20/20 or 65/15/20 is a perfectly good plan if it's what your rent allows.
Free template
Our Simple Monthly Budget is a free one-page spreadsheet that does all of the above: planned vs actual for up to 25 categories, Need/Want/Save drop-downs, colour-coded progress bars, and an automatic 50/30/20 check with a chart. It works in Google Sheets and Excel and comes with sample data and a blank copy.
If your income changes month to month, read how to budget on an irregular income next. A fixed 50/30/20 split is hard to apply until you have a steady paycheck to split.
General education only, not financial advice.