How to Make a 50/30/20 Budget in Google Sheets

A full tutorial for a 50/30/20 Budget in Google Sheets. I give a VERY brief overview of the 50/30/20 budget rule and a full walkthrough so you can make a 50/30/20 budget in google sheets from scratch. No spreadsheet experience necessary. You can apply all of the same steps to a 50/30/20 budget in Excel.

Mentioned in this Video:

Video Sections - jump to what you want to watch:
0:00 50/30/20 Budget Rule Basics
1:22 Building your 50/30/20 budget template in google sheets
12:00 Updating your formulas when you need to add a new row
14:56 How to freeze rows to simplify your budget
15:36 Calculating your Total Income and Total Expenses
18:25 Adding Yearly Totals and Average Monthly Spending Columns
20:12 Figuring out your 50/30/20 Budget Expenses percentages

Related Videos

Help Getting Out of Debt
Debt Snowball Spreadsheet (free download) -

Budgeting Tips and Resources

Read more on how to budget, save money and get debt free:

Let’s Connect

#503020budget #budgetrule #budgetingooglesheets

[sarahq]

Oh my goodness I’m learning excel and so glad to come across your videos, thank you so much! 🙏

[zacharyrael]

You are the man! I love how easily you explain formatting a spreadsheet for someone like me with zero experience. This is the second budget spreadsheet you have helped me make.

[missbeesn]

Thank you so much! This was extremely helpful especially for being a beginner with google sheets/ excel :)

[heyits_cass]

This was amazing and very helpful! Thank you for this

[HananiahSmith]

Thanks for the help, just finished setting mine up. I will be using this in the future

[aaronmyrie]

My friend you are an absolute legend!!

[charlesgwinter]

choose the last row then insert row ABOVE and the added rows will be included in the total formula

[SPY_-DTE]

Huge help. Very well detailed. Thanks 🍻

[LisaPirrello]

Do you have a final shot of what the spreadsheet looks fully formatted? Thanks!

[Lerhamn]

Hi Jamie, really good Im thinking to buy it rather them setting it up myself, but I get paid weekly is the link edible? and if so is it easo to change to weeks? thank you

[believeinbuffalo]

Thank you for the awesome video! I might create my own version but will most likely make a purchase. Is there a way to format it so that it includes a pie chart? Is the Normal Month a way to plan out your budget under ideal circumstances and then see how it changes throughout the months?

[upfebrm]

Could you please explain why savings is counted as expense? Isn't savings different?

[DeejayAdventures]

Hi Jamie,
Just wondering on your 50/30/20 Budget in columns B is this where I put down actual monthly amounts needs to be paid ? With Jan, Feb months do I copy what put in column B ? Thanks for your budget once I finish it I’ll be able to see the whole year 👍🏻cheers Jason

[KimBrown-rjye]

I bought the $5 template, but I thought I could use it in Excel. Can I only use it in Google Sheets?

[lucysam]

Hi Mr Jamie, just saw video 50/30/20 and purchased it at end of transaction it reads amount total is $80.00. I believe you mentioned that it is just $5.00. Please advise also there is no way for me to cancel the payment

[ReneeThompson-moqj]

❤ this I would love for you to give me step-by-step instructions please.

[ReneeThompson-moqj]

Hello I need a little help with the actual % income