Thank you so much! Honestly, this is one of the most helpful videos I have ever watched on UA-cam and I am not just blowing smoke either. Great step-by-step instructions. You made it easy for us. I love the channel. Continued success!
You are on the road to saving thousands and making millions. Thank you so much for this. As a 60 year old man i never had any knowledge of this stuff. I have started saving for my retirement and hopefully can use this in the future
Thank you very much. Not only did you teach me a very easy way to track my budget but I also learned a few new tips in my use of spreadsheets. Easy to follow instructions.
This was INCREDIBLY helpful. So clear and straight to the point. This is such an effective way to budget compared to other UA-camrs' methods. Thank you!!! Just finished making it, can't wait to use it.
I have been trying to design my budget sheet of over 2 to 3 weeks and this is the first video that helps me to take my first step. I have watched so many videos but this is the first video that I could follow all the steps one by one and achieve to design my first design. Thank you so much. This is point to point and esay to follow.
This was exactly what I was looking for. Thank you so much. You've changed the trajectory of my life. You're making an impact greater than you can probably imagine.
Thank you so much this helped me so much because I’m gonna be 18 next year and my mom is not doing my taxes anymore so this help me organize everything 😭
I agree, very helpful! Very easy to follow. However for some reason as I add more transactions, some of the cells do not calculate to the tracking side. I am not sure what went wrong. It is not with every drop down.
Loved loved loved your tutorial. My problem is that when I go to data rules my screen has differnet options. I can't seem to get it to work the was you describe it because I have things like option 1, option 2. Anyway, I'll keep trying. Its probably me.
Will you need to create separate tabs for each month to see the overall summary for the month? Or is there a way to create a Month column and include that as a criteria range?
Thank you for sharing... This was really helpful. I do have a question. What If I want to create another category for tracking the money put in my Fixed deposit? or you could also say saving. The reason I used the term fixed deposit is because, then the money is transferred to fix deposit (FD) then that should not be termed as expense and rather investment/saving category and vice versa when we break the fd, the money then comes back in the account. Please do share I would love to incorporate this in my monthly budgeting. Thank you.
Do you have any suggestion how to make it dynamic for monthly and yearly. For each year having separate month would be little cumbersome to maintain. Any suggestion?
When I duplicate and rename at the end, the formula then doesn’t work on all categories, but it does in original sheet.Eg it will work on groceries, but not eating out. Why????
Hey quick question, as I am new to budgeting. I have made monthly balance sheets before but they were based off the averages of the previous years income/expenses. It is currently 1/4/24 and I was wondering if I should wait until the end of January to make this sheet or find the averages of the previous year to get my number? Great video BTW!!! very helpful and detailed to help someone who has done minimal excel training learn and understand key functions of excel
While using data validation and sumif formula I tried to select the column as per your video tutorial but the formula didnt work . Later i had to select all column from top and then it work .. i wonder why this happend .. anyways its really helpful tutorial 😊
How do you keep track of your expenses during the day? Do you take notes of everything on your phone? or do you rely mostly on bank statements? what advice can you give? Personally, I struggle to keep track on the daily expense just because I tend to forget or I´m busy during the day, and lets say I pay something cash and you easily lose track.
thank you so much, but for some reason when im trying to insert my pie chart it wont work and says “column 2 needs to be a number” but it is? edit: it works as a column chart but not pie, and i want it as a pie chart
Thank you so much I was so proud of myself for creating this monthly budget. However, there is one step that I was not able to complete. It was the last added Chick-fil-A expense that you added I added the same thing and it did not change my total. What did I do wrong?
This was great. I created this monthly budget tracker and looks super amazing. I miss the last step when you added Chick-fil-A I tried to do the same and it did not change anything. Can you tell me what I did wrong? Thank you so much!
Hi there, does anyone knows how can I select multiple cells and apply it to a category? If I have 3 uber trip rides instead of applying to each one could I select all 3 and apply the categories to it with the menu drop downs. Even better, can you search within the spreadsheet and apply it to multiple cells/transactions which contains such as of the same? thanks
Thanks for sharing this template, can I edit this template to have income vs expenses only that dynamically updates without budget vs actual that is irrelevant to me?
Everything in your tutorial is excellent. The only thing I need to add is to organize all my bills with due dates and amounts paid, especially with credit cards.
What an amazing tutorial and a spreadsheet. I only have one question, when it comes on putting your income sources, are you putting them on gross income or net income??? Assuming someone with a regular job and investment or side hustle,for a job it will be tax right away, in short, net income. On the other hand, making an income on investments and side hustle, such as, capital gains and dividends is I consider gross income. Also, it will only be tax on filing season. Which part of the income should I put on the spreadsheet, the gross/pre tax or the net/after taxes to make everything accurate??? Thank you and have a great day.
I have question if I select the first row or second in transaction category as utility or medical for the results is not match in monthly category. Could you help me please
whenever i finish Data Validation, then my SUMIF formula in column H, my values are always 0, no matter what data i put in to Column D Anyone else get this?
SUPER IRRITATED with your video I’m new to sheets needed the tutorial and I don’t know what going on but as soon as I go to data I’m lost your screen does match mine any longer and I can’t add so what certain are you even using
Hi friend! The pop up is what you need, it’s just an update! If you see the “any value” drop down. Go to list, select the categories in the second box and then just hit ok! I hope this helps!
@@B4by1534Thank you so much for the comment as we are going to make this in our own! You helped me and the class because we didnt have the updated version of it!
this is great! how should one link bank accounts to reflect this? say you have 5 bank accounts, how would one track the end balance at the end of each month, perhaps you used WellsFargo for groceries, then Chase for transportation, etc...
I think you should add another column for the payment method. Then you can also create a pie chart for the several ways you use your money. And if you want an overview of each payment method, you must add a few extra rows to fill in the starting balance of each payment method. And of course a few extra rows with the totals of the payment methods using the sumif function.
Thank you so much! Honestly, this is one of the most helpful videos I have ever watched on UA-cam and I am not just blowing smoke either. Great step-by-step instructions. You made it easy for us. I love the channel. Continued success!
Thank you for the kind words! I’m so glad it helped you!
I've tried several Budget tracker. I can say this one is the one that works for me. Thanks for sharing.
Great to hear!
You are on the road to saving thousands and making millions.
Thank you so much for this.
As a 60 year old man i never had any knowledge of this stuff.
I have started saving for my retirement and hopefully can use this in the future
I decided to take budgeting very seriously this year. This video is the best so far and it’s very detailed and helpful. Thank you.
You are so welcome! Good luck!!
Thank you very much. Not only did you teach me a very easy way to track my budget but I also learned a few new tips in my use of spreadsheets. Easy to follow instructions.
Glad it was helpful!
This was INCREDIBLY helpful. So clear and straight to the point. This is such an effective way to budget compared to other UA-camrs' methods. Thank you!!! Just finished making it, can't wait to use it.
Thank you!
I have been trying to design my budget sheet of over 2 to 3 weeks and this is the first video that helps me to take my first step. I have watched so many videos but this is the first video that I could follow all the steps one by one and achieve to design my first design. Thank you so much. This is point to point and esay to follow.
Glad it helped!
This was exactly what I was looking for. Thank you so much. You've changed the trajectory of my life. You're making an impact greater than you can probably imagine.
Wow! Thank you!
Excellent. Thank you. Note: I found it much easier to follow at 0.75 playback speed -- in the settings option.
This is exactly what I was looking for, tried to do this many time never successful, now with this video I was, thanks for sharing this video.
You're welcome!
thank you man i have cerated my 2024 budget tracker
This is best tutorial ever on the internet ❤
thank you!
Thank you so much this helped me so much because I’m gonna be 18 next year and my mom is not doing my taxes anymore so this help me organize everything 😭
You're the man. Maybe you can do a video that includes how to insert smart chip directly into the spreadsheet, so no manual input is necessary?
Thank you very much, I have been wanting this kind of budget tracker for sooooo long!! So glad I discovered this video.
Glad it was helpful!
I agree, very helpful! Very easy to follow. However for some reason as I add more transactions, some of the cells do not calculate to the tracking side. I am not sure what went wrong. It is not with every drop down.
OMG I LOVE U thank you so much i was struglling so much with other tutorials but yours its very clear and beginner friendly
Glad I could help!
Finally i found best tutorial.. thanks
Thanks for the tutorial. My validation data doesn’t seem to work. Can you update a new tutorial with the updated version? Please…
Thank you! This sheet helps me at my current level, all the other videos just has too much complexity.
This is awesome but I cant figure out how to do the data validation step with the updated version
Thank you! This looks organized and easy to follow. But I would suggest using Format table
Great suggestion!
When I try to do the formula it doesn't populate numbers only for the income portion everything else stays at zero.
Excellent video. Very straight forward making it easy to follow and understand.
Thank you! This looks organized and easy to follow.
You are so welcome!
This is perfect, but having a small calendar showing bill due dates would be better.
Simple and effective
Well done! I will be using it as well. Thanks a lot!
Loved loved loved your tutorial. My problem is that when I go to data rules my screen has differnet options. I can't seem to get it to work the was you describe it because I have things like option 1, option 2. Anyway, I'll keep trying. Its probably me.
Thank you. I followed along and made mine in excel.
Glad it helped!
Excellent vid! This is exactly what I was looking for!! Appreciate your work.
Glad it was helpful!
Thanks for your demonstration! It looks great
it is not counting some section of monthly budget. pls help
Will you need to create separate tabs for each month to see the overall summary for the month? Or is there a way to create a Month column and include that as a criteria range?
Just followed your steps to create it. thanks
Glad it helped!
Thank you for sharing... This was really helpful. I do have a question. What If I want to create another category for tracking the money put in my Fixed deposit? or you could also say saving. The reason I used the term fixed deposit is because, then the money is transferred to fix deposit (FD) then that should not be termed as expense and rather investment/saving category and vice versa when we break the fd, the money then comes back in the account. Please do share I would love to incorporate this in my monthly budgeting. Thank you.
Do you have any suggestion how to make it dynamic for monthly and yearly. For each year having separate month would be little cumbersome to maintain. Any suggestion?
Very good table.Thanks!
Excellent video, thank you.
When I duplicate and rename at the end, the formula then doesn’t work on all categories, but it does in original sheet.Eg it will work on groceries, but not eating out. Why????
Awesome video and lesson to create a budget tracker.
Thanks so much!
Hey quick question, as I am new to budgeting. I have made monthly balance sheets before but they were based off the averages of the previous years income/expenses. It is currently 1/4/24 and I was wondering if I should wait until the end of January to make this sheet or find the averages of the previous year to get my number?
Great video BTW!!! very helpful and detailed to help someone who has done minimal excel training learn and understand key functions of excel
Nice and easy. One thing I would want to it is chart to show expences compare to incomes. I working on my own sheet and thinking how to do?
Now a subscriber.
How would you get each month to add up into a yearly budget?
While using data validation and sumif formula I tried to select the column as per your video tutorial but the formula didnt work . Later i had to select all column from top and then it work .. i wonder why this happend .. anyways its really helpful tutorial 😊
Thank you so much.
This is so good!! thank you so much !
You're so welcome!
Great tutorial! After duplicating for the next month, my income is summed properly but my expenses are not. Any suggestions?
Thank you so much sir!
Thank you so much you deserve a subscribe.
Glad I could help!
How do you keep track of your expenses during the day? Do you take notes of everything on your phone? or do you rely mostly on bank statements? what advice can you give? Personally, I struggle to keep track on the daily expense just because I tend to forget or I´m busy during the day, and lets say I pay something cash and you easily lose track.
Thank You ❤
The has given me a few useful ideas to track my portfolio / expenses. Nice explanation. Are you using a Mac or PC here?
I’m glad! And I’m using a Mac.
thank you so much, but for some reason when im trying to insert my pie chart it wont work and says “column 2 needs to be a number” but it is?
edit: it works as a column chart but not pie, and i want it as a pie chart
Thank you so much I was so proud of myself for creating this monthly budget. However, there is one step that I was not able to complete. It was the last added Chick-fil-A expense that you added I added the same thing and it did not change my total. What did I do wrong?
How do you replicate for different months?
This was great. I created this monthly budget tracker and looks super amazing. I miss the last step when you added Chick-fil-A I tried to do the same and it did not change anything. Can you tell me what I did wrong? Thank you so much!
Question, can you not just filter by date instead of duplicate
Hi there, does anyone knows how can I select multiple cells and apply it to a category? If I have 3 uber trip rides instead of applying to each one could I select all 3 and apply the categories to it with the menu drop downs. Even better, can you search within the spreadsheet and apply it to multiple cells/transactions which contains such as of the same? thanks
Love the tracker. Stay connected.
Thanks for sharing this template, can I edit this template to have income vs expenses only that dynamically updates without budget vs actual that is irrelevant to me?
There is something wrong in the column of Total, even I dragged the formula going down some of the amount its not taking the amount in transactions😢
Great tutorial!!
Thank you!
Great tutorial! Can I add this in Excel? Also, can I create another sheet to track my bills with due dates and mark each payment in my budget?
Everything in your tutorial is excellent. The only thing I need to add is to organize all my bills with due dates and amounts paid, especially with credit cards.
Yes, all those things are possible.
How can I create a calendar with bill due dates linked to the one you made?
Awesome!!!
What an amazing tutorial and a spreadsheet. I only have one question, when it comes on putting your income sources, are you putting them on gross income or net income??? Assuming someone with a regular job and investment or side hustle,for a job it will be tax right away, in short, net income. On the other hand, making an income on investments and side hustle, such as, capital gains and dividends is I consider gross income. Also, it will only be tax on filing season. Which part of the income should I put on the spreadsheet, the gross/pre tax or the net/after taxes to make everything accurate??? Thank you and have a great day.
Net income will make things the most accurate!
@@Dividendology in that case, what do you suggests on how to include an investment income??? Thank you.
I have question if I select the first row or second in transaction category as utility or medical for the results is not match in monthly category. Could you help me please
Even I'm facing same problem.
Good info, subscribed :)
This is exactly what I needed. I tried this and but some of the categories don’t total the amount for some reason. What could it be?
I would check and make sure your formulas are correct. Also be sure to check your formulas have absolute values if needed.
This was so easy and fun to create. Thank you!
You’re welcome!
whenever i finish Data Validation, then my SUMIF formula in column H, my values are always 0, no matter what data i put in to Column D
Anyone else get this?
Do you have this template available for download ?
Yes! Available on my patreon page. Link in description.
icolud't see it can I purchase it @@Dividendology
is there a one time buy to use it
Sorry if i missed it but is this in excel or google im new to this stuff and trying to put together budgets
I made it in google sheets, but it could be in excel as well.
@Dividendology thank you for a quick response it's much appreciated and I've subbed have a great day
Thanks!
How can I download this template?
You can download it on tickerdata.com !
@@Dividendology I got it. I was confused when I went to the website.
Great Video! Would you be able to add a “yearly summary sheet” that would total income and expenses for all 12 months?
Good idea!
@@Dividendology How is this coming? Soon?
You can look at “Personal Finance with Leila” she has a template for that.
@@jenniferhernandez-p.7106 Thank you. I’ll check out her channel
can i create the same TEMPLaNTE and seel it ?
no, these spreadsheets are copyrighted.
@@Dividendology AND HOW TO GET ONE LIKE THIS WHITOUT COPYRGHTED
Amount left to invest in the end ....??? good luck! you gotta put investment in transaction. first invest then spend.
SUPER IRRITATED with your video I’m new to sheets needed the tutorial and I don’t know what going on but as soon as I go to data I’m lost your screen does match mine any longer and I can’t add so what certain are you even using
Hi friend! The pop up is what you need, it’s just an update! If you see the “any value” drop down. Go to list, select the categories in the second box and then just hit ok!
I hope this helps!
Wow! People like you make me laugh! You need to work on your manners and remember you are not entitled to this information, they are giving you!
@@B4by1534Thank you so much for the comment as we are going to make this in our own! You helped me and the class because we didnt have the updated version of it!
Great video man this was very fun to make
Glad you enjoyed it!
this is great! how should one link bank accounts to reflect this? say you have 5 bank accounts, how would one track the end balance at the end of each month, perhaps you used WellsFargo for groceries, then Chase for transportation, etc...
I think you should add another column for the payment method. Then you can also create a pie chart for the several ways you use your money. And if you want an overview of each payment method, you must add a few extra rows to fill in the starting balance of each payment method. And of course a few extra rows with the totals of the payment methods using the sumif function.