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

[@bappo1525]

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]

yessir gotchu! fast and efficient, we like that

[@shar555]

RIGHT!!! ❤

[@quietstorm3254]

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]

thanks! appreciate it 😁

[@aly1784]

OMG I hate numbers and formulas but I was able to create my own expenses tracker thanks to this video! Tysm!

[@JeremysTutorials]

you're welcome! 😁

[@saminates2002]

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!!

[@JeremysTutorials]

Let's go!

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

i appreciate that! thanks for your kind words! :)

[@bhavneshparikh8283]

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

[@anastasiasemeniuk779]

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]

great to know! i appreciate it :D

[@vvslzr]

No seriously!! god bless him

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

Glad it was helpful!

[@michaelorlando3007]

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]

awesome! grats on your house purchase! 😁

[@susanapedroza730]

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]

Glad I could help!

[@iamawesome829]

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!!

[@JeremysTutorials]

youre welcome!!

[@itsmemonicapaula]

HEAVEN SENT! This is a less overwhelming budget tracker and very simple especially on expense categories 🤣

[@JeremysTutorials]

appreciate it! :)

[@Jeffin_Around]

23 about to try being self employed. Need to get expenses in check down to the dollar. So this is awesome. Thanks!

[@JeremysTutorials]

You're welcome! Best of luck to your journey!

[@LohBikes]

I really appreciate how you made the tracker so simple and efficient yet effective. Helped me out a lot, cheers 👍

[@JeremysTutorials]

glad i can make it helpful for you :)

[@antonetteesparagal4929]

Thank you! Been looking for an easy way to manage finances, you're a lifesaver! ❤

[@JeremysTutorials]

Happy to help!

[@johnchens]

You're the best man!!! Can we get some more slides tutorials though?

[@JeremysTutorials]

for sure more coming your way 🫡😁

[@christopherdejesus4913]

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]

awesome! glad you enjoyed. i will keep note of enlarging formulas next time 😊 great suggestion!

[@antoniacatalina2441]

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!

[@JeremysTutorials]

You're welcome! I appreciate it

[@EvansStaff007]

This saved my life, as I would have NEVER figured out these formulas in my own 💚

[@JeremysTutorials]

glad i could help!

[@EvansStaff007]

@ yes, thank you!!!!

[@yeonieee1]

This is so easy, quick and a simple video tutorial. Thank you!

[@JeremysTutorials]

You're welcome!

[@aayushjaiswar5488]

Such a nice and awesome way to track expenses. Thank you, everything was clear.

[@JeremysTutorials]

Glad it was helpful!

[@cassiemyers6689]

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]

awesome! glad you found the video :D

[@abisolaoladipo7402]

Thank you for breaking it down so well and short

[@JeremysTutorials]

youre welcome!

[@mellymello8747]

Thanks for the tutorial. You answered every question I had regarding a Budget Tracker.

[@JeremysTutorials]

Glad it was helpful!

[@andonisr]

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..🙂

[@JeremysTutorials]

No worries! I'm glad you're able to find this solution out. I appreciate your comment :)

[@alez296]

You're my hero man! Tysm for this easy tutorial! really appreciated

[@JeremysTutorials]

you're welcome!

[@moralesska0131]

I’m not savvy with spreadsheets but you made it easier than others to follow along. Thanks

[@JeremysTutorials]

appreciate that! not savvy with spreadsheets either :)

[@jastdeh]

straightforward and simple, thanks brother!

[@JeremysTutorials]

Glad it helped!

[@ciera-2]

BRO THANK YOU SO MUCH GETTING MY PAYMENT FROM FIRST JOB EVER TOMORROW AND THIS HELPED SM THANK

[@JeremysTutorials]

best of luck to your new job!

[@ciera-2]

@@JeremysTutorials omg thank you so muchh

[@ArtByCelyne]

This is awesome! It's so simple and effective. Thank you!!

[@JeremysTutorials]

Glad it was helpful!

[@elainewagayen3721]

Thank you. 👏 This is exactly what I was looking for my Google Sheets.

[@JeremysTutorials]

great! enjoy :)

