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

[@zacharyrael8006]

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.

[@MrJamieGriffin]

Thanks for the positive feedback! I love helping people make budgets, and I’m glad this helped you get yours set up!

[@sarahq8728]

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

[@MrJamieGriffin]

@@sarahq8728 happy to help! Have fun learning!

[@missbeesn]

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

[@MrJamieGriffin]

Glad it helped! Spreadsheets can have such a steep learning curve, but you can do a lot with just a couple simple formulas! Good luck budgeting and let me know if there are more ways I can help!

[@HananiahSmith]

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

[@MrJamieGriffin]

You’re welcome! Send any questions my way if something comes up!

[@heyits_cass]

This was amazing and very helpful! Thank you for this

[@MrJamieGriffin]

@@heyits_cass you’re welcome! Happy to to help!

[@abiolaayokunle1553]

Hii, thank you so much for this video. I'll love to ask how fhe 50-30-20 rule is applied at the end of this video?

[@aaronmyrie]

My friend you are an absolute legend!!

[@MrJamieGriffin]

Well that’s pretty dang kind of you! Thanks!

[@mathiasmllerrasmussen417]

Hello! Love you video! I have made my own 50/30/20 budget from your video and i was wondering - we put money aside each month for our mortgage payment as it is paid every 3rd month. How would you adjust the sheet to compensate for the months where payments come from the budget account and not from our direct income? Greeting from Denmark

[@MrJamieGriffin]

If I'm understanding you correctly, you only pay your mortgage every 3 months, but essentially save 1/3 of that payment every month so that when your payment is due, the money is there for your payment. Here's how I would manage that: Whatever your mortgage is, split it into thirds and mark that amount in your budget every month. Then make sure you don't spend it on other things when you see the extra money in your checking account. If you do that, the entire mortgage can just be paid right from your checking account AND it's marked in the budget every month.

[@JustTamMexo]

Very helpful. Thank you.

[@MrJamieGriffin]

@@JustTamMexo you’re welcome! ☺️

[@SaadonAksah]

Nice! Thanks for sharing this 👍

[@MrJamieGriffin]

@@SaadonAksah happy to help!

[@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?

[@MrJamieGriffin]

Yes that’s absolutely the purpose of the Normal Month column. You be oils absolutely format it into a pie chart. Creating a dashboard for my budgets is the plan for the future to make everything a bit more user friendly. I think the simplest way to set up a pie chart is to use each sections total expenses cell and format it from there or if you purchase the template, there’s a row for each section that shows what percent of your income that is. If you use that row, it should create a pretty nice pie chart.

[@believeinbuffalo]

@@MrJamieGriffin Thank you! I am using the 50/30/20 budget now and it is definitely worth the purchase. Another question that I have is about peer to peer transactions like CashApp, Zelle or Venmo. I often lend 20 bucks here and there to my cousins/siblings. Where/how would you suggest budgeting that? I use them to payback friends at the end of a night out but I suppose that would be included in the night out total.

[@MrJamieGriffin]

@@believeinbuffalo good! I’m glad it’s worth the money and I appreciate the feedback! I would include it in whichever budget category it aligns with best, just like you mentioned it being in your “night out” category.

[@charlesgwinter]

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

[@MrJamieGriffin]

That will definitely work too!

[@KB-oc5ux]

Amazing, thank you so much!

[@MrJamieGriffin]

You’re welcome! Best of luck on your budgeting adventure! Swing back if you have questions!

[@LisaPirrello]

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

[@Deejay1628Adventures]

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

[@MrJamieGriffin]

Yea, column B says “Norm” so that’s your monthly expenses that need to be paid or your estimated amount you pay for variable expenses like groceries. You can copy what you put in column B for the other months of the year or enter the amounts in as you pay them throughout the month. That way it kind of acts as a checklist for paying bills too.

[@SPY_0-DTE]

Huge help. Very well detailed. Thanks 🍻

[@MrJamieGriffin]

Glad it’s helpful!

[@RuvArit]

Thank you! Also, what camera do you use?

[@MrJamieGriffin]

@@RuvArit this was filmed with a canon m50 with a 22mm lens.

[@Lerhamn78]

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

[@MrJamieGriffin]

The spreadsheet will be fully editable and customizable so if you want to set it up to display weeks instead of months.

[@Lerhamn78]

@@MrJamieGriffin great thanks for quick reply, only thing thou im not sure 52 columns will be very user friendly. 🤔

[@MrJamieGriffin]

@@Lerhamn78 maybe not, but you could set it up quarterly and have a new tab for each quarter.

[@Lerhamn78]

Yes good idea will purchase after work :)​@@MrJamieGriffin

[@tyronejackson1150]

Thanks for the info

[@MrJamieGriffin]

No problem 👍 happy to help!

[@lynnalexandre9258]

