Cash Flow

Cash Flow report gathers projects' invoicing forecasts and shows them 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


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 values for the project.

Filters and an example dataset
Forecast start date = Cash Flow report's Invoicing forecast tab uses current date as cut-off date by default and calculates values 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)

Show empty rows = Decide if you want to see totally empty rows in the dataset

Order results by value = You can order the dataset according to the total value visible in the screen. The biggest project will be on top and the smallest project in the bottom.

Conflict icon in the dataset = Indicates that project's one or more project role's pricing is calculated with the global (default) price.

How did we do with this article?