50/30/20 Budget Excel Template

One page, three buckets, one rule. Enter income, needs, wants and savings for the month; three gauges show how far you are from 50/30/20 and plain sentences tell you exactly what to move.


  • One-time payment · no subscription · instant download
  • Two files included: a Sample Data version (a realistic two-earner household) so you can see the gap logic working, and a Blank version with one example row per table.
  • This templates also available in the Budget Starter Pack ($49) and Life OS ($99).

Original price was: $ 49.Current price is: $ 19.

61% Off

  • Works with Excel 2016+ & Microsoft 365

  • Instant download

  • Fully customisable — no password

  • Secure checkout

Budget & Finance · Personal budgeting

What’s inside — one sheet you fill in, one you set once

Most budgets tell you what you spent. This one tells you whether the shape of your spending is right.

Click to view full image

Sheet 1 · You fill this in

50-30-20 Budget

Four input tables — Income, Needs, Wants, Savings — each with Budget, Actual and a colour-coded Difference. The dashboard above them updates live.

  • KPI cards for income and each bucket, with the gap in points and money
  • Three half-ring gauges: your actual share around the target ring
  • “What needs to move” — exact amounts to shift between buckets
  • Budget health score (6 checks) and Income check for unassigned money or a deficit
  • Budget vs Actual by bucket chart; prints on one Letter / A4 page
Click to view full image

Sheet 2 · Set once

Setup

Make the rule fit your life, then leave it alone.

  • Split presets: 50/30/20 · 60/20/20 · 70/20/10 · 50/20/30 · Custom
  • Tolerance band — how far a bucket may drift before it’s flagged
  • 49 currencies + custom symbol; 16 languages + custom labels
  • Default, Edit, Print and Dark view modes
Click to view full image

Sheets 3–4 · Read, don’t touch

Instructions & Calc

A one-page how-to, and a hidden Calc sheet that holds the rule engine, health checks, insights and chart data.

  • Input cells are unlocked, formulas are locked — protect the sheet and keep typing
  • Nothing hidden from you: unhide Calc and read every formula
  • No macros, no external links

How it works

This pack is right if you…

  • Want a simple rule instead of forty categories

  • Are a couple aligning on one plan for the month

  • Have fixed costs above 50% and need a 60/20/20 or custom split

  • Want a five-minute monthly check-in, not a bookkeeping system

  • Like a one-page dashboard you can print

Look at a different option if you…

Can’t decide? The Budget Starter Pack ($49) includes this and every other budgeting method.

What makes it different

Three gauges showing actual share vs target for needs, wants and savings, with gap in points and dollars

Gauges that show the gap, not just the number

Each half-ring draws your actual share around the target ring. The big number is your actual %, the caption gives the gap in points and money, and the status reads over, under or within tolerance — so you see at a glance which bucket is the problem.

“What needs to move” — in plain sentences

Below the gauges, a table lists target %, actual %, gap and status for each bucket, and sentences underneath say exactly how much to shift and where: “Needs: $506 over target — move $506 to Wants.” When all three are within tolerance, it tells you the month follows the rule.

"What needs to move" table with plain-English sentences saying how much to shift between buckets
Setup sheet with split rule presets 50/30/20, 60/20/20, 70/20/10, custom percentages and tolerance

The rule bends to your fixed costs

  • Presets for 50/30/20, 60/20/20, 70/20/10 and 50/20/30, or type your own three percentages
  • Tolerance setting, so a 1-point drift isn’t flagged as a failure
  • Six-check Budget health score and an Income check that catches unassigned dollars or a deficit

Your currency, your language, your screen

49 currencies plus a custom symbol; 16 languages plus custom labels. Edit mode highlights every input, Print mode strips the colour bars for paper, Dark mode is easy on the eyes for an evening review.

Setup sheet with split rule presets 50/30/20, 60/20/20, 70/20/10, custom percentages and tolerance

Specifications

Each pack is built for one situation; Life OS includes all three plus every planner.

