How to build your Expense Tracker from scratch! | Debbbag

by SOUthkoreaquIZ



오늘은 처음부터 이 비용 + 소득 추적기를 만드는 방법을 알려 드리겠습니다. 원리와 공식을 보여주므로 라이프스타일에 맞는 완벽한 트래커를 만들 수 있습니다 🙂 타임스탬프: 0:39 지출 양식 만들기 3:48 수입 양식 만들기 6:17 샘플 데이터 추가: 지출 + 수입 8:15 제목, 국가 + 시간대 변경 8:58 메인 대시보드 만들기 14:02 수입 대시보드 만들기 15:04 공식 이해하기 17:46 메인 비용 대시보드에 공식 추가하기 18:38 공식 추가하기 수입 대시보드 20:04 메인 대시보드에 총 수입 추가 20:52 비용 목록 색상 코딩 22:17 수입 목록 색상 코딩 23:02 조건부 서식으로 예산 설정 24:47 테이블 마무리 25:45 만들기 지출에 대한 그래프 29:09 소득에 대한 그래프 만들기 31:16 새 시트에 이전 데이터 추가 여기에서 Expense Tracker 2.0 다운로드: Original Expense Tracker 다운로드: 사용자 지정 자습서: 내 원본 Tiktok 보기 – 모든 것이 시작된 곳: Buy me a Kofi: 웹사이트: Tiktok: Inst a 그램: 트위터:

Images related to the topic finance tracker

How to build your Expense Tracker from scratch! | Debbbag

How to build your Expense Tracker from scratch! | Debbbag

Search related to the topic How to build your Expense Tracker from scratch! | Debbbag

#build #Expense #Tracker #scratch #Debbbag
How to build your Expense Tracker from scratch! | Debbbag
finance tracker
여기에서 많은 유용한 정보를 볼 수 있습니다: 여기에서 더 보기
여기에서 많은 유용한 정보를 볼 수 있습니다: 여기에서 더 보기

You may also like

34 comments

Deborah Ho 15/12/2021 - 5:11 Chiều

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, "<"&(EOMONTH($A2, 0)+1), Expenses!$E$1:$E, "="&B$1)

INCOME (Put in B2 of your Income Dashboard)
=SUMIFS(Income!$D$1:$D, Income!$B$1:$B, ">="&$A2, Income!$B$1:$B, "<"&(EOMONTH($A2, 0)+1), Income!$C$1:$C, "="&B$1)

NOTE: The reason why you might be coming up with an error is because this formula works ONLY for countries with English as it's main language (Australia, United States, UK etc). I would recommend you do it exactly as I have done it here (putting Australia as your country) THEN after you've put in the formulas, switching over your country + currency.

Unfortunately I can't help create formulas for every language because I don't know them T_T

Reply
suvn 15/12/2021 - 5:11 Chiều

So do you sit down once a month to fill everything out? Are you submitting expenses through the form every day, week, or as soon as you make purchases?

Reply
suvn 15/12/2021 - 5:11 Chiều

Watching all these "How to track your expenses" videos on youtube made me realize… am I the only one with 1 "Workplace" income? All these other trackers I see always have at least 2 workplaces.

Reply
Mao Kue 15/12/2021 - 5:11 Chiều

Thanks a lot for sharing these tips with us. Now, I can track my crypto investments and the gas fees as well as the NFT sales. Much love from Morocco.

Reply
Danielle Miller 15/12/2021 - 5:11 Chiều

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

Reply
Michelle ODonoghue 15/12/2021 - 5:11 Chiều

I Litterally followed excatally step by step AGAIN and my income formual is coming up as 0 can anyone help#

Reply
Michelle ODonoghue 15/12/2021 - 5:11 Chiều

i only have one source of income so my formula isnt working is there anyone that can help me for the income dashboard

Reply
Tasha Losange 15/12/2021 - 5:11 Chiều

Woooww is there one for small businesses?

Reply
Lili 15/12/2021 - 5:11 Chiều

Hi i have 2 checking accounts how can i track their incomes and expenses separately?

Reply
Premsons Jewellers 15/12/2021 - 5:11 Chiều

