Opens in a new tab

Free 50/30/20 Budget Calculator Spreadsheet for Excel & Google Sheets

Free 50/30/20 budget calculator for Excel and Google Sheets. Enter your annual income and instantly see suggested monthly, weekly, bi-weekly, and yearly amounts for needs, wants, savings, and debt. Includes a doughnut chart, editable percentages, category guidance, and 17 income examples from $20,000 to $100,000.

United States dollar ($) - USD
  • United States dollar ($) - USD
  • Euro (€) - EUR
  • Pound sterling (£) - GBP

$0.00

See it in action

Plan Your Money with the 50/30/20 Budget Rule

This free 50/30/20 budget calculator helps you organize your income into three practical spending categories: needs, wants, and savings and debt.

Enter your annual take-home income and the spreadsheet automatically calculates your suggested budget by month, week, bi-weekly period, and year. You can also adjust the percentages to match your own financial goals.

See Your Budget Allocation at a Glance

The main budget sheet gives you a clear view of where your money goes:

  • 50% for needs such as housing, groceries, utilities, transportation, insurance, and minimum debt payments.
  • 30% for wants such as restaurants, subscriptions, travel, shopping, entertainment, and coffee.
  • 20% for savings and debt, including emergency savings, retirement, investments, extra debt payments, larger goals, and education.

A doughnut chart makes the distribution easy to understand, while the built-in percentage check helps confirm that your allocation totals 100%.

Monthly, Weekly, Bi-Weekly, and Yearly Calculations

Use your annual income as the starting point and review the suggested allocation across different time periods. This makes it easier to turn a yearly budgeting rule into practical spending targets.

17 Income Examples Included

The second worksheet includes income examples from $20,000 to $100,000 in $5,000 increments. Compare the suggested needs, wants, savings, and debt amounts at different income levels while using the percentages from the main budget sheet.

What Is Included

  • Free XLSX budget calculator.
  • 50/30/20 needs, wants, and savings and debt allocation.
  • Editable annual income field.
  • Monthly, weekly, bi-weekly, and yearly calculations.
  • Customizable percentage split.
  • Category guidance for common expenses and financial goals.
  • Doughnut chart showing your budget distribution.
  • Percentage total check.
  • 17 income examples from $20,000 to $100,000.
  • Excel and Google Sheets compatible XLSX format.

Download this free spreadsheet, enter your income, and use the 50/30/20 method as a simple starting point for your budget.

 

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

FAQ's

The 50/30/20 rule divides your income into 50% for needs, 30% for wants, and 20% for savings and debt repayment.

Yes. This spreadsheet is completely free to download and use.

Yes. It is provided as an XLSX file designed for Microsoft Excel.

Yes. Upload the XLSX file to Google Sheets to use it there. Some formatting or chart details may display slightly differently.

Yes. The Needs, Wants, and Savings and Debt percentages are editable as long as the total allocation remains 100%.

The calculator shows suggested allocations by month, week, bi-weekly period, and year.

The examples worksheet covers annual incomes from $20,000 to $100,000 in $5,000 increments.

For a more practical budget estimate, enter your yearly take-home income after taxes and deductions.

Yes. The main budget sheet includes a doughnut chart showing the distribution between Needs, Wants, and Savings and Debt.

Yes. The 50/30/20 rule is a starting point, and you can adjust the percentages to fit your financial priorities.