How to Build an Income and Expense Tracker from Scratch - Google Sheets TUTORIAL Budget Spreadsheet
Вставка
- Опубліковано 5 лют 2025
- 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
Ive been going through so many budget sheets tutorial since early dec 2024, and let me tell you, THIS IS THE BEST ONE YET! The step by steps and explainations are easy to follow, and so informative on the formula used. Very Very educational and helpful indeed! Thank you so very much!
I’m so happy you liked it! Thank you so much for watching!! 😊👩🏻💻✨
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: ua-cam.com/video/VHKFLDjyBQI/v-deo.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! 😊👩💻✨
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!! 😊👩💻✨
I have spent roughly four hours plus following this tutorial and implementing it step by step, and my back hurts, but I am glad I only have to create this one. Thank you so much for making this free; I am grateful. I needed to track my finances properly, and this tutorial and process have helped me. Thank you once again.
And one more thing, I just subscribed. I am grateful
Did this in Jan 11, 2025
I’m so happy you found it useful! Thank you so much for watching and following along! 😊👩🏻💻✨
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!! 😊👩🏻💻✨
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!! 😊👩💻✨
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! 💕
I do the same, my husband keeps asking me “are you making another?” Lol
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!! 😊👩💻✨💕
cmd=ctrl on windows. Thanks for the video. It was a massive help
Thank you!! I'm glad you liked it! 😊👩🏻💻✨
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 really appreciate all your work. Your tutorials are very clear and simple, no time is wasted. Very easy to follow. Thank you! Thank you! I have been looking for some kind of automation spreadsheets for a while.
Thank you so much! I'm so happy you like my tutorials! 😊👩🏻💻✨
This my second spreadsheet of yours I’m making, i appreciate that you even put the info out there to be learned.
Thanks!
Hi!! I received your "Super Thanks" you're AWESOME! Thank you so much!! 😊👩💻✨
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! 😊👩🏻💻✨
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 🙂
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! 😊👩🏻💻✨
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, 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! 😊👩🏻💻✨
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 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! 😊👩💻✨
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! 😊👩💻✨
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!! 😊👩💻✨
Thank you for this, I was about to pay for a finance tracker spreadsheet. This saved me, thanks
I'm so glad it did! 😊👩🏻💻✨
LOVE LOVE LOVE THE TUTORIAL! VERY EASY TO FOLLOW!! PLEASE DO MORE!!
Thank you so much!! I will!! 😊👩🏻💻✨
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!! 😊👩💻✨
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
This video was AWESOME! Took me step by step and I love the outcome.
Thank you so much for watching! 😊👩💻✨
Very helpful. I use excel and some of what you do in Google docs isn't the same, but I was still able to make it work. Thank you.
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 😊👩💻✨
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!! 😊👩💻✨💕
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!! 😊👩💻✨
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 for this tutorial. It was very informative and fun. I was looking for ways to track my expenses and this will really help me.
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?
Wow this is AMAZING!!! i follow your steps and the chart and it made my expenses and income monitored clearly! thanks to your channel
I'm so happy you liked it! Thank you for watching!! 😊👩🏻💻✨
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! 😊👩🏻💻✨
I want to just say, Thank you so much! I enjoyed as I learn from this video tutorial!
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! 😊👩💻✨
Simply put, you're the best.
Thank you so much! I'm glad you liked it!! 😊👩💻✨
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!! 😊👩💻✨💕
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 😊👩🏻💻✨
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!! 😊👩🏻💻✨
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! 😊👩💻✨💕
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!! 😊👩💻✨💕
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! 😊👩💻✨
Thanks for a really great video!!! it was easy to follow along and now I’m inspired to learn more sheets formulas hahahah
Thank you 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! 😊👩🏻💻✨
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!! 😊👩💻✨💕
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!! 😊👩🏻💻✨
Much love from Jamaica! This is great ngl. Keep up the good work.
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! 😊👩🏻💻✨
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! 😊👩🏻💻✨
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!! 😊👩💻✨
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! Your channel is truly amazing. The habit tracker and this one especially.
I'm so happy you like them, thank you for watching!! 😊👩🏻💻✨
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!! 😊👩💻✨
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!! 😊👩🏻💻✨
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.
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! This looks organized and easy to follow.
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!! 😊👩💻✨
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!! 😊👩💻✨💕
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 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! 😊👩💻✨
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!! 😊👩🏻💻✨
Thank you so much for this
I'm so happy you found it useful!! Thank you 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!! 😊👩💻✨
AMAZING THANK YOU SOOOO MUCH FOR THIS , THIS MADE MY LIFE SO MUCH EASIER
I'm so happy to hear that!! 😊👩💻✨
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 😊👩🏻💻✨
SUCH A GREAT WORK SISTER DONE IN 2 HOURS
That's amazing!!! Thank you for watching!! 😊👩💻✨
LEARN ALOT FROM YOUR VIDEO , THANK YOU SO MUCH
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! 😊👩💻✨
The Windows Alternative for Cmd in Mac is Ctrl
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 😊👩🏻💻✨
Amazing Very Soft to understand.
Thank you so much!! 😊👩💻✨
Thank you for sharing your knowledge. It is very helpful for me❤..God bless you!
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! 😊👩💻✨💕
Thank you so much for this!
Do you have a tutorial that has a dashboard containing monthly summaries?
Thanks you so much! Your tutorial was super helpful and easy to follow. Appreciate the effort you put into making it. 👍
On to your 3rd sheet that I’m making ❤
Ty Ty again 😊
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! 😊👩🏻💻✨
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 the tutorial, its so helpful😄
Thank You So Much. Finally did it
Thank you so much for watching and following the tutorial! 😊👩🏻💻✨
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!! 😊👩💻✨💕
Thanks for sharing free template, it was really helpful.
I'm so glad it was helpful! Thank you for commenting! 😊👩🏻💻✨
This is great! How would I be able to make the date reflect a year instead of just the month, and what would the formula look like for the tables too?
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! 😊👩💻✨
You did an incredible job on this video. Absolutely helpful. I have a quick question, if I wanted to add a second or third expense transaction column for like a different account, what would the formula be to get them to both or all to sum into the expense summary?
Thank you so much for teaching us All of this. I really do enjoy it.
Wow- great video. Thank you
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.
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! 😊👩🏻💻✨
Thanks for taking the time to go through this!
Thank you, We love it
THIS IS VERY HELPFUL, thanks for creating this video.
Thank you for watching! I'm glad you liked it! 😊👩💻✨
Absolutely amazing !!!! This is exactly what I was looking for. Thank you! Thank you! Thank you!!!!!!!!!!!
I'm so happy you like it! 😊👩💻✨
Incredibly helpful. Thank you.