Digital Google Sheets Budget Planner

Поділитися
Вставка
  • Опубліковано 30 лис 2024

КОМЕНТАРІ • 107

  • @excelwithmark
    @excelwithmark  5 місяців тому +1

    🙌 SUBSCRIBE for more Excel Tutorials: bit.ly/3SYHKFQ
    👨‍🏫 FREE Excel Courses: bit.ly/EssentialCourseEWM
    🖥 Templates: bit.ly/TemplatesEWM

  • @mntn_moth
    @mntn_moth 7 місяців тому +67

    I sat here watching this, stuffing my face with chipotle, planning my financial future. Ultimate self care. 🎉

  • @lovetahsin
    @lovetahsin 4 місяці тому +35

    Now THIS is a tutorial 😭 thank you! I do recommend adding timestamps though!

  • @h1ray4
    @h1ray4 4 місяці тому +9

    Thanks for this man! I can finally track my own budget without paying a hefty price just to have access to it 😊😊

  • @janiascott3192
    @janiascott3192 Місяць тому +3

    This was EXTREMELYYYY HELPFUL, and I love that I didn't have to pay like the other templates on etsy lol. thank you!!!!!

  • @surgingtides
    @surgingtides 2 місяці тому +3

    Thank you for this tutorial ❤ I also love your choice of palette here. Not too generic pastel theme yet vibrant and pleasant enough for the eyes ❤

  • @azriellen8865
    @azriellen8865 6 місяців тому +3

    I made it while watching. It took me 3 hours and a break. But I love it.

  • @MsAnderson-
    @MsAnderson- 2 місяці тому +3

    EXCELlent tutorial!! ...and with music that I didn't have to quickly mute at that. 😆Thank you!

  • @ksuavemente
    @ksuavemente 7 місяців тому +6

    Thank you for this tutorial! Followed it and now have a great financial tracker for free!

  • @timewithgwen
    @timewithgwen 9 днів тому

    You did a great job! I also love the music. Thank you!

  • @karenmeetsworld
    @karenmeetsworld 2 місяці тому +4

    Finally a tutorial on budget tracker. The thumbnail has a dropdown for the month. May I ask how to do it. :)

  • @raeesaam304
    @raeesaam304 3 місяці тому +1

    Going to have to watch this again because the first time I was just vibing to the music and pretending to be at a mini-concert.

  • @Nurse_Na2010_
    @Nurse_Na2010_ 3 місяці тому +2

    Thank you so much for this tutorial. You have saved me money. Now I am motivated to budget!

  • @myhallyulife
    @myhallyulife 11 місяців тому +7

    Love this budget set up! I'm going to make my own 😊

  • @uxnne4492
    @uxnne4492 Місяць тому

    ahh! i'm only at the data validation part of creating a dropdown for the bills - but i feel so accomplished 😀 no greater feeling than doing something yourself, thank you so much for this tutorial!☺

  • @adisaputeri.s3111
    @adisaputeri.s3111 3 місяці тому +4

    just found the video, really great!
    but I have a problem, why can't I click the next cells (the L14) to put it in the formula like in 14:39 can someone explain to me what I did wrong?

    • @M4rty360
      @M4rty360 3 місяці тому +3

      I figured it out u must put ";" instead of ",". hope this helps

    • @adisaputeri.s3111
      @adisaputeri.s3111 3 місяці тому

      @@M4rty360 thanks it worked

  • @bimaagg
    @bimaagg 9 місяців тому +5

    Yo King dropped hella banger guide and left the sheet unnamed 👑

  • @zyhah4585
    @zyhah4585 Місяць тому

    Thank you soooo much for this tutorial. you really help me for my financial!

  • @bwriker
    @bwriker 9 місяців тому +2

    Hi! Can you show us how to then create the dropdown menu to switch between months?

  • @PranavManohaur
    @PranavManohaur 8 місяців тому +14

    Good taste of music though..

  • @IELTSED
    @IELTSED 4 місяці тому

    It was excellent. Thank you so much. I made it and it looked great. Learned a lot from this video. 🥳🥳💯💯

  • @aleniaallen5925
    @aleniaallen5925 День тому

    24:17 600 was added for actual electricity for the bills table. Thats why the percentages changed. Hope that helped 😊

  • @gitawidisetyowati7292
    @gitawidisetyowati7292 Місяць тому

    Thank you. This is very useful for me. It takes hours for me to make it hahahha. But thanks to you 😂👍

  • @windsmagnolia1031
    @windsmagnolia1031 3 місяці тому

    Thank you so much for this! Is such a detailed tutorial, I'm going to try to do it

  • @클래스공부하는
    @클래스공부하는 3 місяці тому

    hello, I am really thankful for you tutorial on creating this content and I followed it!! Thank you very much!!!

  • @mbworldph2433
    @mbworldph2433 9 місяців тому +1

    How about if you pay your bills using your credit card.? How would we able to calculate using your form? This will double up the cashflow

  • @alexiacuadras2149
    @alexiacuadras2149 8 місяців тому +1

    Hi I am trying to learn. I'm new here, what does currency means? and why is it useful in a budget planner?

  • @nancybella7474
    @nancybella7474 9 місяців тому +1

    I would love to see profit and loss per project event in every month. Thank you

  • @halitsanr4439
    @halitsanr4439 3 місяці тому

    Thank you for your efforts !!!

  • @Yushiska
    @Yushiska 2 місяці тому

    New subscriber here, thank you for the tutorial!

  • @mownikarokkam7875
    @mownikarokkam7875 6 місяців тому +1

    Can you show a dropdown option where i can switch between months rather than creating this at the start of every month

  • @TaylorKario
    @TaylorKario 10 місяців тому +2

    Thank you for this video! Exactly what I'm looking for❤

    • @excelwithmark
      @excelwithmark  10 місяців тому

      Glad it helps

    • @marielamartinez6146
      @marielamartinez6146 5 місяців тому

      ⁠@@excelwithmark Would you bring able to explain why when I put my § input just pops up as an error

  • @mollyallum1450
    @mollyallum1450 3 місяці тому +1

    Hi, I'm flowing the tutorial and code for this but it in my income and expense and saving sections is just said 0 even though I have put numbers in the amount section in the entries sheet (7:24) would anyone be able to help me understand what I may be doing wrong

  • @Vee8854
    @Vee8854 4 місяці тому

    Excellent work! My husband and I both get paid bi-weekly but on alternate pay weeks, so we end up receiving a paycheck weekly between the two of us. How would you suggest I tweak this setup to show a weekly budget?

  • @cahyadesthian.widigda
    @cahyadesthian.widigda 7 днів тому

    love it

  • @amelia.aprieto.a3716
    @amelia.aprieto.a3716 Місяць тому +1

    Hello. I have a problem with the formula =IF(M14="", "", L14-M14). My Excel gives me an error and I don't know how to fix it.

    • @misscristal876
      @misscristal876 16 днів тому

      Figure out it is because is a ; nota a ,

  • @andcos6516
    @andcos6516 4 місяці тому

    Thanks for sharing, very useful and easy to follow! New sub 👍

  • @vanesabotella7084
    @vanesabotella7084 7 місяців тому

    muchas gracias. Asi es genial porque podemos hacerlo paso a paso. Super util y super practico el video muchas gracias saludos

  • @SayidaNafisaFisa
    @SayidaNafisaFisa Місяць тому

    Ka playlist nya apa ya heheh saya suka denger nya

  • @maiphuong459
    @maiphuong459 8 місяців тому

    Hi Mark, wonder if you have this template in Excel spreadsheet?

  • @ogechukwuofili2422
    @ogechukwuofili2422 Місяць тому

    Can anyone write out the formula for the column that says "Actual" on the expense part. Mine keeps returning an error after deleting the difference formula.

  • @keishawhite4440
    @keishawhite4440 4 місяці тому

    Thank you for this!

  • @FaydraBailey-y5q
    @FaydraBailey-y5q 8 місяців тому

    What do you put in the saving after total

  • @grapessyrop6755
    @grapessyrop6755 7 місяців тому

    but how do you change it month to month and keep the same settings? thank you

  • @ahaxnzj
    @ahaxnzj 8 місяців тому

    bende kenarlıklar kalınlaştırsam bile bu kadar kalın görünmüyorlar, nasıl sizinki gibi yapabilirim

  • @myhallyulife
    @myhallyulife 11 місяців тому +2

    I would love to see a budget with sheets for each month (just copying the same monthly sheet multiple times) and an "annual summary" sheet that summarizes the totals for each month in the whole year.

    • @excelwithmark
      @excelwithmark  11 місяців тому +1

      Hi is this what you are looking for excelwithmark.com/products/budget-spreadsheet-for-personal-finance

    • @ReneeThompson-mo4qj
      @ReneeThompson-mo4qj 10 місяців тому +1

      ❤ to see one using the mobile of Google Sheets

  • @helderparruque8618
    @helderparruque8618 7 місяців тому

    Amazing, thank you so very much, keep it up

  • @Eliecerjpalacio
    @Eliecerjpalacio 8 місяців тому

    La música super relajante. Saludos desde Colombia

  • @Unkn0wn54_
    @Unkn0wn54_ 6 місяців тому

    In 23:40, what command did you use to get the percentage below cash flow? Thank you!

    • @Unkn0wn54_
      @Unkn0wn54_ 6 місяців тому

      Pause at 24:10, what command or symbol is after D19?

    • @jessrivera2125
      @jessrivera2125 2 місяці тому

      @@Unkn0wn54_ hi please help me. I'm having a hard time in 24:10. the percentage I dont get it

    • @jessrivera2125
      @jessrivera2125 2 місяці тому

      the symbol you use. for me it came out error

    • @Zatara254
      @Zatara254 Місяць тому

      Does anyone knows how that 68.8% came to be.

    • @Zatara254
      @Zatara254 Місяць тому

      C19/d19 that I understood. I tried to slow motion still I can't understand how 68.8% is coming

  • @XoogwayX
    @XoogwayX 10 місяців тому

    Thank you! Something simple to put my actual down.

    • @excelwithmark
      @excelwithmark  10 місяців тому +1

      Glad it helps is you have any ideas to improve these templates let me know what you would like to include

    • @kbanghart
      @kbanghart 9 місяців тому

      ​@@excelwithmark​ hi, hoping I might get a response from this question.
      I get paid every week so I'm looking for an app or excel formula that will look at all my income and the dates I get paid, then look at all my bills per month and plot out where to pay them during the month (example.. I have $100, bill is $120, so then it automatically figures out how to spread that out).
      Do you offer an app or something that will do this for me?

  • @orlandorodriguez1965
    @orlandorodriguez1965 4 місяці тому

    I want to purchase one of your budget planners, I'm in the U.S. Is it simple to change the currency to U.S. dollars?

  • @MPFernz
    @MPFernz 2 місяці тому

    I am really having hard time setting up the "Left to Spend" section, I cannot get the right percentage with the symbol §. How am I supposed to correctly create this? I am getting an error following that part. Anyone can help?

    • @Zatara254
      @Zatara254 Місяць тому

      Everything workout well. Then I got confused how 68.8% is coming from.

  • @JhenelleMaeOlaguer
    @JhenelleMaeOlaguer 2 місяці тому

    Thank youuuu

  • @jejakmasabdul
    @jejakmasabdul 10 місяців тому

    love this, thankyouu❤

    • @excelwithmark
      @excelwithmark  10 місяців тому

      glad you enjoyed thanks fopr watching

  • @MOHAMMADJUNAID-n8q
    @MOHAMMADJUNAID-n8q 11 місяців тому +2

    GREAT KEEP UP UPLOADING

  • @rancho0071
    @rancho0071 6 місяців тому +1

    Watchet it made it LOVE IT

  • @julierobinson8338
    @julierobinson8338 Місяць тому

    What formula are you using for 17.01

  • @WaleedKhan-ku5ff
    @WaleedKhan-ku5ff 8 місяців тому

    Please create a video for travel planer sheet.

  • @nurulshafirakamarudin03
    @nurulshafirakamarudin03 10 місяців тому

    hello,, why display using mobile not same,, please help me.. chart at left to spend not display the number

  • @Ghassan-Balatif
    @Ghassan-Balatif 10 місяців тому

    Hello thank you for this video but I have a problem in Expenses when I write +IF(L15+" " , " " , ... can you help pls

    • @lenoberio8094
      @lenoberio8094 10 місяців тому +2

      =IF(M14="", "",L14-M14)

    • @benalex51
      @benalex51 10 місяців тому +6

      If it can help:
      Put ; instead of ,

  • @cuteonej1919
    @cuteonej1919 4 місяці тому

    The song 🥺🥺😍😍

  • @_ethanknight_
    @_ethanknight_ 8 місяців тому +1

    Would be nice if I knew why my § input just pops up as an error

  • @katepatriciamolinagarrido6838
    @katepatriciamolinagarrido6838 2 місяці тому

    Cómo hago esto en Excel , no encuentro los mismos atajos

  • @tanishadas8051
    @tanishadas8051 6 місяців тому +1

    Can somebody tell me how we are getting 68.80% and 31.20% suddenly from 56.54%(100%-(C19/D19) and 43.46%(C19/D19) UNDER THE CASHFLOW TABLE

    • @ariang5103
      @ariang5103 3 місяці тому +1

      Same I confuse to this how suddenly change😢

    • @jessrivera2125
      @jessrivera2125 2 місяці тому

      @@ariang5103 please help. did anyone has an answer to that?

    • @Zatara254
      @Zatara254 Місяць тому

      Been watching this hours and hours still can't figure it out. 😅

    • @aleniaallen5925
      @aleniaallen5925 День тому

      600 was added for actual electricity for the bills table. Thats why the percentages changed. Hope that helped 😊

  • @NingDarsih
    @NingDarsih 7 місяців тому

    bagus banget ini rapi juga cantik,aku mau buat bisnis plan

  • @unfinishedproject2504
    @unfinishedproject2504 10 місяців тому

    Hi, what program do you use to record your screen?

  • @mtu_sitizelikakinanti1265
    @mtu_sitizelikakinanti1265 5 місяців тому

    why the IF formula (duration 14.48) is error?😭

  • @WaleedKhan-ku5ff
    @WaleedKhan-ku5ff 8 місяців тому

    Thank you so much sir

  • @justinvanleeuwen799
    @justinvanleeuwen799 7 місяців тому

    Between 24:16 and 24:17, all the little lines are gone in between the categories, the budget and the actual collum, does anyone know how to do that?

    • @ksuavemente
      @ksuavemente 7 місяців тому +1

      In the menu bar select View > Show > Gridlines and they should toggle off

  • @darwandoo
    @darwandoo 11 місяців тому

    So cool I want to do this

  • @Zatara254
    @Zatara254 Місяць тому

    @excelwithmark How did you come up with 68.8%

  • @BrendaDiaz-lc8vm
    @BrendaDiaz-lc8vm 6 місяців тому

    A Voice over would be great to minimize the pausing

  • @gesi4104
    @gesi4104 4 місяці тому

    can anyone tell me what happened in 21:13, how to do it?

    • @excelwithmark
      @excelwithmark  4 місяці тому

      hi a chart was created using the data from the cashflow actual column. Hope this helps sorry it wasnt clearer

    • @gesi4104
      @gesi4104 4 місяці тому +2

      @@excelwithmark I was able to figured it out, but thank you so much for replying and for the this video. I learned a lot.

  • @catedoge3206
    @catedoge3206 9 місяців тому +2

    music?!?

    • @algor2127
      @algor2127 8 місяців тому +1

      I need the spreadsheet and the playlist😂

  • @SantiagoCordero-th6ff
    @SantiagoCordero-th6ff 7 місяців тому

    muchas gracia pa

  • @halitsanr4439
    @halitsanr4439 3 місяці тому

    Thank you for your efforts !!!