I want to create a template in which I can write all of my expenses and by putting a limit for each category having an overview of how much I can still spend. Any suggestions?
Connect
Notion Answers
Help between Notion users
Register & Ask
It's free & easy
Get answers
Answers, votes & comments
Vote and select answers
Receive points, vote and give the solution
Question
2 Answers
Create a table database and list the name of all your expenses in the name column add 3 more properties. 2 of them will be # values and the third one will be a formula.
The two # values are Budget and Actual Amount. Then you will edit the formula so the output will be subtracting the budget from the actual amount. The Formula property should be titled "Remaining Balance"
You can calculate in table view at the bottom a total sum of both your budget and remaining balance.
For a month to month overview use filters and make sure you add another property value select and title that Month the tags for the Months should be 12 in total OR however frequently you get paid if you wanted to use your pay cycle.
Related questions
- How to create a new database item based on a trigger status in another database
- How do I created a status formula based on the status/presence of multiple variables?
- How do I use rollups to pull in filtered data (e.g. total expenses for current month)? Finance/Budgeting Related.
- Is there a limit to how many databases I can create on Notion?
- How to use multiple if statements in one formula to return words based on tags
Without Answer
-
- 25
- 0
- 1 day ago
-
- 46
- 1
- 3 days ago
-
- 46
- 1
- May 29
-
- 243
- 1
- Apr 25
-
- 111
- 0
- Apr 25
-
- 185
- 1
- Apr 10
-
- 116
- 2
- Apr 9
-
- 116
- 1
- Apr 7
- see all
Exclusive for Notion Answers Users
- • Dynamic Calendar Icon | Info | Download
- Add yours here
Recent Activities
anonemousse666 commented 16 hours ago
Enable web-share users to filter for multiple valu…polle commented 17 hours ago
Is it somehow possible to have a clickable image i…MissNotion commented 17 hours ago
Is it somehow possible to have a clickable image i…polle answered 20 hours ago
How to create a left-side tree menu as a template …polle answered 21 hours ago
Is it somehow possible to have a clickable image i…