Skip to main content

How to allocate your forecast as expected transactions?

Turn your monthly or weekly forecast into daily expected transactions to keep your cash position more precise.

Updated yesterday

What is this feature?

Allocation rules let you specify on which day(s) and which bank account your existing monthly or weekly forecast will appear as expected transactions. Once applied, the system removes those expected transactions on their due date, keeping your view accurate.

For customers with a weekly input forecast frequency, you can create allocation rules to allocate forecasts on specific days of the week (Monday, Tuesday, …, Sunday). This allows for more accurate data on cash positioning, especially for short-term forecasts involving salaries, taxes, recurring spending, or B2C inflows with strong intra-week seasonality.

New Updates:

  • You can now choose a different bank account for each condition in your allocation rule. This includes bank accounts in any currency, with automatic conversion using the exchange rate of the 1st day of each month.

  • For categories with a forecast input level, you can now select a mother category and assign subcategories for each condition of the rule.

  • The number of conditions you can add to a rule has increased to 30, giving you greater flexibility in managing your forecasts.

  • Allocation percentages can now include up to 3 decimal places, allowing for more precise distribution of your forecasts.

  • You can modify the amount, date, and bank account of each expected transaction created from an allocation rule. Once modified, these transactions will no longer be updated through the allocation (neither the date, amount, nor bank account). You can also view the initial values of the modified transactions for reference. However, if the allocation rule itself is changed, all modifications will be overridden.

These updates ensure that the feature is now accessible to customers with multiple currencies and those managing B2C inflows, providing more flexibility and precision in cash flow management.

How to configure allocation rules?

  1. Click on drop down menu next to allocate forecast in the Cash Positioning module and on manage allocation rules.

  2. Add a new rule by selecting:

    • A category with a forecast input level. (The category must be a leaf category, or you can now select a mother category and assign subcategories for each condition.)

    • A bank account. You can now select accounts in any currency, and the system will handle currency conversion using the exchange rate of the 1st day of each month.

    • The specific day(s) you want to allocate your forecast amount. For weekly forecasts, you can now select specific days of the week (e.g., Monday, Wednesday, Friday).

    • Up to 30 conditions, with allocation percentages that can now include up to 3 decimal places for precise distribution.

  3. Save your rule to confirm your choices.

  4. Manually trigger the allocation by clicking on allocate forecast so you can reflect your updated forecast in your cash position.

How it works?

  • Expected transactions are labeled for easy identification (e.g., “Allocated from forecast of Your CategoryDate”).

  • They are automatically removed on their due dates to keep your cash position clean.

  • If a rule becomes invalid (due to a deleted category or account, or if the category or bank account no longer meets the requirements), the system removes all related expected transactions on the next allocation and displays an error message in the settings.

  • Expected transactions created from the allocation can now be modified. You can adjust the amount, date, or bank account of these transactions. However, once modified, they will no longer be updated through the allocation. If the allocation rule itself is changed, all modifications will be overridden.

  • You cannot choose to mark the resulting expected transactions as paid for now.

💡 Tips

  • Combine several rules to break down a monthly or weekly forecast into multiple days, so you can anticipate recurring expenses more precisely.

  • Manually trigger the allocation whenever you update your forecast for a real-time view of your cash position.

  • Use this feature for social, taxes, recurring spendings (e.g., rents, subscriptions), or B2C inflows with strong intra-week seasonality to make them directly visible in your Cash Positioning and 13-week view.

  • Modify expected transactions individually to gain precise control over their amounts, dates, or bank accounts.

  • Take advantage of the ability to allocate forecasts across multiple bank accounts, currencies, and subcategories for more detailed cash flow management.

FAQ ❓

What if I need to change an expected transaction date?

You can now directly modify the date, amount, or bank account of an expected transaction created from an allocation. Once modified, these transactions will no longer be updated through the allocation. If you need to reset them, you can adjust the allocation rule and reallocate. Keep in mind that if the rule itself is changed, all modifications will be overridden.

Do these transactions appear in my 13-week view?

Yes. They show up as daily expected transactions on the days you selected, providing a clearer short-term cash forecast.

Is the allocation automatic?

No. You need to click the allocate forecast button in the settings whenever you want to bring your forecast changes into your daily cash position.


Did this answer your question?