It's 2022 and one of my urgent tasks for the week was to find a budgetting system. WOW! You put so much work into this system and it is exactly what I was looking for!! Thank you!!
Hi, I just want to say again that you're template is great, I've been using it for several months now. Unfortunately, I saw there's a question that is not answered and that a lot of people have : change the budget for specific months. You can also see my other comment above. I wish I could continue using your template...
Comparing this one with Easlo's it's way easier to have control of your finances due to the monthly balance and amount available per category. Thank you so much, Red. I'm donating a good amount of ☕ so you get inspired and fueled to keep working on your notion projects
OMG, that's soooo clever! Especially, in the Budget table, use 'monthly average' and the conception of amount of month to evaluate whether the spending by now is under budget or not , which smartly solves the problem that I encountered when tried to build a budget page on my own before. THANK YOU SO MUCH! LOVE YOU AND YOUR VIDEOS!
This budget template is awesome, if you could make a detailed video on how to make is step by step. I think that would help others to creat one of their own. At least me for sure 😍
WE NEED YOUR HELP!! Many of us would like the budget database to include a way to see if we are in budget for a given month. As it's set up we can see the total spent per category over all time, and average spent monthly. however as soon as you get 2 months in, you can no longer see how much you spend in a given month for a category. There's got to be a way to add/fix this. Can you please help us Red?
I love Notion but I hit a wall with connecting my expense tracking database with the months and item category databases! I am glad that your videos popped up as the top search result for my RUclips query for a Notion expense tracking system. Your video helped me understand Notion, and in particular, how you explained so clearly how to separate the relations for E. Month & Year and S. Month & Year is so simple yet extremely effective. Thank you thank you thank you :)
Red, you are a creative genius! I’m always beyond impressed with your templates & I honestly don’t know how I lived before them. I thought your last budgeting system was great but this is on another level of greatness. I especially love how clean & simple it is, SO easy to use! I was wondering if there’s anyway to add a debt calculator to the one you have now? Also, the only thing I’m confused about is how the budget will know when it’s a new month so the total re-starts at zero?? Thank you for everything you do
I was also searching for it at 13:50 she explains how to start a new month. In the Month template itself you can set the timeline of your month. I did it from the 20th till the 19th... It's a bit late but maybe this response is useable ☺️
Hi Red! I absolutely love this template! It definitely beats the Numbers Sheet I've been using for years.. and it's all in Notion! TY!! > In the Month view (and also in the Month template) 1. Duplicate the CASHFLOW table under INCOME 2. Change Filters: I/O Is Out | Name Contains Spend | E. Month & Year contains [August 2021 OR New Month for template] ***This will create a table with your TOTAL Spending for a given MONTH; Notice that the Total Amount Spent for the Month can be calculated at the bottom of the table (SUM)*** 3. In this new table, duplicate the table view 4. Add Grouping by Budget Item 5. In Grouping, Sort Manually if desired 6. Make sure the Groups display the calculation (SUM) >> You should now be able to see the total amount spent on all your expenses, for a given budget item, in the given Month. I keep the budget table Red included, next to this new table, so I can easily see.. I spent X on Food this month and my budget was Y. I hope this helps someone! Truly a powerful tool Red created here! Thank you again 😍
I love this, seriously. I've been looking for a new budgeting tool since YNAB is raising its price, and all other tools I've found are either insufficient or I don't understand them enough to tweak them for my preferences. This one I can actually work with. I do want to point out that you don't need both the IN/OUT column and the INCOME/SPEND column. You could even have separate columns for income and spending.
That actually helped, because instead of INCOME I prefer to put specify exactly there which kind of income it is instead of in the notes, but i was worried that it might be connected to a template which won't work anymore due to me deleting this filter :)
👍👍👍👍👍👍 Hey Red! Thank youuuu!!!!!! Thank youuuu!!!!!! Thank youuuu!!!!!! Thank youuuu!!!!!! Thank youuuu!!!!!! Thank youuuu!!!!!! I’m so grateful and really well explained! Looking forward to your videos! Have fun & peace! ✌️
I watched a loooot of videos with differents notion templates, and this is by far the best! Only one thing, It would be great having two differents type of currency (like USD and EUR) :)
I've just discovered your channel and this brilliant template. I love Notion, but have yet to find a way of using it to budget that I've stuck with. Looking forward to seeing how I go with this! Thanks for your hard work in preparing the template :)
Hi Red! I have a question, is it possible to change the budgets for a specific month while editing in the months page? Every time I try to add another budget or change it only for a specific month it changes the monthly base and every other month I have planned...
the month section is bugged for me, i think... the earnings is linking to the spending and its acummulating both spending and earnings. i didn't change anything, idk what happened
I am trying to use your template but i need to set each month from the 26. of the month before to the 25. of the current month. That does not seem to be a big problem untill i try to have the Box „currently“ checked as my format does not look like MMMM YYYY. But like 26.Nov- 25.Dez 2022 or November - December 2022. Could you help me change the formula so it will still work. I would really love to use your template as it is amazing and covers all my other needs!!
hello. I just learned about notion last week and as a student, I can see that it has some really cool features that would be really helpful to me. at first, I was very overwhelmed with all the new things you can do using notion but watching your videos have really helped me get the hang of it. the one thing that I have been looking for on the internet but I can't seem to find is an attendance tracker for students. as a uni student, we have the criteria to hit 70% attendance to attend the exams. and I really want to track which classes I attend and which classes do I skip. and which classes are currently low on attendance. I am looking to build a database where I enter the subject name, date, and a check box if the class is attended or not. and based on the no of classes missed/attended it could calculate in which classes I have low attendance. I thought this I a pretty common thing and I would find at least one person who has made something like this but unfortunately, I haven't. can you please make something like this?
friend, how to separate expenses between personal and professional so that we can filter the totals according to filters added for this? I think that this would be just perfect, as we would be integrating the professional with the personal, all in the same control, since many times we may suddenly need to "direct" capital from one to the other, apart from the very fact that we have exactly everything in the same control. This being possible... it would be interesting to have a transfer function, so that we can easily direct capital from one department to another (personal/professional) wow
Great template, great video, thank you for your work. I just got one question, I don't understand why you name "Spend" ou "Income" in the cashflow database ? Is it only because you can't erase "name" column but you don't want to write the name of every line every month ?
This is so great, love what you've done with this template! I'm curious about one thing, is there a way to add in a "total for month". I see you have the function for monthly average, but would there be a way to just see the amount for that specific month? For example: Groceries Monthly Average : $450 Total amount spent on groceries on month of August : $410
I love this template, only thing is (which may sound dumb but i’m new to this kind of thing), how do you reset your total property at the beginning of a new month?
Hi Red! Thank you for such a phenomenal tutorial. However, I have a question, how to create a monthly budget for each month on the month's page. For instance, I am editing page November and want to edit a specific budget that does not depend on every month's data. Hoping you could reply to me. One more time, thank you so much ~~~~~~
Did you ever figure this part out? Everything works so well except the "Budget" table becomes useless after one month due to it not resetting. I guess maybe just looking at it under the "Month" table makes the "most" sense...but then what's the point outside of looking at the monthly averages.
Thank you for such a great tutorial, it really helps me to be more productive. I wished there is an option to have different accounts as for example I have multiple bank accounts and I would like to have summary and cashflow details for each one of them, for example in the cashflow I can change the type from "SPEND" to " TRANSFER" then in the dashboard, I have a database named "Payment Accounts" and it's linked with relation to the Cashflow, also whenever I have the income I can choose to which account I would like to add it, I have tried to make a relation then roll up to count the sum but I don't know how to subtract the amount from this payment account that I have created when I make spend or transfer to another account. I hope you understand me and you can suggest the solution to that. Thanks.
Thank, you so much! I'm using your savings template. Can I connect the saving payments of that template to the total balance & savings database of this template.
dear Gregory, top knowledge could you figure out or remember how to link a "✔checkbox" to the "$ amount" field so that it is computed in the totals only if the "✔checkbox" is checked? And more, if possible, that this "✔ checkbox" is interrelated with all the tables. in short, really confirm that the income or expense to be computed in the budget it would be more friendly to visualize future earnings and expenses already "categorized and budgeted" with that we can create goals It would be incredibly exceptional and wonderful thank you for your existence, helpfulness and generosity with us 💪🏼
Gregory, I did it like this I created a property with this formula prop("Checkbox") ? format(prop("Amount")) : "" [worked] brought me the value if the checkbox is checked then I created another property unaryPlus(prop("Formula")) which converted the result of the property to a number I think this should work just fine for now Let us know if you have a more direct way we are together hugs
Last month I use this template and is powerfull!! Thanks. The problem is when I start a new month, the start page does not show the data of that new month, it shows the old one. how can I solve that?
Hi Red, thank you for the video. I've been watching it many times and each time I still can learn something new. Just wondering one thing - what happened if the box of CURRENTLY is UNCHECKED for the current month (in Months Section). Did I miss something? Thank you for your time in advance.
This is so awesome! Also, is there a way to make 2 balance amounts for 2 different accounts? I've made a database for the different accounts I'm using but I can't seem to figure out how to get it to total separately.
This is insame and thank you so much for putting your time and effort into it. Question, is there a way to account for multiple bank accounts and transfer funds between them? Well in terms of Transfer and can just treat it as a spend from one bank account and income to the other. But is there a way we would be able to have say 3 bank accounts then, be able to see the balance in each as well as the overall roll up like what you already have here. I pretty much use 2 bank accounts and cash envelopes and it would be super to track each of their spending individually. Of course you have done this wonderful template and I'm super grateful for that, I'm not complaining AT ALL, just inquiring.
First of all, thank you for sharing such an amazing template and taking the time to explain it in detail! I was able to completely adopt it except for one hitch. Since the monthly average's formula divides by the # of Months an expense is associated to, it seems the Over/Under formula by extension would only work with recurring expenses. Any suggestions on how to adapt it to work with one time annual expenses? Should I just change the estimate from monthly to annual in that case? I feel that would get confusing really fast though!
Yes, this is only for recurring bills and expenses every month that are budgeted by broader categories. I can look into creating something more detailed in the future.
@@RedGregory Thank you! That would be amazing. For now, I'm just gonna change the Monthly Average formula to divide by 12 instead of the # of Months value. Cheers!
I dont know how to make my budged to only read the spendings of the current month. It always shows that im over my budged, but is bc it reads the spendings of all months,, can someone help me?
Hello Red, firts of all i want to thank you for your work. and I have a question I hope you can answer it. When it comes to create a new month on the Budget data base, how do I reset or empty the data information from previous month. I hope you can answer, this is preventing me to keep tracking my finances.
I would like to know this too. I thought the cashflow view would allow me to put in expenses that recurr every month so I don't have to fill those in each month. But that is not the case...
I mean in the budget page, beside the column for ‘monthly average’ there’s a column as ‘total’, for mine it’s calculating sum of all months instead of only one month. Or is it my formula has problem? Btw thanks for your quick reply! :D
@@Pyra_mis The formula for monthly average inside the Budget page takes each budget item (ex. charity), sums the total spent, then divides that number by the total number of months that item has been used. The formula looks like this: round(prop("Total") / prop("Months #")). The window to your monthly budget inside a month page is calculating the overall monthly average as well. I'll make the documentation more clear in the month template.
@@RedGregory I don't think you understand the question. The "total"column is the total of every month, but we want it to be the total of only the current month. Is there a way to do that ?
Are you doing a guide on how to create a per month total? I have followed your previous tutorial for budget but it just adds on and not a per month total like you have in this tutorial..... Please help
Hello there! Thank you so much for this budget template. I was wondering if you could go a little more into the debt section...I am trying to figure out how I can add the total debt (from Student Loans and CC) so I can see the grand debt total getting lower and lower each month. Is that possible? Thanks again!
Your video is wonderful, and I would like to give it a try. I am wondering if most fields can be edited, such as the budget items. I have some that are not in your template, and you have some that I do not need. I also utilize PDF attachments in my current budget and registers, can this be added. I have not yet tried building anything with Notion, but what you show in your video is very intriguing.
Hi, thank you to share this with us, I have question about the month, so how set up another month? because when I add a month I need to change the price for spreading and when I change the price for the new month it will change for the previous month also :(
Thank you for this! It's been really helping me! I didn't understand how to add a new month though... Idk why.. When I add a new month I'm not able to separate the budget from the month I'm in, the table is still costing the last db, Ill always be over budget then.. So what I've been doing for the past 3 months is that I'm deleting all the Budget items in the cashflow (out) db, I'm not sure that's what I'm supposed to do. Thks for you feedback
@@guillermocast01 Not sure I understand the problem. You can always add a new month from the Months database. Are you guys talking about the Budget view inside a Months page?
@@guillermocast01 Ah I saw Ben's other comment and finally understand. I guess they didn't clarify in the video but the Estimate column in the Budget database is a Monthly Estimate for the entire year. For instance, you can estimate that you will probably be spending $50 dollars on average every month on groceries. So you start with that forecast and every month, after adding the actual grocery expenses, you can check in the Budget view if your actual average consumption is "Over" or "Under" the forecast. Now mid-year you realize, for whatever reason, you need to pay more every month for groceries. Simply, adjust the Estimate column to account for the change and the I/O column will work just fine for the remaining months as well (e.g: old estimate=$50, new estimate=$60 for next 5 months, updated estimate = (50 * 7 + 60 * 5) / 12 = $54). Now, if you don't want that and want a separate budget on a month to month basis, you will need to create yet another database for it. You will need to link it to the original budget table to get access to the budget items and change whatever formulas you want to use to work on a month to month basis. Hope this helps!
Hi there. I love this but my balance doesn't seem to work. The gross balance is the same as total earnings and doesn't seem to tally up with the spend and income columns. could you help with this please? I really don't know how to fix it
Hey! Love your notion videos, great job. I like this layout but I'm a bit confused on how to go about doing this if I have a checking account where my money gets direct deposit for income and thats where most of my expenses come from. However I also have a savings account that I transfer to when any income comes in.. I take a set amount of my paycheck and transfer it directly to savings. How do you think I should treat multiple accounts?
Hi! I need your help. For some reasons, I can't work my saving round with percentages, but with fixed amounts. For example, I need to save exactly, savings 1: $200, Saving 2: $150 and Savings 3: $100. How could I edit the savings formula to a fixed amount without messing up with the rest of formulas?
🤔you should consider making course on notion that focuses on formulas, btw Video is awesome as always.
It's 2022 and one of my urgent tasks for the week was to find a budgetting system. WOW! You put so much work into this system and it is exactly what I was looking for!! Thank you!!
The only channel which shows only the full mathematical use case of notion and its features.
Hi, I just want to say again that you're template is great, I've been using it for several months now. Unfortunately, I saw there's a question that is not answered and that a lot of people have : change the budget for specific months.
You can also see my other comment above. I wish I could continue using your template...
MOST underrated ytchannel out there on god! thank you sarah
Just wow! I've been using Notion quite a while, but never take it to the next level like this. Thank you for your efforts, explanation and resources
Comparing this one with Easlo's it's way easier to have control of your finances due to the monthly balance and amount available per category. Thank you so much, Red. I'm donating a good amount of ☕ so you get inspired and fueled to keep working on your notion projects
OMG, that's soooo clever! Especially, in the Budget table, use 'monthly average' and the conception of amount of month to evaluate whether the spending by now is under budget or not , which smartly solves the problem that I encountered when tried to build a budget page on my own before. THANK YOU SO MUCH! LOVE YOU AND YOUR VIDEOS!
I love this verison !!! very organize and simple understanding! this is exaclty what I wanted but it takes forever
This budget template is awesome, if you could make a detailed video on how to make is step by step. I think that would help others to creat one of their own. At least me for sure 😍
WE NEED YOUR HELP!! Many of us would like the budget database to include a way to see if we are in budget for a given month. As it's set up we can see the total spent per category over all time, and average spent monthly. however as soon as you get 2 months in, you can no longer see how much you spend in a given month for a category. There's got to be a way to add/fix this. Can you please help us Red?
I love Notion but I hit a wall with connecting my expense tracking database with the months and item category databases! I am glad that your videos popped up as the top search result for my RUclips query for a Notion expense tracking system. Your video helped me understand Notion, and in particular, how you explained so clearly how to separate the relations for E. Month & Year and S. Month & Year is so simple yet extremely effective. Thank you thank you thank you :)
Red, you are a creative genius! I’m always beyond impressed with your templates & I honestly don’t know how I lived before them. I thought your last budgeting system was great but this is on another level of greatness. I especially love how clean & simple it is, SO easy to use! I was wondering if there’s anyway to add a debt calculator to the one you have now? Also, the only thing I’m confused about is how the budget will know when it’s a new month so the total re-starts at zero?? Thank you for everything you do
I was also searching for it at 13:50 she explains how to start a new month.
In the Month template itself you can set the timeline of your month. I did it from the 20th till the 19th...
It's a bit late but maybe this response is useable ☺️
@@minahondeveld7813 I don't clearly understand what you did. Did you add a new column?
Red, YOU'RE FABULOUS!!! This is a fantastic Template and explanation!!! thanks for that!
WOW!!!!! This has a major learning curve, but it's totally worth it! I'll start right now!
Hi Red! I absolutely love this template! It definitely beats the Numbers Sheet I've been using for years.. and it's all in Notion! TY!! > In the Month view (and also in the Month template)
1. Duplicate the CASHFLOW table under INCOME
2. Change Filters: I/O Is Out | Name Contains Spend | E. Month & Year contains [August 2021 OR New Month for template]
***This will create a table with your TOTAL Spending for a given MONTH; Notice that the Total Amount Spent for the Month can be calculated at the bottom of the table (SUM)***
3. In this new table, duplicate the table view
4. Add Grouping by Budget Item
5. In Grouping, Sort Manually if desired
6. Make sure the Groups display the calculation (SUM)
>> You should now be able to see the total amount spent on all your expenses, for a given budget item, in the given Month.
I keep the budget table Red included, next to this new table, so I can easily see.. I spent X on Food this month and my budget was Y.
I hope this helps someone! Truly a powerful tool Red created here! Thank you again 😍
I love this, seriously. I've been looking for a new budgeting tool since YNAB is raising its price, and all other tools I've found are either insufficient or I don't understand them enough to tweak them for my preferences. This one I can actually work with. I do want to point out that you don't need both the IN/OUT column and the INCOME/SPEND column. You could even have separate columns for income and spending.
That actually helped, because instead of INCOME I prefer to put specify exactly there which kind of income it is instead of in the notes, but i was worried that it might be connected to a template which won't work anymore due to me deleting this filter :)
I'm out of words, this is just greatness, thanks for sharing
👍👍👍👍👍👍 Hey Red! Thank youuuu!!!!!! Thank youuuu!!!!!! Thank youuuu!!!!!! Thank youuuu!!!!!! Thank youuuu!!!!!! Thank youuuu!!!!!! I’m so grateful and really well explained! Looking forward to your videos! Have fun & peace! ✌️
Impressive work and template!
Thanks red you're charmant
Wow this video was so helpful. You have offered the best budget templates that I have seen by far!!! keep up the great work
I watched a loooot of videos with differents notion templates, and this is by far the best! Only one thing, It would be great having two differents type of currency (like USD and EUR) :)
OMG amazing video as always!!! Very informative and you continue to show me the depth of notion!!!
Thanks for watching. Glad you enjoyed it! 😁
Red, You are magnificient on Notionn, Thank a lot!!!
I've just discovered your channel and this brilliant template. I love Notion, but have yet to find a way of using it to budget that I've stuck with. Looking forward to seeing how I go with this! Thanks for your hard work in preparing the template :)
Thank you so much!
This is amazing as usual, thanks!
Glad you like it! 🥰
Wow, this is insane. I've done most of this in Excel, but this is way, way better. Thank you!
Thank you for creating this amazing budget manager! I'm using it and absolutely loving it! ❤
I feel like this video is so important, I have to download it
This is exactly what my life needed!
Thank you Red! Impressive work!
You really ate this up. I love this and you thank you!!
Thank you for the template. Great Job!
Great template & tutorial! Could you show us how you set up a new year with this kind of budget manager? Thanks!
Hi Red! I have a question, is it possible to change the budgets for a specific month while editing in the months page? Every time I try to add another budget or change it only for a specific month it changes the monthly base and every other month I have planned...
also looking for an answer to this!! :D
Wondering the same here!
Yes wondering about this myself. If you could make a follow up on this, I'm stuck after budgeting for the first month. @Red Gregory. Great tool!
Has anyone found a solution for this? Still looking for one
Up this comment again!
the month section is bugged for me, i think... the earnings is linking to the spending and its acummulating both spending and earnings. i didn't change anything, idk what happened
I am trying to use your template but i need to set each month from the 26. of the month before to the 25. of the current month. That does not seem to be a big problem untill i try to have the Box „currently“ checked as my format does not look like MMMM YYYY. But like 26.Nov- 25.Dez 2022 or November - December 2022. Could you help me change the formula so it will still work. I would really love to use your template as it is amazing and covers all my other needs!!
thank you so much red
This is amazing. I'm trying to keep and make a budget
hello. I just learned about notion last week and as a student, I can see that it has some really cool features that would be really helpful to me. at first, I was very overwhelmed with all the new things you can do using notion but watching your videos have really helped me get the hang of it.
the one thing that I have been looking for on the internet but I can't seem to find is an attendance tracker for students. as a uni student, we have the criteria to hit 70% attendance to attend the exams. and I really want to track which classes I attend and which classes do I skip. and which classes are currently low on attendance.
I am looking to build a database where I enter the subject name, date, and a check box if the class is attended or not. and based on the no of classes missed/attended it could calculate in which classes I have low attendance.
I thought this I a pretty common thing and I would find at least one person who has made something like this but unfortunately, I haven't.
can you please make something like this?
friend, how to separate expenses between personal and professional so that we can filter the totals according to filters added for this?
I think that this would be just perfect, as we would be integrating the professional with the personal, all in the same control, since many times we may suddenly need to "direct" capital from one to the other, apart from the very fact that we have exactly everything in the same control.
This being possible... it would be interesting to have a transfer function, so that we can easily direct capital from one department to another (personal/professional)
wow
Thanks for this Red
Great template, great video, thank you for your work. I just got one question, I don't understand why you name "Spend" ou "Income" in the cashflow database ? Is it only because you can't erase "name" column but you don't want to write the name of every line every month ?
Great Red, thanks!!!!
This is so great, love what you've done with this template!
I'm curious about one thing, is there a way to add in a "total for month". I see you have the function for monthly average, but would there be a way to just see the amount for that specific month? For example:
Groceries Monthly Average : $450
Total amount spent on groceries on month of August : $410
I would really like to add this as well!
You can add, just flow how the the monthly average was done then use sum
@@johnrussel5911 can you clarify this
Thanks a lot Red!!
You're just AWESOME! So perfect
🙌
thank you so much! it's an amazing video!
Very good and useful!!!🙂
Thank you so much !! This is sooooo helpful
I love this template, only thing is (which may sound dumb but i’m new to this kind of thing), how do you reset your total property at the beginning of a new month?
Hi Red!
Thank you for such a phenomenal tutorial. However, I have a question, how to create a monthly budget for each month on the month's page. For instance, I am editing page November and want to edit a specific budget that does not depend on every month's data. Hoping you could reply to me. One more time, thank you so much ~~~~~~
Did you ever figure this part out? Everything works so well except the "Budget" table becomes useless after one month due to it not resetting. I guess maybe just looking at it under the "Month" table makes the "most" sense...but then what's the point outside of looking at the monthly averages.
Thank you for such a great tutorial, it really helps me to be more productive.
I wished there is an option to have different accounts as for example I have multiple bank accounts and I would like to have summary and cashflow details for each one of them, for example in the cashflow I can change the type from "SPEND" to " TRANSFER" then in the dashboard, I have a database named "Payment Accounts" and it's linked with relation to the Cashflow, also whenever I have the income I can choose to which account I would like to add it,
I have tried to make a relation then roll up to count the sum but I don't know how to subtract the amount from this payment account that I have created when I make spend or transfer to another account.
I hope you understand me and you can suggest the solution to that.
Thanks.
how to set monthly to be period like 25nov-24dec and all data connect to that date
How do I take money out of my savings? Thank you for an amazing template and video.
Nice video. Do u have similar video on daily calender planner, where we can plan and track activities
Thank you so much for this!
Thank, you so much! I'm using your savings template. Can I connect the saving payments of that template to the total balance & savings database of this template.
I wonder what enhancements can be made to this with the new and improved formulas 2.0
dear Gregory,
top knowledge
could you figure out or remember how to link a "✔checkbox" to the "$ amount" field so that it is computed in the totals only if the "✔checkbox" is checked? And more, if possible, that this "✔
checkbox" is interrelated with all the tables.
in short, really confirm that the income or expense to be computed in the budget
it would be more friendly to visualize future earnings and expenses already "categorized and budgeted"
with that we can create goals
It would be incredibly exceptional and wonderful
thank you for your existence, helpfulness and generosity with us 💪🏼
Gregory, I did it like this
I created a property with this formula
prop("Checkbox") ? format(prop("Amount")) : "" [worked]
brought me the value if the checkbox is checked
then I created another property
unaryPlus(prop("Formula")) which converted the result of the property to a number
I think this should work just fine for now
Let us know if you have a more direct way
we are together
hugs
Last month I use this template and is powerfull!! Thanks. The problem is when I start a new month, the start page does not show the data of that new month, it shows the old one. how can I solve that?
In the budget section, I want to add a column where I can see how much I've spent in the current month, can you please tell me how to do that?🥺
Great template
Is there a video on how to build this? I'd love to learn from it!:)
Amazing your video!! thank so much !!!
Thanks!
you are amazing , thanks.
It sounds weird but are you a computer science student? You are truly a genius 😂😂😂
Great job thanks for sharing
Thanks for watching!
Hi Red, thank you for the video. I've been watching it many times and each time I still can learn something new. Just wondering one thing - what happened if the box of CURRENTLY is UNCHECKED for the current month (in Months Section). Did I miss something? Thank you for your time in advance.
This is so awesome!
Also, is there a way to make 2 balance amounts for 2 different accounts? I've made a database for the different accounts I'm using but I can't seem to figure out how to get it to total separately.
You are superb!
This is insame and thank you so much for putting your time and effort into it. Question, is there a way to account for multiple bank accounts and transfer funds between them? Well in terms of Transfer and can just treat it as a spend from one bank account and income to the other. But is there a way we would be able to have say 3 bank accounts then, be able to see the balance in each as well as the overall roll up like what you already have here. I pretty much use 2 bank accounts and cash envelopes and it would be super to track each of their spending individually. Of course you have done this wonderful template and I'm super grateful for that, I'm not complaining AT ALL, just inquiring.
Well done ,Genius!!!!!
13:50 thank you!
Great video- how do you get it so that your budget only shows the values for one of your months?
I was struggling with the same thing
I found a sneaky work around which is duplicating the template 12 times 😁
First of all, thank you for sharing such an amazing template and taking the time to explain it in detail!
I was able to completely adopt it except for one hitch. Since the monthly average's formula divides by the # of Months an expense is associated to, it seems the Over/Under formula by extension would only work with recurring expenses. Any suggestions on how to adapt it to work with one time annual expenses?
Should I just change the estimate from monthly to annual in that case? I feel that would get confusing really fast though!
Yes, this is only for recurring bills and expenses every month that are budgeted by broader categories. I can look into creating something more detailed in the future.
@@RedGregory Thank you! That would be amazing. For now, I'm just gonna change the Monthly Average formula to divide by 12 instead of the # of Months value. Cheers!
You are AMAZING!
I dont know how to make my budged to only read the spendings of the current month. It always shows that im over my budged, but is bc it reads the spendings of all months,, can someone help me?
Were you able to solve the problem, having the same issue :(
Hello Red, firts of all i want to thank you for your work. and I have a question I hope you can answer it. When it comes to create a new month on the Budget data base, how do I reset or empty the data information from previous month. I hope you can answer, this is preventing me to keep tracking my finances.
did you figure it out? im looking for the same answer as well
THis is great, Thank you
WHat should I do if I need to change my savings goals just for one month? It that possible? When I try to change it for one, it changes for all.
Aw man, I really need help on this part: 3:30 I'm trying to figure out how you connected those dots for "SPEND"
Hi! great tool. I have a question: How do I copy recurring expenses from one month to the next? Thanks!
I would like to know this too. I thought the cashflow view would allow me to put in expenses that recurr every month so I don't have to fill those in each month. But that is not the case...
Why the total in budget is counting all month’s cash flow? Can it be only calculate the spending of each month?
Each month page should calculate only for that month
I mean in the budget page, beside the column for ‘monthly average’ there’s a column as ‘total’, for mine it’s calculating sum of all months instead of only one month. Or is it my formula has problem? Btw thanks for your quick reply! :D
Or the budget page should have each page for each month?
@@Pyra_mis The formula for monthly average inside the Budget page takes each budget item (ex. charity), sums the total spent, then divides that number by the total number of months that item has been used. The formula looks like this: round(prop("Total") / prop("Months #")). The window to your monthly budget inside a month page is calculating the overall monthly average as well. I'll make the documentation more clear in the month template.
@@RedGregory I don't think you understand the question. The "total"column is the total of every month, but we want it to be the total of only the current month. Is there a way to do that ?
This is so cool! Thanks🔥🔥🔥 and you're gorgeous🙃
Are you doing a guide on how to create a per month total? I have followed your previous tutorial for budget but it just adds on and not a per month total like you have in this tutorial..... Please help
Hello there! Thank you so much for this budget template. I was wondering if you could go a little more into the debt section...I am trying to figure out how I can add the total debt (from Student Loans and CC) so I can see the grand debt total getting lower and lower each month. Is that possible? Thanks again!
what is starting amount index for ? I can't get it....I'm new at personal finance and I wanna know when should I use it?
Your video is wonderful, and I would like to give it a try. I am wondering if most fields can be edited, such as the budget items. I have some that are not in your template, and you have some that I do not need. I also utilize PDF attachments in my current budget and registers, can this be added. I have not yet tried building anything with Notion, but what you show in your video is very intriguing.
Hi, thank you to share this with us, I have question about the month, so how set up another month? because when I add a month I need to change the price for spreading and when I change the price for the new month it will change for the previous month also :(
Thank you for this! It's been really helping me! I didn't understand how to add a new month though... Idk why.. When I add a new month I'm not able to separate the budget from the month I'm in, the table is still costing the last db, Ill always be over budget then.. So what I've been doing for the past 3 months is that I'm deleting all the Budget items in the cashflow (out) db, I'm not sure that's what I'm supposed to do.
Thks for you feedback
Thanks god im not the only one with this issue. Did you came up with a solution that you can share?
@@bebezer0 Not yet unfortunately
@@bengananda2133 Having the same issue, 1 month later, did you guys found a solution?
@@guillermocast01 Not sure I understand the problem. You can always add a new month from the Months database. Are you guys talking about the Budget view inside a Months page?
@@guillermocast01 Ah I saw Ben's other comment and finally understand. I guess they didn't clarify in the video but the Estimate column in the Budget database is a Monthly Estimate for the entire year. For instance, you can estimate that you will probably be spending $50 dollars on average every month on groceries. So you start with that forecast and every month, after adding the actual grocery expenses, you can check in the Budget view if your actual average consumption is "Over" or "Under" the forecast. Now mid-year you realize, for whatever reason, you need to pay more every month for groceries. Simply, adjust the Estimate column to account for the change and the I/O column will work just fine for the remaining months as well (e.g: old estimate=$50, new estimate=$60 for next 5 months, updated estimate = (50 * 7 + 60 * 5) / 12 = $54).
Now, if you don't want that and want a separate budget on a month to month basis, you will need to create yet another database for it. You will need to link it to the original budget table to get access to the budget items and change whatever formulas you want to use to work on a month to month basis.
Hope this helps!
brazil here with u!
Hi there. I love this but my balance doesn't seem to work. The gross balance is the same as total earnings and doesn't seem to tally up with the spend and income columns. could you help with this please? I really don't know how to fix it
Hey! Love your notion videos, great job. I like this layout but I'm a bit confused on how to go about doing this if I have a checking account where my money gets direct deposit for income and thats where most of my expenses come from. However I also have a savings account that I transfer to when any income comes in.. I take a set amount of my paycheck and transfer it directly to savings. How do you think I should treat multiple accounts?
Is this template no longer available? Couldn't get the link to work.
Amaizing!
Hi! I need your help. For some reasons, I can't work my saving round with percentages, but with fixed amounts. For example, I need to save exactly, savings 1: $200, Saving 2: $150 and Savings 3: $100. How could I edit the savings formula to a fixed amount without messing up with the rest of formulas?