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
- Open the spreadsheet and go to the Budget Planner tab.
- Enter your total monthly after‑tax income in the Actual column of the Income row (cell C2).
- The Planned amounts for Needs, Wants, and Savings are calculated automatically with the 50/30/20 formulas.
- Record your real spending in the Actual column for each category.
- 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).