The formula for easy copy + paste! *EXPENSES (Put in B2 of your Main Dashboard)* =SUMIFS(Expenses!$D$1:$D, Expenses!$B$1:$B, ">="&$A2, Expenses!$B$1:$B, "="&$A2, Income!$B$1:$B, "
hi!! google sheets has this really cool function that let's you type the formulas in english even if everything else is another language. then all i had to do was change income and expenses to the word i used in my language. hope this helped :)
I think the problem is that the name in the code has to match the name of the sheet on google sheets. for example, if you named the income tab "money in", "income" it won't work, only "money in" would work.
my neurodivergent brain was going brrrrrrrrrrrrrrrrrr for like 30 minutes watching this, and i mean that in the literal best way possible. i've been making my own income spreadsheets for things like summer jobs but i was trying to make a new one for income and expenses now that i'm in college but i could never make it look nice enough so i turned to youtube and im so glad i did. i was also pondering on a way to add photos of receipts but i really wasn't getting my hopes up about having that option integrated into my spreadsheet so when i got to the point where you added a question on the form for receipts, my jaw LITERALLY dropped and i went to start making my own system following along with the video. thank you so much for this omg
FOR EVERYONE GETTING THE ERROR MESSAGE, while copypaste the code. MAKE SURE THAT INSTEAD OF EVERY COMMA YOU PUT A SEMICOLON. MAKE SURE THAT YOU CHANGE THE WRITING "EXPENSES" WITH THE NAME OF YOUR OWN SHEET.
I watched this video a few months ago and made the expense tracker. I come back just to thank you for making this video! :) I really loved it and it was easy to follow your instructions! Thank you Deborah :)
Omg this is just soooo well explained! Followed every step (deeply detalied) and created the perfect thing for me. Really really thankful to you for putting this up (and for free!) Absolutely loved it
You are a HERO for uploading this and explaining everything so clearly. I loved your explanation of the formulas as well. So, so, so helpful! Thank you!!
I want to express my heartfelt gratitude for your exceptional kindness and dedication. Your detailed explanations, user-friendly formulas that can be easily copied and pasted, and in-depth guidance on creating the spreadsheet have been invaluable to me. This is, without a doubt, the most remarkable spreadsheet I have ever come across! While I may not be an Excel expert, I have a basic understanding, and your video has provided immense help with the parts I struggle with. Words cannot adequately convey how appreciative I am for the time and effort you invested in creating this video. You have most certainly gained a devoted subscriber in me! Thank you sincerely for everything you have done!
I love this tutorial-- it is so detailed and easy to follow, especially with the formulas. I am not an excel expert at all and not tech savy but I defiinitely understood it. Thank you!
Hello there! Thank you so much for taking the time to create this video alongside all the other videos. As a recent college graduate, I am late in starting to budget and manage my expenses because to be honest, I didn't know where to start. I am glad I came across your video on tiktok! You are an unsung hero to those trying to adult properly. Thank you so much!
When she talked about formula and my brain went to La Land! lol Thank you for this. I may have to watch this over and over again. To really understand how to apply it on my monthly budget.
I was having issues with the income formula but someone here said to rename it and change the Income on the formula so i changed it to "I" and the formula as well and it worked ! after that i just changed the name back to income and it kept the formula it just renamed itself thank you for the spreadsheet this will be very useful!!!!! i just wish i knew about this from the beginning of the year
I just spent two whole days going though ALL of our bank and credit statements from the last 6 months to be able to get a better idea of our budgeting and pop them into this system 😅 totally worth it!
Thank you very much Debs, I was giving up on tracking my expenses. Then my gf showed me your tiktok. It was amazing. I loved the function that works no matter where you put it on the dashboard. Did I say thanks? Now I'm planning on buying a coffee, but still need to find out how to do it from Brazil. kss
Hi! Thank you so much for this tutorial! Definitely gonna be more conscious about my spendings. :') Just an idea for a future video: It'll be cool if you included a section on your savings and investments- basically anything that you can do with the money that doesn't belong to the income or expense sections. For example, after your gross savings, you have a column for say 10% of your gross savings that you put aside for investment purposes. Then another column after that with your final savings for the month/year. But don't forget the other income categories that come with this- interest, dividends, etc.
Deborah, This was so unbelievable helpful. As a freelancer in the media world I wanted to create system to keep track of my expenses income in an automated system and your tutorial was so fun and easy to follow I had a great afternoon creating my financial system. Thank you so much! xxx
I've started my own small bussiness fitting off grid solar systems and have been building up all the paperwork as i cannot find a way to proccess it in a way i understand, building it from scrach lets me understand the process and what im looking at this is the best thing I've found so thank you so much ! i really think you have just kickstarted my business in the background !
Hi Deborah, Great work! Watched all the videos and enjoyed a lot. Not sure why you stopped making more videos but if possible start again as it is a great learning for many many people.
Thank you so much! This was so easy to follow for someone as digitally illiterate as me! Hopefully making it from scratch will motivate me to actually start tracking my spending and savings - thanks again!!!
I really appreciate this video! I'm so glad there are videos by people trying to help, and not just people trying to sell you their downloadable spreadsheet. This one is awesomely simple. As a total noob, I have a few questions though. - If I were to add categories, would it mess with the formulas? - Do I delete the sample-expenses and incomes so it doesn't read as a part of the budget?
thank u so much for this!!!! im always so lazy to track all of my expenses and i just give up using apps in play store, but this sheet is AWESOME.. i finally motivated to track my expenses hahah
Thank you so much! I'm attempting to expand this into two separate sheets, one for me and one for my fiancé along with a combined totals sheet so we can start saving for our wedding and continue saving on our farm. This has been an IMENSE help!!
I am impressed. this is so awesome. i have been struggling to find the right platform for my business income and expenses. thank you so much for sharing this and taking the time to walk trough so detailed.
I am so happy I stumbled upon this video. I've used yours for the last months of these years. But I noticed I had to customize it a lot to fit my household situation and this helped me understand how it all works :). So for 2021 I made my own and my husband is thrilled by it. This will make filling out our taxes a lot easier :)
Thank you Deborah, its 2024 and I just created this sheet. For anyone that is getting the following "Error Message ("Argument Must be a range",) Make sure that the name of the your Expenses form, the name on the sheet is Expenses..as that is that she uses in the formula.. I had changed mine and was getting the error message as form name didnt match the name in the forumla! Hope this helps someone...
This is sooo awesome! I've been using Spreadsheets for years but always thought there should be a smarter way to use them. This has everything I was needing! Thank you so much!
Conteúdo gratuito e de qualidade, obrigada por disponibilizar. Irei utilizar para fazer meu controle de gastos pessoal, ganhou uma inscrita!!!! ❤ Brasil por aqui 🇧🇷
this is such a great and valuable video series! I....broke mine though by adding extra categories ;n; not sure what I did wrong yet but the sample numbers don't all input when I do the big fomulae
Hello. I don’t know if you believe in God but I want to tell you that God will continue to bless you, the best things in life will find you, you will never lack help, you’ll be provided for abundantly ijn amen. You are so kind and intelligent. Thank you for spending your precious time to teach us how to build it in a very simple, easy to follow way. You are blessed
The formula for easy copy + paste!
*EXPENSES (Put in B2 of your Main Dashboard)*
=SUMIFS(Expenses!$D$1:$D, Expenses!$B$1:$B, ">="&$A2, Expenses!$B$1:$B, "="&$A2, Income!$B$1:$B, "
hi!! google sheets has this really cool function that let's you type the formulas in english even if everything else is another language. then all i had to do was change income and expenses to the word i used in my language. hope this helped :)
I think the problem is that the name in the code has to match the name of the sheet on google sheets. for example, if you named the income tab "money in", "income" it won't work, only "money in" would work.
Thank you millions!!!
Thank you this is awesome
Sorry, this is the one for incomes! Got the wrong one...
=SUMIFS( Inkomst!$D$1:$D ; Inkomst!$B$1:$B ; ">="&$A2 ; Inkomst!$B$1:$B ; "
You are the best person who has ever lived in this world
My mind when she tells the formulas = 🤯
my neurodivergent brain was going brrrrrrrrrrrrrrrrrr for like 30 minutes watching this, and i mean that in the literal best way possible. i've been making my own income spreadsheets for things like summer jobs but i was trying to make a new one for income and expenses now that i'm in college but i could never make it look nice enough so i turned to youtube and im so glad i did. i was also pondering on a way to add photos of receipts but i really wasn't getting my hopes up about having that option integrated into my spreadsheet so when i got to the point where you added a question on the form for receipts, my jaw LITERALLY dropped and i went to start making my own system following along with the video. thank you so much for this omg
Thank you for providing this for free in youtube !
I have now organized my entire life with this method this is insane how did I not this about this sooner. Thank you!
FOR EVERYONE GETTING THE ERROR MESSAGE, while copypaste the code.
MAKE SURE THAT INSTEAD OF EVERY COMMA YOU PUT A SEMICOLON.
MAKE SURE THAT YOU CHANGE THE WRITING "EXPENSES" WITH THE NAME OF YOUR OWN SHEET.
Riccardo Varone thanks
thank you so much! perfect solution!
Thank you very much !! Something so simple ;-)
I tried this one and the thing Deb suggested, still showing #N/A... :(
It worked i just did not use Expenses i used Expense Your the man/ women of the year your amazing
I watched this video a few months ago and made the expense tracker. I come back just to thank you for making this video! :) I really loved it and it was easy to follow your instructions! Thank you Deborah :)
Omg this is just soooo well explained! Followed every step (deeply detalied) and created the perfect thing for me. Really really thankful to you for putting this up (and for free!)
Absolutely loved it
You are a HERO for uploading this and explaining everything so clearly. I loved your explanation of the formulas as well. So, so, so helpful! Thank you!!
This is fantastic teaching for an extreme novice. Thanks!
I was drawing something, then i opended tiktok and you know the rest, thanks for this!
I want to express my heartfelt gratitude for your exceptional kindness and dedication. Your detailed explanations, user-friendly formulas that can be easily copied and pasted, and in-depth guidance on creating the spreadsheet have been invaluable to me. This is, without a doubt, the most remarkable spreadsheet I have ever come across! While I may not be an Excel expert, I have a basic understanding, and your video has provided immense help with the parts I struggle with. Words cannot adequately convey how appreciative I am for the time and effort you invested in creating this video. You have most certainly gained a devoted subscriber in me! Thank you sincerely for everything you have done!
Thank you for this useful Information! God Bless You! 💜💜💜
This is fantastic!!! 2nd year in a row for me using it and I still get lots of value, thanks incredibly much Deborah!
I love this tutorial-- it is so detailed and easy to follow, especially with the formulas. I am not an excel expert at all and not tech savy but I defiinitely understood it. Thank you!
Hello there! Thank you so much for taking the time to create this video alongside all the other videos. As a recent college graduate, I am late in starting to budget and manage my expenses because to be honest, I didn't know where to start. I am glad I came across your video on tiktok! You are an unsung hero to those trying to adult properly. Thank you so much!
When i saw your tiktok i was going crazy about this one! Yaayyyy! I can finally make my own.
When she talked about formula and my brain went to La Land! lol Thank you for this. I may have to watch this over and over again. To really understand how to apply it on my monthly budget.
I was having issues with the income formula but someone here said to rename it and change the Income on the formula so i changed it to "I" and the formula as well and it worked ! after that i just changed the name back to income and it kept the formula it just renamed itself
thank you for the spreadsheet this will be very useful!!!!! i just wish i knew about this from the beginning of the year
I just spent two whole days going though ALL of our bank and credit statements from the last 6 months to be able to get a better idea of our budgeting and pop them into this system 😅 totally worth it!
took me 2 days to do it but I did !!! thank you so much I love it
found this on tiktok! thank u so much!! this was really helpful 🌼🤩
Thank you very much Debs, I was giving up on tracking my expenses. Then my gf showed me your tiktok. It was amazing. I loved the function that works no matter where you put it on the dashboard. Did I say thanks? Now I'm planning on buying a coffee, but still need to find out how to do it from Brazil. kss
Glad you found it helpful!!! 🥺❤️
Hi! Thank you so much for this tutorial! Definitely gonna be more conscious about my spendings. :')
Just an idea for a future video: It'll be cool if you included a section on your savings and investments- basically anything that you can do with the money that doesn't belong to the income or expense sections. For example, after your gross savings, you have a column for say 10% of your gross savings that you put aside for investment purposes. Then another column after that with your final savings for the month/year. But don't forget the other income categories that come with this- interest, dividends, etc.
Deborah,
This was so unbelievable helpful. As a freelancer in the media world I wanted to create system to keep track of my expenses income in an automated system and your tutorial was so fun and easy to follow I had a great afternoon creating my financial system. Thank you so much! xxx
So glad to hear it! :')
I've started my own small bussiness fitting off grid solar systems and have been building up all the paperwork as i cannot find a way to proccess it in a way i understand, building it from scrach lets me understand the process and what im looking at this is the best thing I've found so thank you so much ! i really think you have just kickstarted my business in the background !
Hey! Thank you so much! i had something like this but i added everything manually, never thought about making a form! youre awesome!
Deborah Thank you!! You have made my life so much easier!!
Hi Deborah,
Great work! Watched all the videos and enjoyed a lot.
Not sure why you stopped making more videos but if possible start again as it is a great learning for many many people.
This video blew my mind. What a wonderfully cogently explained process. Amazing initiative. Thank you!!!
Thank you so much! This was so easy to follow for someone as digitally illiterate as me! Hopefully making it from scratch will motivate me to actually start tracking my spending and savings - thanks again!!!
This is fantastic. Thank you so much for the detailed breakdown!
This is amazing! Thank you so so much!
Thank You very much from Portugal!!! You are amaizing at this and make it sound so easy 🙂
I really appreciate this video! I'm so glad there are videos by people trying to help, and not just people trying to sell you their downloadable spreadsheet. This one is awesomely simple. As a total noob, I have a few questions though.
- If I were to add categories, would it mess with the formulas?
- Do I delete the sample-expenses and incomes so it doesn't read as a part of the budget?
thank u so much for this!!!! im always so lazy to track all of my expenses and i just give up using apps in play store, but this sheet is AWESOME.. i finally motivated to track my expenses hahah
LOVE THE WAY YOU EXPLAIN IT, VERY SIMPLE AND EASY TO UNDERSTAND. THANK
Thank you so much! I'm attempting to expand this into two separate sheets, one for me and one for my fiancé along with a combined totals sheet so we can start saving for our wedding and continue saving on our farm. This has been an IMENSE help!!
You're AWESOME! I can't wait to implement using this for my expenses and income.
I am impressed. this is so awesome. i have been struggling to find the right platform for my business income and expenses. thank you so much for sharing this and taking the time to walk trough so detailed.
one of the amazing way to track expense, Thanks so much Deborah
Thank you for this amazing resource!!! I have used it for over 2 years :D
I am so happy I stumbled upon this video. I've used yours for the last months of these years. But I noticed I had to customize it a lot to fit my household situation and this helped me understand how it all works :). So for 2021 I made my own and my husband is thrilled by it. This will make filling out our taxes a lot easier :)
Doing this for 2021!!! Thank you so much!!!
THANK YOU SO MUCH!! I have been looking for an easy way to keep myself on track!! This is super helpful!!
Thanks heaps! I have been looking for a proper way to assist me with my budget plan and this is exactly what I have been looking for.
Thank you Deborah, its 2024 and I just created this sheet.
For anyone that is getting the following "Error Message ("Argument Must be a range",)
Make sure that the name of the your Expenses form, the name on the sheet is Expenses..as that is that she uses in the formula.. I had changed mine and was getting the error message as form name didnt match the name in the forumla!
Hope this helps someone...
Thank you so much for generously sharing all of these. It's really helpful! :)
This is sooo awesome! I've been using Spreadsheets for years but always thought there should be a smarter way to use them. This has everything I was needing! Thank you so much!
Conteúdo gratuito e de qualidade, obrigada por disponibilizar. Irei utilizar para fazer meu controle de gastos pessoal, ganhou uma inscrita!!!! ❤ Brasil por aqui 🇧🇷
Thank you very much. God knows I needed this.
YOU ARE BRILLIANT! THANK YOU SO MUCH
Thanks Deborah I found this so valuable in Jan 2022
Watching this in 2023, might be late for the trend but appreciate your kind tutorial!
thankyou so much! This was a really well explained video, god bless!
This was exactly what I was looking for! Thank you so much
You are fantastic - so simple and useful. THANK YOU
This is so helpful. Thank you Debby
Thank you so much, I’ve needed something like this for a while now, you are an absolute life saver 💜💜💜
Thank you so much!! I really need this to keep track of my spendings and to stay organized.
Damn, I feel like an accountant 😎 Thank you, this is very useful!
Wow! Such amazing instruction! Thank you!
Thank you so much for this video. I cannot tell you how much it has already helped me
This is amazing! I definitely need to create one that also tracks debt payoff. Thanks so much for this
thank you so much for this video.
THANK YOU this video was so helpful.
You are awesome, thank you for sharing this amazing spreadsheet with us!
Very well explained. Thank you.
you are brilliant - thank you so much!!!!
this is literally a game changer thaanks a lot
this is such a great and valuable video series!
I....broke mine though by adding extra categories ;n; not sure what I did wrong yet but the sample numbers don't all input when I do the big fomulae
This was such a great tutorial. the way you helped me make this, I'm so grateful!! Thanks for doing this.
Thank you so much for sharing your knowledge
So much value out of this video. Thank you so much 💛
You're a lifesaver! Thankyou so much for teaching us how to do this
Waw...your one of the best ever 🎉
THIS IS BEAUTIFUL, THANK YOU SO MUCH
That was extremely informative and helpful for an excel noobie like myself. Thank you so much :-)
Where is the 10 star button? This is an awesome tool and a great tutorial; thanks, thanks and thanks!
I was literally updating your original spreadsheet to this. Ps you're amazing. 😍😍😍
I appreciate this so much i would love to learn more
Thank you so much for sharing your knowledge!
Omg thank you!!!! This is amazing!!!!!!!!!
Hi thank you so much for sharing i love this outlay - you make is so convenient for us! can you create a debt tracker snowball tracker pleasE?
Thank you so much! Soooo helpful.
Thank you! Super helpful!
Freakin' brilliant! Thank you!
I literally just finished costumising the other one just before this one
Thank you so much for this! Just set mine up for this year 😊
Hello. I don’t know if you believe in God but I want to tell you that God will continue to bless you, the best things in life will find you, you will never lack help, you’ll be provided for abundantly ijn amen. You are so kind and intelligent. Thank you for spending your precious time to teach us how to build it in a very simple, easy to follow way. You are blessed
Thanks so much for the help girl!! Bless!!!
Thank you, you are awesome. This is very helpful!
Awesome tutorial, and thanks for taking the time to break everything down to the simplest level for the viewers! Keep doing your thing!
This video deserves my like and subscribe 👍💯😍
thank you so much for this! i subscribed after watching this video
Well explained ! Thank you
Thanks you Deb !!
YOURE AN ANGEL
Thank you so so much, it helps me a lot!!
No wonder this went viral. Shit is amazing