Creating A Powerful Finance Tracker with Formula 2.0 (Full Step by Step Tutorial)

  Рет қаралды 69,678

Rosidssoy

Rosidssoy

Күн бұрын

Пікірлер: 180
@rosidssoy
@rosidssoy 10 ай бұрын
Hi everyone, thanks for watching my video! if you have difficulty to add emoji, you can press "Win" +"." (for windows user).
@beleniumoxide
@beleniumoxide 7 ай бұрын
Thank you so much!! For those of us who are making our first budget ever... Do you have any sort of tutorial on how to use your template? It is incredible, but I am also having trouble figuring out how to record transfers out of my account to external accounts vs internal accounts, and also, not entirely sure how to categorize a credit card payment.. Is there any help you could offer?
@verifiedawesome1366
@verifiedawesome1366 8 ай бұрын
Hi Rosidssoy... This is tremendous and very useful. I wanted to share that under the Database/Subscriptions Monthly Cost Formula, you made an error with the "Quarterly" math; it should be /3 not /4 (i.e., 3 months in a quarter). Here's the formula I used (and added Daily and Semi Yearly): if(prop("Status") == "Inactive",0, if(prop("Billing") == "Yearly",prop("Amount")/12, if(prop("Billing") == "Semi Yearly",prop("Amount")/6, if(prop("Billing") == "Quarterly",prop("Amount")/3, if(prop("Billing") == "Daily",prop("Amount")*30,prop("Amount"))))))
@eclipsenow5431
@eclipsenow5431 7 ай бұрын
Is this in formula 1.0 or 2.0? I'm no coder - and am lost why this isn't being accepted. if(prop("Expense this Month")/prop("Monthly Budget")1, "Used " + format(round((prop("Expense this Month") /prop("Monthly Budget"))*10000/100) + "%,"+ style(" Overbudget ⚠","b","i","red"),style("Not Budgeted","b","i")))
@CelesteParas
@CelesteParas 7 ай бұрын
did it work on you?@@eclipsenow5431
@Glacefenrir
@Glacefenrir 7 ай бұрын
@@eclipsenow5431 Here's the new code: if(prop("Expense this Month")/ prop("Monthly Budget") 1, "Used " + format(round(prop("Expense this Month") / prop("Monthly Budget") * 100)) + "%, " + style("Overbudget", "b", "i", "red"), style("Not Budgeted", "b", "i") ) )
@analuciasancheztron9514
@analuciasancheztron9514 Ай бұрын
Hi, I'm trying to add a formula for weekly cost, but my formula isn't working, can anyone help? Thks
@lennycloudz2cloudz233
@lennycloudz2cloudz233 28 күн бұрын
this one is good
@MarioValenteNZ
@MarioValenteNZ 6 ай бұрын
Here is the long formula: if(prop("Expense this Month") /prop("Monthly Budget")1, "Used " + format(round((prop("Expense this Month") /prop("Monthly Budget"))*10000)/100) + "%,"+ style(" Overbudget ⚠","b","i","red"),style("Not Budgeted","b","i")))
@SweetDreem-v4v
@SweetDreem-v4v 6 ай бұрын
thanks a lot man
@VictorFreddi
@VictorFreddi 4 ай бұрын
if(prop("Expense this Month") /prop("Monthly Budget")1, style("Used " + format(round(((prop("Expense this Month") /prop("Monthly Budget"))*10000)/100)),"b","i") + "%,"+ style(" Overbudget ","b","i","red"),style("Not Budgeted","b","i")))
@bharathgurram7947
@bharathgurram7947 2 ай бұрын
Thank you
@orum7761
@orum7761 Ай бұрын
Thanks man
@ΚωσταςΛουρακης-μ3κ
@ΚωσταςΛουρακης-μ3κ 19 күн бұрын
@jesperhvid8299
@jesperhvid8299 6 ай бұрын
at 31:22 there is a formula input in the Income type &Target database for the "Mo. Target Status. I cannot get that to work ? My input is this: if(prop("Income this Month")/prop("Monthly Target")
@4h00am
@4h00am 6 ай бұрын
this will help you: if(prop("Income this Month")/prop("Monthly Target")=1, format(round((prop("Income this Month")/prop("Monthly Target"))*10000)/100) + "%"+ style("On Target ","b","green"),style("Not Targeted","b")))
@jesperhvid8299
@jesperhvid8299 6 ай бұрын
@@4h00am Brilliant - Thanks alot for your help
@VishalPatel-yu9yc
@VishalPatel-yu9yc 6 ай бұрын
Thank you soo much @@4h00am
@yvesbismor
@yvesbismor 2 ай бұрын
@@4h00am Still doesn't work :(
@ctnahda
@ctnahda 7 ай бұрын
It would be very generous of you if you could paste all the formulas to this youtube description 😅
@leonardosteiner9581
@leonardosteiner9581 2 ай бұрын
Great video. How can i change currency?
@ganesh6132
@ganesh6132 Күн бұрын
Hi @rosidssoy, Is there a way to segregate the monthly and yearly income type, account and expense type separately as my previous month data is not getting reset and is overlapping with this month data.
@albagomez1875
@albagomez1875 7 ай бұрын
Hi, does anyone know how to view the % of the budget used in previous months? It only shows the percentage and expense of the current month and I would like to check how much I sticked to the budget on other months as well... Thanks for the help!
@XxTownGamersxX
@XxTownGamersxX 9 ай бұрын
Great tutorial, especially for beginners to learn concepts and databases. I would also like to point out an issue that is luckily easy to fix. Let say for example at this timestamp 31:25 you have formula for "Mo. Target Status" where you divide "Income This Month" / "Monthly Target"... In Monthly target you have Bonus that is equal to 0, and some really basic math says that dividing by zero is impossible, therefore, the formula won't work as expected... What should be done is correcting formula with another "if" as error handling, to check if Monthly Target is equal to 0. If it is, check if Income this month is larger than 0 or not, and print the right text for both cases, and if Monthly Target is not equal to 0, only then, apply the formula you already provided. This is some basic error handling, hope it helps... (EDIT: Provided formulas in reply to this comment)
@XxTownGamersxX
@XxTownGamersxX 9 ай бұрын
In this comment, I am going to provide fixed formulas for "Expense Type & Budget" table - "Monthly Utilization" field, and also fixed formula for, "Income Type & Target" table - "Mo. Income Target Status" field. NOTE TO EVERYONE: For the love of God, please verify that your database column names match the column names in my formulas, and also, in my examples I used "$" as a currency inside my formulas, just make sure to change it or remove it as needed!!!!!! [1] "Expense Type & Budget" table - "Monthly Utilization" field FORMULA: if(prop("Monthly Budget")==0, if(prop("Expenses This Month")>0, prop("Expenses This Month")+"$"+style(" Overbudget","b","i","red"), style("Not Budgeted","b","i")), if(divide(prop("Expenses This Month"),prop("Monthly Budget"))1,format(round(divide(prop("Expenses This Month"),prop("Monthly Budget"))*10000/100))+"%"+style(" Overbudget","b","i","red"),style("Not Budgeted","b","i")))) [2] "Income Type & Target" table - "Mo. Income Target Status" field FORMULA: if(prop("Monthly Target")==0, if(prop("Income This Month")>0, prop("Income This Month")+"$"+style(" Above Target","b","green"), style("Not Targeted", "b")), if(divide(prop("Income This Month"),prop("Monthly Target"))=1,format(round(divide(prop("Income This Month"),prop("Monthly Target"))*10000/100))+"%"+style(" On Target","b","green"),style("Not Targeted", "b")))) I hope this helps! Have fun and keep on learning Notion!
@LauraGutiérrezArias
@LauraGutiérrezArias 9 ай бұрын
Thank you! Solved my error
@XxTownGamersxX
@XxTownGamersxX 9 ай бұрын
@@LauraGutiérrezArias I am glad that I was able to help!
@alexysjones4011
@alexysjones4011 7 ай бұрын
Not sure if you're familiar with this or not, but at 30:52 when selecting how to calculate the Rollup property, SUM is not an option, have you come across this before? @@XxTownGamersxX
@grimm8717
@grimm8717 8 ай бұрын
Yet another fantastic template; I will not stop repeating that you are creating such wonderful templates for free. This is unfair that you don't have tons of subscribers by now. Thank you so much for this one; thanks to your tutorials, I started understanding Notion much better. You're my favorite KZbinr on Notion - keep it up! :)
@miguelnavarromusica
@miguelnavarromusica 8 ай бұрын
How would you manage accounts and expenses in different currencies? Thanks for the amazing video and template!
@josephcienfuegos5016
@josephcienfuegos5016 Ай бұрын
Hey Man!! Thanks for the video, I was very lost for half of the time 😅, but as the video went on I started kind of getting it, I haven’t finished yet, but I’m loving the results 🤩🤩🤩. And if any of you have trouble with the formula for the target status mention on minute 31:09, well then, here is a slightly changed of that formula that also bolds and colors the percentages: if(prop("Income this Month")/prop("Monthly Target")=1, style(format(round(prop("Income this Month")/prop("Monthly Target")*10000/100) + "% On Target"),"b","green"),style("Not Targetted","b")))
@aaronslusher9531
@aaronslusher9531 10 ай бұрын
I cannot get the formulas to work. I keep getting errors, do you have a video where you slowly go through how to enter formulas? I'm stuck at the Subscriptions portion, approximately 18:33 into the video. Thanks in advance!
@isla3559
@isla3559 9 ай бұрын
Same here! It shows that O is not defined. [19,20]
@tomwilson204
@tomwilson204 9 ай бұрын
Thank you so much. I have learned a lot of things since I started following your channel. I have tried both versions you provided, and they are well-structured and clear. However, I noticed a small issue: the Subscriptions Database doesn't link to any database, which means that I have to add the subscription every time the due date comes manually. What do you think about linking the Expense Record, Expense Type, and Subscription together and using the Repeat function of the template?
@rosidssoy
@rosidssoy 9 ай бұрын
Hi thanks for watching video and really glad to hear that it helps.. Yes. The subscription database is standalone and has no relation with other database. You need to add manually to the expense database each time you pay the subscription. Or you can set up automatic recurring payment. Perhaps you can check my Wealth OS walktrough minute 20:57
@iridessabumblebee3168
@iridessabumblebee3168 8 ай бұрын
29:12 Correct Formula is: if(prop("Expense This Month")/prop("Monthly Budget")1,"Used "+format(round(prop("Expense This Month")/prop("Monthly Budget"))*10000/100)+"%,"+style("Overbudget ⚠️","b","i","red"),style("Not Budgeted","b","i"))) Just Copy & Paste. There is a very small error in the formula provided, which is why many of you hate having issues with it. Enjoy!
@jess_altorres
@jess_altorres 8 ай бұрын
Life saver, Thank you!!!
@Shibuyaboys
@Shibuyaboys 8 ай бұрын
thanks a lot!
@cloudblinky6189
@cloudblinky6189 8 ай бұрын
thanks a lot! :)
@asdrandomail
@asdrandomail 7 ай бұрын
you are the best!
@Scramblednation
@Scramblednation 7 ай бұрын
thank you so much
@claude13
@claude13 4 күн бұрын
Only thing i want to know is how to see the Expense type and budgeting for each month/past months cus it only shows current month
@kalogerus
@kalogerus 8 ай бұрын
currently sitting at 23:36, and i just had to stop and say you are a LEGEND for making this video, this was exactly what i was looking for in a finance tracker. sure i had to pause and rewind many times going through the video, but even then you still took the time to add in a short pause to make my life just a little easier. you sir, are a gentlemen and a scholar. the attention to detail in this video is spectacular. keep it up! SUBBED
@kalogerus
@kalogerus 8 ай бұрын
i recommend having a copy pasta available for formulas :D
@PaskalisDamar
@PaskalisDamar 7 ай бұрын
I've been using this template and it's amazing. But I have one question. I wonder if we can sum up expenses between two dates. Here's the context, I have a peculiar period of expense (e.g., between the 28th day of a month till the same date next month). Can anyone advise the best formula to do so? Thanks a lot
@hiddenhen
@hiddenhen Ай бұрын
Can this template automate the importing of data via a financial data transfer like Plaid?
@Mustafa-oz3mz
@Mustafa-oz3mz 4 ай бұрын
Hi thank you for that amazing template, I have only one question. How can I make te expense return every month so I don't have to write it every month again.
@becksjan
@becksjan Ай бұрын
Stuck on 40:00 coz my navigation doesn't have a link option
@atiajanssens5654
@atiajanssens5654 3 ай бұрын
this was great. sometimes it was a bit too quick but I just paused the video. I'll use it and see if it suits me, but it's already a huge improvement ot what it was before Thanks!
@gabrielmixtli3623
@gabrielmixtli3623 2 ай бұрын
Hello guys For the formula on 29:12 Its better if you follow the formula on the notion page and not the one that is provided on the screen. That worked for me
@malius1841
@malius1841 8 ай бұрын
Can we also track for the money that we paid by credit card for others and they need to pay me back later? Sometimes I need to track 1. How much to get money from each person (sometimes it’s netflix home subscriptions or when we pay in advance time to time) 2. To see real balance of credit card that I need to pay to the bank each month
@drecordsmx8353
@drecordsmx8353 6 ай бұрын
Hi first of all wonderful template ! thanks a lot , just wanted to ask something; Ive added all my recurring payments in the subscription database but I dont see nothing reflected or synced with the gallery view of budget under (this mo expense) ? .. how can I keep track of that ? ... greetings
@hectorobtavio
@hectorobtavio 6 ай бұрын
Same here. Did you happen to figure it out?
@navaneethk5099
@navaneethk5099 4 ай бұрын
first just change the source to bills and subscription. and watch the video to change some property and layout in it. just a simple step
@navaneethk5099
@navaneethk5099 4 ай бұрын
@@hectorobtavio first just change the source to bills and subscription. and watch the video to change some property and layout in it. just a simple step
@annyatamghosh9198
@annyatamghosh9198 9 ай бұрын
Ok wait! Why are you giving them free? 😱 I'm saying this as you are doing an incredible job here. Can't believe its real.😅
@rosidssoy
@rosidssoy 9 ай бұрын
Haha.. it's real 🤣 Actually there is a pro version if people want to get more useful features..
@annyatamghosh9198
@annyatamghosh9198 9 ай бұрын
@@rosidssoy well i don't think they would need anymore ! Great Work🤩
@rohiththalla
@rohiththalla 8 ай бұрын
Can you create a updated video with option to add credit card too, That would be the ultimate finance tracker
@praveenm1591
@praveenm1591 6 ай бұрын
Yes please
@SAPExpertsGroup
@SAPExpertsGroup 8 ай бұрын
Excellent, I must say... Just a suggestion that there should be a mechanism to manage Receivable and Payable as Well
@sharonliu47
@sharonliu47 9 ай бұрын
The Formula for "Mo. Target Status" under "Income Type & Target" and "Monthly Utilization" under "Expense Type & Budget" doesn't work, anyone has solution on how to fix it? error message said "Function if expects 3 arguments, but only 1 were provided. [0,8] End of input expected. [220,221]
@donettefeliciano6073
@donettefeliciano6073 9 ай бұрын
After rewatching several times, I noticed that at 28:29 he moves one of the options in the rollup to "SUM". You will see it next to Calculate.
@luzcordova9853
@luzcordova9853 9 ай бұрын
if(prop("Gastos de este mes")/prop("Presupuesto Mensual")1, "Used" + format(round((prop("Gastos de este mes")/prop("Presupuesto Mensual"))*10000)/100) + "%," + style(" Overbudget", "b", "i", "red"), style("Not Budgeted", "b", "i")))
@wuwu-ash
@wuwu-ash 10 ай бұрын
Thank you so much, I love this tutorial! I'm wondering how to automatically integrate subscriptions into expenses. Is there a way to do this for payments, for example, that are regularly debited from the account?
@catwarrior2083
@catwarrior2083 9 ай бұрын
Was wondering the same, hopefully we'll get an answer. Amazing tutorial though 😊
@younesmedia
@younesmedia 8 ай бұрын
Same here
@ClaraPérezMartínez-s9u
@ClaraPérezMartínez-s9u 15 күн бұрын
Hi, the formula in 24:28 for the expenses this month doesn't work :( it says that the prep if need 3 arguments and i only typed 1, is there anyone that can help me please?
@cat0181
@cat0181 Күн бұрын
I got the same problem!
@RebeccasRoberts
@RebeccasRoberts 6 ай бұрын
I downloaded the template, but can’t seem to add anything to the subscription database. There’s no “new” button anywhere. It’s almost like it’s not a database anymore. The new menu in the top right corner has disappeared as well. I’ve tried to troubleshoot but can’t come up with any solutions. Anyone have any insight? Thanks!
@rosidssoy
@rosidssoy 6 ай бұрын
Hey,thanks. Let me check the template.
@navaneethk5099
@navaneethk5099 4 ай бұрын
first just change the source to bills and subscription. and watch the video to change some property and layout in it. just a simple step
@An7mehub
@An7mehub 5 ай бұрын
I'm not able to add anything in subscription? It doesn't show the new button or option?
@navaneethk5099
@navaneethk5099 4 ай бұрын
first just change the source to bills and subscription. and watch the video to change some property and layout in it. just a simple step
@ChristianLomasang
@ChristianLomasang 5 ай бұрын
Hi! Great template and tutorial. I'm just wondering how can I create separate expense budget for each month? In that way, I can study and compare it. Thank you!
@4h00am
@4h00am 6 ай бұрын
29:12 Correct Formula is: if(prop("Expense This Month")/prop("Monthly Budget")1,"Used "+format(round(prop("Expense This Month")/prop("Monthly Budget"))*10000/100)+"%,"+style("Overbudget ⚠","b","i","red"),style("Not Budgeted","b","i"))) Just Copy & Paste. There is a very small error in the formula provided, which is why many of you hate having issues with it. Enjoy!
@TheEndlessKnowledge
@TheEndlessKnowledge 5 ай бұрын
Thank you so much 👍🏻
@fraserlee_film
@fraserlee_film 5 ай бұрын
"Function if expects 3 arguments, but only 1 were provided. [0,10] Expense is not defined. [3,10] Expected token ")". [11,12]" 😟
@RachelSockwell
@RachelSockwell 2 ай бұрын
@@fraserlee_film I found this reply above to another comment and this fixed my issue... @donettefeliciano6073 6 months ago After rewatching several times, I noticed that at 28:29 he moves one of the options in the rollup to "SUM". You will see it next to Calculate.
@zay6296
@zay6296 10 ай бұрын
Will there be a updated link of this template for the people who have already bought it in gumroad?
@ellie1808
@ellie1808 24 күн бұрын
Thank you so much for the video and for the template! I tried doing it from scratch to see if I can learn something and it was extremely easy to follow. I have a question tho, if I wanted to have a section that shows a summary of each month and year, how would I achieve that?
@PrabhakarPandey-k1z
@PrabhakarPandey-k1z 3 ай бұрын
Hello, can anyone help me? In the monthly Budget section. for the first month I created this system It worked. For the next month also It adds the expenses in the previous month's Budgets. Please help.
@josephwillott3011
@josephwillott3011 10 ай бұрын
how do i change the currency? i have managed to o it on the accounts as they are coming up as a template but the rest i dont see where i can do it.
@miguelnavarromusica
@miguelnavarromusica 8 ай бұрын
same question here!
@amandatanady376
@amandatanady376 10 ай бұрын
Hi, thank you so much for the in depth tutorial! I have a quick question - how do you get the date field to autopopulate the current date (see timestamp 56:54) in the pages under the quick button section? When I tested mine, I had to input the date manually. Thanks!!
@rosidssoy
@rosidssoy 10 ай бұрын
Hi, it is because on the quick button setting, the date property is set to be "today". So when you click the quick button, the date will be auto populated to current date
@rosam.7958
@rosam.7958 7 ай бұрын
Thank you for teaching us in such detail! Now, would it be possible to see the total spent in each month? Not just the total, but by category too. For example, in January, X amount was spent on doctors, in February Y amount, etc. Thank you in advance.
@eclipsenow5431
@eclipsenow5431 7 ай бұрын
28:00 Oh no! On saving for goals: what if I want to actually transfer money from my savings to my mortgage (as an offset against my mortgage) and use that as a safer place to store all my SINKING FUNDS FOR GOALS - AND I want to see how much I have stored there allocated to my different goals? Can I put 2 accounts in AND the FUND TO GOALS? Or will that do double counting in some unexpected way somewhere else?
@СандраАллен
@СандраАллен 4 ай бұрын
Tell me what to do if, for example, I want to transfer money from goals to a card? It's the same as you show in the video, only in reverse.
@ikeramado6413
@ikeramado6413 9 ай бұрын
I'm following the Notion tutorial step by step, but in the formula at minute 29:07, when I copy it exactly, I get an error: 'Cannot perform mathematical operations on array and number.' I've also tried copying and pasting directly from the template without success. Can you help me troubleshoot this issue?
@kcmacasling7177
@kcmacasling7177 9 ай бұрын
Same question, I checked thoroughly maybe its just a typing error but wahhh its exactly the same yet I can't proceed.
@donettefeliciano6073
@donettefeliciano6073 9 ай бұрын
After rewatching several times, I noticed that at 28:29 he moves one of the options in the rollup to "SUM". You will see it next to Calculate.
@izadoramayeretongue3829
@izadoramayeretongue3829 9 ай бұрын
Try to copy this let( expenseRatio, prop("Expense this Month") / prop("Monthly Budget"), let( formattedExpense, format(round(expenseRatio * 100)) + "% Used", if( expenseRatio 1, style(formattedExpense + " over budget", "b", "i", "red"), style("Not Budgeted", "b", "i", "") ) ) ) )
@LauraGutiérrezArias
@LauraGutiérrezArias 9 ай бұрын
@@donettefeliciano6073thank you! I’ve been troubleshooting for hours and this was it.
@cc_faith
@cc_faith 9 ай бұрын
Try this, the formula is different but it worked for me. With this formula if your monthly budget for an expense type is 0 or blank then nothing will appear in that certain tab under monthly utilization. if(prop(“Expense This Month”)prop(“Monthly Budget”), "Used " +round(1000*prop(“Expense This Month”)/prop(“Monthly Budget”))/10+"% " +style("Over Budget ✕ ","b","i","red"), if(prop(“Monthly Budget”)==0, "Blank")))
@anyasker7055
@anyasker7055 2 ай бұрын
Very detailed and informative tutorial. Thank you very much for your contribution here. I have so much fun doing along your video.
@jerryjohn1995
@jerryjohn1995 8 ай бұрын
I still wonder why he does 1000/100 instead just multiplying by 100 at 29.00
@zeymoha
@zeymoha 10 ай бұрын
Thank you so much! This is super helpful!
@rosidssoy
@rosidssoy 10 ай бұрын
you're welcome, happy to share :)
@navaneethk5099
@navaneethk5099 4 ай бұрын
For those who having problem with bills and subscription. first just change the source to bills and subscription. and watch the video to change some property and layout in it. just a simple step
@OptiMind2816
@OptiMind2816 3 ай бұрын
can you make a video using iphone shortcut adding income expense and transfer
@VampireRhino
@VampireRhino 10 ай бұрын
Hi, if I bought from you finance tracker pro version 1.2 then what is this? Is it upgrade to 2.0 or free notion template for everyone? :)
@rosidssoy
@rosidssoy 10 ай бұрын
Hi, this tutorial is for free, 2.0 meaning it is using notion new formula 2.0. I made this updated tutorial because many people comment on the old finance tracker tutorial that they have difficulty to input the formula due to the notion formula updates. If you have already purchased the finance tracker pro, the latest pro version is still V1.2 :)
@VampireRhino
@VampireRhino 10 ай бұрын
@@rosidssoy thank you for reply. I find the title of this template misleading a little bit for those who paid for Finance Tracker 1.2
@sahankaya1
@sahankaya1 5 ай бұрын
Hey, i have a question. if i want to purchase second brain pro, is this finance tracker goes to there as well?
@bossdasiah
@bossdasiah 8 ай бұрын
Hey when I go to the pages under navigation I’m not able to click navigation again to return back to the dashboard! Any reason why? 😊
@discodipje5405
@discodipje5405 8 ай бұрын
Just wanted to let you know there is a spelling mistake in the Thumbnail! It says Fianance.. Otherwise great tutorial thanks a lot!
@hmmourning
@hmmourning 8 ай бұрын
Still missing debt tracking *sighing* why is it always excluded from templates like it is not a huge part of most peoples life
@harshgohil2032
@harshgohil2032 3 ай бұрын
My formula for subscriptions is not working 18:34
@ItsCramzy
@ItsCramzy 8 ай бұрын
Hello, I added a new Account and the put a expense record on the account but it is not subtracting from the account. thank you
@sim9955
@sim9955 10 ай бұрын
nicely done! thank you! ...wish it wasn't ai voiceover though.
@rosidssoy
@rosidssoy 10 ай бұрын
Hi yeah, still not confident to use my own voice :D But let see in the future, if this channel grows, I will consider to put more extra effort to use real voice 😁
@王婧彤-p9t
@王婧彤-p9t 3 ай бұрын
lol it is hard to understand British, but I should used it.
@KUNAGINSI
@KUNAGINSI 7 ай бұрын
I really love this template and i followed the steps. However is there a way i can add my transaction costs when calculating expenses and transferring money between accounts.
@leonlee82
@leonlee82 7 ай бұрын
waiting for notion team new release database password because finance in ntion is sensitive.
@aesthetic15912
@aesthetic15912 9 ай бұрын
Can you paste the formula used at 18:30 I'm not able to type it properly
@rosidssoy
@rosidssoy 9 ай бұрын
Hi you can actually downlpas the template for free from the link on the description. Then you can check the formula..
@raulminan
@raulminan 9 ай бұрын
@@rosidssoy Hi! The function in the template isn't working either, maybe Notion changed something that broke it?
@marianadelgadomojica2680
@marianadelgadomojica2680 8 ай бұрын
@@rosidssoy no wayy. I just did it by myself and then i came to the comments and found this !!! hahahahaha
@marianadelgadomojica2680
@marianadelgadomojica2680 8 ай бұрын
Thank youu btw@@rosidssoy
@flaviusciurezu6401
@flaviusciurezu6401 7 ай бұрын
How we can merge this tracker with the second brain dashboard ?
@glowinthelens
@glowinthelens 2 ай бұрын
I want to make a database for debts, how can I do that?
@mms3489
@mms3489 6 ай бұрын
Is there a way to track suppliers and client ?
@zhaozhe92
@zhaozhe92 9 ай бұрын
I am benefit a lot from your Notion dashboards. Every One of them! So creative and practical. Thank you so much for your sharing! While I am setting up my own Financial Tracker. I would like to add some more features for credit card. For example, my credit card period is from last month 15th, to this month 14th. So that if i have some expense record on 15th onward this month, I want to count this amount of money to next month expense. I have a problem of convert the string dates to a true date. So that i can compare my credit card payment period start date and end date with my expense date. Do you have any good idea to do that?
@DSGQR
@DSGQR 10 ай бұрын
Thank you for this video. I would love it if you did a video explaining the logic of formulas because 😵‍💫😵‍💫😵‍💫 hahaha
@ChasePearsonsChannel
@ChasePearsonsChannel 2 ай бұрын
31:34 the following formula will work. Make sure to adjust the words in your database as needed. if( toNumber(prop("Monthly Target")) == 0, style("Not Targeted", "b"), if( toNumber(sum(prop("Income This Month"))) / toNumber(prop("Monthly Target")) < 1, format( round((toNumber(sum(prop("Income This Month"))) / toNumber(prop("Monthly Target"))) * 100) + "%" ) + " " + style("Below Target", "b", "red"), format( round((toNumber(sum(prop("Income This Month"))) / toNumber(prop("Monthly Target"))) * 100) + "%" ) + " " + style("On Target", "b", "green") ) )
@mustafamustafaev5392
@mustafamustafaev5392 8 ай бұрын
You are the best😊
@王婧彤-p9t
@王婧彤-p9t 3 ай бұрын
Your video is really helpful ❤❤❤
@ahmad.younes97
@ahmad.younes97 3 ай бұрын
Love it! Thanks a lot man
@cc_faith
@cc_faith 9 ай бұрын
Thank you for sharing this tutorial! I’ve learned so much. ☺️
@belvinorange
@belvinorange 8 ай бұрын
Thank you so much, you already have the best templates❤️
@kajetankistela6020
@kajetankistela6020 9 ай бұрын
Wow! I'm so glad that I find this video. That 's amazing and very helpful. Thank you so much!
@humnaabbasi6422
@humnaabbasi6422 8 ай бұрын
Too easy to understand you're super cool appreciate 👍🏻
@kcmacasling7177
@kcmacasling7177 9 ай бұрын
Hi, thank you for this tutorial but I have 1 question, why does notion keep showing "cannot do math on array and number" whenever I'm typing the formula of 'Monthly Utilization. I've been stuck there for 2 hours yet I can't find what is the problem with the formula . kzbin.info/www/bejne/aJmsnneEnLyjgJY
@donettefeliciano6073
@donettefeliciano6073 9 ай бұрын
After rewatching several times, I noticed that at 28:29 he moves one of the options in the rollup to "SUM". You will see it next to Calculate.
@izadoramayeretongue3829
@izadoramayeretongue3829 9 ай бұрын
Copy This let( expenseRatio, prop("Expense this Month") / prop("Monthly Budget"), let( formattedExpense, format(round(expenseRatio * 100)) + "% Used", if( expenseRatio 1, style(formattedExpense + " over budget", "b", "i", "red"), style("Not Budgeted", "b", "i", "") ) ) ) )
@cc_faith
@cc_faith 9 ай бұрын
Same, it took me a while to figure out 😭. Try this, the formula is different but it worked for me. With this formula if your monthly budget for an expense type is 0 or blank then nothing will appear in that certain tab under monthly utilization. if(prop(“Expense This Month”)prop(“Monthly Budget”), "Used " +round(1000*prop(“Expense This Month”)/prop(“Monthly Budget”))/10+"% " +style("Over Budget ✕ ","b","i","red"), if(prop(“Monthly Budget”)==0, "Blank")))
@thaissaaraquel
@thaissaaraquel 7 ай бұрын
Thanks, very good❤
@winkeeink
@winkeeink 9 ай бұрын
Formula weren’t working for me either….
@pixellmedia9953
@pixellmedia9953 8 ай бұрын
Because tis is not formula 2.0.
@ttone2330
@ttone2330 6 ай бұрын
*Formula
@debevanderheide5953
@debevanderheide5953 8 ай бұрын
I'm at 18:37 and have been loving it so far. I am sooooo new so formulas are foreign to me. I copied the formula but nothing. I'll have to check and see if you have a formula tutorial. Thanks for the awesome video. It's explained so much so far.
@debevanderheide5953
@debevanderheide5953 8 ай бұрын
@rosidssoy I just read Notion formulas have had an upgrade and older formulas no longer work (and have been converted to the new format). Have you created this using the new format? If so and you'd like to share in your notes, that would be awesome.
@yourlocalhuman3526
@yourlocalhuman3526 8 ай бұрын
any luck?@@debevanderheide5953
@Hino_55
@Hino_55 7 ай бұрын
Thank you for your efforts! :)
@berlianakusti460
@berlianakusti460 6 ай бұрын
Thank youuuuu ❤❤❤❤❤❤❤❤❤❤❤❤
@oliver_958
@oliver_958 4 ай бұрын
40:00
@deanne0913
@deanne0913 7 ай бұрын
29:07
@younesmedia
@younesmedia 8 ай бұрын
Best Tutorial ever
@gsytrey
@gsytrey 10 ай бұрын
What is the difference between this and the wealth notion template?
@rosidssoy
@rosidssoy 10 ай бұрын
Hi, wealth OS is a more comprehensive tool where you can manage assets, liabilities, saving, and calculate your net worth. You can check on below video kzbin.info/www/bejne/b2mQo2ifYrCIpJYsi=P6JB-1vKkN96Blce
@Anvarmaks19
@Anvarmaks19 6 ай бұрын
Hey! I need your help, please. Can you tell me the differencce between Accounts type: cash( this i understood), checking, Saving and Business Thaaanks
@rosidssoy
@rosidssoy 5 ай бұрын
Hi, A checking account is primarily used for everyday transactions like paying bills, making purchases, and withdrawing cash. It typically offers easy access to funds through checks, debit cards, and online transfers. Checking accounts usually don't offer high interest rates. A savings account, on the other hand, is designed for saving money over time. It often pays interest on the balance, helping your money grow. Savings accounts may have limits on withdrawals and transfers to encourage saving rather than spending. They're ideal for building an emergency fund or saving for specific goals. Business account is designed for your side hustle/business purpose, such as PayPal etc
@Anvarmaks19
@Anvarmaks19 5 ай бұрын
@@rosidssoy thanks a lot!!
@saveyourpityfortheweak
@saveyourpityfortheweak 7 ай бұрын
The formula at 29:10 was not working for me so I fixed it. Here it is: ifs(prop("Expense this Month")/prop("Monthly Budget")1,style("Used " + format(round((prop("Expense this Month")/prop("Monthly Budget"))*10000)/100),"b","i")+"%"+style("Overbudget⚠","b","i","red"),style("Not Budgeted", "b", "i"))
@28pinkdancer
@28pinkdancer 7 ай бұрын
I'm very new to coading and I was struggling at this part. Yours worked for me, thanks so much for sharing your work! :)
Wealth OS Notion Template Full Walkthrough
46:15
Rosidssoy
Рет қаралды 14 М.
Cute
00:16
Oyuncak Avı
Рет қаралды 12 МЛН
Do you choose Inside Out 2 or The Amazing World of Gumball? 🤔
00:19
Остановили аттракцион из-за дочки!
00:42
Victoria Portfolio
Рет қаралды 3,8 МЛН
Win This Dodgeball Game or DIE…
00:36
Alan Chikin Chow
Рет қаралды 38 МЛН
Notion Build With Me: Track Budget, Income And Expenses
18:04
Red Gregory
Рет қаралды 342 М.
How to Get Started with Notion (without losing your mind)
18:16
Simple Notion Tour | How I Organize My Life, Work, and Money
14:15
How I Organise My Life In Notion: Tour My Top 5 Simple Tools 2024
15:29
How To Build A Fully Automated Finance Tracker In Notion
43:22
Matthias Frank
Рет қаралды 3 М.
Notion for Finance: A Monthly Cashflow Manager w/ Budget Tracker
20:25
Budget Spreadsheet | Google Sheets Budget Template | Personal Finance Tips
18:49
Work Smarter Not Harder
Рет қаралды 305 М.
Cute
00:16
Oyuncak Avı
Рет қаралды 12 МЛН