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!
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.
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.
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.
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?
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
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.
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!
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!!!
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! :)
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!
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!
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.
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 !
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 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
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!
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...
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.
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!!!
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 🙏💙
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!
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.
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!
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’!
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!
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!
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 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.
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🤙🏽🤙🏽🤙🏽
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!
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.
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
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!
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
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!😊
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.
@@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. 👍👍
@@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!
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!
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.
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!
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 :)
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.
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!
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!
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!
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 🙏🏽😇
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?
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.
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
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.
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!!!!
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!
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.
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
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: @
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!
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.
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!!
Really good planner. I'd suggest you put =IF(AND(D3="",E3=""),"",F2+D3-E3) in the cell, F3 and copy down to the bottom of the column for better results.
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!
Wow! Great tutorial - presented very well and extremely helpful. I very seldom comment on RU-vid presentations but this is just outstanding. Thank you so much for your time and effort!
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!
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.
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!
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!
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
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
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!!
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!
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.
Very good video, thx. If you add a "countif" for the -500 bucks you don't have to scroll to search everytime you want to know if there's a problem with the budget. You also can look for those specific dates... Just adding to your video with ideas... Thx for sharing ✨
Really solid video. The one thing that I think would be nice to include is a way of tracking your savings. I'm sure you could create a new column titled savings account and have an initial balance then query whenever we transfer to our savings account? What would be the cleanist way to track savings with this setup?
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.
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
I'm so thankful that I found your page since I've been searching for the past couple of days. My brain is wrecked from recreating multiple ideas. So I have a question since my brain is stuck. If I have multiple bank accounts and want to still see the running balance including those, how'd I go about setting that up? Maybe in the morning I can better wrap my brain around the addition. Lol. Thanks!!! Appreciate all the help.
Interesting approach to the topic. It really is so important to be getting our heads around this type of content considering the current state of the world. Great video keep up the good work!
