The are two databases to record all cash flowing in (income) and out (spending).
They have 12 database views each from January to December.
And a property filtered to automatically fill Month relation that associates with each month view. All relations connect to Monthly Calculator.
Monthly Calculator Table
From the cash flow in (Income)and cashflow out (Spending)relations, two rollups are made; In and out are configured to show the amount sum of their corresponding relations:
The In and Out rollups are used inside a formula property to find the Total sum from subtracting both rollups (In - Out).
if(or(not empty(prop("In")), not empty(prop("Out"))), prop("In") - prop("Out"), toNumber(""))
If the Total is positive, a graph pointing up is shown in another formula property. If the total is negative, a graph is shown pointing down.
if(prop("Total") > 0 and or(not empty(prop("In")), not empty(prop("Out"))), "Up 📈", if(prop("Total") < 0 and or(not empty(prop("In")), not empty(prop("Out"))), "Down 📉", ""))
Yearly Calculator Table
Each month inside the Monthly Calculator is connected via a relation property to the year. In this case, 2021. Each month is also connected to its corresponding quarter (1-4). The year and four quarters reside in the yearly calculator shown below.
Here you’ll find the total net sum of incoming payments for the year. After determining the Start Amount, a running balance will update as entries are added to the two Cashflow databases.
How to create a one-click checklist using Notion. This includes a free template that can be used for personal or professional tasks. The recurring checklist is designed to simplify the process of adding checklists and completing projects, allowing you to focus on what needs to be done rather than spending time recreating repetitive to-do lists.
Notion formulas can now be used to create clickable links that make constructing and navigating URL links a breeze. Creating clickable links in Notion formulas only requires inputting the correct code that results in a url syntax (https://www.website.com/…). Below are instructions on how to generate clickable links in Notion formulas for maps, social media searches, Twitter profiles, Wikipedia, Goodreads, and Amazon.
There are many reasons why Notion is a great note-taking app. For starters, it's extremely user-friendly and easy to use. The interface is clean and simple, making it quick and easy to find what you're looking for. There are also tons of features and customization options available, so you can tailor the app to your specific needs. Here is how you can get started.
Utilize the immensely useful Notero integration with Notion to save and organize citations and web clippings from the Zotero browser extension and app. In this short tutorial, I show you how to get started with Notero in 2022, and where to add integrations in Notion. Here’s how it works.