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


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 an example dataset
Forecast start date

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)

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

The conflict icon in the forecast tab 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?