Cash Flow Dashboard Full View

Two Cash Flow Tables

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.

A Simple Cash Flow Alternative

[video]