50/30/20 budget rule spreadsheet

Or try it now: use the free 50/30/20 monthly budget calculator. You can keep the usual split or type your own percentages, compare plan versus actual, and download a CSV. It is an educational tool, not financial advice.

What the 50/30/20 rule says

The 50/30/20 rule is a simple way to split take-home income into three buckets: about 50% for needs, 30% for wants, and 20% for savings and extra debt payments. It is often attributed to a budgeting framework popularised in personal-finance books in the 2000s. It is a rule of thumb, not a law, and not a plan that fits every household. This guide shows how to apply it in a spreadsheet, how to sort transactions without getting stuck, and what to do when the percentages do not match your rent or your income.

Used calmly, the rule is a check you run after you already have a monthly budget. It answers a narrow question: of the money that arrived this month, how much went to needs, to wants, and to savings? It does not tell you what you should spend on groceries, and it is not financial advice.

Start from take-home income

Use the income that actually arrives — after tax and mandatory deductions — because the percentages are meant to be applied to money you can allocate. If you enter gross pay, the “needs” bucket will look too small once tax has already left the account. List all take-home sources for the month: pay, regular side income, benefits, a housemate’s contribution. For a variable month, you can apply the percentages to that month’s actual income, or to a typical figure you have already chosen, as long as you label which one you used.

The three target amounts are then straightforward:

• Needs target = income × 0.50
• Wants target = income × 0.30
• Savings target = income × 0.20

Illustration only, with fictional figures: if take-home income is 4,000, the targets are 2,000 for needs, 1,200 for wants, and 800 for savings. If actual needs come to 2,150, wants to 900, and savings to 800, needs are over the line and wants are under it. The sheet should show that clearly. It should not scold you, and it should not move money on its own.

Sorting needs, wants, and savings

A need is a cost you would have trouble dropping quickly without disrupting housing, health, or the ability to get to work: rent or a mortgage payment, basic utilities, groceries at an ordinary level, required insurance, minimum debt payments, a commute you cannot replace this month, essential medication. A want is a cost you could postpone or cut without that kind of disruption: restaurants, streaming, hobbies, nicer groceries, most clothing beyond replacements, gifts beyond a modest plan.

Savings, in this rule, usually includes money you set aside plus extra payments that reduce debt faster than the minimum. Required minimum payments are typically needs. The distinction matters: if you put the whole debt payment in savings, your needs will look artificially low.

Some rows will not sit neatly in one bucket. A phone plan can be a need at a basic level and a want in the part that is a family of extra lines. A car can be the commute and also a weekend habit. When a row is mixed, either split the amount or assign it to the stricter bucket and accept a little roughness. A spreadsheet that asks you to classify every coffee will not be filled in by the third week.

Subscriptions are often wants, but a required work tool might be a need. If you already keep a subscription renewal list, you can tag each service there and bring only the monthly totals for each bucket into the budget, so you are not sorting the same charges twice.

A sheet layout that stays usable

On top of an ordinary monthly budget, add a column that tags each expense and savings row as Need, Want, or Savings. Then sum the actuals for each tag and place those three sums next to the three targets. A further column can show the difference (actual minus target). You already have leftover and a savings rate from the budget itself; the 50/30/20 block is a second view of the same month, not a second set of transactions.

Keep plan and actual for your usual categories — rent, groceries, transport — because those rows are what you will adjust. The three-bucket totals are a summary. If you only track the three buckets and never the underlying categories, you will not know whether “needs” ran high because of rent or because groceries absorbed a party month.

Colour the tag cells, or use a simple drop-down, so a row cannot be left unsorted and silently dropped from all three sums. If a row is a savings transfer, tag it Savings and, as in a standard budget, do not also count it as an expense.

When the rule does not fit

In some cities, rent and a basic commute already take more than half of take-home pay. In that case a 50% needs target is not a moral failing and not a reason to abandon the file. You can record the real percentages and treat 50/30/20 as a reference line, not a grade. A household paying 60% toward needs can still watch whether that share is stable, rising, or falling, and whether the remaining 40% is going mostly to wants or mostly to savings.

Irregular income, parental leave, a year of study, or a large official bill (a yearly tax payment, a security deposit) will also break a tidy month. Label those months. Do not average them away unless you are deliberately building a year view. The rule is easier to apply in a typical month than in a month that contains a once-a-year event.

The 20% savings slice may also be too high or too low for a season of life. Employer contributions you never see in the checking account should be included if you want the percentage to be honest. Someone paying down a high-interest balance may send more than 20% there for a while. The spreadsheet should follow the decision you already made, not the other way around.

Use it once a month, then stop

The value of the rule is a short conversation: is this month roughly in the shape we expected? If wants ran well above 30% and savings were close to zero, you have a fact to talk about. If needs are structurally above 50%, the useful question is not “how do I force the rule,” but “which needs are fixed for now, and what is left.” That is the same work a budget already does; the three percentages just make the shape easier to see.

You do not need a bank connection to do this. An ordinary spreadsheet that stays on your computer is enough. Do not store passwords or full account numbers in the file. Confirm amounts with your statements. This is an organizational method, not financial or tax advice, and not a claim that households who follow the rule will reach any particular goal. For a longer-range yardstick, a FIRE number calculator is a separate, simplified tool — and also not advice.