Free 50/30/20 Budget Spreadsheet
The simplest budgeting rule: 50% needs, 30% wants, 20% savings. Enter your income and the spreadsheet shows your targets, then tracks your actual split against them. Free for Excel or Google Sheets.
Download for Excel (.xlsx)Works in Google Sheets too — open Google Sheets and choose File → Import.
What's inside
- Income calculator that shows your 50% / 30% / 20% targets instantly
- Separate Needs and Wants trackers with % of income columns
- Savings & Debt section for your 20% allocation
- Monthly Summary comparing your actual split to the targets
- Adjustable for high cost-of-living or aggressive debt payoff
- Works in Excel and Google Sheets — free, no email required
How to use it
- 1Download the template (or open it in Google Sheets via File → Import).
- 2Enter your monthly after-tax income to see your needs / wants / savings targets.
- 3List your expenses in the Needs and Wants trackers and your savings in the Savings tab.
- 4Check the Monthly Summary to see whether your actual split matches the 50/30/20 targets.
Skip the manual data entry
ReceiptSync scans your receipts and pushes the data straight into a spreadsheet like this — no typing. Snap a photo and it's logged and categorized.
A simple spreadsheet is the most reliable way to take control of your money — you own the data, there's no subscription, and it works offline. This template is pre-built so you can start today instead of designing tabs and formulas from scratch. For a full walkthrough and tips, see the 50/30/20 guide and the interactive 50/30/20 calculator.
Frequently asked questions
What if my needs exceed 50% of my income?
This is common in high cost-of-living areas. Either reduce needs (cheaper housing, refinanced debt, lower insurance) or increase income. In the meantime, adjust your targets — a 60/20/20 split is still far better than no budget.
Should I include my 401(k) contribution in the 20%?
Yes — pre-tax retirement contributions count toward your 20% savings target, and an employer match counts too. Many people are already saving 10–15% through their 401(k) without realizing it.
Is 50/30/20 good for paying off debt?
It's a starting point. With high-interest debt, consider shifting to 50/20/30 (30% toward savings and debt payoff) until the debt is gone, then shift back.
Can I automate tracking each expense?
Yes — ReceiptSync scans your receipts and exports the data to the spreadsheet, so your needs/wants/savings totals calculate automatically without manual addition.