Personal Finance • Published on Nov 22, 2026 • By SheetVault Editorial Team • Free .XLSX

Free 50/30/20 Monthly Budget Planner Spreadsheet for Excel & Google Sheets (Download)

=C2-B2

What Is the 50/30/20 Budget?

The 50/30/20 rule splits after‑tax income into three buckets: 50% for essential needs, 30% for discretionary wants, and 20% for savings or debt repayment.

Benefits of Using This Planner

  • Instant visual of how much you should spend in each category.
  • Automatic calculations keep your plan up‑to‑date.
  • Shows variance between planned and actual spending.

Step‑by‑Step Setup

  1. Open the spreadsheet and go to the Budget Planner tab.
  2. Enter your total monthly after‑tax income in the Actual column of the Income row (cell C2).
  3. The Planned amounts for Needs, Wants, and Savings are calculated automatically with the 50/30/20 formulas.
  4. Record your real spending in the Actual column for each category.
  5. Watch the Variance column (C‑column minus B‑column) highlight over‑ or under‑spending.

Pro Tips

  • Adjust the percentages in the formulas if your personal goals differ (e.g., =B2*0.55 for a 55% needs allocation).
  • Copy the rows for additional expense sub‑categories and reference the same income cell (B2) for consistent percentages.
  • Use conditional formatting on the Variance column to flag negative values in red.

Download Ready-to-Use Spreadsheet

Instant .xlsx file download with pre-loaded formulas, formatted totals, and clean design.

Download Template (.xlsx)

Frequently Asked Questions

Can I change the income amount later?

Yes—just edit the Actual value in the Income row (C2). All dependent formulas recalculate automatically.

How do I add more expense categories?

Insert a new row below the appropriate section, enter the category name, and use the same Planned formula (e.g., =B2*0.05) or a fixed amount, then copy the Variance formula =C(row)-B(row).