|

The 50/30/20 Budget Spreadsheet and Calculator (with Examples)

The 50/30/20 Budgeting Method is one of the easiest ones to use to get your finances in order easily. If you want to get better at seeing where your finances are, and focus on building wealth. Get details on the method for budgeting, along with a free budgeting spreadsheet and calculator that you can use yourself! The template can be used in Excel and Google Sheets as well.
Pin It!

As it is the start of a new year, many people began to get their minds refocused on all-things-budgeting. I love starting of the new year right with organized finances, and I want to show you that it is not hard at all with the right framework! The framework that I’m referring to is the 50/30/20 Budget.

I’ve been using this method to track my expenses for several years, and it is just so easy to follow! In this post I’ll explain what this budget is, how to use it, and provide a FREE 50/30/20 budget spreadsheet and calculator that you can use to get started right away!

The 50/30/20 Budget Spreadsheet

If you just want the download and don’t want to wait until the end – you can grab your 50/30/20 spreadsheet below. It includes both the 50/30/20 budget template and calculator. For more information / instructions – keep reading!

Why Set a Budget?

Maybe the most important question of them all, as I’ve mentioned in this post . For those of you who have been following me for a while, you may wonder why I’m focusing on this topic at all. As part of my (in-progress) re branding, I’ll be incorporating some money tips from time to time, as it is a major factor in traveling as much as possible.

If you know where your money is going and track expenses, you are put in a position where you can allocate your money to the things you like to do too. And if you stick to your budget, you are very likely to hit still hit your savings targets / reduce debt without any issues. Isn’t that a place where we all want to be? The 50/30/20 budget spreadsheet that I’ll provide in this post will help you do just that.

Take control of your family's finances.

The 50/30/20 Budget Explained

The 50/30/20 Budget is one that was made popular by the book “All Your Worth: The Ulitmate Lifetime Money Plan”, written by Senator Elizabeth Warren and her daughter, Amelia Warren Tyagi. The intention of this book is to help the reader master their finances by allocating a set percentage to three categories of money:

50% – Needs or Must-Haves

The “needs” are the items that you have to purchase in order to survive and those bills that you have to pay off each month. This may vary a bit from person to person, but here are a few examples:

  • Groceries
  • Utilities
  • Rent / Mortgage / Car Payments
  • Health Insurance
  • Minimum Debt Payments

Note that this category does not include seemingly related items, such as restaurants, as eating out is not necessary but eating is. Keep that in mind as you make the budget your own.

30% – Wants

The “wants” category includes all the expenses you make to enhance your quality of life. Example categories include:

  • Entertainment (Movies, concerts, etc.)
  • Cable TV
  • Eating Out
  • Travel 😉
  • Hobbies

This category will vary the most as “wants” are very particular to the individual. Add what’s most important to you here when you personalize your spreadsheet.

RELATED: How to Budget for Travel

20% – Savings / Debt

This category is entirely devoted to increasing the size of your bank accounts. The smallest of the three categories, this one includes the following:

  • Saving Accounts (Includes building an emergency fund)
  • Retirement Accounts
  • Investments (ETFs, Stocks, Real Estate, etc.)
  • Debt Repayment (Anything greater than the minimum)

The last item may seem like it doesn’t fit, but keep in mind that any payments that you make greater than the principal will give you savings in the long run.

Download the FREE 50/30/20 Budget Template and Calculator

So now that you know what the budget is, let’s start taking action to put this budget into use now! In the download below, you’ll access a Google Sheets spreadsheet.

This spreadsheet has two tabs: The first helps you calculate the amount of money that goes into each category, while the second is an automated template that you can use to keep track of your monthly budget.

Note: It does not matter if you are starting in January or December, it’s never to late in the year to start budgeting!

How to Use the 50/30/20 Calculator

The first tab of the spreadsheet includes the 50/30/20 Calculator. To use this form, just add in your total after-tax income, and the rest of the budget will be calculated for you automatically!

If you don’t make a standard income from month-to-month, calculate your average after-tax income for the past three months and add that value to the form.

One thing I’ll add is that while the percentages are a great starting point, you’ll likely have to modify a bit yourself when you start using the spreadsheet. However, this should only be due to circumstances outside your control (e.g., high bills, large debts).

How to Use the Spreadsheet

The second tab of the spreadsheet includes the monthly budget tracker. To use this form, you must first review the categories in each budget group, and update based on your personal expenses. There are open categories (marked other) that you can use to add additional categories, if necessary. If you do need to do this, be sure to make the same updates on the list on the “dropdown” tab so that expenses pull in appropriately.