You receive Two Excel files: Sample Data (pre-filled September 2026 two-earner household) and Blank (one example row per table). Download link by email immediately after payment.
File format .xlsx (Excel). Instructions sheet included in the workbook
Works with Excel 2016, 2019, 2021, 2024 and Microsoft 365 on Windows and Mac; Excel for the Web for viewing and light editing. Not built for Google Sheets
Macros None. No external links. 100% formula-based
Sheets Instructions · Setup · 50-30-20 Budget · Calc (hidden)
Scope One month per file — a fast monthly check-in. For 12-month planning see the Personal Budget Planner & Tracker
Split rule Presets 50/30/20 · 60/20/20 · 70/20/10 · 50/20/30 · Custom, with adjustable tolerance
Customisation 49 currencies + custom symbol; 16 languages + custom labels; Default, Edit, Print and Dark view modes. No password — every cell, label and formula is editable

Budget Packs

Other options

Got the budget covered? The Starter Pack adds every other budgeting method, the Ultimate templates go beyond budgeting into debt, savings and net worth, and Life OS is everything we make.

Click to view full image

Budget Starter Pack

Simple, Monthly, Paycheck, Personal Budget Planner & Tracker, Zero-Based and 50/30/20 budgets plus the Bill Payment Calendar. Seven templates.

$49 separately $150

Click to view full image

Ultimate Personal Finance Excel Templates

26 personal finance templates in one workbook, one tab each — budgets, expense & bill tracking, debt payoff, savings, insurance, tax prep, investments and net worth — plus 30 bonus templates. 54 tools, one download.

$69 separately $1,100+

Click to view full image

Life OS™

Every budget and finance template we make, plus planners, calendars, ADHD tools, habit, meal and workout trackers.

$99 separately $1600+

Questions before you buy

Is the 50/30/20 split fixed?

No. Pick 60/20/20, 70/20/10, 50/20/30 or Custom in Setup, and every gauge, target and correction sentence follows the new split. A tolerance setting decides how far a bucket may drift before it’s flagged.

Does it track a whole year?

It’s a one-month snapshot by design — a fast monthly check-in. Keep one file per month, or for twelve-month planning with a transaction log see the Personal Budget Planner & Tracker.

What is the difference between this and the Zero-Based Budget?

Zero-Based assigns every dollar to a specific line until nothing is left. 50/30/20 checks the shape of your spending against three buckets. Zero-Based is more control; 50/30/20 is faster and needs fewer categories. Both are in the Budget Starter Pack.

Where does debt payoff go?

Minimum payments are Needs; extra principal counts as Savings, as the rule intends. The table headers say so, so you don’t have to remember.

What’s the difference between the two files?

Sample Data is a filled example — a realistic two-earner household that deliberately runs Needs above 50% so you can see the gap logic working. Blank has one example row per table so you see the pattern and start typing.

Can I change the currency or language?

Yes. 49 currencies and 16 languages are built in, plus Custom for both — type your own symbol or your own labels in Setup.

Does it connect to my bank?

No. It’s a plain Excel file — nothing leaves your computer and there are no accounts. Type your numbers in or paste them from a bank export.

Does it work on a Mac or in Google Sheets?

Excel for Mac 2016 or later, yes. Google Sheets is not supported — the gauges and view modes rely on Excel features.

Can I add more rows to the tables?

Yes. Insert rows inside any table and the totals, gauges and checks pick them up. Every cell is editable; there is no password.

Is it a one-off payment?

Yes. $19 once, keep it forever, free updates. No subscription.

Is it cheaper in a pack?

Yes. The Budget Starter Pack includes this template and six others for $49, and Life OS includes everything we make for $99. Buy this one first and contact us with your order number if you upgrade — we’ll credit it.

Take Control of Your Money
with Analysistabs Templates

Whether you’re budgeting for yourself, your family, or your business, our templates give you the automatic calculations, dashboards, and insights you need to plan, save, and stay on track.

Original price was: $ 49.Current price is: $ 19.

61% Off

50/30/20 Budget Excel Template – dashboard with needs, wants and savings gauges against the 50/30/20 target

Get Instant Access in 3 Simple Steps

Yes! Pay once for use it forever. No monthly subscriptions, no hidden fees.
Questions? Contact us at Info@analysistabs.com

Why choose us!