How to Build an Income and Expense Tracker from Scratch - Google Sheets TUTORIAL Budget Spreadsheet
HTML-код
- Опубликовано: 20 сен 2024
- In today's tutorial I will show you how to create this simple Income and Expense tracker from scratch in Google Sheets.
You will be able to:
Add your Income Sources
Register Income Transactions that will be added up in their corresponding Income Source
Add Expense Categories
Register Expense Transactions that will be added up in their corresponding Expense Categories
You will also be able to compare expected/budget amounts vs actual amounts.
Finally, you will create a summary showing your Income and Expense totals and how much money you have left for the corresponding month.
📌 Get the FREE template: tinyurl.com/wj...
Please note: The template is sent automatically to your email (don’t forget to check your promotions folder). It should arrive within a few minutes, if it doesn’t please send an email to hello@thinklikeagirlboss.com
📌 Shop Spreadsheets: thinklikeagirl...
📌 Need a more advanced version? Check out the FULL 12 Month Income and Expense Tracker: • Income and Expense Tra...
I decided to create something a bit more elaborate than usual and I would love to know your thoughts! Was it too easy? Was it too hard? Please let me know! 😊👩🏻💻✨
#personalfinance #googlesheets #moneymanagement #tutorial
You make Excel less intimidating! I slowed down the video speed, wrote down the steps for each part, and used a doble window screen to follow along while I built the sheet. I like how you presented multiple features to create: Calendar, Expense, Income, dropdown menus (that was really cool) and formula shortcuts. I feel so smart after this and feel like I can now knowingly customize my personal and business finances. Thank you for sharing your knowledge and in an easy-to-follow manner!
Hi! Reading this message brought me so much joy!! Thank you so much for taking the time to write it!!! 😊👩💻✨ I'm so excited you found it useful, I hope I can keep on creating things that help you!! 💕
i can't be grateful enough for this tutorial. I patiently replicated it and i have used it to manage the inventory in my work place by adapting the inflow and outflow system in it. I have created many templates for our stores and the warehouse from this tutorial. It's like all that i needed. Thanks a million time. Meanwhile i have a need. i wish there is a section that will extract items that negative money and money before the items, so that i can know what is draining my money easily.
Hi! I'm so happy you found different uses from what you learned! If you're looking for a more advanced version you can check this one out: ruclips.net/video/VHKFLDjyBQI/видео.html
I hope it helps! 😊👩🏻💻✨
Thank you so much for this amazing video, i am just ashamed that i discovered you 1 year later after you uploaded this insightful gem of knowledge.. you gained a subscriber from Kenya 😊😊😊😊
Thank you so much for your kind words and for subscribing! 😊👩💻✨
I think that was the most clear and easy to follow tutorial I have ever watched in my entire life. Can you make a tutorial for everything imaginable?
I loved your comment! Thank you so much for watching!! I'm so happy you liked it! 😊👩💻✨
You're an outstanding teacher -you keep in mind the learning curve. Which a lot of people aren't capable of doing. Thanks
Hi!! I'm so happy you think that!! Thank you so much for commenting!! 😊👩💻✨
cmd=ctrl on windows. Thanks for the video. It was a massive help
Thank you!! I'm glad you liked it! 😊👩🏻💻✨
OMG I cannot believe that I actually accomplished following step by step from this video and actually created my own income tracker from scratch and all the formulas are working properly. I had to reconnect to my web design programming side to coding on excel. I just realized how much I miss coding. I just don't want to give up. It took me 3 days to complete this on and off with break times, but I accomplished this. I wished I had stuck with this side instead of going to teaching lol.
Wow! Thank you so much for watching the whole thing, even if it took a couple of days! I'm so excited to hear you completed it!! 😊👩💻✨💕
This is exactly what I was looking for. This template is 200% customizable. Thank you for your time!
I'm so happy you found it useful! Thank you for watching and commenting!! 😊👩🏻💻✨
Thank you so much for explaining everything. I did turn your 45 minute video into about 2.5 hours because I kept stopping to make sure I was aligned with you. I love my outcome.
Hi! Wow! thank you so much taking that time to watch my video! 😊👩💻✨ I'm so happy you loved your outcome! 💕
THIS WAS PHENOMENAL!!! It took me a long time just to do it however, I learned so many new shortcuts and tricks and I havent even used the actual document yet. Thanks
I'm so happy you did the whole tutorial!! Thank you so much for watching!! 😊👩💻✨
I created this for my household! Thank you for all of your cool tricks! I’ll use this forever!!!
I'm so happy you liked it!! Thank you so much for commenting! 😊👩💻✨
I just love how you explained this Sheet, Im very dyslexic and following others is hard for me. But you made this lesson more understandable to me. I have Subscribed. Thank You
Thank you so much for subscribing! I'm so happy you liked it! 😊👩🏻💻✨
This video was AWESOME! Took me step by step and I love the outcome.
Thank you so much for watching! 😊👩💻✨
i loved it. youre my hero
for windows command key, use ctrl, use it without releasing when selecting cells
You're so sweet!! Thank you so much for watching and commenting!! 😊👩💻✨💕
You're so GREAT at making these tutorials. I've been learning A LOT from your channel. Thank you so much for making videos!
Thank you so much for watching!!! I'm so happy you like them 😊👩💻✨
I was able to build the Excel version. It took a while to deciper how to adjust some of the functions , but I did it!
Hi! I'm so glad you were able to build it in excel! I hope you had fun! 😊👩💻✨
BEYOND helpful. I'll be using this for my bookkeeping for my small business. I currently can't add another expense to my business so Quickbooks wasn't an option but I really needed to get more organized with finances. THANK YOU for making bookkeeping accessible.
I'm so glad it was helpful! Thank you for watching! 😊👩🏻💻✨
Thank you! Your channel is truly amazing. The habit tracker and this one especially.
I'm so happy you like them, thank you for watching!! 😊👩🏻💻✨
Simply put, you're the best.
Thank you so much! I'm glad you liked it!! 😊👩💻✨
LOVE LOVE LOVE THE TUTORIAL! VERY EASY TO FOLLOW!! PLEASE DO MORE!!
Thank you so much!! I will!! 😊👩🏻💻✨
Thank you, I loved how the tutorial went from A-Z, quite good for someone who does not have full knowledge of Sheets/Excel.
I'm so happy you liked it! Thank you so much for following along! 😊👩🏻💻✨
Thank you for this, I was about to pay for a finance tracker spreadsheet. This saved me, thanks
I'm so glad it did! 😊👩🏻💻✨
I watched, learned, and copied your moves from the first click! Thanks a bunch
I'm so happy to read this!! I hope you enjoyed it! Thank you for watching! 😊👩💻✨
This is exactly what I NEED and I'm glad I found this🎉🎉🎉🎉 thank you.. it's a little bit confusing at first but I get a hang of it even a little bit but it still a progress so I really grateful I found your channel
I'm so glad it was helpful! Thank you for watching!! 😊👩💻✨
You are great at teaching, I was able to pause and replicate everything you did and also I have something to use for my business in 2024. Thank you
Thank you so much for this tutorial. It was very informative and fun. I was looking for ways to track my expenses and this will really help me.
This is definitely what I need. Now, I'm loving google sheet. Thank youuuuuu! 💚❤️♥️
I'm so excited to hear that!! Thank you for watching!! 😊👩💻✨💕
Much love from Jamaica! This is great ngl. Keep up the good work.
As someone new to this, you made everything so easy! I understood all you were saying and doing. I followed along and was able to finish this in just one sitting. I'll be using this starting today!! As a thank you, I subscribed to your channel. I look forward to your content!!
I'm so excited to read this! Thank you so much for subscribing!! 😊👩💻✨💕
I'm trying to learn new formulas and when I stumbled upon this video, just going through this made it easier for me to recreate it, did not think twice and immediately subscribed to your channel, definitely looking forward to watching more of your videos
Thank you so much for subscribing!! I'm so happy you like my work 😊👩💻✨
I just created this by following your video step by step-thank you so much for your help!
I'm glad you found it useful! 😊👩💻✨
Can you please put the template here?
Just discovering this tutorial and channel, and WOW!!! You are incredible! This has helped my husband I with creating a realistic budget SOOO much! Thank you for being an awesome teacher and sharing your knowledge, you are so appreciated!! :D
Hi! I'm so happy you found it useful! Thank you so much for watching and commenting! 😊👩💻✨💕
Thank you so much for this template!! It´s super useful, you can do it yourself but its superkind of you to give it for free, very helpful and explicative video, thanks
Thank you so much for watching!! 😊👩💻✨
I'm in a difficult journey in life, trying to get life-work balance and personal finances under control again after 6 months of work related burnout. My mental energy is not the greatest at the moment, but watching your video and following along made it SO MUCH EASIER for me to learn what I need to know right now! I am so happy I found this video.
I'm a new follower and will be consuming *ALL* of your videos haha good work!
It really makes me so happy to hear this helped you!! I wish you the best on your journey and I hope I can keep helping in some way. Thank you so much for watching! 😊👩💻✨💕
I am trying to learn on managing my expenses everyday. I also get tried tolike encode all of it but after a month it was pretty hard to summarize everything. This really helped me alot on improving my money managing skill. Thank you!
I'm so happy it helped you! Thank you so much for watching! 😊👩🏻💻✨
This was a fantastic video, thank you very much. As someone who has good experience with excel and a little in sheets this was very easy to follow. Thank you!
I'm so happy to hear that! Thank you so much for watching! 😊👩🏻💻✨
Thank you so much, I really like sheets and couldnt find a good tutorial until you.
Hi! I'm so happy you found it useful!! Thank you so much for watching!! 😊👩💻✨
this was an excellent tutorial! i LOVE the outcome, and am very unfamiliar with the intricacies of google sheets. your explanations were really clear & helpful. thank you!
I'm so happy to read this! Thank you so much for watching!! 😊👩💻✨
Ah! This is what I was looking for. I had to slow down the video speed a bit in order to follow along, but got done what I wanted to get done. Thanks very much for taking the time to do this teaching vid.
Glad it helped! Thank you for watching! 😊👩🏻💻✨
@@thinklikeagirlboss No problem. Also liked and subcribed too 🙂
Thank you very very VERY much. I just put this together and its just what I was looking for! You made it so easy to follow and explained it so well! THANK YOU
I'm so happy you liked it! Thank you so much for watching and commenting 😊👩🏻💻✨
Loved the Tutorial, I made the exact same thing seeing this entire video. Very easy and helpful. :)
I'm so happy you loved it! Thank you so much for watching!! 😊👩💻✨
Absolutely amazing !!!! This is exactly what I was looking for. Thank you! Thank you! Thank you!!!!!!!!!!!
I'm so happy you like it! 😊👩💻✨
Thank you so much!! I have been searching for this since a year and finally🎉🎉😊😊😊
I'm so glad it was helpful! Thank you for watching! 😊👩💻✨
This is awesome! Just have to figure out how to do it ot in Microsoft Excel. Some of the steps are different for Microsoft Excel, but you are a great teacher!
Thank you so much! I hope it turns out great in Excel! 😊👩💻✨
Amazing! I learned so much and had fun following along. First time using a spreadsheet and I'm feeling quite proud at the moment. Thank You!!
Hi! I loved reading this!! Thank you so much for watching and commenting! 😊👩🏻💻✨
thank you so much for your tutorials! love exploring google sheets on my own, but your tutorials/templates are so helpful. was able to make 2 trackers today :>
Wow!! I'm so excited to hear that!! Thank you so much for watching!! 😊👩💻✨
Thank you so much for your tutorials!! I just discovered your channel last night and have been binge-watching your videos all day today! You're amazing!!
That's so sweet! I'm so happy you like my work!! Thank you so much!! I never imagined someone would be binge watching something I made, that's just awesome. Thank you!! 😊👩💻✨
Thank you so much for creating this tutorial. It is really help me, who don't understand excel from the basic, easy to follow along. I learn a lot and I appreciate you so much, you do very great job. I'm your new subscriber now!! Love from Indonesia
I'm so glad it was helpful!! Thank you so much for watching and subscribing!! 😊👩💻✨
Awesome tutorial! I used it to help me upgrade my budget sheet.
You do have to be a little patient with yourself. She does an excellent job explaining the steps but sometimes you still might miss something. So you have to pause and then look over the formulas very carefully to ensure you captured it correctly.
Hi! I'm so happy it helped you! Thank you so much for your feedback! 😊👩🏻💻✨
Thank you! This looks organized and easy to follow.
Who knew how addicting your videos would be... thank you 😄
Hi! I never imagined someone would say that about my videos, thank you SO much!! 😊👩💻✨💕
Just set up mine and this was so helpful! The step by step directions really made it easy for me to follow. Thank you!!
I'm so happy to hear that!! Thank you for watching!! 😊👩🏻💻✨
Thank you so much for this
I'm so happy you found it useful!! Thank you for watching!! 😊👩💻✨
I want to just say, Thank you so much! I enjoyed as I learn from this video tutorial!
I followed you all the way and I got it. Thank you. I always wanted to do this but I’m always mess up
I'm so happy you got it!! Thank you for watching! 😊👩🏻💻✨
Wow! Came for a formula and ended up getting your template and just starting over completely. This template is a game changer! Thank you so much. Will definitely check out your other templates in the future. If even possible, I'd love to be able to sync my Google Calendar with the Google Sheets. The projected transactions, along with the dates, showing up in my calendar as well.
Thank you sooo much! You explained everything perfectly & I was able to create my very first Google Sheets! I can’t wait to use it! ❤
I'm so happy this was your first one!! Thank you for watching! 😊👩💻✨
this is such a cool tutorial and i've learned a lot about using sheets/excel in just a span of watching your video. You explain things very well too. Thanks and kudos!
Thank you so much!! I'm so glad it was useful!! 😊👩🏻💻✨
Wow- great video. Thank you
This was excellent! I've been looking for a way to make a Google Sheet into a budgeting device, and your tutorial was excellent!
Thank you so much! I'm glad it was helpful! 😊👩💻✨
Thank you for doing this, I followed exactly, and hopefully I will now use this to actual track my income and expenses!
I'm so glad you found it useful! Thank you for commenting!! 😊👩💻✨💕
LEARN ALOT FROM YOUR VIDEO , THANK YOU SO MUCH
Thank you for watching!! 😊👩💻✨
Thanks For the tutorial, its so helpful😄
Wow wow wow Thank You! absolutely Great, saved a lot of stress! will be tuned in for more 👍🏾
I'm so happy you liked it!! Thank you for watching and commenting 😊👩🏻💻✨
Thank you for an excellent video, demonstrated and explained in a very simple to follow manner. Learned so much from this.
I'm so happy to hear that! Thank you so much for watching and commenting!! 😊👩🏻💻✨
Thanks so much for this super helpful video!
Thank you for watching! 😊👩💻✨
SUCH A GREAT WORK SISTER DONE IN 2 HOURS
That's amazing!!! Thank you for watching!! 😊👩💻✨
This was so helpful! I followed along great. Had to pause here and there but it got done!
Hi! I'm so glad you followed along! Thank you so much for watching and commenting! 😊👩💻✨
It was really helpful. I use google online services quite a lot and this turned out to be a really nice substitute to the offline excel spreadsheet I previously used. Thanks 👍
I'm so happy you found it useful! Thank you for commenting! 😊👩🏻💻✨
You are so amazing Excel Queen for making this. Thank you for the free template. Really helps a lot. ♥ Keep up the good work!
You're so sweet thank you so much for commenting!! 😊👩💻✨💕
This was excellent. It me hours because of the formulas, but I appreciate it very much. Could you do a video on the various formulas, the ones that are used more commonly? Would be great. Thank you. You earned a new subscriber....cheers!
Hi! Thank you so much for subscribing! I will add that to my list of requests. I guess everyone has their own favorite/most used ones but I can make a video on mine 😊👩🏻💻✨
Hi, I am your new follower. Your all videos are Very good and easy to understand. I never feel bored or hard to watching your all videos. After watching your videos I do not like any other person 😊videos. Thank you so much. Keep making videos.
Hi! I loved your comment! Thank you so much for taking the time to write it, I'm so happy you like my work! 😊👩💻✨💕
AMAZING THANK YOU SOOOO MUCH FOR THIS , THIS MADE MY LIFE SO MUCH EASIER
I'm so happy to hear that!! 😊👩💻✨
Thank you so much for making this! Absolute gem of a find, and especially helps for conducting business transactions, etc.!
I'm glad you liked it! Thank you for commenting! 😊👩🏻💻✨
Thank You So Much. Finally did it
Thank you so much for watching and following the tutorial! 😊👩🏻💻✨
This is very helpful, Thankyou
Thanks you so much! Your tutorial was super helpful and easy to follow. Appreciate the effort you put into making it. 👍
Thank you! I have learnt so much from you - you are a fantastic teacher!
Hi! Thank you so much!! I'm really happy you liked it!! 😊👩💻✨💕
Amazing Very Soft to understand.
Thank you so much!! 😊👩💻✨
Thank you for this. I've been looking to stream line my already automated budget, and this helped me a lot, so many great formulas I didn't know about!
I'm so happy you liked it! Thank you for watching!! 😊👩🏻💻✨
I loved this video. I built it - thank you. Won't it be cool to have a worksheet that becomes a dashboard, graphically tracking and comparing financial performance for all the months? I wish that can be an addendum to this video.
Thank you - you just got a new subscriber.
Wow, what a great video. Thank you so much. I wish I would of have found it a year ago, 😊😊 definetly subscribing.
I'm so glad you found it useful! Thank you so much for subscribing! 😊👩💻✨
I made this and I love it! I would love to see a tutorial how you would turn monthly data into an annual spreadsheet of all monthly totals.
I'm so excited you made it!! Thank you so much for watching! What you would need to do is duplicate the tab to create one for each month and then use a separate tab to reference totals.
To reference totals you need to select a cell and enter =, then click on the cell you want to reference (no matter on which tab it is) and the value from that cell you referenced will always be shown.
I hope this helps! 😊👩🏻💻✨
@@thinklikeagirlboss Oh my goodness! Yes that thank you!! I understand that!!
I'm glad it helped! 😊👩🏻💻✨
i watched till the end. gotta say, best spreadsheet i have and gonna use this for like a long long time. i just had one suggestion i.e. maybe adding a column beside the expenses where we can put in comments about the expense. ex. subscription for sim, wifi, spotify etc
Thank you for your suggestion and for watching till the end! 😊👩🏻💻✨
THIS IS VERY HELPFUL, thanks for creating this video.
Thank you for watching! I'm glad you liked it! 😊👩💻✨
Followed this all the way through. Thank you! I hope it works.
I hope it does! If not, you can always look at my original file and compare 😊👩🏻💻✨
Wow! Great tutorial. Thanks a lot for teaching so much google sheets.. u are an awesome teacher ❤
That's so sweet of you to say, thank you so much!! I'm really happy you like it! 😊👩💻✨💕
I didn’t mind. I learned a lot ❤❤❤❤
I'm so happy to hear that! Thank you for watching! 😊👩🏻💻✨💕
This is a great tutorial! Thanks for walking through everything step-by-step. I love the One Formula Wonders. :)
Thank you so much!! I love that formula too 😊👩🏻💻✨
Incredibly helpful. Thank you.
Thank you so much for teaching us All of this. I really do enjoy it.
LOVED THIS! THANK YOU SOOO MUCH!!! Please make more tutorials. I'm looking for a travel itinerary tutorial if you don't mind making one
Hi! I'm so happy you like it!! Thank you for watching!! I will definitely keep on making tutorials 😊👩🏻💻✨
Thank you so much. You made learning so easy.
Thank you so much for watching! 😊👩💻✨
Thank you so much for valuable content, Watched it completely
Thank you for watching the whole thing!! 😊👩🏻💻✨
You’re amazing! Thank you so much! You are greatly appreciated!! ❤
That's so sweet!! Thank you so much!! 😊👩💻✨💕
Thanks for sharing free template, it was really helpful.
I'm so glad it was helpful! Thank you for commenting! 😊👩🏻💻✨
Now that I have made this, is there any way to add a savings report with regular savings/ retirement/etc that reflects in the summary?
Thanks for taking the time to go through this!
Love your tutorials! I did have an issue with the Array formula at the 13:31 mark but the same formula worked in the other areas fine. Not sure what I did wrong as I copied it exactly, so I did an alternate way which was the drag down option you mentioned, and it worked. Learning so much with these tutorials. Definitely have subscribed and will follow your videos as you are an excellent, informative and easy to follow teacher.
Thank you so much for subscribing!! I'm so happy you are liking them!! If you would like me to check your formula and find out what went wrong you can DM me on instagram with a screenshot of the formula 😊👩🏻💻✨💕
@@thinklikeagirlboss Would love to but I'm not on Instagram 😏
Oh! you can also send an email to hello@thinklikeagirlboss.com 😊👩🏻💻✨
This video was very helpful
I'm so happy to hear that!! Thank you for watching! 😊👩💻✨