Budget Spreadsheet | Google Sheets Budget Template | Personal Finance Tips

  Рет қаралды 314,155

Work Smarter Not Harder

Work Smarter Not Harder

Күн бұрын

Пікірлер: 812
@mariestewart4619
@mariestewart4619 2 жыл бұрын
This budget tracker has absolutely changed my life! Thank you thank you! I've been using it for a month now and I can't believe how in control I feel of my money. I have had various iterations of budgets over the years and I'm actually an accountant but I never felt I was in control throughout the month. I would just look at the numbers at the end of the month and wonder what happened. I knew I needed this I just didn't know how to go about it. Future us thanks you when we can retire!
@whyworksmarternotharder
@whyworksmarternotharder 2 жыл бұрын
Love this!! It’s why I do it!!
@libbysworld7649
@libbysworld7649 2 жыл бұрын
I feel the same way. It has changed my whole spending, budgeting and savings game.
@Marnie67854
@Marnie67854 2 жыл бұрын
I agree completely!
@Tsuchimursu
@Tsuchimursu 2 жыл бұрын
I have been running really low on funds and wanted to see what kind of changes I need to make and how fast to stay afloat. This gave me peace of mind knowing that I can stay afloat until I can either increase my income or get rid of bigger expenses, but am not in a hurry.
@gilwoode
@gilwoode 2 жыл бұрын
I need a budget sheet that I can add all my bills too plus be able to add the interest rates for my credit cards so when I make my payments the balances will decrease. Can you help me with that? Something like a Amortization Chart, but for all my bills.
@generalalwick4242
@generalalwick4242 Жыл бұрын
Just about to graduate from college and had a little bit of a meltdown yesterday thinking about finances in the next 4-5 months (money is going to be tight transitioning into the workforce). I've taken a spreadsheets class so I decided to look up a tutorial. The amount of relief I feel right now from doing this is wild! I feel like I have control over everything I do financially moving forward now and can even look toward the future with savings using this format. You are a lifesaver, thank you sir!
@joe28374
@joe28374 3 жыл бұрын
Its 4 am and I just finished building this. This is absolutely a god send budget tracker. I am going to be back in a month and say how it actually turned out to be. Thank you for your work my man
@VariantK-82
@VariantK-82 2 жыл бұрын
Aaaaand…….how’s it working?
@libbysworld7649
@libbysworld7649 2 жыл бұрын
@@VariantK-82 I've been using mine since January of 2022 and it's COMPLETELY changed my life for the better.
@ShriramVaradarajan-f4t
@ShriramVaradarajan-f4t Жыл бұрын
@@libbysworld7649 Btw, where do you enter your investments? Like stocks and stuff?
@casorys
@casorys 2 жыл бұрын
For anyone having trouble when dragging down cells from income on 6:26, if you're getting different numbers, make sure you hold CTRL on Windows or Command on Mac when dragging down. This should give the right results.
@ariellesketch4501
@ariellesketch4501 Жыл бұрын
Thank you!
@MrsMonicaSilva
@MrsMonicaSilva Жыл бұрын
Not having any success. i was doing well until here. =( Im really not tech savy. Im on a Windows. Pressed CTRL but nothing happens.
@everythigari2061
@everythigari2061 Жыл бұрын
@@MrsMonicaSilva I have a Chromebook and it didn't work until I hit the Shift button. Hold that down while dragging to desired week.
@bill1363
@bill1363 Жыл бұрын
@@MrsMonicaSilva Fill in the date category for the dates that you will get your paycheck for only the first 2 cells under the date header. Next, highlight those 2 cells, which should be A2 and A3, and you should see at the bottom right of cell A3 a little blue box. Hover over that little blue box, and your cursor will turn into a cross. Drag that cross down the date column and release. Google Sheets should have spaced out your dates according to the pattern that it interpreted. I tried the control and shift attempts as other people have advised and those didn't work for me. Try the way that I told you, and hopefully it works for you. I was having problems with this as well, but I eventually got it and so can you. 👍👍
@nooshy8290
@nooshy8290 Жыл бұрын
​@@bill1363 Hi Bill, thanks for explaining however for some reason my dates for 15,30th income doesn't pan out correctly. For example, i get paid on the 15th and 30th of every month (sometimes 31, 29) i've got 08/15/2022, 08/31/2022 then the drop down shown in this video gives me 09/16/2022,10/02/2022. Do you know how i can fix that? Thank you!
@pearlstar28
@pearlstar28 4 жыл бұрын
Exactly what I’ve been looking for! I keep a spreadsheet but was so sick of manually calculating my paydays and putting in every paycheck amount. I thought to myself, there has got to be a better way, and you have showed me. My hero!
@whyworksmarternotharder
@whyworksmarternotharder 4 жыл бұрын
Awesome to hear! It’s why I do it!
@libbysworld7649
@libbysworld7649 Жыл бұрын
I've been using this budget method for 18 months... Best decision ever. I have referred this video to hundreds of people.
@Ari-li1ht
@Ari-li1ht 4 ай бұрын
I've been doing this manually since 2020 and thought "hey, a spreadsheet can do this for me" and I was so excited to find your tutorial! So many other budget styles aren't helpful to me! I love having a running log of all income and expenses so THANK YOU for teaching me how to do this on Google Sheets! This will save me so much time! :)
@bobhaley3915
@bobhaley3915 3 жыл бұрын
Great tutorial. I got rid of my Quicken. This is better. I added two columns to the Final Tracker sheet. Column G with the label Complete, and added checkboxes to the entire column. Column H is labeled Bank Balance. The formula for Column H starting at H3 is: =IF (G3,H2+D3-E3,H2) then drag it down. Put the starting balance in H2 (same as D2). The Bank Balance will change as you check off the transactions as they occur. If you want to make it a little cleaner, add conditional formatting, custom formula starting at G3 with this formula: = (G3=FALSE) Make the action to change the text color White, then drag it down. Then the calculated numbers in the Bank Balance column will only show up when the check box is checked in the G column. Hope this helps someone.
@laurenbrown3476
@laurenbrown3476 2 жыл бұрын
This is great! Thank you!
@karlakarla2456
@karlakarla2456 2 жыл бұрын
Thank you this is a great addition! One question though, is there a way to pull in the complete column from the other tabs ( fixed and other expenses) so that the final track will auto-populate the completed checkmark as you make your entries?
@elizabethgrosse3411
@elizabethgrosse3411 Жыл бұрын
It's 2 years later and it worked great for me! Thank you.
@AveriP-ck2un
@AveriP-ck2un 2 жыл бұрын
You are a LIFESAVER! My husband made me a budget like this and I didn't know how to change things and ended up deleting the entire thing. Thank you so, so much.
@taylorogg1865
@taylorogg1865 2 жыл бұрын
ALL I CAN SAY IS THANK YOU SO MUCH!! I kept a spreadsheet of my big bills but it wasn’t close to as helpful as this! This has helped me so much with planning. Saving for a house, etc!
@leinaalalowe2354
@leinaalalowe2354 4 жыл бұрын
Your tutorial was AWESOME!! You haven given me peace of mind! Now I literally don't have to lose sleep anymore. You have no idea....lol I've been praying for something like this and I am forever grateful! This totally blew me away. Thank you so much!!
@whyworksmarternotharder
@whyworksmarternotharder 4 жыл бұрын
I appreciate you very kind words! And I’m glad this worked for you! It’s why I do what I do!
@davidwright7324
@davidwright7324 3 жыл бұрын
@@whyworksmarternotharder thank you for all your help with understanding Budgeting with Google sheets Template. The trouble that I’m having is with how to query and import form multiple sheets (months) With our family budget we would like to have a carryover of the ending month difference in each category. So that in the next month - under actual there would be a total (“Starting Total”) Example - At the end of October there is a budget of $100 for clothing that we did not spend. - Now in November we would in the actual column isi $100. But the rest of the Planned vs Actual to create a difference at themed of the month And so on - And so on Thank you for any advise or tutoring
@tonibrandon4749
@tonibrandon4749 2 жыл бұрын
As silly as it sounds, I have always been intimidated by Excel and Google Sheets. This tutorial actually makes me feel like I can do it! Thank you!
@libbysworld7649
@libbysworld7649 2 жыл бұрын
5 months since using this method and I am making serious money moves with this transparency. THANK YOU SO MUCH again! Best budgeting spreadsheet EVER. EVER...
@pcamacho722
@pcamacho722 Жыл бұрын
I've been following various Excel and Google Sheets teachers for a long time trying to choose the best personal budget. But this... is another level!!!! THANK YOU VERY MUCH for this project, this really changes the way we manage our money, it gives us peace of mind! Thank you one more time!
@antonlindberg7117
@antonlindberg7117 2 жыл бұрын
I came here with the intention to merely replace my previous excel budget tracker that you helped me build last year for a swift overview. It made me more aware of tracking, but I fell out of coming back to excel as I got busy. By the 16th minute of this video I realise what an immense formula you've implemented to help me see my financial situation one year from now. This is so powerful. Wow. Thank you.
@jennyh92
@jennyh92 2 жыл бұрын
I'm surprised by how much I'm geeking out on this!😅 "Sorry guys, can't make it Friday, my budget needs adjusting." THANK YOU SO MUCH for this clear, easy-to-follow, incredibly helpful video. I appreciate the time you took to make this and share it for free 🙏💙
@whyworksmarternotharder
@whyworksmarternotharder 2 жыл бұрын
Lol. Love hearing this! It’s why I do it!
@libbysworld7649
@libbysworld7649 2 жыл бұрын
I've been that way for the past 9 months. This spreadsheet has changed my finance, budgeting and savings game. My friends want to go out all the time. Sorry guys, not in the budget this week. Or, I can't prioritize that in my budget right now. LOL I've saved over $8K this year so far and have paid off a lot of debt!
@libbysworld7649
@libbysworld7649 2 жыл бұрын
Nearly 12 months later, my life is forever changed by this spreadsheet. Forgive my serial commenting, however this is a sure fired game changer. Thank you again!
@dispatch4779
@dispatch4779 2 жыл бұрын
Hi, would you be able to help me, I am unable to get past (4:31) the part where I have to choose criteria "List from range" I don't have that option. am I doing something wrong ?
@dispatch4779
@dispatch4779 2 жыл бұрын
I just figured it out, I had to step away and take a break and come back, it was labeled differently on my end "drop down range" ughh sorry to bug you
@libbysworld7649
@libbysworld7649 2 жыл бұрын
@@dispatch4779 You didn't bug me at all. My apologies for not responding sooner, but you didn't tag me, so I didn't get notified. Glad you figured it out though! This method has been my saving grace all year.
@mathewjerome
@mathewjerome 3 жыл бұрын
I've used Google Sheets as a budgeting tool for several months, but this automation will make my budgeting process so much more dynamic. Thank you, sir! Quality content.
@clue___
@clue___ Жыл бұрын
yes but how are you making the formulas work
@moebewan
@moebewan 2 жыл бұрын
I'm not sure what I did differently, but I got a lot more out of this video than my first watch earlier in the year. Thank you for the steps in the description and for the entire video. This works masterfully with my EveryDollar Budget and Ramsey Finance. Muchos Gracias!!!
@martinprinceton9858
@martinprinceton9858 2 жыл бұрын
One word for this video: OUTSTANDING. I love budgeting and tracking my expenses using modern software. Looks like Google Sheets gives me the ability to even predict how much I'll spend in the future. Thanks a lot
@klambert6941
@klambert6941 Жыл бұрын
I have been using this for about 3 months now. Absolutely love this. Its so easy to track and love I can see months in advance to know if I am going to be short or not. This has change my life for the better. Thank you!
@whyworksmarternotharder
@whyworksmarternotharder Жыл бұрын
Love it!
@CalvinsChannel-ug4hj
@CalvinsChannel-ug4hj 9 ай бұрын
Super video! One piece of advice for those that have expenses that fall on the last day of the month each month. What you do is on the first date, you manually enter the date (the last day of the month like normal). Then the second date, you will use this formula =EOMONTH(cell with first date, 1). The first number is the reference, the 1 is the number of months it will return based on the cell reference. This in our case will be "1" since we want the following month!
@Lindsey-kc5oy
@Lindsey-kc5oy 3 жыл бұрын
First off I want to say THANK YOU SO MUCH for creating this video. My sister has been telling for awhile to create a budget plan so I can see what areas we need to improve on with spending & bills. The way you made this video was so easy & simple to follow, that I was able to create my budget plan in less than 30 minutes! I kept thinking about signing up and paying for one of those people that help you with all your finances & budgeting.. so you've definitely helped me save money in that area as well. I can keep going on about how amazing you are for helping so many people financially!! You are awesome and I will continue to follow and support your page! Thank you again, all the way from Hawaii🤙🏽🤙🏽🤙🏽
@anneardiente8526
@anneardiente8526 4 ай бұрын
One of the most helpful and simple yet high-impact budget tracker!
@sophiehutsen7391
@sophiehutsen7391 2 жыл бұрын
I can't thank you enough for sharing this. I have three incomes I use for different expenses and one of them varies a bit. I have been so overwhelmed trying to stay on track. With this system I have set up three different sub trackers that all link to the master tracker so I can get the big picture. I lost a grip on my finances after the loss of my marriage and then my business during the pandemic. I haven't felt this in control and hopeful in years. Thank you thank you thank you. Life changing and I am excited to check out the dashboard!
@kayleehaley8289
@kayleehaley8289 2 жыл бұрын
Thank you for making it so quick and easy to have an ongoing tracker like this! Ive moved 4 times in 21 months, and my pay changes quarterly, so I have tons of varying frequencies + one-off charges. Normal budgets are great in theory, but none do what this simple little sheet has done. Saved this video for the last 6-7 months for when I finally had time to redo everything. I wish everything were as easy as you made this! Thank you for taking all of the RELIEF you provided here :)
@Edwardx703
@Edwardx703 11 ай бұрын
Every new year, I always reflect back on this video and use it to create a strong budget plan. I hope to keep this video with me for as long as I live.
@summerhiggins4272
@summerhiggins4272 2 жыл бұрын
I'm not one for commenting on videos but had to give a MAJOR thanks here. I've been struggling to find a method that works for me and with there being so muchhhhh to choose from in the inter webs and many templates that honestly suck, I got fatigued from even looking. This video made things so straight forward and I really feel like I can take control of my finances now! Looking forward to watching other videos as I'm sure they are as valuable as this one. TY TY TY !
@whyworksmarternotharder
@whyworksmarternotharder 2 жыл бұрын
Awesome! Glad it works! It’s why I do this!!
@peterkinslow1375
@peterkinslow1375 2 жыл бұрын
This video has transformed me from a financial budgeter (looking at the past) to a financial planner -> always looking forward. The act of changing the mindset to oh now, what bills are next and how can I pay to getting on top and saying "I have this money for this month and I am going to allocate it to meet my finance goals. I've shared it with a large finance group, so if view go up the next few days, just helping spread the great vid. Thanks.
@whyworksmarternotharder
@whyworksmarternotharder 2 жыл бұрын
So glad to hear this!!
@upcycledhealth
@upcycledhealth 2 жыл бұрын
Thank you so much! I have just become self employed and this is going to ensure I am on track with all my expenses and should make the end of year accounts so much easier. What a game changer!!!
@gingersnapfitness7010
@gingersnapfitness7010 3 жыл бұрын
This is SO helpful! I just built this for my personal finances to help my husband and I combine finances as a newly married couple and now building this for my business finances as I am a business owner. Can't wait to watch the 2nd video following this! Great video is starting to plan finances for the next year
@whyworksmarternotharder
@whyworksmarternotharder 3 жыл бұрын
This makes me so happy! It’s why I do it!!
@moneybee
@moneybee 4 жыл бұрын
It's amazing how excel still dominates the budget world, when Google sheets is available for free! I love how you walked through this. Just subscribed, keep it up!
@whyworksmarternotharder
@whyworksmarternotharder 4 жыл бұрын
Thank you so much for the kind words and encouragement! I totally agree with your sentiment about Google sheets! Excel and Google sheets each have their strengths. Being free is one of Google Sheets’!
@benbwma
@benbwma 3 жыл бұрын
You're a genius! This is life changing. I'm planning to retire in 4 1/2 years and "was" concerned about our spending habits, planning, etc. No more... Thank you!
@whyworksmarternotharder
@whyworksmarternotharder 3 жыл бұрын
Wow! I read this comment to my wife! Thanks! Glad it worked out for you!
@whyworksmarternotharder
@whyworksmarternotharder 3 жыл бұрын
Congrats by the way on your pending retirement!
@unusualelephant
@unusualelephant 3 жыл бұрын
I have been wanting to use this type of budget for the longest time but, had not been able to find one. This is perfect! I am finally able to see my running balance and can tell right away what I can and can't afford to spend. I was in spreadsheet heaven the entire time I was working on this. Thank you so much for this awesome tutorial!
@whyworksmarternotharder
@whyworksmarternotharder 3 жыл бұрын
Sorry for the delay in response! I love hearing this. That’s why I do it!
@kenndricktv2108
@kenndricktv2108 Жыл бұрын
I really appreciate you for this. Im terrible with money and seeing how terrible in the specific dollar amount has been a slap in the face for me to get it together. I just did everything over 2 years and seeing what the running balance should be if i was responsible is just night and day.
@MrTheBritishness
@MrTheBritishness Жыл бұрын
This has been a great addition to my personal budgeting --- thanks a ton for keeping this on YT for the masses to learn and practice!
@whyworksmarternotharder
@whyworksmarternotharder Жыл бұрын
Very welcome!
@Markantonycarey
@Markantonycarey 3 жыл бұрын
Hi This is so great. Looking forward to setting up the dashboard. But, three questions... 1. How to make this work across multiple bank accounts? 2. How to work with two currencies? 3. How to import CSV bank statements into the spreadsheet?
@libbysworld7649
@libbysworld7649 2 жыл бұрын
The two currencies is beyond my scope of understanding...but there's another video on this channel on how to add a savings account to this spread. And as far as importing from csv data sets, if you use chrome, as I do, there is an extension to import csv tables to a master spreadsheet. From there you can adjust your queries to blend the data with the expense and income tabs. Hope that helps.
@elizabethd3038
@elizabethd3038 Жыл бұрын
Thank you!! This is the first time I can actually see the potential of my money and where it actually goes.
@cent9861
@cent9861 3 жыл бұрын
Thank you so much for this video! It don't matter how much money you make if you don't know how to budget what you have you will always end up with nothing at the end of the month. Thank you so much for making budgeting an easy function through google sheets!
@whyworksmarternotharder
@whyworksmarternotharder 3 жыл бұрын
Thank you for the kind words. Glad it was helpful! It’s why I do it!
@jacquifisher3129
@jacquifisher3129 2 жыл бұрын
This is so helpful! I am currently completing my second university degree so have gone back to living as a student. I've been struggling financially for the past two years and have known I need to budget properly. This is so user friendly and has helped me clearly see how much I can spend on necessities but also how much I have for fun! I'm surprised with how much I have left over! Thank you so much for creating this video. I'm really really excited about my finances for the first time in forever!!
@jetoptimusprime
@jetoptimusprime Жыл бұрын
Using this budget spreadsheet since mid 2022 and it's been really damn good! I have extended it to fit my needs (credit cards, investments etc) but this was a really solid foundation! Don't think I'll be updating this for a while. Really appreciate you making this video
@Neptunianist
@Neptunianist Жыл бұрын
This is very good. Well done. Relatively simple but provides a lot of useful information. It occurred to me, when you were testing the conditional formatting using the speculative expense of the Boat, that perhaps there could be a function that would suggest when you COULD afford the Boat, or other exceptional expense. If we created a sheet “Anticipated” or “Speculative” which contains expenses that you might want to spend, perhaps it could search through the Tracker sheet to see when, for each, the Balance is higher than that expense and that forthcoming expenses aren’t going to cause it to drop below the $500.
@carleenshaw8167
@carleenshaw8167 3 жыл бұрын
My mind is BLOWN!! Thank you SOO much for sharing and posting this AMAZING video. I came across this video at the perfect time as I am changing up how I budget; this has absolutely been incorporated into my budgeting. I had to keep pausing to keep up (created my spreadsheet along with the video) and I slowed down the speed of your voice via settings and it worked out great for me. I am of course now a new subscriber. Thanks again!😊
@alimullen1352
@alimullen1352 3 жыл бұрын
I think this is about to change my life...... I have been budgeting (or at least thinking I have been budgeting properly) for a couple of years but I have been making my life so hard for myself based on what I have just watched. Thanks a lot for your time putting this together. Only watched one of your videos so far but I can see me spending a lot of time working through them now.
@thaliajohnson4047
@thaliajohnson4047 2 жыл бұрын
I’ve been watching many videos on budgeting and started using other templates but was more working harder than smarter…!I’m absolutely GRATEFUL that I found this video🙏🏽🙏🏽🙏🏽 You made this so easy and I did by personal budget while watching it in one go. I will use this for my business finances also!! Thanks a million! God bless You and your family 🙏🏽😇
@sahilnerurker8143
@sahilnerurker8143 3 жыл бұрын
This is the best Budget Planning Tutorial i have seen . Could you please help with tutorials about 1) Managing multiple accounts while Budgeting 2) Product Costing and cost accounting 3) Inventory Management with multiple accounts 4) Sales Tracking & Funnels , CRM 5) Investment Portfolio Tracker 6) Return on Investment Love the way you explain
@whyworksmarternotharder
@whyworksmarternotharder 3 жыл бұрын
More videos to come
@agnieszkawiejak938
@agnieszkawiejak938 3 жыл бұрын
Thank you! I never thought I'd be excited about using a spreadsheet. Can't wait to start.
@ClareOConnell-jq4cf
@ClareOConnell-jq4cf 5 ай бұрын
Hi there. I absolutely love this budget plan, thank you. Quick question - I've set it up for a year. Is there a quick way to continue it for next year too, other than inputting all the fixed expenses again? Thanks for your help!
@celiajones9253
@celiajones9253 2 жыл бұрын
This is sooo good and exactly what I was looking for! Now I just need to do this for every year, add loans, 401K, HSA, etc to another sheet to see how I'll be looking for retirement, roughly. Thanks!
@shelbishultz8305
@shelbishultz8305 2 жыл бұрын
This video is incredible! After completing my own budget, I feel like I have my life together going into the new year!
@alodiaprie1
@alodiaprie1 3 жыл бұрын
I am so thankful for people like you who are willing to teach and help others. God bless you!
@cwhylly
@cwhylly Жыл бұрын
This is awesome. Just what I needed! 👏🏾
@PFGFrankly
@PFGFrankly 10 ай бұрын
thank you. i feel soo much better now
@aokiohyeah
@aokiohyeah 3 жыл бұрын
AMAZING!!!! I have been doing it manually all this while and it takes a toll on my time and effort. This is magic. Thank you for teaching me to work smarter!
@a_suslov
@a_suslov 2 жыл бұрын
The best budgeting template I’ve seen out of first 10 in search results!
@whyworksmarternotharder
@whyworksmarternotharder 2 жыл бұрын
That makes me happy! I’ve got a pre built version. www.etsy.com/listing/1252378574/
@cailinanne
@cailinanne 3 жыл бұрын
This is one of the best tutorials for someone with medium experience, wow. 💕
@SidelineFS
@SidelineFS 5 ай бұрын
omg I Love this video the best one I have seen when it comes to house budget, I have been running around myself for the past 2 months to find a good guide or template to follow, seriously Thank you!
@OmegaRejectz
@OmegaRejectz Жыл бұрын
Woohoo! I now know how to make Dropdown Lists thanks to you!!!
@priyasankara32
@priyasankara32 2 жыл бұрын
Thank you so much- a big virtual hug...You helped me create a Budget Spreadsheet and I feel so empowered.
@whyworksmarternotharder
@whyworksmarternotharder 2 жыл бұрын
This is awesome! Love it when people are empowered! Much more fun and practical than using budget software!!
@SunilKumar-zi7xf
@SunilKumar-zi7xf 3 жыл бұрын
Awesome guide! I don’t know how long I’ve been looking for this and just dint feel happy trying out most of the excel guides out there.. God bless you!!!!
@LupusLifestyle
@LupusLifestyle 4 жыл бұрын
Bruh! My budget has been so complicated over the years. I'm going to work on this right away. Thank you!
@whyworksmarternotharder
@whyworksmarternotharder 4 жыл бұрын
It takes some work to set up but totally worth it in the end. Will make your life easier and less stressful!
@jerrellkirby8107
@jerrellkirby8107 2 жыл бұрын
Thank You. This is tremendous for our budget woes and the best part is we can update and plan our budget live from Home Depot, lol, when we decide to buy that dishwasher, lawnmower, etc. that's on sale.
@shekharpandey8459
@shekharpandey8459 3 жыл бұрын
This is just Awesome.. thank you so much.. :) I have added this formula to the final tracker page in conditional formatting =$A$2:$A = today() It automatically highlights the entire row based on current date.
@sohailakram8616
@sohailakram8616 2 жыл бұрын
I have seen a lot of ideas on budgeting on excel, as far for now this has been best google sheet for my budget.
@jessicabaez2882
@jessicabaez2882 3 жыл бұрын
I paused the video SO MANY TIMES but I’m glad I finished! I feel accomplish & ready to tackle my budget, thank you for bringing value to KZbin! 😊
@Drizz1717
@Drizz1717 Жыл бұрын
This is the best version. I hope to see more added to budget template. Credit cards, vaults (for savings account), 2nd or 3rd accounts, etc. Please
@soyoonbangtan
@soyoonbangtan 2 жыл бұрын
Wow, I've been searching and testing out spreadsheet ideas for the past two days! haha. And this one is what I've been looking for, something to actually forecast. I feel like I've been on my computer all day long. I've just started setting mine up but I already feel my anxiety reducing. hehe. Thanks!
@libbysworld7649
@libbysworld7649 2 жыл бұрын
Keep going. I'm almost a year in and it just keeps getting better and better!
@Aj-po9dc
@Aj-po9dc 2 жыл бұрын
Hey ... I know I'm 2 years late to the party, but I have to say this was a great budget tracker. I have tried and made so many of these thing over the past 4 years or so, I build some good one that I now longer use because I was trying to do things I couldn't figure out, like how to write a formula that updates the due date bi-weekly as todays date reaches the due date. I figured out how to do it for monthly and for yearly, but for the life of me I cannot figure it out for bi-weekly or semi-monthly. I like how your tracker is just really simple and how the query formula combines everything on to 1 sheet. I may have thought about that once before, but I was to scared to try it I guess.. LoL Anyways, Great video guy! Look forward to watching more of them!
@whyworksmarternotharder
@whyworksmarternotharder 2 жыл бұрын
Love hearing it!
@amandas.9116
@amandas.9116 6 ай бұрын
Absolutely amazing! I am using this to get myself out of debt! Thank you so much
@dinero_efectivo
@dinero_efectivo 2 жыл бұрын
You are amazing! your spreadsheet is not just awesome you are a natural teacher!
@irisnegrete-regagnon2704
@irisnegrete-regagnon2704 Жыл бұрын
Thank you so much! I was thinking about getting rid of YNAB due to the cost, but I didn't have a backup plan yet. This is a super helpful video, and best of all, it is free.
@rofidaa9498
@rofidaa9498 2 жыл бұрын
This is hands down the best budget tracker I ever used!! Thanks for the video
@liahona7936
@liahona7936 3 жыл бұрын
Thank you for showing me this style of organizing the budget!! I did not know you could use categories and Query formulas in this way. I love looking a year ahead and this is way easier than doing it manually. I appreciate the checking off expenses as they hit the bank account. This an approach to a puzzle I have been trying to make simpler. I have been trying to find an easier way to represent money that has already been spent(ex: Rent), but is not represented in my bank account. I pay off my credit cards in full every month. Thinking of a way to represent money spent on a credit card and showing that money being spent in checking although the money has not been taken out of my bank account has been a bit tricky. This video was very clear and easy to follow. Thank you for putting the formulas in the description. Next up for me is your Budget Dashboard video: @
@barry-fast
@barry-fast Жыл бұрын
I live and die by this spreadsheet. I use it every single day. Thank you so much for taking the time to share this with us!
@rooklunary790
@rooklunary790 2 жыл бұрын
Thank you for the quickly set up template. Recording all my purchases that put me at a deficit was not so quick or painless though. This will definitely help me curb purchases that aren't strictly necessary. (Edit) I'm commiting to lots of overtime lol
@whyworksmarternotharder
@whyworksmarternotharder 2 жыл бұрын
I have a pre built version on google sheets www.etsy.com/listing/1252378574/
@elizabethgrosse3411
@elizabethgrosse3411 Жыл бұрын
I think Google Sheets is more intuitive than excel so I'm glad I made the change. Thanks for a great video. I'm watching this video before I do the Dashboard video
@Meg-db2ij
@Meg-db2ij 3 жыл бұрын
I am so hopeful that this will help my partner and I to finally get on top of our finances. This is AWESOME!!!
@mdanialfazal
@mdanialfazal Жыл бұрын
I have been looking for someone to explain something like this in this simple way for soo long man. So glad I stumbled across this. Amazing content, thank you so much for putting this together!!
@nofiltermega389
@nofiltermega389 2 жыл бұрын
I have an existing tracker but I input everything manually! Thank you so much for this content. I can improve my tracker and moving towards automation! Thank you so much!
@jeffkerr9020
@jeffkerr9020 3 жыл бұрын
Wow! Great tutorial - presented very well and extremely helpful. I very seldom comment on KZbin presentations but this is just outstanding. Thank you so much for your time and effort!
@whyworksmarternotharder
@whyworksmarternotharder 3 жыл бұрын
Thank you! Glad it worked
@haileymaurer122
@haileymaurer122 Жыл бұрын
Wow, I was so nervous I was going to make a mistake, but it seems sound. Thank you for providing an affordable option to purchase as some of the formatting was tricky. However, I do believe I completed the tutorial. I've learned so much from your classes. Thank you!
@libbysworld7649
@libbysworld7649 Жыл бұрын
I've used this budget officially for a whole year and it has been incredible. It's helped me see things crystal clear and as a result I've paid off over $10,000 of debt. I've also saved over $5,000. Always know my bottom line and I have created a buffer as a line item so that I never go under budget.
@FindingFinancialFreedom
@FindingFinancialFreedom 4 жыл бұрын
I have always used Excel spreadsheets! But you have made it so easy to follow how to use google sheets which is free! Just subscribed! Great video, keep it up!
@whyworksmarternotharder
@whyworksmarternotharder 4 жыл бұрын
Thank you for the kind words! Much appreciated
@em1tulsa
@em1tulsa 9 ай бұрын
Fantastic. Thank you.
@whyworksmarternotharder
@whyworksmarternotharder 4 жыл бұрын
*common issue* if the formula is not working for you it might be because of the difference in location for google sheets. You could try replacing the semicolons with commas.
@tinaelmills
@tinaelmills 2 жыл бұрын
WOW! I paused a lot and took a break but i got it done! Thank you.
@chrisandsamaltman8398
@chrisandsamaltman8398 3 жыл бұрын
My mind is BLOWN! AWESOME Video. Building as I type!
@madigrcd
@madigrcd 3 жыл бұрын
omg thank you! this video is going to save a uni student's life!
@kuyamikecuts
@kuyamikecuts 3 жыл бұрын
Loved this video. And your point about naming your money (or something like that) really stuck with me. Thank you!
@Alex_Booe
@Alex_Booe Жыл бұрын
Thanks so much! Super helpfful as someone who has little experience using sheets.
@mhacNH
@mhacNH 3 жыл бұрын
Love it!!! Been wanting to do something like this. Can you show how formulas would look like in excel
@janinepelletier9965
@janinepelletier9965 2 жыл бұрын
I was wondering this too. As much as I love some of the features of Google I like that excel is on my computer and not in the cloud. But I'm not sure how the formulas translate if at all. I hope he sees and responds to this. Or hopefully someone can
@karkar2006
@karkar2006 2 жыл бұрын
This is amazing! Great instructions. Thanks so much!
@Justin-mh9zq
@Justin-mh9zq Жыл бұрын
Awesome! I plan on using it for 2023. Is there anyway to create a new sheet that keeps track of all your transactions once you check off "complete" on the "fixed expense" sheet, "income" sheet and fill out your "other expenses", this way you can track things month by month?
@libbysworld7649
@libbysworld7649 Жыл бұрын
Hi Justin, what I did was create a pivot table of my "Final Tracker" sheet and I was able to use that rolling data to plan and forecast all kinds of things. You can easily set up a tracker doing this month to month and add additional columns for your own tracking purposes. I did something similar to show me my spending trends. You can place it in an independent tab on the spreadsheet. Best of luck.
@tanyabonniface8015
@tanyabonniface8015 3 жыл бұрын
All I can say is WOW! Thank you so much for making this video, I can see things so clearly now and I am just so happy I can do this properly now and see everything! Thank you, thank you!
@duyenle2212
@duyenle2212 4 жыл бұрын
This was a great tutorial! Straightforward and easy to follow! Thanks for helping me begin my journey to personal finance. Keep up the great work!
@whyworksmarternotharder
@whyworksmarternotharder 4 жыл бұрын
Awesome news. Welcome to the community!
@luffy-ic7pb
@luffy-ic7pb Жыл бұрын
This was super helpful and informative, you seem like a genuine good dude.
@libbysworld7649
@libbysworld7649 2 жыл бұрын
Dude, you are amazing! Not only am I a new subbie, I'm sharing this with tons of people. Thank you for creating this and sharing. I wish I would have seen this sooner.
@whyworksmarternotharder
@whyworksmarternotharder 2 жыл бұрын
Wow! Thank you!!
@Onelonewolf1998
@Onelonewolf1998 3 жыл бұрын
This has helped me manage my budget so much more efficiently than i have been before. Thank you
@dianamcghee9729
@dianamcghee9729 5 ай бұрын
I really like this and appreciate it. It's exactly what I've been looking for and MORE! Thank you.
@benuriwickramarathne5443
@benuriwickramarathne5443 Жыл бұрын
Wow this is amazing!!! Thank you so much for sharing your valuable knowledge!!
@lordsonic4567
@lordsonic4567 3 жыл бұрын
AWSOME! I will attempt to make my own. I am strugling with my bookeeping for my small buiness. Thank You!
Excel Budget Template | Automate your budget in 15 minutes
9:29
Work Smarter Not Harder
Рет қаралды 3 МЛН
Build Your Own Personal Budget Dashboard | Budget Spreadsheet | Personal Finance
26:35
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 47 МЛН
One day.. 🙌
00:33
Celine Dept
Рет қаралды 79 МЛН
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 23 МЛН
黑天使被操控了#short #angel #clown
00:40
Super Beauty team
Рет қаралды 56 МЛН
10 INCREDIBLE things Google Sheets can do Right Now!
13:27
Jeff Su
Рет қаралды 58 М.
The Best Budget Template You’ll Ever Use - Plan Your Finances in 15 Minutes!
16:03
Work Smarter Not Harder
Рет қаралды 1,7 М.
How To Track Your Expenses in 2023 | Mind Blowing Google Sheets Tutorial
20:47
Brian Turgeon (bmturgeon)
Рет қаралды 440 М.
The One Simple Budgeting Method That Changed My Life
13:53
Humphrey Yang
Рет қаралды 258 М.
Google Sheets Import Range | Multiple Sheets | Import Data | With Query Function
10:36
Beginners Google Sheets Tutorial - Lesson 1
43:16
Teacher's Tech
Рет қаралды 289 М.
ULTIMATE Personal Budget & Interactive Dashboard in Excel (FREE Template)
33:20
Take Control of Your Finances in 2024 with Excel!
15:35
Kenji Explains
Рет қаралды 110 М.
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 47 МЛН