Once the categories are updated, add in the values for each one. As you do this, make sure your total for each group does not exceed the amounts set on the “50 30 20 Calculator” tab.

You are now ready to start adding your expenses in the “Tracking Expenses” table. The most important thing here is to use the drop down to elect the proper category for each expense. That will pull in each value automatically to the totals on the left-hand side.

If you have questions at any time, feel free to email me at [email protected].

50 30 20 budget spreadsheet
If you monitor your money and invest, you can watch it grow!

50/30/20 Budget Example : Couple Making $125,000

Now, let’s put this into practice shall we? In our first example, let’s assume there is a couple (John and Mary) that jointly makes $125,000/year (after tax) that lives in Washington, DC. They have 1 daughter that they are raising as well. Using the 50/30/20 budget calculator, here’s what the breakdown of their expenses would be:

CategoryTotal Amount
Monthly Income$10,416
Needs$5,208
Wants$3,125
Savings / Debt$2,083

Note: For the purposes of this example, let’s assume both are paid monthly.

Needs – 50% of $125,000 Salary

Now, $5,208 may seem like a lot of money, but in DC you’ll find that your dollars don’t go as far as they do in most of the US. Here are some estimations on what her monthly expenses might be:

  • Housing: They own a home in the Capitol Hill neighborhood, and pay $3,000/month for their mortgage
  • Utilities: For gas, electric, and water, they typically pay $200/month
  • Groceries: The family shops at the local Safeway for groceries and spends around $700/month on groceries
  • Car Insurance and Maintenance: They only own one car since they live close to public transport, and are done with car payments. They spend about $100/month for insurance, and an average of $12/month for maintenance. (The car is still in good condition.)
  • Transportation: Both John and Mary usually take public transportation to work on the bus / subway. During the week, they may also incorporate the use of Uber in the mix, and when driving during the weekend, the usually incur parking fees. They pay a total of $550/month total on transportation costs for their MetroCard, Ubers, gas, and parking fees
  • Health Insurance: John’s job provides solid health coverage, and since everyone in the family is healthy, they have opted for a high-deductible spending plan. Cost – $150/month for family coverage (health + dental)
  • Childcare Costs: Their daughter is of elementary school age, so their costs are extremely high, but they still set aside $500/ month for any babysitting / childcare costs, as well as extracurricular activities

Total amount spent/month: $5,212 on Needs. Note they are just slightly over by $4.

Wants – 30% of $125,000 Salary

As shown in the prior section, the family has $3,125 to spend on Wants each month. Let’s get into how they may use this bucket of money:

  • TV/Internet: The family does not subscribe to cable TV, but does pay $70/month for subscriptions to Netflix, Hulu TV, and HBO Max. In addition, they pay for high-speed internet, since John often works from home. Their internet subscription costs $60/month
  • Entertainment: They set aside $200/month for entertainment costs. This includes anything from trips to paid museums, concerts, or local shows (such as those at the Kennedy Center)
  • Restaurants: John and Mary plan to eat out about 1x/week as a family and may also pick up lunch during the work week. They spend $600/month on all eating out expenses
  • Travel: Exploring new places both in the US and internationally is a high priority for the family. They save $700/month towards travel so that they always have a pool of money to pull from
  • Hobbies: Mary is a hobby photographer, and spends around $150/month on new gadgets for her camera

Total amount spent per month: $1,780 on Wants. Note, they have saved $1345/month, let’s see how they make the most of this in the next category.

Savings/Debt – 20% of $125,000 Salary

Let’s get into my favorite category – the one that’s focused on building wealth / getting rich. Please note that John and Mary have no debts outside of their mortgage. As a refresher, the couple has $2,083 allocated towards this bucket:

  • High-Interest Savings Account: They have built up their savings to cover 3 months of expenses, and typically add around $200/month to keep it growing
  • Retirement Account (401K): The couple puts up to their company match each month into their individual retirement accounts. Both of their companies match up to 6% of their salaries. They spend a total of $625/month towards their retirement account
  • Health Savings Account: Since they have a High-Deductible Health Plan, they are eligible for an HSA. As this can be used as an investment account, they opt to max out their investment and add $592/month into the account
  • Roth IRA: With the additional money left over from the “Wants” category, John and Mary fully fund their Roth IRAs for the year. They both add $800/month to their accounts
  • Taxable Brokerage Account: John and Mary set aside the additional $411/month to invest as they please in ETFs and individual stocks
  • Giving: Giving back is important to the couple, and they set aside $800/month towards charitable causes