How long does it take to receive the template I paid for? It has been 20 minutes since I paid for it.

[@MrJamieGriffin]

@@lynnalexandre9258 it should hit your email within a few minutes. Check your spam folder. If it’s not there, I can take a look tonight and see what the issue is.

[@Vero.does.better]

Great video. Liked and subscribed ❤😊

[@MrJamieGriffin]

Thanks! Welcome to the fam!

[@KaziSafaetHossain]

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

[@MrJamieGriffin]

Great question! I set budgets up as a zero based budget, which means that once on - expenses = zero. Counting savings as an expense helps account for all money coming in and giving it a specific job, in this case building my savings. When you don’t count savings as an expense, it gets really easy to forget it or miss it. But when you think of it as an expense like your electricity or rent, it’s easier to remember and prioritize.

[@KaziSafaetHossain]

Thank you for the explanation, sir. This really helps, please upload content such as these. @@MrJamieGriffin

[@MrJamieGriffin]

@@KaziSafaetHossain happy to help! Is there any budget content you’d like to see?

[@KaziSafaetHossain]

@@MrJamieGriffin I have been interested in Credit Cards and Credit Scores recently. It would be helpful if you chronologically describe concepts about Credit Cards and how budgeting is related, such as APR and so on...thank you!

[@lucysam5820]

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

[@MrJamieGriffin]

Hi! I can absolutely answer this question. On the purchase page there is a button to click for an upgraded budget that is Done for You. By clicking the button, you purchased the upgraded version where you fill out a simple spreadsheet and I make a customized budget for you. That’s why your receipt said $80.

[@lucysam5820]

@@MrJamieGriffin Hello Mr.Jamie, I have read your reply, I did not fill out any additional spreadsheet, I was only interested in the offer of $5.00 so that I can fill out myself as I am learning how to budget, please advise how do I receive a refund of $75.00? Thank you and see you again on your other videos

[@MrJamieGriffin]

@@lucysam5820 I just started the refund process. You should see it in your account in 5-10 business days

[@wanjiraireri4258]

Thankyou Very helpful

[@MrJamieGriffin]

You’re welcome! Happy to help!

[@KimBrown-rj6ye]

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

[@KimBrown-rj6ye]

OMG!!! I figured it out...feeling pretty silly...

[@MrJamieGriffin]

Awesome! Let me know if questions pop up during set up!

[@fadumomohamed5053]

Thanks you so much it was helpful

[@MrJamieGriffin]

You’re welcome!

[@RicardoNunez90]

Thank you good sir

[@MrJamieGriffin]

You’re welcome!

[@ReneeThompson-mo4qj]

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

[@MrJamieGriffin]

There’s a link in the description for a Done for You Budget where I basically make your budget for you. Follow this link to see if it’s what you’re looking for. mrjamiegriffin.thrivecart.com/done-for-you-budget/

[@ReneeThompson-mo4qj]

Well Jamie I would ❤️ to purchase this, but as of ✅️ I can purchase with my lack of funds to do so,is there any other way you could get me this please.

[@MrJamieGriffin]

@@ReneeThompson-mo4qj Another option would be the $5 budget spreadsheet where the actual budget with formulas is done for you, you just need to enter in your categories and the amount you budget for that each month. Here's a link for that - mrjamiegriffin.thrivecart.com/50-30-20-budget-template/

[@ReneeThompson-mo4qj]

Is there any way you could get me this $5 budget spreadsheet to me for free because I am having a hard time coming up with the funds to purchase this please.

[@MrJamieGriffin]

@@ReneeThompson-mo4qj Im sorry, I don’t have a free option for this budget spreadsheet

[@ReneeThompson-mo4qj]

Hello I need a little help with the actual % income

[@MrJamieGriffin]

How can I help? Are you getting an error for the formula?

[@ReneeThompson-mo4qj]

Yes I am getting an error from formulas and I also need a little help in calculation formulas as well,thanks for getting back to me when I comments,I love ❤️ your 50/30/20 budget spreadsheet it is a great teach step for me learning this.

[@MrJamieGriffin]

@@ReneeThompson-mo4qj What error message are you getting? If you go to 15:36 in the video and 20:21 those sections will help you recreate the steps I did in this video. Without more information or screenshots it's difficult for me to diagnose your specific problems with calculations and formatting.

[@ReneeThompson-mo4qj]

Need help with the calculations.

[@de-vek]

🔥

[@kevtd23]

Have you done a 50/30/20 on tiller?

[@MrJamieGriffin]

I have used their monthly budget template but I haven’t set it up as a 50/30/20 budget. But if you’re looking for more automation, Tiller is the way to go

[@bhavneshparikh8283]

sample file?

[@MrJamieGriffin]

I’m not sure what you mean when you say sample file. I do have this budget for $5 if you don’t want to make one yourself. It’s already formatted for you to enter your budget categories.