No video :(

How to build your Expense Tracker from scratch! | Debbbag

Подписаться 8 тыс.

Просмотров 350 тыс.

50% 1

Today I'm going to teach you how to build this Expense + Income Tracker from scratch. It will show you the principles and formulas - so you can make the perfect tracker to suit your lifestyle :)
Timestamps:
0:39 Create a form for your expenses
3:48 Create a form for your income
6:17 Adding sample data: expenses + income
8:15 Change your title, country + timezone
8:58 Building your main dashboard
14:02 Building your income dashboard
15:04 Understanding the formulas
17:46 Adding the formulas to your main expense dashboard
18:38 Adding the formulas to your income dashboard
20:04 Adding income total to your main dashboard
20:52 Colour coding your expense list
22:17 Colour coding your income list
23:02 Setting a budget with conditional formatting
24:47 Finishing touches on the table
25:45 Making graphs for your expenses
29:09 Making graphs for your income
31:16 Adding old data to your new sheet
Download Expense Tracker 2.0 here: drive.google.com/drive/folder...
Download the Original Expense Tracker: deborahho.com/productivity/exp...
Customisation Tutorial: • How to Customise your ...
Watch my original Tiktok - where it all started:
www.tiktok.com/@debbbag/video...
Buy me a Kofi: ko-fi.com/debbbag
Website: deborahho.com/
Tiktok: / debbbag
Instagram: / debbbag
Twitter: / debbbag

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 544

@debbbag 3 года назад

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, "

@TheJoanaBorga 3 года назад

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 :)

@rachelkroger 3 года назад

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.

@carolinac.4829 3 года назад

Thank you millions!!!

@fatmarko742 3 года назад

Thank you this is awesome

@beckalund 3 года назад

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 ; "

@gabrielaugusto9107 3 года назад

You are the best person who has ever lived in this world

@sugengriyanto229 3 года назад

My mind when she tells the formulas = 🤯

@jorgemonzon7401 3 года назад

Hey! Thank you so much! i had something like this but i added everything manually, never thought about making a form! youre awesome!

@KuroAlis 3 года назад

Thank you so much, I’ve needed something like this for a while now, you are an absolute life saver 💜💜💜

@aprylchiem 3 года назад

Thank you so much!! I really need this to keep track of my spendings and to stay organized.

@loz8861 3 года назад

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!!!

@genesisalvarez648 3 года назад

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!

@de6klompjes108 3 года назад

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 :)

@thirstkirstreads9835 Год назад

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!!

@erinlindsey3 3 года назад

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!!

@silvanatoma7464 Год назад

This is fantastic!!! 2nd year in a row for me using it and I still get lots of value, thanks incredibly much Deborah!

@hlove1314 Год назад

I have now organized my entire life with this method this is insane how did I not this about this sooner. Thank you!

@laurabrizuela8853 3 года назад

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

@heysybil Год назад

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 :)

@HaydenJWeal Год назад

This video blew my mind. What a wonderfully cogently explained process. Amazing initiative. Thank you!!!

@periwinkle_loyalist16 3 года назад

Thank you so much for generously sharing all of these. It's really helpful! :)

@alfiesimbajon275 Год назад

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!

@thomasrimell8064 3 года назад

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 !

@riccardovarone9468 3 года назад

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.

@marcosmielnikowicz4560 3 года назад

Riccardo Varone thanks

@elinaihnatsiuk 3 года назад

thank you so much! perfect solution!

@litasousa77 3 года назад

Thank you very much !! Something so simple ;-)

@agneszeluna3579 3 года назад

I tried this one and the thing Deb suggested, still showing #N/A... :(

@afirstgenerationfarmer9791 3 года назад

It worked i just did not use Expenses i used Expense Your the man/ women of the year your amazing

@benlawrence9704 3 года назад

Thank you so much for this video. I cannot tell you how much it has already helped me

@belemsantillan826 2 года назад

LOVE THE WAY YOU EXPLAIN IT, VERY SIMPLE AND EASY TO UNDERSTAND. THANK

@irwingrungerson2776 3 года назад

Thank you so much for creating this video and for walking us through your process. Was unbelievable helpful! :)

@ColinLevy 3 года назад

This is fantastic. Thank you so much for the detailed breakdown!

@andrewmerz8580 3 года назад

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.

@anakateandrasko2403 Год назад

THANK YOU SO MUCH!! I have been looking for an easy way to keep myself on track!! This is super helpful!!

@anitaprudnikow2088 2 года назад

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.

@coreyr.3344 2 года назад

You're AWESOME! I can't wait to implement using this for my expenses and income.

@irish.franchesca 3 года назад

You're a lifesaver! Thankyou so much for teaching us how to do this

@EayshaScaife 2 года назад

This is amazing! I definitely need to create one that also tracks debt payoff. Thanks so much for this

@raghuraj-peakperformance2104 3 года назад

one of the amazing way to track expense, Thanks so much Deborah

@natva89 3 года назад

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!

@hannahleuterio 3 года назад

When i saw your tiktok i was going crazy about this one! Yaayyyy! I can finally make my own.

@isadorarios2832 Год назад

Conteúdo gratuito e de qualidade, obrigada por disponibilizar. Irei utilizar para fazer meu controle de gastos pessoal, ganhou uma inscrita!!!! ❤ Brasil por aqui 🇧🇷

@09abbiee 3 года назад

Thank you so much for this! Just set mine up for this year 😊

@whitneytyler6664 Год назад

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!

@gesireci 3 года назад

