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

Поделиться
HTML-код
  • Опубликовано: 12 янв 2025

Комментарии • 588

  • @brianturgeon
    @brianturgeon  2 года назад +147

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

    • @MrNGTfan123
      @MrNGTfan123 Год назад +3

      You can only view it

    • @brianturgeon
      @brianturgeon  Год назад +7

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

    • @DJClarkedezigns
      @DJClarkedezigns Год назад +1

      @@brianturgeon Thanks, ill give it a go

    • @CamMineo
      @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
      @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
    @codyrouse2372 Год назад +161

    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

  • @cabrak4n311
    @cabrak4n311 Год назад +45

    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!

  • @01adikz
    @01adikz 6 месяцев назад +15

    My man, I just started a business and I have to say, your videos is going to save me a lot of headaches. I've tried to work with google sheets before but it was too confusing for me. Your video if freaking amazing for new business owners trying to keep their paperwork in order. Thank you so much for making this video.

  • @josephsamano1950
    @josephsamano1950 Год назад +11

    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!

  • @mollymcgreevy1187
    @mollymcgreevy1187 Год назад +37

    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!

  • @SylwiaUrban
    @SylwiaUrban Год назад +9

    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
      @brianturgeon  Год назад +1

      Thank you so much! Glad it helped!

  • @edsterling5258
    @edsterling5258 Год назад +24

    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
      @Jonesy02445 Год назад

      You mind sending a formula for that?

    • @alexiamcbride7441
      @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
      @joukenienhuis6888 Год назад +1

      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
      @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
      @jpsc1316 Год назад

      Exceptional work

  • @lukeyluke69
    @lukeyluke69 Год назад +21

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

  • @Hoodieharrison
    @Hoodieharrison Год назад +2

    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

  • @brunatavares1812
    @brunatavares1812 Год назад +24

    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

  • @maryhilker7526
    @maryhilker7526 5 месяцев назад +3

    I came accross this by accident. What an awesome video. Clear and consise training. This will really help me in my business! Thank you so much! You did an awesome job!

  • @PopoRamos
    @PopoRamos 9 месяцев назад

    Thank You very much! This has made my income and expenses tracking significantly easier!

    • @brianturgeon
      @brianturgeon  9 месяцев назад +1

      Wow thank you so much for the generous donation! Glad it helped!!!

    • @PopoRamos
      @PopoRamos 9 месяцев назад

      @@brianturgeon I know you worked hard on this, you deserve much more

  • @mohummadshaikh86
    @mohummadshaikh86 6 месяцев назад +7

    this video was simple to understand, easy to follow and extremely helpful, thank you

  • @johnpanik7511
    @johnpanik7511 9 месяцев назад +6

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

  • @Igottabooty
    @Igottabooty Год назад +12

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

  • @TerenceJacksonFA
    @TerenceJacksonFA 10 месяцев назад +1

    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.

  • @robertodiana7798
    @robertodiana7798 11 месяцев назад +1

    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!

  • @kshegde3000
    @kshegde3000 11 месяцев назад +1

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

  • @shacheb
    @shacheb Год назад +3

    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.

  • @unakapoor1997
    @unakapoor1997 Год назад +16

    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.

  • @KaanOrantv
    @KaanOrantv 4 месяца назад

    That's the best expense & revenue tracking sheet design and explanation on whole RUclips. It's simple yet highly effective. Thank you!

  • @teaootamaakinui
    @teaootamaakinui 6 месяцев назад +2

    this was the best tutorial by far. Thank you. You were very clear and precise.

  • @deannajohnson3548
    @deannajohnson3548 8 месяцев назад +1

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

  • @thomasgargano5920
    @thomasgargano5920 11 дней назад

    This is very helpful and incredibly well done. My mind does not naturally grasp these things on which you're instructing-I had to watch it several times-I appreciate how thoroughly you covered everything; I am using this for my budget this year.

    • @brianturgeon
      @brianturgeon  11 дней назад

      @@thomasgargano5920 Thanks so much! Happy New Year

  • @seh5908
    @seh5908 Год назад

    Thanks!

  • @andonisr
    @andonisr 2 месяца назад

    Hey Brian,
    This is a great, easy to follow video. I particularly liked the Reports work you did with the drop down menus - this is incredible and it was a nice addition to my Expense tracker!!
    Cheers for providing the template too. I could see exactly what you'd done there!

  • @Aliallah_Empire_Gaming
    @Aliallah_Empire_Gaming Год назад

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

  • @shortykief4839
    @shortykief4839 Год назад

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

  • @sarahironsbaker5228
    @sarahironsbaker5228 Год назад +1

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

  • @mjs28s
    @mjs28s 2 года назад +11

    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
      @brianturgeon  2 года назад

      Thank you! I'm so glad you enjoyed!

  • @KristiineMerzin
    @KristiineMerzin 8 месяцев назад +1

    Best template/tutorial i have found, thanks!!

  • @mariusz6362
    @mariusz6362 Год назад +1

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

  • @Gal-VezHeatingCooling
    @Gal-VezHeatingCooling 11 месяцев назад +1

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

  • @Michelle-dj7dv
    @Michelle-dj7dv 19 дней назад

    Thank you! Your video was the easiest and most helpful. I am saving this in my playlist for future reference.

  • @gsteel9408
    @gsteel9408 11 месяцев назад +1

    Very Good, Well Done, Thank You!!!

  • @ankitahaidale
    @ankitahaidale 3 месяца назад

    I was looking to update my expenses tracker to make it easier and efficient. This was such a helpful tutorial, thank you so much! This automated tracker has made it so much easier to track my spending.

  • @bonzaiandcactus
    @bonzaiandcactus 3 месяца назад

    You're a really good teacher! Thanks for sharing your hard work!

  • @konstantinosvlachos2325
    @konstantinosvlachos2325 Год назад

    Perhaps the most valuable recourse if you have a business or you are student! Thank you very very much!

  • @yoflor6412
    @yoflor6412 7 месяцев назад

    Loved your video. It was very detailed. I plan to use it to keep up with my finances. I can tell you put in a lot of work. I appreciate you sharing your work.

  • @georgepoulos
    @georgepoulos 9 месяцев назад

    Genius - thank you for this.

  • @OptimalTransit
    @OptimalTransit 10 месяцев назад

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

  • @hannadigamon328
    @hannadigamon328 4 месяца назад

    After watching a million how to track your finances videos, this alone solved my problems!

  • @earllouiebagay5522
    @earllouiebagay5522 9 месяцев назад

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

  • @agronoxdt
    @agronoxdt 5 месяцев назад

    This just blew my mind... I am going to make this for myself as soon as my mind is back together.

  • @artventuresyeg
    @artventuresyeg 4 месяца назад

    This template is amazing! Just what I've been looking for. Thanks for this :)

  • @imran-yl7td
    @imran-yl7td Год назад

    To all RUclipsrs, This is how you ask for thumbs up and subscription.
    Hard Work, and helpfull. Great Work!
    Well Done Sir!

  • @jasonj2570
    @jasonj2570 Год назад

    My man, this is the best expenses tracker and I've been looking for a while now! Remaking it !!

    • @jasonj2570
      @jasonj2570 Год назад

      Is it possible to change the designated "accounting" currency from $ to whatever applies to my country? I like that it is separated, instead of the "Currency" option where the symbol sticks to the number, which is not visually appealing imo.

  • @montellellis4168
    @montellellis4168 Год назад +1

    Very clear and helpful video.

  • @MrCluelessQT
    @MrCluelessQT 6 месяцев назад

    Thank you so much for working hard on this and making it so easy to walk through and create . God Blessed you

  • @thetimgale
    @thetimgale Год назад +1

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

  • @ejovio3291
    @ejovio3291 Год назад

    Wow Brain! This was amazzing! Im so grateful for your process! You make it look so easy. A true google sheets wiz!

  • @tonedo7925
    @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.

  • @Joseslilsis
    @Joseslilsis 9 месяцев назад

    Thank you so much. It is incredible how much you can do with Google Sheets. I appreciate the tutorial and the template. You're the best. Liked and subscribed!

  • @rhickey2011
    @rhickey2011 4 месяца назад

    Brian, this was phenomenal. I am actually excited to implement this. Thank you for your gift to the world, brother

  • @TR4zest
    @TR4zest 8 месяцев назад

    What an excellent tutorial. Thank you so much. I wish you every success with the channel.

  • @kjthirty3
    @kjthirty3 9 месяцев назад

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

  • @CopyMSaka
    @CopyMSaka Год назад

    you got my like dude, straight to the point and no BS

  • @janetgreenler7602
    @janetgreenler7602 Год назад +1

    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!

  • @vivianang3741
    @vivianang3741 7 месяцев назад

    Thanks Brian! Sending you love and support from Singapore!

  • @dennisquach1233
    @dennisquach1233 6 месяцев назад

    you the man! thank you! simple, clean, effective!

  • @desimusgrove
    @desimusgrove 11 месяцев назад

    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!

  • @Jay-re6bw
    @Jay-re6bw Год назад

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

  • @jillschlueter2125
    @jillschlueter2125 Год назад +1

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

  • @RogerClubv
    @RogerClubv Год назад

    Hey Brian, thank you for your informative posting on this personal income/expense tracking Google sheet. Awesome job!

  • @Letha222
    @Letha222 Год назад

    Very helpful. Thanks.

  • @justina1713
    @justina1713 11 месяцев назад

    Very helpful, thank you so much for the walkthrough.

  • @CandyManSam17
    @CandyManSam17 5 месяцев назад

    Thankyou! you are awesome for making this!

  • @wolfwarrior1869
    @wolfwarrior1869 Год назад

    I Love this help. I've been trying to get the Net Income for a while and your Video helped me get what I was looking for. Thank You!

  • @wesleydick7727
    @wesleydick7727 11 месяцев назад

    This was a fantastic tutorial and I appreciate the time and effort you spent making it easy to understand and follow! This was exactly the guidance I was looking for to help my parents and I get better at tracking our finances.

  • @8ooOaceOoo8
    @8ooOaceOoo8 13 дней назад

    Thank you so much - simple and easy to follow compared to some other videos.

  • @mendocinoflowerfarm
    @mendocinoflowerfarm 10 месяцев назад

    This is really empowering to create my own expense spreadsheet! Thank you so much for making this video!! You made it so easy.

  • @mayraraphael6488
    @mayraraphael6488 10 месяцев назад

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

  • @MadeItEasyBeauty
    @MadeItEasyBeauty 7 месяцев назад

    this was very very helpful! thanks for taking the time to share!

  • @kwijukaderek4682
    @kwijukaderek4682 7 месяцев назад

    And trust me your effort is highly appreciated.thanx again

  • @garyskiff561
    @garyskiff561 11 месяцев назад

    Thanks, Brian! Excellent tutorial video for sheets. I've changed the year, and set up the accounts to reflect my photography business, and it was my first exposure to spreadsheets. I've done databases before, but no spreadsheets. Great job!

    • @TR4zest
      @TR4zest 8 месяцев назад

      Hi Gary. How did you set up the accounts? I tried but am struggling. No worries - I saw the edit pen ......

  • @rodneymaina4351
    @rodneymaina4351 7 месяцев назад

    Amazing video! Definitely moving from Notion.

  • @kristynvilcinskas8407
    @kristynvilcinskas8407 11 месяцев назад

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

  • @darsheetvora
    @darsheetvora 10 месяцев назад

    Thank you so much for this wondeful gesture of giving this template for free!

  • @IhmePaskaa
    @IhmePaskaa Год назад

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

  • @mitchellvogel4058
    @mitchellvogel4058 Год назад

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

  • @sassybanjo3586
    @sassybanjo3586 11 месяцев назад

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

  • @deekelly9137
    @deekelly9137 Год назад

    I think you may have just saved my little business. Thank you x

  • @AF-gd6uv
    @AF-gd6uv 9 месяцев назад

    This video is perfect. I'm a beginner in Google sheets, trying to start a budget, great explanation. Keep posting good videos like this , just subscribed, looking for tutorial videos that you.post.

  • @susanm012
    @susanm012 7 месяцев назад

    I’ve never used Sheets before. This was a great tutorial and I made my kids help me too so they could learn. Thank you!

  • @lizbethsuarezrealtor
    @lizbethsuarezrealtor Год назад

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

  • @im.makinya.wannit
    @im.makinya.wannit Год назад

    Giiirrrlllll. THANK YOUUU. I had ZERO idea about any of this and you made it so easy. Wonderful job.

  • @HodCohen135
    @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

  • @Stevesutanto79
    @Stevesutanto79 7 месяцев назад

    Very easy to follow and super helpful - thank you!

  • @91210paige
    @91210paige Год назад

    Thank you Brian! My Family desperately needs this!

  • @sherrainehiggs7380
    @sherrainehiggs7380 Год назад

    Thank you for very helpful presentation.

  • @_kevinwm
    @_kevinwm Год назад

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

  • @মুহাম্মাদনায়ীম
    @মুহাম্মাদনায়ীম 11 месяцев назад

    Thank you,
    You gave the file in highlighted comments .
    I already subscribed to your channel and saw videos many times.

  • @ozcanonal
    @ozcanonal Год назад

    Thank you for this very informative and easy to understand video..!

  • @Bluetopz
    @Bluetopz Год назад

    Man this is a great tool. Amazing video!

  • @kimaraiza1965
    @kimaraiza1965 5 месяцев назад

    Thank you so very much for this video! I learned so much and It is so helpful!

  • @Barter709
    @Barter709 5 месяцев назад

    Thank you! You helped two small businesses.

  • @MiaKim-jd8ie
    @MiaKim-jd8ie 9 месяцев назад

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

  • @capnkirk5528
    @capnkirk5528 Год назад +1

    Very nicely done. This is the kind of thing that people need to use to learn where there money is REALLY going.

  • @AnthonyMunoz-rt2ep
    @AnthonyMunoz-rt2ep Год назад

    Never usually leave a comment but this video deserved it ! Super helpful and Clear Explanation