50/30/20 RULE Budget System to Track your Money & Finances | Notion Template Tutorial

[@theorganizednotebook]

✨Download our template
Grab the ULTIMATE Personal Finance Tracker Notion Template:
Template Link: theorganizednotebook.com/product/ultimate-personal-finance-tracker-notion-template/
Template Tour: ua-cam.com/video/wi9XrGWU-J0/v-deo.html
🔗 Free Resources
How to Build a Finance Tracker with Notion | Manage your finances with ease! ✨
ua-cam.com/video/WuI46zLVVl8/v-deo.html

[@gabs152]

I follow your tutorial! The formula works perfectly, thank you so much ❤❤❤

[@theorganizednotebook]

You're welcome 😊

[@DunjavanderZee-m5r]

how did you do it?

[@linahtem21]

thanks a lot for the template, it helped a lot!! idk how but i fcked up so many things, but i did it, so im really grateful for it😭

[@theorganizednotebook]

Thank you for watching! Glad to hear that you were able to set up the template and the video was helpful! Stay tuned for more!

[@nsrtxjx]

thank you a lot .

[@theorganizednotebook]

You are welcome!

[@aishwaryajoshi8105]

OH MY GOD! what are the formulas! i spent last 2-3 hours doing what you are doing and im now stuck half way though at formulas!!!!!!!!!!!! HELPPPPPPPPPPP!!!!!!!!

[@theorganizednotebook]

Thank you for watching! Sorry to hear you got stuck in the formulas, the formula we used in this template is below. Please note that the props must be named exactly the same for it to work. Let us know if this helps!
Needs:
abs(round(-(sum(prop("Income & Spending").map(if(current.prop("Type") == "Needs",current.prop("Total"), 0))))/sum(prop("Income & Spending").map(if(current.prop("Type") == "Income", current.prop("Total"), 0)))*100)/100)
Wants:
abs(round((sum(prop("Income & Spending").map(if(current.prop("Type") == "Wants",current.prop("Total"), 0))))/sum(prop("Income & Spending").map(if(current.prop("Type") == "Income", current.prop("Total"), 0)))*100)/100)
Saving:
abs(round(-(sum(prop("Income & Spending").map(if(current.prop("Type") == "Saving",current.prop("Total"), 0))))/sum(prop("Income & Spending").map(if(current.prop("Type") == "Income", current.prop("Total"), 0)))*100)/100)
Income:
sum(prop("Income & Spending").map(if(current.prop("Type") == "Income", current.prop("Total"), 0)))

[@aishwaryajoshi8105]

@@theorganizednotebook I'll try this asap!! But one of the issues I'm having is even though my prop is Income & Spending it's not showing 🙁. It's only showing untitled database...I'm starting out with formulas for first time hence getting stuck at basics...but Thank you for the help!!! And the video!!

[@aishwaryajoshi8105]

@@theorganizednotebook OMGGGGGGG it worked!!!!!!!!!!!! just one thing even though database name is Income & Spendings its showing everywhere else as untitled but apart from that everything is great! Thank you soooooo much!

[@DunjavanderZee-m5r]

@@aishwaryajoshi8105 same problem here

[@lennycloudz2cloudz233]

sum(prop("Income & Spending").map(if(current.prop("Type") == "Income", current.prop("Amount"), 0)))

[@aishwaryajoshi8105]

i tried this formula and its not working...please help!

[@DunjavanderZee-m5r]

@@aishwaryajoshi8105 same problem please help

[@DunjavanderZee-m5r]

now its just '0" instead of de sum

[@blackstone12]

Good Video

[@theorganizednotebook]

Glad you enjoyed

[@leonlee82]

waiting for notion new update for set password on database.

[@theorganizednotebook]

Same here with us, it would be a powerful feature!

[@lennycloudz2cloudz233]

abs(round((sum(prop("Income & Spending").map(if(current.prop("Type") == "Needs",current.prop("Amount"), 0))))/sum(prop("Income & Spending").map(if(current.prop("Type") == "Income", current.prop("Amount"), 0)))*100)/100)

[@gamerboyrax2222]

I am not able to use the Type in the formula 🥲
Can you help in that?

[@theorganizednotebook]

Hi! Thank you for watching! Could you clarify what Type you're referring to in the formula? If it is easier feel free to send an email with a screenshot at [e-mail]