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

[@JeremysTutorials]

‼‼IMPORTANT‼‼ Hey guys! Heads up, I'm aware some of the SUMIFs aren't working. If some formulas don't work, try interchanging some , with ; and vice versa! You can also try retyping the "Needs" and different categories (both on the dropdown AND formula) to ensure there are no odd characters or spaces that may affect it (it's case sensitive!) Remember that "Needs", " Needs ", and "needs" are NOT the same thing; Sheets will read these differently.

[@gpdrhfh]

my goodness, Jeremy! This is so kind of you to give your viewers & followers quick updates on some issues....!

[@hotdisonoscar5348]

Brother why I can't use dropdown in my HP spreadsheet

[@rinujacob7623]

Thank you. Your video helped me in a big way. the way you presented was very simple and easily understood

[@SamiCleveland-b6b]

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?

[@bigz9937]

Did you figure this out? My sumif formula is not working.

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

[@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!!! ❤

[@junbecks]

You got this!

[@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! 😁

[@tuhanaeshelman61]

This is great! I am 47, have a 20 yr old in college, married and have as a manger of a finance department for years. However, I now have a brain injury and struggle with budgeting. So many don’t understand my anxiety over money.

[@JeremysTutorials]

Glad I could help!

[@adamsales]

people would pay 20$ for content like this. can't believe this stuff is free in the internet... as someone who completely knows nothing about Sheets, thank you brah

[@JeremysTutorials]

thank you!

[@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! :)

[@bwint]

This helped me so much. Most other videos are specifically for month-long budgets. I didn't know anything tech wise on how to make this work. THIS WORKS. THANK YOU!!!

[@JeremysTutorials]

youre welcome!

[@calebsmommy1531]

Thank you so so much!!! This was beyond helpful! Super easy to pause and follow along plus now I kind of understand how to use sheets for other purposes! 😊😊

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

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

[@marianjohnston1755]

Thank you!! It took me a long time to understand this but after watching I finally understand! Thankyou for your simplicity and for making it simple for me to understand. I normally get very overwhelmed by spreadsheets and don't understand! Now I do! Thank you!

[@JeremysTutorials]

Glad it was helpful!

[@melissae3337]

Thank you so much! The formulas worked for me and this will really help our family keep track of our expenses throughout the month to reach our goals for various categories of spending!

[@JeremysTutorials]

You are so welcome!

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

[@amandasinks5425]

Thank you so much! This was super easy to follow. I was worried Google Sheets would be overstimulating to me with all the columns and whatnot (as silly as that sounds). But nah, this turned out to be exactly what I was looking for.

[@iluvart1482]

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!

[@JeremysTutorials]

You are so welcome!

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

[@Abbie725]

Hi Jeremy! I just wanna say, THANK YOU SO MUCH for creating this video!!! I just bought a house and have been looking at a simple budget tracker. This was extremely helpful. I know this video is 1 year old, i was wondering if you’d be able to post a video or put a comment on how to add additional months in the quickest and easiest way.

[@JeremysTutorials]

hey Abbie! I would either make an empty sheet as a template and duplicate the sheet, or you can copy and paste what youve made to underneath it as a new month!

[@Abbie725]

⁠thank you! I will try your suggestions 😊ive been sending your video to my friends as well.

[@JeremysTutorials]

@@Abbie725 thanks! appreciate you!

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

[@mahimapaladugu4343]

OMG!!! This is the simplest and best tutorial ever. The sheet turned to be so vibrant!!!🙌🙌

[@JeremysTutorials]

appreciate it!

[@pamkarickhoff7814]

This is just what I needed for work to track technician tool allowances. Thank you for sharing your knowledge.

[@JeremysTutorials]

you're welcome!

[@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 :)

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

[@ViralReelMusic]

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

[@JeremysTutorials]

you're welcome! Love to India!

[@14kaiju]

Has to be one of the best tutorials I've ever seen on the topic

[@JeremysTutorials]

appreciate you!

[@iitzprestige8324]

Thank you for your helpful tutorial, brother!🙌 Now, I can start tracking my income and side gigs using the 50/30/20 rule.

[@JeremysTutorials]

Fantastic! Best of luck to your budget tracking!

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

[@itsmemonicapaula]

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

[@JeremysTutorials]

appreciate it! :)

[@Demian_Juarez]

this helped me so much! the SUMIF is Exactly what i needed to better my income sheets. Thank you!

[@JeremysTutorials]

you're welcome! ya that formula is clutch haha

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

[@antonetteesparagal4929]

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

[@JeremysTutorials]

Happy to help!

[@dannikasaur]

Thank you so much for this. It is a huge help with how you get straight to the point 🙏✨

[@JeremysTutorials]

appreciate it!

[@shadinej9388]

Jeremy that's so much for this simple and straightforward tutorial. Super helpful! Found FIX for the SUMIF, Steps: 1) click on arrow in dropdown menu (Column E); 2) click on the pencil icon to edit; 3) click cursor (mouse) at the end of "Needs" and delete any extra spacing after the "s"; repeat (Step 3) for Wants and Savings and delete extra spacing at the end of each word, then hit DONE, then APPLY TO ALL if that is an option. Then this formula will work =SUMIF(E1:E15, "Needs", D1:D15). NOTE: use only one space after each comma in formula. Hope this helps!

[@JeremysTutorials]

Great, thank you for helping me and the community out!

[@Jordyphysique]

DUDE INCREDIBLE BASIC TRACKER AND CAN BE USED ON PHONE THANK YOU

[@JeremysTutorials]

not a problem! appreciate it :)

