Notion for Finance: A Monthly Cashflow Manager w/ Budget Tracker

[@aftab_aaman]

The only channel which shows only the full mathematical use case of notion and its features.

[@CatalleyaStorm]

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

[@MSanzSH-0]

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

[@tajmathakiya]

🤔you should consider making course on notion that focuses on formulas, btw Video is awesome as always.

[@bengananda2133]

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

[@gfgit6148]

MOST underrated ytchannel out there on god! thank you sarah

[@sasainie]

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!

[@xmrdatax]

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

[@Lizlizzie]

I love this verison !!! very organize and simple understanding! this is exaclty what I wanted but it takes forever

[@paulabologna1327]

Red, YOU'RE FABULOUS!!! This is a fantastic Template and explanation!!! thanks for that!

[@liviere1]

👍👍👍👍👍👍 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! ✌️

[@juanpablopantojaruiz6381]

WOW!!!!! This has a major learning curve, but it's totally worth it! I'll start right now!

[@pmoncayo]

I'm out of words, this is just greatness, thanks for sharing

[@voltaireherrera7116]

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?

[@greys7734]

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

[@HahaHihi-dw5ot]

Red, You are magnificient on Notionn, Thank a lot!!!

[@_E_R_]

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 😍

[@achrafgr5449]

Impressive work and template! Thanks red you're charmant

[@wilma888]

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 😍

[@danteguzman2918]

Wow this video was so helpful. You have offered the best budget templates that I have seen by far!!! keep up the great work

[@jillianjacobson4615]

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

[@minahondeveld7813]

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 ☺️

[@luissolaruiz4503]

@@minahondeveld7813 I don't clearly understand what you did. Did you add a new column?

[@b.schurman]

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.

[@lenaball6331]

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

[@desmondenglish6055]

OMG amazing video as always!!! Very informative and you continue to show me the depth of notion!!!

[@RedGregory]

Thanks for watching. Glad you enjoyed it! 😁

[@ahmedtrabelsi8012]

Thank you for creating this amazing budget manager! I'm using it and absolutely loving it! ❤

[@darwin-luque]

This is exactly what my life needed!

[@Willemdreess]

Wow, this is insane. I've done most of this in Excel, but this is way, way better. Thank you!

[@FlorEnrulada]

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

[@Ana-zx2ot]

This is amazing as usual, thanks!

[@RedGregory]

Glad you like it! 🥰

[@BrendaSarmanho]

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

[@bradleyevenden1407]

also looking for an answer to this!! :D

[@guillermocast01]

Wondering the same here!

[@supriyajayasimha]

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!

[@tarasdiary]

Has anyone found a solution for this? Still looking for one

[@faishalrizal5052]

Up this comment again!

[@mizzrosemary]

You really ate this up. I love this and you thank you!!

[@JanSchick]

I feel like this video is so important, I have to download it

[@solilos]

Thank you Red! Impressive work!

[@HollyJaneYT]

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

[@HungNguyen-zp5es]

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

[@MrOGThrilla]

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.

[@mellowpuff_2732]

Great template & tutorial! Could you show us how you set up a new year with this kind of budget manager? Thanks!

[@EarthonWheels]

Thank you for the template. Great Job!

[@elinab4047]

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

[@roccomalarett5332]

Thank you so much!

[@jorisb.3113]

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 ?

[@Notion]

🙌

[@Assisting2ObeybyGSC]

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.

[@coco7091]

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?

[@johnrussel5911]

Thanks for this Red

[@nursaidah4786]

how to set monthly to be period like 25nov-24dec and all data connect to that date

[@errole]

This is amazing. I'm trying to keep and make a budget

[@Susan-ln3tu]

Thanks!

[@kratosgodofwarize]

You're just AWESOME! So perfect

[@EugeneHo88]

Nice video. Do u have similar video on daily calender planner, where we can plan and track activities

[@sunnyday5663]

thank you so much! it's an amazing video!

[@khrisnachris]

thank you so much red

[@katehildenbrand4847]

How do I take money out of my savings? Thank you for an amazing template and video.

[@bradleyevenden1407]