Hello, what exactly are those categories? I do not have such categories for my data, so how would I put the formula then?

Reply
Kimberly A 15/12/2021 - 5:11 Chiều

You are opening my mind to a brand new world of financial tracking. It's such a big deal for someone as unorganized as me. Thank you!

Reply
Chelsi Chavez 15/12/2021 - 5:11 Chiều

Love this video! I followed along with the video as I created my own. My only problem is that I'm not sure how to customizing the labels of my sheets (category 1,2,3 etc.,) without restarting altogether.

Reply
COVa CONstruction 15/12/2021 - 5:11 Chiều

THIS IS BEAUTIFUL, THANK YOU SO MUCH

Reply
Mariela Sosa 15/12/2021 - 5:11 Chiều

Could you please do a Savings Tracker? Pleeeeease 👏👏👏

Reply
Krafty Korner by Trish 15/12/2021 - 5:11 Chiều

hi, firstly thank you for this video. However, why doesn't the Main dashboard reflect information with any date after July of any year? I can input january to july 31but nothing after this date is reelcted…. some insight is appreciated

Reply
Andrea Taylor 15/12/2021 - 5:11 Chiều

YOURE AN ANGEL

Reply
Jim Pat 15/12/2021 - 5:11 Chiều

What if you add an expense by mistake? Do you just go back to the expense tab and delete the row?

Reply
Hazel Nishitha 15/12/2021 - 5:11 Chiều

Can someone kindly help me with a question,
After using the sheet if I need to add more categories in the future will it affect the sheets or the previous data in any way? Or if after a few months I need to add an extra question then would it affect the previous data on the sheet or obstruct the formula?

Reply
Robbie Bore 15/12/2021 - 5:11 Chiều

excellent work!

Reply
Techy Friends 15/12/2021 - 5:11 Chiều

Is there a way for the dates to change. For example I want October in my expenses to be October 20-November 19

Reply
Peace.n.Blessings 15/12/2021 - 5:11 Chiều

You are Freaking AMAZING

Reply
Seyla Brown 15/12/2021 - 5:11 Chiều

mine is showing #REF!… please someone help aaahhhhh

Reply
Belem Santillan 15/12/2021 - 5:11 Chiều

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

Reply
Vickey Heisler 15/12/2021 - 5:11 Chiều

Do you have one for a tablet?.

Reply
Anita Prudnikow 15/12/2021 - 5:11 Chiều

32:24 That was a cheep cake 🙂

Reply
Anita Prudnikow 15/12/2021 - 5:11 Chiều

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.

Reply
Laura Brizuela 15/12/2021 - 5:11 Chiều

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

Reply
Irwin Grungerson 15/12/2021 - 5:11 Chiều

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

Reply
Ain Nasuha 15/12/2021 - 5:11 Chiều

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

Reply
Patricia Condino 15/12/2021 - 5:11 Chiều

I have been using your income and expense tracker for a few months now and I love it. I did come across an issue. Since I backtracked my expenses and income and in order to save time, I just manually typed in everything instead of using the forms and now when I now enter responses in the form, it places the response in the middle of the excel spreadsheet (where the responses would be placed if i did not manually type all the data). Is there a way I can fix this? I also want to add a savings forms and savings dash board and add it in a the monthly overview. So that the excel is more transparent rather than just having a gross savings section. Would you be able to help me with out with these issues? Thank you so much

Reply
Thomas Rimell 15/12/2021 - 5:11 Chiều

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 !

Reply
Alysa Nemoto 15/12/2021 - 5:11 Chiều

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

Reply
Alesandro Alberto 15/12/2021 - 5:11 Chiều

a too good to be true tutorial

Reply
Maximiliano 15/12/2021 - 5:11 Chiều

For some reason in my main dashboard it will not add the $80 in Category 2 even after I add the formula. Everything else seems correct. I checked the formula twice and it's correct. I also checked the expenses tab and it has 80 in the D column so I'm not sure what I did wrong but I can't seem to fix it. Ahhhh it took me forever to finish it and it's still wrong!!! PLEASE HELP!!

Reply

Leave a Comment