First! Thank you so much for your amazing work! I actually was inspired to create my own tracker with both expenses and incomes after downloading and really liking your expense tracker 1.0. Keep up the amazing work and I hope you create many more things that help people grow!

@debbbag 3 года назад

Amazing! Thanks so much - I made these tools so everyone can learn to make their own personalised ones, getting comments like these really make my day :)

@hilaryratnayake1046 3 года назад

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.

@joelynicol9736 2 года назад

Thank you for this amazing resource!!! I have used it for over 2 years :D

@yvonnevaruka5507 3 года назад

You are fantastic - so simple and useful. THANK YOU

@carlgrigson824 7 месяцев назад

This is fantastic teaching for an extreme novice. Thanks!

@alysanemoto5719 3 года назад

This was exactly what I was looking for! Thank you so much

@nikitaalekseyeva4533 3 года назад

So much value out of this video. Thank you so much 💛

@ainnaeyo 3 года назад

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

@lev9161 3 года назад

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?

@waneframe Год назад

Deborah Thank you!! You have made my life so much easier!!

@federicas3808 3 года назад

found this on tiktok! thank u so much!! this was really helpful 🌼🤩

@enjimrehim 3 года назад

took me 2 days to do it but I did !!! thank you so much I love it

@SantiYounger 3 года назад

You are awesome, thank you for sharing this amazing spreadsheet with us!

@nataliaospinamelendez6023 3 года назад

Thank you so much for sharing your knowledge!

@pcamacho722 Год назад

Thank You very much from Portugal!!! You are amaizing at this and make it sound so easy 🙂

@Oladipupo_ 3 года назад

This video is so detailed and easy to understand.Thanks so much for holding my hand through out the whole process, especially during the breakdown of the formula syntax 💀. Please what applications do you use to edit these videos, they look so good!

@ohmygodnat 3 года назад

That was extremely informative and helpful for an excel noobie like myself. Thank you so much :-)

@AP_EDUARDO 3 года назад

I was drawing something, then i opended tiktok and you know the rest, thanks for this!

@megasobe 3 года назад

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

@debbbag 3 года назад

Glad you found it helpful!!! 🥺❤️

@rebeccabee6615 2 года назад

Wow! Such amazing instruction! Thank you!

@akashpalanisamy5659 8 месяцев назад

Thank you for providing this for free in youtube !

@PaulinaRmrz 3 года назад

Doing this for 2021!!! Thank you so much!!!

@anophrinedesdeus6139 Год назад

This is so helpful. Thank you Debby

@mbadisheila 3 года назад

Thank you very much. God knows I needed this.

@vishaljain5019 Год назад

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.

@JillianShelton-uu3ku Месяц назад

This is amazing! Thank you so so much!

@Alex-vg8of 3 года назад

This is really neat! Thanks for this! Would love a version that has a list of all the accounts that I have.

@savannah_mar 3 года назад

Thanks so much for the help girl!! Bless!!!

@roshninagendra1264 Год назад

thankyou so much! This was a really well explained video, god bless!

@jesterfun123 3 года назад

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

@debbbag 3 года назад

So glad to hear it! :')

@covaconstruction9901 2 года назад

THIS IS BEAUTIFUL, THANK YOU SO MUCH

@mandylove987 3 года назад

I was literally updating your original spreadsheet to this. Ps you're amazing. 😍😍😍

@DuongPham-ou9qe 3 года назад

Thank you so so much, it helps me a lot!!

@daimaosensei_edits 3 года назад

Thank you, you are awesome. This is very helpful!

@marbeluzanndg 3 года назад

Thank you so much for this!

@lokeshv7575 Год назад

Thank you so much for sharing your knowledge

@arc.the.sharky 2 года назад

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

@rema262 Год назад

YOU ARE BRILLIANT! THANK YOU SO MUCH

@waleedosama1630 3 года назад

Well explained ! Thank you

@abigailfolgar5818 Год назад

Thank you so much! Soooo helpful.

@thomashart431 Год назад

Very well explained. Thank you.

@NehaJaju-ok7fw 3 месяца назад

thank you so much for this video.

@reginaphalange4055 3 года назад

thank you so much for this! i subscribed after watching this video

@laurensinreich9917 Год назад

Thank you! Super helpful!

@JoelManrique 3 года назад

awesome.. this video just made me subscribe :) thanks for knowledge and hardwork!😍

@bloomvisuals6587 Год назад

THANK YOU this video was so helpful.

@jeremy2967 Год назад

This helped a lot, thank you very much

@saiduzzamansalim7809 3 года назад

Thank you for soo much ! You're too good♥️

@treymendel 3 года назад

This is really cool, you’re awesome !

@ChristianBjork 3 года назад

This is... amaaaaaazing.

@asdfghjkllkjhgfdsa1022 Год назад

Omg thank you!!!! This is amazing!!!!!!!!!

@HaileyKwon-jb5qv 10 месяцев назад

you are brilliant - thank you so much!!!!

@ljiljankocurcic8893 3 года назад

Damn, I feel like an accountant 😎 Thank you, this is very useful!

@lolaloliepop 2 года назад

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

@feonnaadelhi 2 года назад

Thank You so nice video for helping us.

@papagary4185 5 месяцев назад

Thank you so much!

@robbiebore4712 2 года назад

excellent work!

@JohnGreen-sc8kj 2 года назад

Thanks Deborah I found this so valuable in Jan 2022

@azukar93 3 года назад

I fell in love with your tracker and I personalice it but it's a little bit bigger with income statements and balance sheet. I would love to share it with you and maybe make it better 🥳