Тёмный

EASY Budget & Expense Tracker with Google Sheets! *FULL TUTORIAL* 

Jeremy's Tutorials
Подписаться 12 тыс.
Просмотров 64 тыс.
50% 1

Хобби

Опубликовано:

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 136   
@bappo1525
@bappo1525 2 месяца назад
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
@JeremysTutorials
@JeremysTutorials 2 месяца назад
yessir gotchu! fast and efficient, we like that
@abisolaoladipo7402
@abisolaoladipo7402 8 дней назад
Thank you for breaking it down so well and short
@JeremysTutorials
@JeremysTutorials 6 дней назад
youre welcome!
@aly1784
@aly1784 6 месяцев назад
OMG I hate numbers and formulas but I was able to create my own expenses tracker thanks to this video! Tysm!
@JeremysTutorials
@JeremysTutorials 6 месяцев назад
you're welcome! 😁
@camillewilson2003
@camillewilson2003 Месяц назад
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.
@JeremysTutorials
@JeremysTutorials 23 дня назад
i appreciate that! thanks for your kind words! :)
@iamstar5575
@iamstar5575 Месяц назад
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.
@JeremysTutorials
@JeremysTutorials 23 дня назад
Glad it was helpful!
@yeonieee1
@yeonieee1 День назад
This is so easy, quick and a simple video tutorial. Thank you!
@elainewagayen3721
@elainewagayen3721 3 дня назад
Thank you. 👏 This is exactly what I was looking for my Google Sheets.
@aayushjaiswar5488
@aayushjaiswar5488 4 дня назад
Such a nice and awesome way to track expenses. Thank you, everything was clear.
@iamawesome829
@iamawesome829 3 дня назад
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!!
@quietstorm3254
@quietstorm3254 6 месяцев назад
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. 🙌
@JeremysTutorials
@JeremysTutorials 6 месяцев назад
thanks! appreciate it 😁
@christopherdejesus4913
@christopherdejesus4913 16 дней назад
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!
@JeremysTutorials
@JeremysTutorials 13 дней назад
awesome! glad you enjoyed. i will keep note of enlarging formulas next time 😊 great suggestion!
@susanapedroza730
@susanapedroza730 10 дней назад
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!
@JeremysTutorials
@JeremysTutorials 9 дней назад
Glad I could help!
@itsmemonicapaula
@itsmemonicapaula Месяц назад
HEAVEN SENT! This is a less overwhelming budget tracker and very simple especially on expense categories 🤣
@JeremysTutorials
@JeremysTutorials 23 дня назад
appreciate it! :)
@LohBikes
@LohBikes 27 дней назад
I really appreciate how you made the tracker so simple and efficient yet effective. Helped me out a lot, cheers 👍
@JeremysTutorials
@JeremysTutorials 23 дня назад
glad i can make it helpful for you :)
@anastasiasemeniuk779
@anastasiasemeniuk779 2 месяца назад
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 🥲
@JeremysTutorials
@JeremysTutorials 2 месяца назад
great to know! i appreciate it :D
@michaelorlando3007
@michaelorlando3007 3 месяца назад
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.
@JeremysTutorials
@JeremysTutorials 3 месяца назад
awesome! grats on your house purchase! 😁
@cassiemyers6689
@cassiemyers6689 2 месяца назад
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!
@JeremysTutorials
@JeremysTutorials 2 месяца назад
awesome! glad you found the video :D
@ArtByCelyne
@ArtByCelyne Месяц назад
This is awesome! It's so simple and effective. Thank you!!
@JeremysTutorials
@JeremysTutorials 23 дня назад
Glad it was helpful!
@moralesska0131
@moralesska0131 Месяц назад
I’m not savvy with spreadsheets but you made it easier than others to follow along. Thanks
@JeremysTutorials
@JeremysTutorials 23 дня назад
appreciate that! not savvy with spreadsheets either :)
@fatkitty4207
@fatkitty4207 2 дня назад
This is great, thank you.
@ciera-2
@ciera-2 Месяц назад
BRO THANK YOU SO MUCH GETTING MY PAYMENT FROM FIRST JOB EVER TOMORROW AND THIS HELPED SM THANK
@JeremysTutorials
@JeremysTutorials Месяц назад
best of luck to your new job!
@ciera-2
@ciera-2 Месяц назад
@@JeremysTutorials omg thank you so muchh
@thehoodedcow6696
@thehoodedcow6696 15 дней назад
Dude thank you!
@JeremysTutorials
@JeremysTutorials 13 дней назад
No problem!
@johnchens
@johnchens 8 месяцев назад
You're the best man!!! Can we get some more slides tutorials though?
@JeremysTutorials
@JeremysTutorials 8 месяцев назад
for sure more coming your way 🫡😁
@ErnestoBarbon-mm6zs
@ErnestoBarbon-mm6zs Месяц назад
Just what I was looking for, Great video bro 😎
@JeremysTutorials
@JeremysTutorials 23 дня назад
appreciate it! :)
@dillaananda4971
@dillaananda4971 3 дня назад
Thanks Jeremy!
@alvarorodrigues1141
@alvarorodrigues1141 29 дней назад
Thanks man, you rock!
@JeremysTutorials
@JeremysTutorials 23 дня назад
no you do!
@fizjotherapist
@fizjotherapist 26 дней назад
Thank you for that!
@JeremysTutorials
@JeremysTutorials 23 дня назад
youre welcome :)
@priscillavon
@priscillavon Месяц назад
NEEDED THIS! Liked and Subscribed! ✅
@JeremysTutorials
@JeremysTutorials Месяц назад
appreciate it :D
@dickyzuerst2828
@dickyzuerst2828 23 дня назад
thank you so much for your awesome video
@JeremysTutorials
@JeremysTutorials 23 дня назад
thank you for watching! :D
@arihtawulan7569
@arihtawulan7569 14 дней назад
Thankyouuuu very much❤
@JeremysTutorials
@JeremysTutorials 13 дней назад
You're welcome 😊
@thegryd0128
@thegryd0128 11 дней назад
Thanks a lot!
@JeremysTutorials
@JeremysTutorials 9 дней назад
You're welcome!
@danielladargenzio5080
@danielladargenzio5080 25 дней назад
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
@JeremysTutorials
@JeremysTutorials 23 дня назад
thank you! yes, keep track of those expenses, let's go :)
@hishammariyas.
@hishammariyas. Месяц назад
Useful Thank you
@JeremysTutorials
@JeremysTutorials 23 дня назад
you're welcome!
@thehoodedcow6696
@thehoodedcow6696 15 дней назад
I've been wanting an automatic way to do my budget
@JeremysTutorials
@JeremysTutorials 13 дней назад
yep now you can 😁
@yuletide4805
@yuletide4805 8 дней назад
Can you please make a tutorial on how to create an inventory tracker sheet
@JeremysTutorials
@JeremysTutorials 6 дней назад
sure!
@giovanniabraham7653
@giovanniabraham7653 Месяц назад
trying this out !!!
@JeremysTutorials
@JeremysTutorials 23 дня назад
lmk how it goes!
@carriganowens3472
@carriganowens3472 Месяц назад
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
@JeremysTutorials
@JeremysTutorials 23 дня назад
can you put your formula?
@hinimajesty3769
@hinimajesty3769 4 месяца назад
Very useful 🤗
@JeremysTutorials
@JeremysTutorials 4 месяца назад
Glad you think so!
@amitranjan7658
@amitranjan7658 4 дня назад
Would be great if this is linked with a google form where entries can be put from google form
@myhighserotonin
@myhighserotonin 3 месяца назад
you're a lifesaver
@JeremysTutorials
@JeremysTutorials 3 месяца назад
thank you!
@HaPpPySuRpriSe
@HaPpPySuRpriSe Месяц назад
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!
@Isabella-cn2lj
@Isabella-cn2lj Месяц назад
Hi i think the equal sign should be a comma!
@JeremysTutorials
@JeremysTutorials Месяц назад
yep, the second one should be a comma!
@utxedfit
@utxedfit 2 месяца назад
bro you are legend
@JeremysTutorials
@JeremysTutorials 2 месяца назад
no you are!
@RyanWeaver-i3j
@RyanWeaver-i3j 3 месяца назад
thank you!!
@JeremysTutorials
@JeremysTutorials 3 месяца назад
You're welcome!
@MaCherie-zd7tw
@MaCherie-zd7tw 2 месяца назад
The SumIf formula doesn't work :/
@JeremysTutorials
@JeremysTutorials 2 месяца назад
can you drop your formula?
@dr3271
@dr3271 Месяц назад
@@JeremysTutorials =SUMIF(E:E="Gas",D:D) All my categories just show zero
@dr3271
@dr3271 Месяц назад
put commas instead of = ......... e.g. =SUMIF(E:E,"Needs",D:D)
@rahmahajarwaheed3653
@rahmahajarwaheed3653 18 дней назад
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!
@siggeee1
@siggeee1 19 дней назад
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
@JeremysTutorials
@JeremysTutorials 13 дней назад
you can try using the SUM() formula?
@JeremysTutorials
@JeremysTutorials 13 дней назад
might be a tad complicated tho!
@michaelklindtofficial805
@michaelklindtofficial805 Месяц назад
Holy shit. I will be thanking you in life later.
@JeremysTutorials
@JeremysTutorials 23 дня назад
i'm thanking you now for watchin :)
@andiwuzlikeBAM
@andiwuzlikeBAM 18 дней назад
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". :(
@JeremysTutorials
@JeremysTutorials 17 дней назад
Try using ; instead of , as someone else mentioned!
@andiwuzlikeBAM
@andiwuzlikeBAM 17 дней назад
@@JeremysTutorials thank you!!
@bhavneshparikh8283
@bhavneshparikh8283 8 месяцев назад
can you provide this file?
@eveningswitheve8054
@eveningswitheve8054 3 дня назад
Can someone help me with the actual percentage formula for column I please!!
@hunderskunder2596
@hunderskunder2596 Месяц назад
thank you
@JeremysTutorials
@JeremysTutorials Месяц назад
You're welcome
@franklinwong6920
@franklinwong6920 13 дней назад
I wanted to ask is it possible to add only "Needs" and "wants" for total expenses instead of the whole column? Ive been trying to find answers else where but cannot...
@JeremysTutorials
@JeremysTutorials 9 дней назад
Should be possible!
@JeremysTutorials
@JeremysTutorials 9 дней назад
Try messing with the values and formulas for the columns. How do you have it formatted?
@ksao13.13
@ksao13.13 2 месяца назад
sorry if this doesn't make sense, but say I want to continue into the other month (upcoming is august) would I just continue adding into the chart or create a new sheet with the same formulas/format?
@JeremysTutorials
@JeremysTutorials 2 месяца назад
up to you! you can do either way
@Brassen9
@Brassen9 2 дня назад
Can i download this?
@Poetic_Pallete
@Poetic_Pallete 2 месяца назад
jusr wish you zoom wheb typing formulas
@JeremysTutorials
@JeremysTutorials 2 месяца назад
huh
@kamod7929
@kamod7929 2 месяца назад
crazyyyyyyyyyyy
@JeremysTutorials
@JeremysTutorials 2 месяца назад
appreciate it!
@Anakin-ai
@Anakin-ai Месяц назад
How can i calculate the next month?
@JeremysTutorials
@JeremysTutorials Месяц назад
same idea, just change month!
@LuxuryOption4756
@LuxuryOption4756 3 месяца назад
Where is the windows key that pops up the emoji's?
@JeremysTutorials
@JeremysTutorials 3 месяца назад
windows + . (dot) 😁
@LuxuryOption4756
@LuxuryOption4756 3 месяца назад
@@JeremysTutorials on Windows 11 you must use ; instead of . Thanks.
@atharvbokade8130
@atharvbokade8130 Месяц назад
How can i do the same for the next month?
@JeremysTutorials
@JeremysTutorials Месяц назад
same exact thing, just change the number of days in the formula!
@careenjanepilayre8239
@careenjanepilayre8239 Месяц назад
How to do the dropdown on iphone ? 😢
@JeremysTutorials
@JeremysTutorials Месяц назад
not sure :(
@landoneroberts
@landoneroberts 14 дней назад
My finances are in shambles!
@JeremysTutorials
@JeremysTutorials 13 дней назад
whaatt
@mutifatiya3890
@mutifatiya3890 2 месяца назад
i love you
@JeremysTutorials
@JeremysTutorials 2 месяца назад
thank you! much love and appreciation to you as well!
@alpicoo
@alpicoo 6 дней назад
3:23
@JeremysTutorials
@JeremysTutorials 6 дней назад
what happened
@alpicoo
@alpicoo 6 дней назад
@@JeremysTutorials sorry I just wanted to have a bookmark for myself at that timestamp 😳
@JeremysTutorials
@JeremysTutorials 6 дней назад
you scared me i thought i did something sus 😂 i was like huhhh LOL
@3viecos920
@3viecos920 3 месяца назад
Thank you! While this is great, you speak too fast and do not really show the step by step (ie. sum, percentage, etc) in an easy to understand way for beginners.
@JeremysTutorials
@JeremysTutorials 3 месяца назад
understood, ill keep your words in mind!
@PFGFrankly
@PFGFrankly 26 дней назад
its pay, awnnn man
@JeremysTutorials
@JeremysTutorials 23 дня назад
yuhh
@PFGFrankly
@PFGFrankly 23 дня назад
​@@JeremysTutorialsfound a free version anyway
@JeremysTutorials
@JeremysTutorials 23 дня назад
@@PFGFrankly wait i just realized you meant it's paid. nothing here is paid lol it's all free
@Devest8
@Devest8 23 дня назад
Is sheets an app? Or it’s off Google drive?
@JeremysTutorials
@JeremysTutorials 17 дней назад
Both! App on the phone and off Google Drive on the computer
Далее
Digital Google Sheets Budget Planner
28:22
Просмотров 141 тыс.
Китайка стучится Домой😂😆
00:18
Сколько стоит ПП?
00:57
Просмотров 338 тыс.
V16 из БЕНЗОПИЛ - ПЕРВЫЙ ЗАПУСК
13:57
Best Budget Apps for Families (2024) RIP Mint 🙏
12:10
EASILY Make an Automated Data Entry Form in Excel
14:52
How To Manage Your Money Like The 1%
12:45
Просмотров 1,3 млн
Take Control of Your Finances in 2024 with Excel!
15:35
How I Would Learn to be a Data Analyst
12:30
Просмотров 1,5 млн