Hey guys! Heads up, if some formulas don't work, try interchanging some , with ; and vice versa! I'm aware some of the SUMIFs aren't working. I'll be on the lookout and see if there is a consistent solution
Thank you so much for the easy to understand budget calculator!! I was able to get it to accept the formula when using a ; but once I type numbers in and choose the drop down, it is not registering the percentage or the dollar amount. Have any suggestions?
Jeremy, you just did a tutorial on what I've been looking for to track my own finance. I wanted something simple and not cluttered. Been binge watching your videos. Great tutorials. A new follower here. 🙌
As a teen with one foot barely in the doorway, I've been scrolling for hours and oh my gosh u helped me in like 5 minutes, u cooked with this one brother thank u so much
Honestly this is the best, most straight forward tutorial of a google sheet budget tracker I have ever seen, I'm 40 years old and have spent years trying to figure this out myself or through other videos. I just set my budget tracker up in 10 minutes thanks to you. Thank you so much for this video. I literally just felt weight lifted off of me knowing I can set my budgets up monthly easier and more efficient. Game changer.
YOU HAVE SAVED MY BUTT!!! I was putting FAR too much expenses on my credit card. Now I can manage my money so much better. I'll be one step closer to financial freedom!!
This was the quickest way to create a tracker! I thought this was so hard and its not! And I love how you separated into needs, wants and savings. Thank you so much.
1) Integration of 1 to n subcategories per main category and related evaluation options & Give to add & remove category & subcategory 2) Tracking of fixed vs. variable expenses 3) Also Add payment type add like cash ,credit card,Different bank , Google pay etc also maintained balance 4) Add Taypes menas (income expenses contra etc) Again, thank you so much, I am looking forward for upcoming tutorials
THANK YOU for a simple expense tracker! I get too overwhelmed with many other ones people have created, or all the elements others recommend to include. I feel that this is a fantastic base to build off of, thanks again!
Thank u so much of making this video i'm from india and I had searching this kind of video from past few days and I had received only excel video's that I don't want it now I had subscribed you ❤❤❤
I have been talking about doing this for some time now. .. especially, now that I have bought my first home. I have tried something similar but it was "meh" and I was not impressed with it BUT now I have found something that will work for me. Thank you, Bro. I appreciate ya. I think this idea and tracker will be more beneficial for me to use and be successful.
I literally sat here re creating it with you step by step. All the other ones Ive searched for including the old one I used to use were cluttered with too much going on, thank you this was a huge help!
thank you so much for this. for the month of october, i am finally starting to keep track of my expenses and finances. i was orignally looking up templates to download on google sheets or excel but they were all really complicated and extra. THIS!!! literally is so straightforward and what exactly im looking for!!
Dude, this is also neurodivergent-friendly!!! I have ADHD and it seems like the first budgeting spreadsheet that's simple enough but has everything I need. I might be able to stick with it this time 🥲
THANK YOU!!!!! This is solid tracker and the formulas were fantastic. Would have been cool to see them enlarged for us aging folk, but otherwise PERFECTION!
This is pretty sweet Jeremy! I've been through half a dozen apps - which after a while I gave up! I've been trying to come up with an elaborate sheet where I can track both my businesses and personal finance - but, I end up not knowing how to differentiate or not between business and personal or not! So your simple but to the point sheet, just gave me a really good head start. I like the figures and percentages of each and the only thing I may add are dates within the month so I know when I spent or received income, (I know a bit anal...ha ha...). Thanks a tone dudie..🙂
Thank you I really appreciate this tutorial! however when I set up my percentages in the beginning with the income the 50% totals to $0.00 what could i be doing wrong??
Hey I am actually working on my tracker using this and I’m not understanding why it’s not calculating. I did the same formula it did it for the goals but not the actual could I get some help pleasseeeeee
Hi, Jeremy. I just came across on this video and created it right away. But, I got error for the SUMIF formula. Is there any way you could help me? I was following every step & detail on the video. Thanks in advance!
Hi, thanks for the video, this will definitely give me a better look at my budget. If I want to use some funds from my savings account, do I add that to my Income list?
So if we get paid every week do we just add it each week into the income Column and every single time we spend money we can add it in the expense column I thjnk this will be really good to see how I’m spending my money throughout the month! That way the following month I can focus on my financial goals a lot better ! Amazing video
Hello! This video is supper helpful but I'm having a bit of trouble with the SUMIF formula. This is what I used =SUMIF(E:E="Needs"=D:D) Can you please tell me what I did wrong? Thank you!
I know it's been a while since this video was posted but if I could get some help on one of the formulas. When I Put =SUMIF (E:E, "Needs", D:D) it sums that up fine. But if I try to put =SUMIF (E:E, "Wants", D:D) it doesn't do anything even though I have categorized an expense in column E as either "Wants" or "Savings". :(
@@andiwuzlikeBAM Hello, I'm trying to figure out this too. Do you have the formula? I'm trying the add the ; but it doesn't seem to work when adding multiple categories into the same formula.
how do i go about adding the next month? I tried to copy paste the chart below the first one but the total expenses is trying to read the entire spreadsheet all together, instead of just giving me the total for the month beside it, if that makes sense!
I think I went over the dropdown on the video! Not sure if you can have subcategories though... you might have to start titling it like "Needs - Food", "Needs - Rent" etc.
Awesome tutorial, definitely going to start using this. Just one question, is there a way to add dates to this? As in adding dates to income and expenses? Cheers!
I am having a hard time getting the numbers to show on the actual when setting up the needs, wants,…. for the currency part. I followed the video but for some reason I can only get wants to populate numbers. The others stay at 0 when I plug numbers in.
What if I want to use multiple categories to sum up into my needs. For example, I want the categories "Food" and "Bills" to equal my "Needs" I'm not fluent in google sheet (or excel) formulas at all, and been trying to solve this issue and either get errors or $0 in my "J" column
Hey guys! Heads up, if some formulas don't work, try interchanging some , with ; and vice versa! I'm aware some of the SUMIFs aren't working. I'll be on the lookout and see if there is a consistent solution
my goodness, Jeremy! This is so kind of you to give your viewers & followers quick updates on some issues....!
Brother why I can't use dropdown in my HP spreadsheet
Thank you. Your video helped me in a big way. the way you presented was very simple and easily understood
Thank you so much for the easy to understand budget calculator!! I was able to get it to accept the formula when using a ; but once I type numbers in and choose the drop down, it is not registering the percentage or the dollar amount. Have any suggestions?
Jeremy, you just did a tutorial on what I've been looking for to track my own finance. I wanted something simple and not cluttered. Been binge watching your videos. Great tutorials. A new follower here. 🙌
thanks! appreciate it 😁
As a teen with one foot barely in the doorway, I've been scrolling for hours and oh my gosh u helped me in like 5 minutes, u cooked with this one brother thank u so much
yessir gotchu! fast and efficient, we like that
RIGHT!!! ❤
OMG I hate numbers and formulas but I was able to create my own expenses tracker thanks to this video! Tysm!
you're welcome! 😁
Honestly this is the best, most straight forward tutorial of a google sheet budget tracker I have ever seen, I'm 40 years old and have spent years trying to figure this out myself or through other videos. I just set my budget tracker up in 10 minutes thanks to you. Thank you so much for this video. I literally just felt weight lifted off of me knowing I can set my budgets up monthly easier and more efficient. Game changer.
i appreciate that! thanks for your kind words! :)
YOU HAVE SAVED MY BUTT!!! I was putting FAR too much expenses on my credit card. Now I can manage my money so much better. I'll be one step closer to financial freedom!!
Let's go!
Has to be one of the best tutorials I've ever seen on the topic
appreciate you!
This is just what I needed for work to track technician tool allowances. Thank you for sharing your knowledge.
you're welcome!
This was the quickest way to create a tracker! I thought this was so hard and its not! And I love how you separated into needs, wants and savings. Thank you so much.
Glad it was helpful!
1) Integration of 1 to n subcategories per main category and related evaluation options & Give to add & remove category & subcategory
2) Tracking of fixed vs. variable expenses
3) Also Add payment type add like cash ,credit card,Different bank , Google pay etc also maintained balance
4) Add Taypes menas (income expenses contra etc)
Again, thank you so much, I am looking forward for upcoming tutorials
THANK YOU for a simple expense tracker! I get too overwhelmed with many other ones people have created, or all the elements others recommend to include. I feel that this is a fantastic base to build off of, thanks again!
You are so welcome!
Thanks Jeremy for the tutorial. it helps a beginner like me
Happy to help!
this helped me so much! the SUMIF is Exactly what i needed to better my income sheets. Thank you!
you're welcome! ya that formula is clutch haha
Thank u so much of making this video i'm from india and I had searching this kind of video from past few days and I had received only excel video's that I don't want it now I had subscribed you ❤❤❤
Such a lifesaver!! Thanks!
Glad it helped!
Very good and simple budget! Thank you, Jeremy!
youre welcome Nancy!
I have been talking about doing this for some time now. .. especially, now that I have bought my first home. I have tried something similar but it was "meh" and I was not impressed with it BUT now I have found something that will work for me. Thank you, Bro. I appreciate ya. I think this idea and tracker will be more beneficial for me to use and be successful.
awesome! grats on your house purchase! 😁
This is exactly what I was trying to find, thank you so very much!!!
You're very welcome!
I literally sat here re creating it with you step by step. All the other ones Ive searched for including the old one I used to use were cluttered with too much going on, thank you this was a huge help!
Glad I could help!
You're my hero man! Tysm for this easy tutorial! really appreciated
you're welcome!
thank you so much for this. for the month of october, i am finally starting to keep track of my expenses and finances. i was orignally looking up templates to download on google sheets or excel but they were all really complicated and extra. THIS!!! literally is so straightforward and what exactly im looking for!!
youre welcome!!
Thank you! Been looking for an easy way to manage finances, you're a lifesaver! ❤
Happy to help!
As someone who is 16, thank you this was so easy 🙏🙏
You’re welcome 😊
Dude, this is also neurodivergent-friendly!!! I have ADHD and it seems like the first budgeting spreadsheet that's simple enough but has everything I need. I might be able to stick with it this time 🥲
great to know! i appreciate it :D
No seriously!! god bless him
Such a nice and awesome way to track expenses. Thank you, everything was clear.
Glad it was helpful!
Thank you for breaking it down so well and short
youre welcome!
This is so easy, quick and a simple video tutorial. Thank you!
You're welcome!
straightforward and simple, thanks brother!
Glad it helped!
23 about to try being self employed. Need to get expenses in check down to the dollar. So this is awesome. Thanks!
You're welcome! Best of luck to your journey!
HEAVEN SENT! This is a less overwhelming budget tracker and very simple especially on expense categories 🤣
appreciate it! :)
This is awesome! It's so simple and effective. Thank you!!
Glad it was helpful!
Thanks for the tutorial. You answered every question I had regarding a Budget Tracker.
Glad it was helpful!
Thank you so much! I spend money buying templates that didn’t work and this video helped me creat just what I needed. Thank you thank you thank you!
You're welcome! I appreciate it
This saved my life, as I would have NEVER figured out these formulas in my own 💚
glad i could help!
@ yes, thank you!!!!
I really appreciate how you made the tracker so simple and efficient yet effective. Helped me out a lot, cheers 👍
glad i can make it helpful for you :)
THANK YOU!!!!! This is solid tracker and the formulas were fantastic. Would have been cool to see them enlarged for us aging folk, but otherwise PERFECTION!
awesome! glad you enjoyed. i will keep note of enlarging formulas next time 😊 great suggestion!
Thank you!! I was getting confused by my own spreadsheet so I knew it was time for some reorganization. This works super well for me!
awesome! glad you found the video :D
BRO THANK YOU SO MUCH GETTING MY PAYMENT FROM FIRST JOB EVER TOMORROW AND THIS HELPED SM THANK
best of luck to your new job!
@@JeremysTutorials omg thank you so muchh
Thank you, great tutorial.
Glad it was helpful!
Bro, it is sooooooo useful. God bless.
Glad it helped
Good work. very simple and very effective.
Thank you. 👏 This is exactly what I was looking for my Google Sheets.
great! enjoy :)
I’m not savvy with spreadsheets but you made it easier than others to follow along. Thanks
appreciate that! not savvy with spreadsheets either :)
Just what I was looking for, Great video bro 😎
appreciate it! :)
4:16 when you say "is equal to needs" you put a comma, but when I put it my code becomes an error, what have I done wrong?
Not sure if there are any updates, try using , or ; interchangeably
same
Same! Mine just remains zero
Amazing video bro, I was able to turn in my homework and learn how to make a quick and easy budgeting sheet🔥
Nice! That's the way to do it :)
This is pretty sweet Jeremy! I've been through half a dozen apps - which after a while I gave up! I've been trying to come up with an elaborate sheet where I can track both my businesses and personal finance - but, I end up not knowing how to differentiate or not between business and personal or not!
So your simple but to the point sheet, just gave me a really good head start. I like the figures and percentages of each and the only thing I may add are dates within the month so I know when I spent or received income, (I know a bit anal...ha ha...).
Thanks a tone dudie..🙂
No worries! I'm glad you're able to find this solution out. I appreciate your comment :)
This is amazing, thank you!
you're welcome!
Thank you bro for you detailed tutorial. God bless!
You are very welcome
NEEDED THIS! Liked and Subscribed! ✅
appreciate it :D
It's so useful. Thank you so much
You're welcome 😊
Thanks man, you rock!
no you do!
Thank you I really appreciate this tutorial!
however when I set up my percentages in the beginning with the income the 50% totals to $0.00 what could i be doing wrong??
not sure, try double checking the formulas again
Thank you so much omds this was so life changing ❤❤❤❤❤❤❤❤❤❤
appreciate it!
Great tutorial thank you
You’re welcome 😊
Hey I am actually working on my tracker using this and I’m not understanding why it’s not calculating. I did the same formula it did it for the goals but not the actual could I get some help pleasseeeeee
can you put your formula?
Hi, Jeremy. I just came across on this video and created it right away. But, I got error for the SUMIF formula. Is there any way you could help me? I was following every step & detail on the video. Thanks in advance!
Try using the ; and , interchangably
Thanks for the video, pls um what should I do if I want to add a column that shows if I've exceeded my goal or I'm under it.
can you provide this file?
Hi again,
Could you pls help with the formulae you mention to see the negatives you mention in 6:07 ??
Thank you
What do you mean?
This is great, thank you.
youre welcome;
Thank you. Much appreciated!
You're welcome!
thank you so much for your awesome video
thank you for watching! :D
Hi, thanks for the video, this will definitely give me a better look at my budget. If I want to use some funds from my savings account, do I add that to my Income list?
Glad it was helpful!
Dude thank you!
No problem!
So if we get paid every week do we just add it each week into the income Column and every single time we spend money we can add it in the expense column I thjnk this will be really good to see how I’m spending my money throughout the month! That way the following month I can focus on my financial goals a lot better ! Amazing video
thank you! yes, keep track of those expenses, let's go :)
Can you create a chart on this? To know which expenses are more spent than others
❤thank you where can I get a copy please.
no copy of it unfortunately 😕 you gotta DIY it with the video
Hello! This video is supper helpful but I'm having a bit of trouble with the SUMIF formula. This is what I used =SUMIF(E:E="Needs"=D:D) Can you please tell me what I did wrong? Thank you!
Hi i think the equal sign should be a comma!
yep, the second one should be a comma!
I know it's been a while since this video was posted but if I could get some help on one of the formulas. When I Put =SUMIF (E:E, "Needs", D:D) it sums that up fine. But if I try to put =SUMIF (E:E, "Wants", D:D) it doesn't do anything even though I have categorized an expense in column E as either "Wants" or "Savings". :(
Try using ; instead of , as someone else mentioned!
@@JeremysTutorials thank you!!
@@andiwuzlikeBAM Hello, I'm trying to figure out this too. Do you have the formula? I'm trying the add the ; but it doesn't seem to work when adding multiple categories into the same formula.
for some reason i can´t get the "=SUMIF" formula right, i need help!
try using ; instead of , if some formulas dont work
how do i go about adding the next month? I tried to copy paste the chart below the first one but the total expenses is trying to read the entire spreadsheet all together, instead of just giving me the total for the month beside it, if that makes sense!
Very useful 🤗
Glad you think so!
omg i loved it, how could i make a pie chart using the drop down labels? honestly, just for the vibes
hmm good idea, i can go over that in the future
Thank you for that!
youre welcome :)
The video was very through! Really easy to do but I was wondering if it was possible to have dropdown categories and dropdown subcategories?
I think I went over the dropdown on the video! Not sure if you can have subcategories though... you might have to start titling it like "Needs - Food", "Needs - Rent" etc.
Love this budget with the color code, but I think I’m limited on what I can do on my iPhone, or maybe I just don’t know what I’m doing.
phone may be limited. I think a computer might be required for more controls
Thanks Jeremy!
you're welcome!
Thanks, love from Bangladesh
appreciate it! greetings to Bangladesh
The SumIf formula doesn't work :/
can you drop your formula?
@@JeremysTutorials =SUMIF(E:E="Gas",D:D) All my categories just show zero
put commas instead of = ......... e.g. =SUMIF(E:E,"Needs",D:D)
Happened the same to me, problem was some countries/ languages don’t use commas rather ; so instead of commas use semicolons and that should solve it!
this was cool
thanks youre cool!
Thankyouuuu very much❤
You're welcome 😊
bro you are legend
no you are!
Awesome tutorial, definitely going to start using this. Just one question, is there a way to add dates to this? As in adding dates to income and expenses? Cheers!
Yes you can! just add another column
Merci 🙏🏿❤️
you're a lifesaver
thank you!
where to get a copy of this?
Such a legend
youre a legend!
Useful Thank you
you're welcome!
superb thanks
you're welcome!
Can you please make a tutorial on how to create an inventory tracker sheet
sure!
Can you then forward your savings to next month's budget and keep track of your total savings or does it start over each month?
why sumif i have an error?
check my pinned comment
I am having a hard time getting the numbers to show on the actual when setting up the needs, wants,…. for the currency part. I followed the video but for some reason I can only get wants to populate numbers. The others stay at 0 when I plug numbers in.
Did you get the formula correctly?
why is my SUMIF formula not working 😢 it's so frustrating
try using ; instead of ,
Would be great if this is linked with a google form where entries can be put from google form
ohh that would be a good idea!
What if I want to use multiple categories to sum up into my needs. For example, I want the categories "Food" and "Bills" to equal my "Needs"
I'm not fluent in google sheet (or excel) formulas at all, and been trying to solve this issue and either get errors or $0 in my "J" column
you can try using the SUM() formula?
might be a tad complicated tho!
trying this out !!!
lmk how it goes!
Thank you!
You're welcome!
Amazing
Thank you! Cheers!