Activating Completion Rate Percentage Tags
To enable this feature:
Go to the Options menu in the top right corner of your Cashflow plan.
Click on Show comparison with forecast.
Please note:
These settings are kept regardless of the scenario displayed.
Settings are specific to your web browser (saved using cookies):
They persist while navigating between different entities on the same browser.
They are not kept if you change computers or browsers.
They are not shared between users, unless another user logs in on the same computer and browser.
Understanding Completion Rate Percentage Tags
The completion rate percentage shows how close you are to achieving your forecast with your registered transactions.
Percentage Computation
For standard setups where your forecast frequency matches the display frequency and forecast is set at the consolidated level, the calculation is:
Completion Rate (%) = (1 - (Gap to Forecast / Forecast)) × 100
Where:
Forecast is the forecasted amount for a category in a given period.
Gap to Forecast is the difference between the forecast and the sum of paid and expected transactions.
Calculated as:
Forecast - Sum of Transactions (paid and expected)The Gap to Forecast is always ≥ 0.
Example:
Forecast: €1,000
Transactions (Paid + Expected): €800
Gap to Forecast: €1,000 - €800 = €200
Completion Rate: (1 - (200 / 1,000)) × 100 = 80%
Colors and Their Meanings
The percentage tags are color-coded for quick understanding:
Inflows
🟢 Green: Good news! This forecast was achieved or exceeded.
🟠 Orange: There's a gap to forecast (applies only to past periods).
⚪ Grey: All other cases.
No Percentage Displayed:
No forecast defined.
Forecast value is zero.
Comparison is disabled.
Outflows
🔴 Red: Warning! This forecast was exceeded.
🟠 Orange: There's a gap to forecast (applies only to past periods).
⚪ Grey: All other cases.
No Percentage Displayed:
No forecast defined.
Forecast value is zero.
Comparison is disabled.
Consolidations and Computation Modes
Consolidation by Category
Each entity's computation mode is overridden.
All computations are in individual mode.
Consolidation by Company
Each entity's own computation mode is used.
Tips 💡
Consistent Frequency: For accurate percentages, ensure your forecast frequency matches your display frequency.
Browser Specific Settings: Remember that your settings are browser-specific. If you switch devices or browsers, you'll need to re-enable the feature.
Understanding Gaps: Use the Gap to Forecast to identify areas where you need to focus attention to meet your financial goals.
Q&A ❓
Why isn't the completion rate percentage showing for some categories?
Possible Reasons:
No forecast defined for that category.
Forecast value is zero.
Comparison feature is disabled.
How does aggregation affect the completion rate?
When changing the display frequency, offsets are grouped (e.g., days into weeks, weeks into months).
Each offset is independent, and the computation considers each separately.
Aggregated forecasts may not proportionally reflect individual offsets if frequencies differ.
Can I see completion rates for individual bank accounts?
Yes, but only if the forecast is set at the account level.
Calculation:
Only includes transactions and forecasts from bank accounts where a forecast is defined.
Accounts without a forecast are excluded from the calculation.