How To Track Your Expenses in 2023 | Mind Blowing Google Sheets Tutorial

In this video, we go through how to create an automated budget tracker spreadsheet that tracks all of your INCOME and EXPENSES. See all the cool tricks we use with the magic of Google Sheets to make this useful tracker.
#GoogleSheets #BudgetTracker #Excel
/ @brianturgeon
brianturgeon.yt

[@brianturgeon]

Here is the link to my template! Hope it helps! docs.google.com/spreadsheets/d/181zwar-_xxq3oiPvJv8cz2vHYcu3w-il2ZxE-XfonYs/edit#gid=0

[@MrNGTfan123]

You can only view it

[@brianturgeon]

You have to make a copy first. Hope that helps!

[@DJClarkedezigns]

@@brianturgeon Thanks, ill give it a go

[@CamMineo]

How do you make a copy? It’s just a webpage showing the template. How do I save a copy into google sheets?

[@CamMineo]

Ok it gave me an option to add to google sheets on my phone, just not when I clicked the link on the computer. All good. Thank you so so so much 🎉

[@codyrouse2372]

hey brother as another young guy thats less financially educated but tryin to get better I just came across your video and gotta say thanks. me and my girlfriend are planning on moving so we are saving up and we both found this video to be really helpful. I appreciate you for being so clear and concise

[@brianturgeon]

Really appreciate that! Thanks for watching

[@waynemwandi6522]

@brianturgeon what this guy said

[@Dennis_here]

What you read !

[@cabrak4n311]

Hell yeah! A comprehensive, direct video about how to see where your money is going. You are teachings us what we were supposed to be taught in school. Keep it up!

[@josephsamano1950]

I have a small local business and was struggling to keep up with my assets and liabilities, this simple spreadsheet is everything I need to stay organized and stay on top of my business/personal financial side of things. You are a G!

[@lukeyluke69]

Absolutely wonderful. Simple, concise, no fluff. Excellent job.

[@SylwiaUrban]

Brian, I can't thank you enough for this video! I've been tracking my expenses since 2017, I experimented with numerous versions, created my own, used mobile applications but without a doubt, the one you've shared is the most exceptional. I've already started to use it, I slightly customized it so that it fits better to what I need. I've always struggled with sheets having too much information that I ended up not analyzing it at all. Your solution is incredibly precise and minimalist while capturing the core of financial tracking. Thank you!

[@brianturgeon]

Thank you so much! Glad it helped!

[@mollymcgreevy1187]

This is insanely helpful, especially as someone very intimidated by both expense tracking and sheets. You made it so easy to follow and made me a little more confident about learning the tool and getting my finances under control. Thank you so much!

[@brianturgeon]

Thank you!

[@edsterling5258]