Great video- how do you get it so that your budget only shows the values for one of your months?

[@hananeqorar2510]

I was struggling with the same thing

[@Elsiromar47]

I found a sneaky work around which is duplicating the template 12 times 😁

[@dakotasumner741]

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

[@JulieVandebosch]

I would really like to add this as well!

[@johnrussel5911]

You can add, just flow how the the monthly average was done then use sum

[@Dera.artstudio]

@@johnrussel5911 can you clarify this

[@soniafarhah5878]

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.

[@yeepeeyeepee8529]

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.

[@buckyistheone]

Thanks a lot Red!!

[@areejfatimasheikh7208]

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?

[@bebezer0]

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.

[@voltaireherrera7116]

did you figure it out? im looking for the same answer as well

[@iamtasha2]

Is this template no longer available? Couldn't get the link to work.

[@emanuelbarros5132]

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

[@rumanovsky1897]

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?

[@Jay-ox3oy]

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.

[@schvartzmanhernan]

Hi! great tool. I have a question: How do I copy recurring expenses from one month to the next? Thanks!

[@boycottmainstream]

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

[@PedroFernandezRuiz]

Great Red, thanks!!!!

[@cciemike]

I need help. I downloaded your template and it looks nice. One question I have is how do I input my data into the template? I have the last 18 months exported from my checking account into a csv file. Do I just select all the data an paste into the cash flow database or do I need to format my csv file to look like cashflow first then paste. Am I follow the flow correctly? Your help/comments would be appreciated.

[@elliebrooke2246]

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!

[@sunidhijain725]

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?🥺

[@davidtopp1972]

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.

[@bartoskii]

Is there a video on how to build this? I'd love to learn from it!:)

[@karimbenjellountouimi8578]

Thank you so much !! This is sooooo helpful

[@helle9075]

Thank you so much for this!

[@abhimanyubanerjee3999]

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!

[@RedGregory]

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.

[@abhimanyubanerjee3999]

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

[@jomibaja]

Amazing your video!! thank so much !!!

[@jasinAmsterdam1976]

I wonder what enhancements can be made to this with the new and improved formulas 2.0

[@adoravelcacto8508]

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

[@HiImRack]

Aw man, I really need help on this part: 3:30 I'm trying to figure out how you connected those dots for "SPEND"

[@yossefnabil2122]

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?

[@KylfatherPLAYZ]

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

[@Larry0220]

Very good and useful!!!🙂

[@MidGenius]

Great template

[@sirajgraphy]

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.

[@theselfmadecrafter]

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

[@user-luqa]

You are AMAZING!

[@mlanc7775]

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?

[@atulvhanmane]

you are amazing , thanks.

[@shironekojamo]

It sounds weird but are you a computer science student? You are truly a genius 😂😂😂

[@ehabgalal9050]

Great job thanks for sharing

[@RedGregory]

Thanks for watching!

[@Pyra_mis]

Why the total in budget is counting all month’s cash flow? Can it be only calculate the spending of each month?

[@RedGregory]

Each month page should calculate only for that month

[@Pyra_mis]

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]

Or the budget page should have each page for each month?

[@RedGregory]

@@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.

[@leslietriestodoart479]

@@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 ?

[@sophiesandham4134]

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

[@khanh685]

You are superb!

[@adoravelcacto8508]

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 💪🏼

[@adoravelcacto8508]

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

[@paxmash]

Well done ,Genius!!!!!

[@Salamaleikum80]

Is it better to have expenses and income in one table or split them?

[@ArchiboldMimic]

THis is great, Thank you

[@reneeproulx2345]

Is there any way to change the budget view inside of each month to that months spending?

[@camilaramirezzapata994]

This is so cool! Thanks🔥🔥🔥 and you're gorgeous🙃

[@crazypple]

is it possible to copy it without having to going throu all those steps and getting the finale result in the video? please tell me how?

[@bellajade]

how do i start a new month? I tried to create one for jan but idk how to separate it from last month.

[@arielchenpin]

13:50 thank you!

[@ahbiao]

is it possible for this budget planner to have the calendar start from 10th of each month till 10th of next month?