[@danielladargenzio5080]

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]

thank you! yes, keep track of those expenses, let's go :)

[@irenepistia]

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!

[@JeremysTutorials]

Try using the ; and , interchangably

[@takeoverdept.]

Amazing video bro, I was able to turn in my homework and learn how to make a quick and easy budgeting sheet🔥

[@JeremysTutorials]

Nice! That's the way to do it :)

[@abigailsolum6995]

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

[@JeremysTutorials]

not sure, try double checking the formulas again

[@YoshiTheRedstoner]

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?

[@JeremysTutorials]

Not sure if there are any updates, try using , or ; interchangeably

[@janis2421]

same

[@kalmankoseler2093]

Same! Mine just remains zero

[@ErnestoBarbon-mm6zs]

Just what I was looking for, Great video bro 😎

[@JeremysTutorials]

appreciate it! :)

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

Hi i think the equal sign should be a comma!

[@JeremysTutorials]

yep, the second one should be a comma!

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

can you put your formula?

[@IvyLi-s4v]

The video was very through! Really easy to do but I was wondering if it was possible to have dropdown categories and dropdown subcategories?

[@JeremysTutorials]

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.

[@leonvidela5984]

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!

[@Rico4801]

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.

[@JeremysTutorials]

phone may be limited. I think a computer might be required for more controls

[@Dayzview]

for some reason i can´t get the "=SUMIF" formula right, i need help!

[@rogsgimino]

Thank you bro for you detailed tutorial. God bless!

[@awesomedosages]

Can you create a chart on this? To know which expenses are more spent than others

[@andonisr]

Hi again, Could you pls help with the formulae you mention to see the negatives you mention in 6:07 ?? Thank you

[@JeremysTutorials]

What do you mean?

[@TOMMYBMP]

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!

[@luthfiatiambar9577]

It's so useful. Thank you so much

[@thekushagrashrivastava]

This is amazing, thank you!

[@JeremysTutorials]

you're welcome!

[@priscillavon]

NEEDED THIS! Liked and Subscribed! ✅

[@JeremysTutorials]

appreciate it :D

[@henryhawes638]

Great tutorial thank you

[@JeremysTutorials]

You’re welcome 😊

[@relaxedzone2943]

Thank you so much omds this was so life changing ❤❤❤❤❤❤❤❤❤❤

[@fizjotherapist]

Thank you for that!

[@JeremysTutorials]

youre welcome :)

[@andiwuzlikeBAM]

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]

Try using ; instead of , as someone else mentioned!

[@andiwuzlikeBAM]

@@JeremysTutorials thank you!!

[@just_yisah]

​@@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.

[@siggeee1]

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]

you can try using the SUM() formula?

[@JeremysTutorials]

might be a tad complicated tho!

[@latashacoleman1875]

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.

[@JeremysTutorials]

Did you get the formula correctly?

[@fatkitty4207]

This is great, thank you.

[@JeremysTutorials]

youre welcome;

[@razoanahmednishan4112]

Thanks, love from Bangladesh

[@OhLilacc]

I love this so much ! But I’m on my second month now and I’m not sure how to go about it, it’ll just keep adding the expenses and income from the month above because they’re in the same column and idk how to make it so that doesn’t happen, I’m sure there’s and obvious solution lol but I’m an idiot when it comes to to excel 😅

[@bhavneshparikh8283]

can you provide this file?

[@dillaananda4971]

Thanks Jeremy!

[@JeremysTutorials]

you're welcome!

[@NabiAnnyeong]

why is my SUMIF formula not working 😢 it's so frustrating

[@alvarorodrigues1141]

Thanks man, you rock!

[@JeremysTutorials]

no you do!

[@amitranjan7658]

Would be great if this is linked with a google form where entries can be put from google form

[@JeremysTutorials]

ohh that would be a good idea!

[@yuletide4805]

Can you please make a tutorial on how to create an inventory tracker sheet

[@JeremysTutorials]

sure!

[@icha2011]

Does anyone know if he has a video showing how to add this with a monthly dropdown. That way I just click on the dropdown to view all the data entry per month?

