Cash Flow

Cash Flow -report gathers projects' invoicing forecasts which can be grouped by projects, customers or project managers. It consists of three sections:

- Budget Numbers
- Follow up
- Invoicing Forecast


Budget Numbers


Income budget = 
Own income budget + External income budget + Other income budget (Project's Dashboard, Financials section)

Invoiced =
Amount of invoiced money (Project's Dashboard, same number as the Project Numbers -table offers)

Uninvoiced =
(Income Budget + External Income Budget + Other Income Budget) - Invoiced

Realized hours =
Total actual hours for the project (Registered in the system through the Timesheet functionality or via integration)

Expenses =
Amount of fixed expenses (Project's Dashboard, same number as the Project Numbers -table offers)

Invoiced /h =
Amount of invoiced currency / actual hours registered for the project

Uninvoiced work =
Invoiceable actuals that are not yet invoiced (shown in currency)

Example data of Cash Flow -report


Follow-up


Realization = SUM of all Invoiced (Same as Project Numbers -table's Invoiced SUM)

Forecast = Allocations * Project role's hourly rate

Total = Realization + Forecast

Realized hours = Amount of all realized hours for the project

Future reservations = Amount of all future allocations (in hours)

Total hours = Realized hours + Future reservations

Expenses = SUM of all Fixed Expenses (Same as Project Numbers -table's Fixed Expenses SUM)

Turnover /h = Total / Total hours (indicates the value of how much one hour brings money from the project for the company)

Profitability % = Total / Expenses

Follow-up table sums up more financial data for the project


Invoicing Forecast 


Invoicing Forecast -tab lists the invoiced and uninvoiced numbers for the project.
Filters and example of results for some projects

Calculations & numbers


Cash Flow report's "Invoicing forecast" tab uses current date as cut-off date by default and calculates numbers according to the following equations:

Before the selected date: Actual hours for the project * hourly rate (from person/role)
After the selected date: Allocated hours for the project * forecast price (from person / role)

Filters allow you to change the selected date (current day / 1st of this month / 1st of next month / select date)


The same numbers can be seen from the Project Numbers -section on the Project's Dashboard. The invoiced-row in Project's Dashboard is prioritized and shown over Uninvoiced row in the report.
Note: the example below does not correlate with the screenshot above.
For november 2019 the report will show 74,007. For December the Invoiced Row is prioritized and the report will show the Invoiced value of '5,000' - same goes for March 2020 found right side of the report.


Conflict icon


The conflict icon in the forecast tab indicates all the projects that have their forecasts calculated with global (default) prices.

How did we do with this article?