[@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 :)

[@iusedusernamegenerator6569]

Saving my finances at uni, thanks dude!

[@patcstd]

I was able to create my own expense tracker as a newb. This was so helpful!

[@JeremysTutorials]

Appreciate it!

[@godwinakpan5975]

Please can you help share a copy of yours for me use as templete?, i'll appreciate.

[@aayushjaiswar5488]

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

[@JeremysTutorials]

Glad it was helpful!

[@mellymello8747]

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

[@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! 😁

[@reyanthonygarcia5481]

Yo! Was look for a good min through vids. This one aced it! Good work

[@JeremysTutorials]

Awesome! Thank you!

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

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

[@nikhildavies5001]

Hey, thanks man. This video was really helpful. You have a new subscriber 👍

[@TobiTheKat]

Thank you so much! This was extremely helpful, it's been forever since I've made a spreadsheet ^^;

[@JeremysTutorials]

Glad it was helpful!

[@yeonieee1]

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

[@JeremysTutorials]

You're welcome!

[@marco.montreuil]

Great video Jeremy, thank you so much ! God bless you, keep going!

[@JeremysTutorials]

appreciate you brother

[@alez296]

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

[@JeremysTutorials]

you're welcome!

[@bassboostlegend]

This is exactly what I was trying to find, thank you so very much!!!

[@JeremysTutorials]

You're very welcome!

[@elainewagayen3721]

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

[@JeremysTutorials]

great! enjoy :)

[@ArtByCelyne]

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

[@JeremysTutorials]

Glad it was helpful!

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

[@hanvanuffelen8546]

The budget tracking is great. You could however make it more accurate and sophisticated by adding a second sheet to track all transactions (minor and big) by date etc. So if you spend 5,11 on a meal at the supermarket you could track that receipt etc etc. And sum it up in it's entirety so at the end of the month you have tracked every single expense (by category) and can trace back what that category exists of (all the minor transactions you make throughout the month)

[@JeremysTutorials]

Hey appreciate the suggestion! That is an amazing suggestion, I'll definitely see if I can make a v2 in the future implementing your changes. Appreciate it!

[@cardshark111]

As someone who is 16, thank you this was so easy 🙏🙏

[@JeremysTutorials]

You’re welcome 😊

[@TheArchies-s8f]

Thanks Jeremy for the tutorial. it helps a beginner like me

[@JeremysTutorials]

Happy to help!

[@nyaturner4407]

Thank you so much!! The steps were so easy to follow I just paused and looked for it and it turned out great! I can't wait to show my husband and say I created this from scratch before I tell him you told me.😂 Can I ask how you would set this up if you wanted a bi-weekly tracker instead of a monthly one? I could not find any simple bi-weekly budget tracker apps for android ANYWHERE. Could you help me please?

[@JeremysTutorials]

youre welcome! I'm sure you can format it so it's bi-weekly rather than monthly if you just swap January with the week number or paycheck number/date!

[@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 :)

[@nancynewman1469]

Very good and simple budget! Thank you, Jeremy!

[@JeremysTutorials]

youre welcome Nancy!

[@SarahKhokhawala]

simple and to-the-point! Thanks!!

[@JeremysTutorials]

appreciate it!

[@jastdeh]

straightforward and simple, thanks brother!

[@JeremysTutorials]

Glad it helped!

[@sierrasearcy4761]

This was great! Thank you

[@JeremysTutorials]

You're so welcome!

[@abisolaoladipo7402]

Thank you for breaking it down so well and short

[@JeremysTutorials]

youre 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 :)

[@khadyst]

Hey thank you so much for sharing this ! I have question how to change the currency?

