How To Build Your Own Budget in Google Sheets | GOOGLE SHEETS DEMO/TUTORIAL
Вставка
- Опубліковано 2 жов 2024
- Hopefully this video is helpful for those of you learning how to budget and create spreadsheets.
Please let me know if you would like another demo for creating my finance tracker/charts!!
Debt-Free Blueprint Course: debtoverit.thi...
How I Track My Finances: • How I Track My Finance...
Free Budget Templates: docs.google.co...
#GoogleSheets #Budget
Financial Coaching: debtoverit.com...
Get on my Money Monday List: www.subscribep...
Money Blog: www.DebtOverIt...
Follow me on Twitter: / debtoverit
💵 Support me: www.buymeacoff...
💰 Venmo: @DebtOverIt
________________________________________________________________________
SAVE MONEY
Get Mint Mobile for as low as $15/month: www.mintmobile...
ACCOUNT BONUSES
Chase Checking ($200 sign up bonus): accounts.chase...
Capital One 360 Checking: capital.one/3R...
Open an account, set up and receive direct deposit and earn $50
💳 CapitalOne VentureX: capital.one/3W...
75,000 bonus miles after spending $4,000 in first 3 months
Unlimited 2X miles
💳 DiscoverIt: refer.discover...
Earn $100 after making a purchase in your first 3 months
💳 Chase Freedom Flex:
www.referyourc...
Earn $200 after spending $500 in first 3 months
5% cash back on groceries for 1 year
No annual fee
💳 CapitalOne Venture One: capital.one/2J...
20,000 miles after spending $500 in first 3 months
1.25 miles per $1 spent
No annual fee
💳 CapitalOne 360 Checking: capital.one/3R...
Earn $50 after direct deposit of at least $200 2x
MAKE MONEY
🌟Rakuten (earn $40): www.rakuten.co...
🌟MaxRebates (earn up to $50): www.maxrebates...
🌟IBotta: ibotta.com/r/8...
🌟Fetch app: Use my code EJH9Y for 2,000 points
SIDE HUSTLE RESOURCES
🪧 Create Custom Stickers ($10 Credit): www.stickermul...
💻 Start your own website: www.siteground...
Get 3 months free + 75% off your first year
💻 Create a Course! Teachable Launch Accelerator Challenge: teachable.sjv....
🧾 Learn how to sell digital products on Etsy: leila711--gold...
INVEST & EARN MONEY
🤑M1 Finance (Get $10 after investing $100): m1.finance/2RL...
🤑Coinbase (Get $10 of Bitcoin after buying $100 in Crypto): coinbase.com/jo...
🤑WeBull (Get 2 free stocks after depositing $100): act.webull.com...
____________________________________________________________________
MY LIFESTYLE CHANNEL: / livinglikeleila
GOAL ACHIEVEMENT COURSE: livinglikeleil...
SELF-DISCIPLINE COURSE: livinglikeleil...
CHECK OUT MY BLOG:
www.livinglike...
I N S T A G R A M : / livinglikeleila
Camera I use (Canon EOS M50): amzn.to/2KpcE9k
Microphone I use: amzn.to/2KI43zU
Business inquiries: contact@debtoverit.com
*The links above may be affiliate links. This just means that if you make a purchase through one of the links, I make a small commission at no extra cost to you. I appreciate the support!
DISCLAIMER: I am not an expert or a financial advisor. I simply love talking about finances and want to share my journey to financial freedom and help others along the way!
OMG, if I had a dollar for every other you tube video I watched trying to find this information I could create a “Side Hustle” column. 😃 Your video is golden. Thank you SO much.
Thank you Anne!!
26:34 26:34
Can anyone tell me if excel sheets can be converted to Google Sheets, please?
I swear to god we learn more on the internet than school, thank you for this. I didn't know I could of done all this and I took computer classes they've never taught me this stuff. I will thank you again for all this information I never knew. I also liked the video with a subscribe.
Thank you so much Chris! Glad you found it helpful!
I have about 14k in cc debt and I've been struggling to budget and try to pay it down effectively.
This template is going to make me feel so in control of my life, thank you!!! I'm endlessly grateful for this.
Awesome!! I'm glad it's helpful!
You have no idea how helpful this has been for me!! c: Now I have changed all my Google spreadsheets to look as organized as these. Thank you so much!!
Time Stamps:
*To SUM: 5:23
*Same Formula: 13:51
*Difference: 14:41
*Colors: 15:53
*Income - Expenses: 19:52
I was in desperate need for this info. First time here and I’m hooked, you’re not only very easy to understand but very simple, I appreciate the help!
Thank you! Glad it was helpful!
@@PersonalFinancewithLeila yes, But where are the links to the free budget? that are already created.
As a beginner in setting up spreadsheets, this was very helpful, simple and straightforward, thank you.
Glad it was helpful!
i love having my budget spreadsheet on google sheets! easy to access from anywhere with internet and it saves me paper haha
yess I love it!
Thank you so much! I spent so much time trying to find out how to change the color of text or cell color if income is more or less than expenses. You have just show me a very simple way!
Glad it helped!! Thanks for watching!
Hi Leila! I really appreciate you taking the time to show how you build your template! ☺️ I use Google Sheets as well to track my budget: I have 12 tabs (one per month) where I break down day by day how much money is going in/out. Being able to link cells from a previous tab is very useful to carry over the amount to the next month. It is very detailed but it really helped me when I needed to get out of debt to see how much extra money I could use for repayments.
Thank you for watching! And wow that's amazing that you track daily!
Thank you so much for taking the time to not only make this tutorial, but also create and share your template!
Of course, thank you for watching!
Thank you Leila! your patience and clear precise delivery made me excited to learn just tell me where to send the check!
Glad it was helpful! 😊 keep the check and invest it! Lol
Thank you SO much for this i was having a lot of trouble trying to figure this out and you really helped me. You're so amazing
Thank you for this tutorial, super helpful. I’ve been wanting to create a custom google sheet for budgeting 🙂
I love this. After years of not tracking a budget/expenses I’m getting back in the game. What is the personal sinking fund?
Excellent tutorial; exactly what I was looking for!
This is an excellent tutorial. Thank you!
bruh, this was great content. forget the budget, this was great excel 101 which i need.
Thank you so much!
Thanks for this video. I'm obsessed with finances so, I binged watched your videos yesterday. I like to see examples of how other people manage their money. I needed a video like this. When I write out my bidged I perfer to do everything as a list format insted of the way some do theirs but I don't know how to do formulas for budgeting. Can you pkease do another video. Thanks in advance.
Thank you much for this.I really needed it 🙏
This was great! I might import my full tracker spreadsheet to google docs so I can edit on the go! Also yes to the tracker! I made a modified version of your after your last video but I think I missed a few edits.
Thank you! And I'll film the tracker video! 😊
This is awesome❤ I have definitely been doing things the hard way, but this has made my budget look sooooo much better. You are much appreciated. Very clear and to the point. Thanks Leila.
Loooove the notes option!
Very helpful! Thanks so much!
Yes, be sure to share all your finances with Google. I'm sure that's a smart move.
Thank you for this great video!
Thank you!!!
This was really helpful
So helpful! Thank you so much! Are these Google sheets free?
I have looked at numerous videos on this topic. This is the most concise and easy to follow that I have seen. If you are not a teacher, you should. Great job.
Wow! Thank you. That was very clear and easy to follow. I'm going to sit down today and make a spreadsheet for myself. I like that you took this slowly and clearly. Have been watching a number of videos on making a budget in Google and this was the basic groundwork that I haven't found anywhere else so fa.
Glad it helped! Looking back on this I feel there are more things I have learned/could include. May need to do an update. Hope you had fun on your spreadsheet!!
Thank you so much for sharing this! I've always wanted to know how to do this but I am NOT tech savy. You made it easy to follow and understand. I'm a stay at home mom who loves to learn new things so this made me feel so good to learn. Thank you so so so much!
Glad it was helpful Moriah!! Thank you for watching!
Kids these days like Macs...interesting.
thank u so much
THANKS!
It keeps telling me I need to request access in order to get into the template?
You have to make a copy
I updated the link in this video so it forces a copy
Laila, you did a great job with showing this video on making a budget both in a weekly and simple version. It was very helpful. 😊
I like this video, it is very very informative. this will help me a lot since I'm about to move out off my parents house. 👍
This was AMAZING. Thank you for educating us!
Thank you for the template resource! New subscriber.😇
Thanks for being here! 😊
This was great! I definitely picked up some awesome tips. Thank you!!
Yay glad it helped!!
HI Leila, I dont like to see the #DIV/1! Error on the yearly finance tracker page so would put the final formaula in the last column as =if(ISERROR(N6/$N$3),"-",N6/$N$3), (and just copy it down) to just put a dash in the box if you have the divide by zero error.
Thank you so much for your template and this amazing video! Very much appreciated!
do you make a new copy of this template every month? or is that a dumb idea to have all the prior months finance trackers taking up space in my drive?
Amazing value! Subscribed!
Great video! Do you have a video on how I can integrate sinking funds into my budget on google sheets. Either for quarterly/yearly bills or savings.
Thank you for sharing! Your video was very informative and gave me some new insights.
You just changed my life! thank you wonderful video.
Thank you so much Leila! This video was very informative! I was thinking of switching from paper to digital with regards to my budget planning but I haven’t had the time to study or use google sheets or excel. Though you said that this video was long, this will save me a ton of time with regards to doing my spreadsheets. Thank you so much! 😊🙏
Thank you! Once you get started you'll see it's quite easy to use!
This was a very helpful video. Thank you.
So, the only thing that wont work on my end was the conditional formatting. Is there another way to do that part?. Thanks-- by far its been very hopeful.
Honestly sometimes Google sheets is a little finicky with that so I have to delete the row and start over or at least remove all the conditional formatting. If you can't get it feel free to email me your spreadsheet and I can try to fix it!
Oh my goodness this was so informative. Literally explained everything I wanted to know. So helpful, thank you so much!!!
Glad it was helpful!
Thanks for your videos. Under conditional formatting, would you happen to know why when I tell sheets to fill red when less than zero, it fills it when it is zero? Doesn’t do this everywhere on sheet. Strange!
Sometimes mine does this too! I think it's just a bug 🙄
I usually end up deleting everything and starting on a new column/pushing it over
Do you offer any financial coaching sessions on a sliding scale? I don't have a lot of debt but I could use some help to keep me from going into it. I haven't been this poor since I was in college
Yes I can do that Olivia!
Could you please email me at contact@debtoverit.com and tell me a bit more about your situation? 😊
Make a DEBT Tracker and a vacation spred sheet
Thank you
Is there a way to insert more rows just to the “Budget” table later on, say if expenses increase, without also adding extra rows under the “Income” and messing that format up?? Thanks.
Yup of course! Select the cells you want to add below (or select the whole row), right click and select insert cells and shift down (or up)
Thank you, you made it very easy to understand!😀
Great video thank you so much!
Amazing! Thank you very much
Hi Leila, my finances are a little different, Im self employed and just pay myself as needed to pay my bills. My small business makes random amounts monthly and my personal and work finances are very much intertwined. Should I do two completely separate budgets?
Why in the world schools don’t teach useful life classes? 😭
Thank you for this video. I had an Excel Spreadsheet, and my granddaughter put a password on it and forgot the password. Then I did a spreadsheet in Google and that disappeared. Today I've watched several videos but yours is the best. As you can see it is 3:45AM, so I will watch it later today when I wake up. Again, thank you for this information. Have a great day. 👍👍👍👍👍👍
I tried downloading this spreadsheet but I haven't been able to do it. Please let me know if you can download it. Thanks
This was an awesome video. Super easy walk through here!
How do I get the templates?
It's linked in the description!
I learned so much! Thank you!
That was super useful and extremely well explained, thank you.
Such a helpful tutorial. Thank you!
THIS WAS SO HELPFUL, THANK YOU SO MUCH!!!!! Wow this was amazing and eye-opening, I'm def gonna try this!!!
Glad it was helpful!
Thanks for this! I’m assuming this doesn’t work fully on the app? Certain things I’m not able to do
Yes that's correct! I haven't been able to figure out formatting on the app or moving things around, but I usually just fill in my spending and add items.
yo this is so great. im like halfway thru the vid and i have subscribed going to follow on socails as well. love the simplicity and your easy wasy of explaining complex things!!! the template is exactly what i needed and the education on sheets is priceless.
Glad to hear that, thank you! I'll get another tutorial up soon!
Also what does a sinking fund mean in this case?
Can I do this on a IPad? It does not seem to work the same way. Thanks
I see you made this awhile ago nonetheless Very well made video. Just one question, is there nothing to put down on row M column 14 at the 21:50 part? That Column has the statistics of INCOME-EXPENSES. Maybe I misunderstood or were there suppose to be something there to fill in?
Everything was really clear and informative. A great source for someone like me starting with Google Sheets. Thanks!
For the Paycheck part...Does it matter if Paycheck 1 is the end of the month of January and paycheck 2 is the second week of January? Or do do both paychecks have to be the same month? Please let me know!!! Thank you!
Can you please do charts? Please
I wanted to ask if you knew how to use scripts to automate this process. I really love you process and think I could benefit from it. I’ve also learned that the more you can automate your finance the better you will feel. Your expertise is greatly appreciated. Thank you.
Thanks for this. You're really clear and thorough. Quick question though: What's a "sinking fund"? 🧐
Thank you! A sinking fund is just saving for specific things. For example, I have a sinking fund for travel, car insurance, car maintenance, gifts, emergency, etc. You can either add to them on a monthly basis and use them as needed (that's what I do for gifts) or you can save to it until you reach a certain amount to be used later (for example. maybe you need $2K to buy a new home appliance so you keep saving until you reach $2K and then stop).
Hopefully that helps!
Love your video. But can you slow down just a little. If you talk like you’re having a conversation is very fast. Thank you not a criticism.
Thank you! I'll work on slowing down!
I’m grateful for this. I get frustrated with the tutorials using the pretty budget calendars with stickers. I’m an adult. I don’t do stickers. I love that you keep it very simple.
Thanks Holli!!
I ❤ your comment Holli - “I’m an adult. I don’t do stickers” - sooo time consuming having to watch through all those prettying up of a Budget 😮😮😮😮😮. I thought I was the only one 😂. Thankyou ❤
@@josmith2002 I personally believe they are distracting. You don’t need childish stickers to make a budget less intimidating. You need consistency and a mindset that the budget itself offers peace of mind.
This is a game changer. Thank you
Thank you for the information!
I want to use the Google sheets. I do not have excel and don't want to buy it.
I have been tracking my money using paper and pen. I would like to use a digital format now. I am going to save this video.
What if I wanted to put a percentage away from each paycheck in my savings? Is there a way i can make something like that to subtract a certain amount from the total income? I am a freelancer so my paycheck is also changing as well so it would have to be weekly. Hopefully this makes sense
This is the best one !!!!!!!!! Thank youuu so much for the wonderful info 🎉🎉🎉
You're so welcome! Glad it was helpful!
Hi! I really love this and have been working on my spread sheet while watching this :) I need to create the one for the weekly budgeting. Do you have a video on that?
Thank you so much! This is so helpful for a nonmathematical mind!! I love all the tricks..this gives me more confidence to present actual numbers to my roommate.
Hi thanks for sharing this video. I downloaded the template. Thank you
I am in the process of creating an online course and I wanted to create an easy, minimal budget sheet for the students. This was very easy, straight to the point, and helpful. I had a google sheet on the side walking through it with you. Thank you!
This is probably the easiest on the eyes spreadsheet for me that I can comprehend. I've gotten so overwhelmed with budgeting and all those fancy colorful ones I've found online. I appreciate your time and effort creating this and sharing your knowledge.
Hey I have a question, let' say you made some profit off of your investments. Do you or would you add that into the income section?
You definitely could! Then if they're being reinvested you could also record that in your spending. I receive dividends and then they just automatically get reinvested so it would be a lot of work to keep up with it all. I do keep track of all that on a monthly/annual basis, but just prefer not to include it in my monthly budget!
Very informative, I learned a lot. Just a suggestion, though, is to go a little slower!
Thank you and thank you for the feedback!!
Super helpful thank you! I wish I got on top of my finances sooner.
Cute and Smart. Very helpful thank you!
When using the simple budget is each month on a separate sheet? How do you compare each month?
So I use the same tab for 1 full year. I copy paste the budget one column away from the current one (to the right). Then I change that whole column color to a dark gray as a divider. Hopefully that makes sense!
By the end of the year I have 12 months of budgets on one tab that I can scroll through horizontally
Just found you. Thanks for your work on this project. Helped me
This is so incredibly helpful and idiot proof. I should know 😊. Thank you.
This is really helpful and straightforward. Thanks for this!
Omg I love you girl I did research and they wanted us to pay to learn this thank you so much.
Hi👋Is there a Link for your sample demo sheet? Thank You!
Love Love Love this! Thanks! Please make more!!