Tip: on the transactions tab, arrange activity in chronological order, oldest at the top, add new current rows at the bottom. Why? Doing so spares you the hassle of INSERTING a new row for every single event. There are ample empty rows at the bottom. Plus, chronological order just makes sense to view. Bonus tip: place a running sum column on the right side of the main tab. Just be sure to count income as a positive and expenses as a negative. (I've been doing this since the 1990s.) Good video.

[@Jonesy02445]

You mind sending a formula for that?

[@alexiamcbride7441]

⁠@@Jonesy02445 =SUM(Cell#:Cell#) In the paranthesis are the cells you want to calculate Example: (A1:A10). This is a formula that works in Excel I’m going to assume its the same as Google Sheets I could be wrong, but if you can locate the autosum function and click on it when you are at the bottom of the sheet then you can use it as a Total row.

[@joukenienhuis6888]

Isn’t the running sum column just the same as the net income table ? Or do you mean the sum of the transactions ? That also requires a starting total of the balance

[@wallstreettrader1]

A running sum can REALLY slow down the processing speed of even a fast computer. His method avoids this, and is worth the extra effort.

[@jpsc1316]

Exceptional work

[@brunatavares1812]

I'm trying to get on my feet again and recover from a work related burnout, by re-learning new ways of productivity and organisation for my personal life, and one of the main steps is getting my finances in control again. This video of yours is perfect, you're so clear and easy to follow, I've learned so much and can use it on my own Budget Tracker. Great work!! Thank you so much

[@brianturgeon]

Thank you! Glad to hear it!

[@harrywin571]

I have to thank you greatly as a young man trying to get his finances together after life started throwing mean curve balls! You have just simplified my living experience and I appreciate you greatly

[@johnpanik7511]

The absolute best video for my small business. Thank you,thank you, thank you.

[@kshegde3000]

I had given up on Sheet tutorials for Finance Tracking. But this right here is so simple yet effective template. Amazing !

[@Igottabooty]

Clear, concise and to the point and exactly what I was looking for. Brilliant! Thank you

[@brianturgeon]

Thank you!

[@jillschlueter2125]

WELL DONE!!! Thank you for taking the time to record this! MUCH Appreciated.

[@MrMmahesh007]

Well done .. amazing work

[@vielleicht-spaeter]

Awesome work, thank you for sharing

[@user-ld2oi2vl8v]

🙏🏼Thank you so much for your help. Your instructions were clear and easy to follow. Thank you for being so helpful, Brian.

[@TerenceJacksonFA]

Great Job! Very well executed, as you mentioned in your last line that you have worked hard on this video. We can clearly see how much you have invested in getting this video to near perfect from your vocabulary to tone to simplicity and doing it on the fly is amazing. Keep up the good work. Do not give up churning videos like this.

[@drtaibi-techtalks]

Clarity and ease of use is amazing, thumbs up!

[@jhonnidarshan3094]

It is awesome

[@sarahironsbaker5228]

I don't even need a spreadsheet like this and still watched the whole thing. Well done!

[@robertodiana7798]

Hi! This is, for me, the best "easiest way" for create an efficient financial tracker on google sheets. Super simple to do and it works really good! I really appreciate that video. Thank you!

[@mjs28s]

Very nice! This is one of the best 20 minutes spent watching a video. A tool that one can use for life and with spreadsheets from different developers being similar enough in how they work, this video can help with Excel, Softmaker, Open Office, Free Office, etc. 👏

[@brianturgeon]

Thank you! I'm so glad you enjoyed!

[@shacheb]

Great tutorial, thank you so much for taking your time and walking through everything. It's a great video. We can see all of your hard work. Much appreciated.

[@ChaddyMurraytv]

Great Video thanks

[@deannajohnson3548]

This was the best video. You explained this in a way that I GOT IT!! I have been searching for someone that had a simple way to explain this all to me. YOU NAILED IT!!!

[@chtulurr]

Great video

[@desimusgrove]

I could cry! I've been looking for something simple! I thought I should be able to do it easily but everything I found was so complex or didn't work how I wanted. Your video was so easy to follow and I'm about to test out your template!

[@faridfarhumand7888]

This is brilliant! Thank you so much for sharing. I needed a way to analyze my financials and followed your instructions. I added loan repayments, investments and savings to the Journal and now I am all set:)

[@chukulatinha]

Amazing

[@jmaccards15]

Great Video

[@kristynvilcinskas8407]

Thanks Brian! This is exactly what I have been looking for!!! EXCELLENT TUTORIAL!

[@georgepoulos]

Genius - thank you for this.

[@gsteel9408]

Very Good, Well Done, Thank You!!!

[@thetimgale]

This is a game changer for me. The reporting tables are so useful, thanks Brian 🙏

[@same4424]

Thanks for this amazing and simple method. For a guy like me monitoring money is a must and what way better than knowing what each column actually does rather than using apps that confuse you. Also, with this way, as I created it my own(with your help), I will now make sure I script everything in it, and won't be the lazy guy again. Thanks again and I wish you good health and peace. :)

[@donniep.1513]

This was GREAT! The only thing I did differently was I didn't make an accounts page. Since I was adding all my expenses from top to bottom it just made sense to format the entire column in the journal sheet for that drop down menu to track. Thanks for making this sooooo easy!

[@greenspiritarts]

Looking forward to giving this a try! Thank you for all your time, thoughtfulness and effort. Very well done!

[@unakapoor1997]

OMG This is the best video I have ever come across. Your voice is so calming and you take your time in explaining each step without screaming or loud using too many unnecessary words which is so vital to understand. This is my 1st time doing a google sheet and I'm so stoked that I could create one while watching your video simultaneously. Thank you so very much.

[@brianturgeon]

Thank you!

[@christinenguyen2530]

Excellent video. Thank you

[@saltyfabs4502]

Wow!!! You just blew my mind and changed my life!!! I had something totally different then this and it just wasn't working the way I hoped...automating everything is SO INCREDIBLY HELPFUL!!! I already made mine and LOVE IT! Thanks a million! New fan of your great work!

[@brianturgeon]

That's awesome! Glad you enjoyed it

[@manasandmohit]

Nice guide

[@Jay-re6bw]

Thank you for this! Very easy to learn and follow along, looking forward to viewing your other videos.

[@roywilmhoff]

Very helpful and well explained

[@amirrezaax22]

awesome!

[@kjthirty3]

Thank you! Started a new job and taking on a lot of bills and this helped more than any budgeting app. Perfect tutorial!

[@shortykief4839]

Not gonna lie man as someone who's Excel/Sheets illiterate this saved me so much hassle. Thank you so much.

[@kraftymind]

Thank you so much! Really appreciate all the hard work you put into this video and template!

[@Aliallah_Empire_Gaming]

Very great and informative video. Ready to start off 2024 with this income and expense tracker!

[@Letha222]

Very helpful. Thanks.

[@HodCohen135]

I've been wondering how to follow my expenses and revenues more efficiently in google sheets. You just made my life easier, thank you

[@montellellis4168]

Very clear and helpful video.

[@hankl1118]

Love it! Great job! Will use it to improve my overly complicated expense tracker requiring way too much time and actions to get the same results as yours!

[@camioneur]

Thanks Brian, just brilliant!

[@jakubbojczuk5781]

brilliant!

[@sassybanjo3586]

So excited! You have helped me so much for setting up my spreadsheet for 2024!

[@kwijukaderek4682]

And trust me your effort is highly appreciated.thanx again

[@91210paige]

Thank you Brian! My Family desperately needs this!

[@justina1713]

Very helpful, thank you so much for the walkthrough.

[@amritasingharay3095]

Best video ❤

[@user-fo8jy9pq9z]

Thanks for the easy to follow step by step instructions!!! #1 Saved me from a lot of frustration.

[@KristiineMerzin]

Best template/tutorial i have found, thanks!!

[@JKittles]

Nicely done. I like seeing how others create their own expense tracking sheets. I just subscribed.

[@tonedo7925]

After watching your video, I was able to create a customized version that perfectly meets my requirements. It functions flawlessly, and I made a few additional modifications to enhance its performance further.

[@LydiaSantiago]

Wow this was amazing. I was trying to search how to do this but didn’t know how to ask the question. Your video popped up and you answered all the questions and others I didn’t even know I had.

[@chrisdanner2785]

Hey Brian, i really appreciated your work and replicated this expense tracker, i find it so cool and easy to use! Thanks for that little masterpiece you just gave us ;)

