50/30/20 Budget Calculator (Free Spreadsheet)

The 50/30/20 rule is the simplest budgeting framework that actually survives contact with real life: put roughly 50% of take-home pay toward needs, 30% toward wants, and 20% toward savings and extra debt payments. It’s forgiving, it doesn’t require tracking every coffee, and it gives you three numbers instead of thirty.

The catch is that most people have no idea what their real split is. This calculator answers that in about ten minutes: enter your income, tag each spending category as a need, want, or saving, and the comparison table shows your actual split against the targets — including exactly how many dollars over or under you are in each bucket.

Every formula in the file was verified by recalculating a full worked example before publishing; that example ships in the second tab.

How it works

1. Enter your monthly take-home income — what lands in your account after taxes and deductions, not your salary. In the example: $4,200. The calculator instantly computes the three targets: $2,100 for needs, $1,260 for wants, $840 for savings.

2. List your actual monthly spending. Fifteen common categories are pre-filled (rent, groceries, subscriptions, retirement…), with blank rows for your own. Put last month’s real number next to each — bank and card statements beat guessing.

3. Tag each category using the dropdown: Needs, Wants, or Savings. The SUMIF formulas total each bucket automatically.

4. Read the comparison. The example’s outcome is typical and worth walking through: needs came to $2,845 — $745 over the $2,100 target, wants were $615 under, and savings $170 under. Total tracked spending was $4,160 against $4,200 of income.

What to do when needs are over 50%

The example’s pattern — needs over, wants under — is the most common result, and it matters: it usually means the rule isn’t the problem, housing cost is. Three honest observations before you conclude you’re bad with money:

High needs is a structural problem, not a discipline problem. If rent alone is 35% of take-home, no amount of skipped lattes rebalances the budget. The levers that move a needs overage are the big ones: housing, car payments, insurance shopping.

The percentages are guidelines, not laws. In a high-cost city, a 60/20/20 or even 65/15/20 split can be a perfectly healthy budget. What the calculator gives you is the truth about your current split — then you decide the target that’s realistic and protect the savings line first.

Watch the boundary between needs and wants. The most useful part of this exercise is often the tagging itself. Base phone plan: need. The unlimited-everything upgrade: want. Groceries: need. Meal-kit delivery: mostly want. Being honest at the margins frequently “finds” a few hundred dollars without any actual sacrifice.

Where minimum debt payments go

A detail many 50/30/20 guides get wrong: minimum debt payments are a need — you don’t have a choice about making them. Extra payments beyond the minimum are savings, because they build your net worth the same way saving does. The template’s default categories are pre-sorted this way: “Minimum debt payments” sits in Needs, “Extra debt payments” in Savings.

Using it in Google Sheets

1. Google Sheets → blank sheet → File → Import → Upload → select the file → Replace spreadsheet.
2. Formulas, dropdowns, and both tabs carry over.

Re-run it once a quarter — 15 minutes with fresh statements. The split drifts (subscriptions creep, raises land, rent changes), and watching your needs percentage fall over time is one of the more motivating numbers in personal finance.

Frequently asked questions

Should I use gross or take-home income? Take-home. The rule is about money you can actually allocate. If your employer deducts retirement contributions before payout, you can count them in your 20% mentally — you’re saving more than the sheet shows.

Is this template really free? Yes — free for personal and commercial use, no signup. If a number looks wrong, tell us; we re-verify the formulas against the worked example and fix the file.

Nothing on this site is financial advice — the calculator shows you your split; what to do with it depends on your situation, and for big decisions a licensed advisor is the right person to ask.