[@JeremysTutorials]

there should be a currency option in Google Sheets itself!

[@owenfrancisco7464]

Best simple tracker Thank you

[@JeremysTutorials]

appreciate it!! :)

[@believerinhumanity]

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.

[@JeremysTutorials]

You can go ahead and add that column. You can title it GOALS or something and you can easily have a look and compare it. You can also use an IF formula to see if the amount is greater than > or less than

[@ErnestoBarbon-mm6zs]

Just what I was looking for, Great video bro 😎

[@JeremysTutorials]

appreciate it! :)

[@Joseph-x6v7e]

So simple to use. thanks mate

[@JeremysTutorials]

no worries! Appreciate it :)

[@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 :)

[@abrahamjimenez2543]

Excellent, very simplied template

[@Bella-ee3wc]

Such a lifesaver!! Thanks!

[@JeremysTutorials]

Glad it helped!

[@lukebrewer6452]

Hi, thank you so much for the video, how would I then be able to do a remaining balance so I can see what is left to spend ?

[@JeremysTutorials]

you can do a formula where you subtract

[@rolanshegal8144]

Thank you, great tutorial.

[@JeremysTutorials]

Glad it was helpful!

[@zdhvocals9405]

THANK YOU!!! Ive managed to create the perfect tracker. However i have one question... for the expenses and the 'saving' option.. what sort of things would you put? im just confused with what spending i would mark as savings? thank you x

[@JeremysTutorials]

any gain to the account 😊

[@tianthonywagnerjr.5658]

This helped me big time, thank sir!

[@JeremysTutorials]

thank you!

[@princesilos9503]

Good work. very simple and very effective.

[@JeremysTutorials]

appreciate it!

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

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

[@tyraharris1951]

This is perfect, thank you Jeremy. Financial Freedom 2025 !

[@JeremysTutorials]

let's do it!

[@godwinakpan5975]

Please can you help share a copy of yours for me use as templete?, i'll appreciate.

[@dhimasaryadi2167]

Bro, it is sooooooo useful. God bless.

[@JeremysTutorials]

Glad it helped

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

[@kclaw0]

You need to limit the rows to a smaller value on the left side of sheet, I put mine to 50 or else I would have gotten an error as well.

[@takeveyannacobb4434]

For those who are stuck on the sum if after you do sumif click on the column he is clicking and don’t forget the comma before “needs” and after as well and click on the column next to the drop down column

[@takeveyannacobb4434]

I hope this made sense

[@JeremysTutorials]

Great pointer! Thanks for pointing this out!

[@thekushagrashrivastava]

This is amazing, thank you!

[@JeremysTutorials]

you're welcome!

[@henryhawes638]

Great tutorial thank you

[@JeremysTutorials]

You’re welcome 😊

[@Reineri]

Is it possible to sum up all the sheets and make a summary of the year? Would the easiest way be just to copy paste all the income/expense cells into a 13th sheet?

[@JeremysTutorials]

should be able to if you just sum everything up from a column

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

[@1deagr]

Hey I want to make a simplified version of this where I have like a "Bottom Line: £4,500" (for example) but then I want my income and expenses to subtract from it as I update, how can I do this? Currently when I use SUM function it just adds on my expenses which obviously isn't right.

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

[@rogsgimino]

Thank you bro for you detailed tutorial. God bless!

[@JeremysTutorials]

You are very welcome

[@relaxedzone2943]

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

[@JeremysTutorials]

appreciate it!

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

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

[@ChibuezeMuoneke]

HELP!!! SUMIF NOT WORKINGGGGG Edit: My error was being caused because there was a space after each drop down item. Instead of "Needs" in the dropdown i wrote "Needs " hope this helps

[@JeremysTutorials]

Good catch! Glad you're able to solve it

[@MicahKemble]

Bro your a life saver this was the problem with me and I was pulling my hair out thnx so much!

[@ChibuezeMuoneke]

@@MicahKemble haha, I felt the same way. Happy it helped you😁

[@zdhvocals9405]

Would savings be like business expenses? for example a train ticket?

[@JeremysTutorials]

i would assume not because you're technically not gaining any money into your personal accounts

[@luthfiatiambar9577]

It's so useful. Thank you so much

[@JeremysTutorials]

You're welcome 😊

[@awesomedosages]

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

[@fatkitty4207]

This is great, thank you.

[@JeremysTutorials]

youre welcome;

[@ReneeThompson-mo4qj]

❤thank you where can I get a copy please.

[@JeremysTutorials]

no copy of it unfortunately 😕 you gotta DIY it with the video

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

[@JeremysTutorials]

Yes you can! just add another column