What is the Consolidation Cashflow Plan?
Your consolidation plan mirrors the structure of an entity cashflow plan. It displays a cashflow graph, a detailed table of inflows & outflows (grouped by entity or category), and key performance indicators (KPIs).
How to access the details panel
Filter Your View:
If you manage several companies, set the Entity filter to display one company at a time.
Ensure you have access rights for the chosen company.
Open the Panel:
Click on a cell (in the graph or table) corresponding to a specific offset or category.
A panel will appear showing two lists:
Paid transactions (when cell is in the past)
Expected transactions and forecast (when cell is in the future)
Navigate to Transactions:
Use the ↗️ button to jump directly to the bank/expected page of the respective company.
You can modify transactions directly from this panel if you have the appropriate rights.
How to use KPIs for quick insights
The consolidation includes KPIs already implemented to help you understand your cashflow figures:
Ignored Transactions: Displays details per entity.
Ignored Bank Accounts: Lists transactions from accounts not considered in consolidation.
Exchange Difference: Shows the computed gap due to multi-currency conversions.
👉 Exchange Difference Details:
Consider Account A with a $100 balance displayed in €. With a conversion rate change (e.g., from 0.95 to 0.90), a $5 gap appears due solely to exchange rate evolution. This KPI helps you spot such variances.
How to recalculate your cash balance
Recompute the final balance for a past offset using this formula:
Cash Balance (beginning) + Inflows (from table) - Outflows (from table) + Ignored paid transactions (KPI) - Transactions from ignored accounts (KPI) - Transactions from ignored categories + Exchange difference (KPI) = Cash Balance (end)
Follow these steps:
Note your starting balance for the selected offset.
Sum the inflows and subtract the outflows.
Adjust by adding ignored paid transactions and subtracting transactions from ignored accounts/categories.
Finally, add the exchange difference shown in the KPI to get the ending balance.
💡 Tips
Single Entity Focus: Use the entity filter to avoid mixing transactions from multiple companies.
Direct Navigation: Click the ↗️ button only when a single company is displayed.
Rights Check: Ensure you have proper access before attempting to modify transactions.
Consistent Review: Regularly review KPIs to understand discrepancies in your cashflow numbers.
FAQ ❓
How do I filter my consolidation plan by a specific company?
Use the Entity filter available on the cashflow plan view to display data for one company at a time. This ensures that when you click a cell, the details panel reflects only the selected company’s transactions.
Why might I see differences in cash balance numbers between an entity plan and the consolidation?
Differences can arise due to the forecast computation mode. In consolidation by category, the mode is set to individual, which may lead to variations compared to an entity plan if global mode is used on the entity.
How is the exchange difference calculated and why does it matter?
The exchange difference is the gap resulting from applying different exchange rates in the cashflow table versus cash balances. It helps explain minor discrepancies caused by currency rate evolution, despite no actual transaction affecting the balance.
What should I do if I need to modify a transaction?
Ensure you have access rights for the company. Then open the details panel by clicking the related cell, and modify the desired transaction directly from the panel.