[@JeremysTutorials]

i don't have that one yet but that's a good idea!

[@MikeChrisMike]

Such a legend

[@dickyzuerst2828]

thank you so much for your awesome video

[@JeremysTutorials]

thank you for watching! :D

[@therealitychannel6429]

Thank you. Much appreciated!

[@JeremysTutorials]

You're welcome!

[@furiofavetti8887]

I got it why you said in five minutes! You speak so fast that certainly it is not a video for not English speaking natives. BUT Very good and thank you!!

[@JeremysTutorials]

Appreciate it!

[@deedeessunshine]

Amazing

[@JeremysTutorials]

Thank you! Cheers!

[@calista910]

this was cool

[@JeremysTutorials]

thanks youre cool!

[@ksao13.13]

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]

up to you! you can do either way

[@thehoodedcow6696]

Dude thank you!

[@JeremysTutorials]

No problem!

[@austinrpt]

superb thanks

[@JeremysTutorials]

you're welcome!

[@docklikeswamen925]

What if my income fluctuates from period to period? How can i automate that?

[@KylePollard-b5g]

I cant get the actual formula to work on my google sheets It says error when I type in the formula

[@Nihonimode]

where to get a copy of this?

[@softlegogurl]

why sumif i have an error?

[@hishammariyas.]

Useful Thank you

[@JeremysTutorials]

you're welcome!

[@giovanniabraham7653]

trying this out !!!

[@JeremysTutorials]

lmk how it goes!

[@eveningswitheve8054]

Can someone help me with the actual percentage formula for column I please!!

[@JeremysTutorials]

does the video formula not work for you?

[@utxedfit]

bro you are legend

[@JeremysTutorials]

no you are!

[@myhighserotonin]

you're a lifesaver

[@JeremysTutorials]

thank you!

[@MaCherie-zd7tw]

The SumIf formula doesn't work :/

[@JeremysTutorials]

can you drop your formula?

[@dr3271]

@@JeremysTutorials =SUMIF(E:E="Gas",D:D) All my categories just show zero

[@dr3271]

put commas instead of = ......... e.g. =SUMIF(E:E,"Needs",D:D)

[@rahmahajarwaheed3653]

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!

[@arihtawulan7569]

Thankyouuuu very much❤

[@JeremysTutorials]

You're welcome 😊

[@AmicieO]

Merci 🙏🏿❤️

[@franklinwong6920]

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]

Should be possible!

[@JeremysTutorials]

Try messing with the values and formulas for the columns. How do you have it formatted?

[@hinimajesty3769]

Very useful 🤗

[@JeremysTutorials]

Glad you think so!

[@Poetic_Pallete]

jusr wish you zoom wheb typing formulas

[@JeremysTutorials]

huh

[@thehoodedcow6696]

I've been wanting an automatic way to do my budget

[@JeremysTutorials]

yep now you can 😁

[@michaelklindtofficial805]

Holy shit. I will be thanking you in life later.

[@JeremysTutorials]

i'm thanking you now for watchin :)

[@thegryd0128]

Thanks a lot!

[@JeremysTutorials]

You're welcome!

[@Anakin-ai]

How can i calculate the next month?

[@JeremysTutorials]

same idea, just change month!

[@Brassen9]

Can i download this?

[@JeremysTutorials]

unfortunately I don't have a file to download but you can follow along for 5 minutes and youll have the same thing :)

[@atharvbokade8130]

How can i do the same for the next month?

[@JeremysTutorials]

same exact thing, just change the number of days in the formula!

[@RyanWeaver-i3j]

thank you!!

[@JeremysTutorials]

You're welcome!

[@LuxuryOption4756]

Where is the windows key that pops up the emoji's?

[@JeremysTutorials]

windows + . (dot) 😁

[@LuxuryOption4756]

@@JeremysTutorials on Windows 11 you must use ; instead of . Thanks.

[@careenjanepilayre8239]

How to do the dropdown on iphone ? 😢

[@JeremysTutorials]

not sure :(

[@kamod7929]

crazyyyyyyyyyyy

[@JeremysTutorials]

appreciate it!