Total Amount Spent: John and Mary have spent $3,428 in this category, successfully allocating money saved in the “Wants” category to building wealth.

RELATED: 5 Easy Ways to Save More Money

Master Your Money Super Bundle 2020

A Few Budgeting Tips

As you build your budget, there are a few important to keep a few things in mind.

  • Set realistic goals – Don’t set savings goals that you can’t reach, for example
  • Understand your spending habits – As a best practice, it’s a great idea to average out your expenses for the past few months to get a realistic picture of how you spend money. This is particularly useful for informing the “wants” group of your budget.
  • Keep track of your expenses regularly – I recommend tracking your expenses at least bi-weekly, and more if you know you are a spender.
  • Modify the percentages of each group, if necessary – If you are really focused on paying down debt, for example, you may want to increase the amount of money allocated to the “savings/debt” group and decrease the “wants” group.

RELATED: The Best Course for Improving Your Money Mindset

Planning for the Year Ahead

Now that you have the information and the tools you need to start your 50/30/20 Budget, get started tracking your budget today! Once you know where you money is going, you will be amazed how you can refocus your expenses on the things that you want to do or the places that you want to go.

#travelwandergrow

Related Posts:


The 50/30/20 Budgeting Method is one of the easiest ones to use to get your finances in order easily. If you want to get better at seeing where your finances are, and focus on building wealth. Get details on the method for budgeting, along with a free budgeting spreadsheet and calculator that you can use yourself! The template can be used in Excel and Google Sheets as well. #budgetingspreadsheet
Pin It!

Similar Posts

24 Comments

  1. Thank you for the money tips, I think budgeting is important part on planing trips. If you want to travel, you need money and to have the money, you need to save and having budget makes it possible for you to choose where to put the money. Compromising is often part of life. Do I want to travel or do I want to be in bars and clubs every Friday evening 🙂 50/30/20 budget strategy seems like a great strategy. Simple and good. Keep up the good work.

  2. I signed up for the spreadsheet because this post is precisely what I have been looking for since retiring. I’m on a fixed income now, so I have been looking for help with setting up a sound budget.

    The 50/30/20 plan is exactly what I needed. And now that I have a target for saving, perhaps I can look into taking a nice trip after all! I thought those days might be over.

    Thank you so much for putting this together. It really is beneficial.

  3. I definitely will saved this article, I think it help me a lot, planning is very important, this pretty cool, but I hope there are some videos on there so i can more understanding, but still, Thank you for the article!

  4. I need this spreadsheet. I will absolutely use this for sure. Thanks for providing it 🙂 I am a single mom and so budget is hugely important for me. Maybe putting it all down on paper will help me do better. Thank you!

  5. For someone who wishes to invest a lot of money into my own success this year in 2019, this article is a gem to have come across. Currently, I’m making very decent money at my day job but it’s by no means a place I want to be in for too long; perhaps until December at the latest. That said, this article is exactly what I was looking for when pondering on how to heck to make a budget and invest without breaking the bank. Thank you for the insights and I saved this article into my Favorites so I can reference it as needed.

  6. Great advice and nice simple budget ideas. I’ve been in the investment game for many years and absolutely agree with allocating some of every budget to retiring debt, savings and investment as you say. I’ve heard this referred to as paying yourself first which rings pretty true but of course we all need to keep up with the essentials of life as well. Thanks for taking the time to produce this useful tool.

  7. Hey! I love your spread sheet. I am trying to customize it a little bit in the categories and the “other” categories. is there a way to customize it without it messing up the drop down box? i wish the Expense log also had a drop down option for Income that would add up the total in the income box.

    your spread sheet has come the closest to EVERYTHING i want in a spreadsheet. thank you so much.

    1. I’m glad you love the spreadsheet, Brittany! Yes, if you go to the “dropdown” tab, you can make all the edits you’d like to the list there, and that will pull over to the spreadsheet page.

      1. Hello! When I make edits in the “dropdown” tab it is not automatically pulling over to the spreadsheet page for me. Is there anything else I need to do?

        1. Hi Sam! Thanks for your comment. To make sure your dropdown tab works correctly, you need to ensure that the range of cells in the dropdown is still accurate in the spreadsheet. I’m happy to take a look if you send an email to [email protected]. Best,Christen

Leave a Reply

Your email address will not be published.