[@joukenienhuis6888]

Great tutorial and a very good alternative for excel, because everything is easier to find and if not, you tell it where I can find it. I only have a problem inkeping it up to date in real time, because for every expense to fill it in each time you spend takes time, because you have to open your sheet and fill in the data. And if you import the data from your bankaccount, it seldom says expense or revenue in the description

[@_kevinwm]

Simple and effective! Best one I saw, great video man!

[@JennelJohnNatindim]

Thank you Brian! Great help!!

[@MiaKim-jd8ie]

You are truly a life saver! Thank you SO much!

[@matt.ny84]

Amazing job and thank you! I’ve been wanting to learn how to do something just like this for quite a while! You just saved me a bunch of frustration lol

[@IhmePaskaa]

Oh this is so amazing. I have just begun tracking my personal finances and this is perfect for it.

[@jamescummings2131]

This is freaking killer! well done and thank you!

[@ghoul3474]

Brilliant video! Extremely helpful! You couldn't have explained it any clearer. Thank you so much Brian!

[@brianturgeon]

Thanks so much!

[@patriciaespinosa60]

Thank you so much for doing this template! This is exactly what I've been trying to do for my bookkeeping but didn't know how to. God bless you!

[@DillonlSpriggs]

Very helpful, Thank you.

[@vadud3]

Loved it!!

[@mitchellvogel4058]

Thanks so much for the great template. you are very kind to share your expertise and many of us do appreciate you!!!

[@gaila.8830]

Thank you for showing an easy way to do such a tracker 👍😊

[@bukamonkey0917]

Very well done! Thanks for the helpful video!

[@Bamboos_Channel]

AWESOME! learned everything I needed and more!

[@mayraraphael6488]

This is great! You're so detail and easy to follow. Thanks!

[@akhmadsaad2753]

Thank you ♥

[@talie_stowell]

This is so amazing. Seriously. Thank you so much for this, I can't wait to enjoy tracking my finances now!

[@brianturgeon]

Thanks so much! Glad you're excited

[@theromadumela6151]

Definitely worth a like and a subscription, great video! Thank you

[@RonelieRojo]

Thank you so much! much appreciated

[@notta3d]

Very nice. Thank you.

[@janetgreenler7602]

Just watched your video, it was most helpful but will take me awhile to figure all this out and implement it for myself! Thank you!

[@lizbethsuarezrealtor]

Thank you!!! Very simple to follow and create. I'm so glad I found your video :)

[@undergroundsnax]

Thank you for the video

[@WilliamOwens-xt4ro]

This was an awesome video. It was exactly what i was looking to do for my business. Thank you very much!!!!!

[@Wingit_W]

love this!!!

[@earllouiebagay5522]

Thank you. This is very helpful. May the universe bless you with everything you need!

[@veetragparekh]

life saverrr!!!!!

[@naomis8973]

Really great video, thank you so much Brian!

[@coreychauvin7484]

This video is excellent. Worked perfectly. Could have never figured this out. I would have paid for this information.

[@user-gz6mt7dv8t]

Exactly what I was looking for. Many thanks!!

[@mariusz6362]

yes, even more of your personal information for Google to sell to others and profit ... well done people.

[@MrDmuny944]

Very Helpful thank you

[@kelliemcgee1777]

This is exactly what I was looking for. Thanks!