Overview
The Balance Overview displays your cashflow snapshot by consolidating data from all selected companies regardless of consolidation filters.
• It excludes bank accounts that have been ignored from the cash balance.
• It automatically applies the lowest frequency among consolidated companies if their objectives differ.
• The default view is weekly; if you choose a lower frequency, only expected transactions are shown.
Custom Thresholds
Customize your table’s visibility and highlight important values.
Click on the Thresholds settings button.
Add your desired thresholds by setting conditions, and select a color for each rule.
Decide whether to apply them on companies, bank accounts, or both.
• If several rules apply, the latest added rule will take effect.
Exporting the Table
Easily export your cashflow data with all necessary tabs.
Click on the Export button in either the old or new cashflow plan interface.
Assuming you selected a periodicity that meets your companies’ forecast input, you will receive an Excel file per download.
• Note: Custom thresholds settings and the original currency display option are not exported.
Details Panel
Access more information on individual transactions in the Balance Overview.
Click on a cell in the table to open the details panel on the right side.
This panel is available only when the Expected Transactions and Forecast Values option is selected.
• If forecast is set at the company level, forecasts will not appear on bank lines in the table.
Advanced Settings
Display in Original Currency
• Click the dedicated button to toggle between original currency and the consolidations' currency.
• The setting is saved locally for each user.
• Exported files do not reflect this toggled view yet.
Group Table Options
• Choose to group bank accounts by entity or by currency using the grouping settings.
• Your current grouping setting will be applied to the export.
• When one entity uses "forecast at the entity level", grouping by currency forces the filter to Expected only and ignores forecast values.
• Thresholds filtered by “companies” aren’t applied on the total group row, but filters for “All companies and accounts” are applied.
💡 Tips
• Double-check your consolidation settings if you don’t see all bank accounts.
• Review the order of your threshold rules to ensure the correct color is applied.
• Verify your grouping settings to manage forecast data as expected.
FAQ ❓
How do I change the view frequency?
Use the frequency dropdown in the Balance Overview. Changing the frequency adjusts the view to match your companies’ objective settings and determines whether objectives are included alongside expected transactions.
Why are some bank accounts missing from my balance overview?
Bank accounts excluded in your consolidation settings will not appear in this table. Check your consolidation filters to ensure all desired accounts are included.
How can I configure custom thresholds?
Click the Thresholds settings button, add as many threshold rules as needed with specific conditions and colors, and select if they apply to companies, bank accounts, or both. Remember that if multiple rules apply to a cell, only the latest rule is used.
How does grouping by currency affect forecast data?
If at least one entity uses "forecast at the entity level," grouping by currency forces the table to display Expected only values by ignoring forecasts on bank lines. If all entities have forecast per bank account, forecasts are included normally.