How-to use AI pattern in cash flow forecast premium

Modified on Thu, 12 Nov at 2:24 PM

Print

If there are forecast rows e.g. Income Sales, Salaries, Rent etc that have a historical pattern that you want to use to predict the future cash flows Moneypennys AI function can help you forecast those rows. The first step is to import Actual forecast via Autopilot for the AI to use when predicting future cash flows; then it is possible to try out the prediction per forecast row and if it gives a reliable prediction it is possible to apply automatically for each new forecast period . 


AI pattern manual

AI function can be tried out on each row and it is possible to set a start date if it should not be applied on the forecasts first date.  

  1. Open the forecast and select the row's cell.
  2. Open Recurring Cash Flow and switch on AI Pattern.
  3. Check Bank Holiday Calendars. They are preselected from your locale and the row's currency, and you can change them. Without a calendar, bank holidays are ignored.
  4. Set Prediction Start Offset. Actuals are kept up to the offset, and predictions follow.
  5. Select Run Evaluation to see a preview, then apply if you want to use the prediction. 



AI pattern Automatic

Active the function via the template

 

  1. Open the template's commercial rows.
  2. In the AI Pattern column, switch on Use AI Pattern, then set the start date and calendars. The calendar for your locale is preselected. AI pattern  will overwite manual entries and recurring flows from start date. (All history will be kept for review) 
  3. Only tagged rows with no child rows can use it.
  4. To use different settings for different currencies or entities, add identical rows, one per combination, and configure each separately.


Run the batch (first time)

 

  1. On the forecast overview, select one or more forecasts.
  2. Select AI Pattern → Apply from template.
  3. Each forecast shows a spinner while it runs, and a warning if nothing could be applied.

 

Completed forecasts are skipped. Rows that already have a function, and rows with too little history, are also skipped.


TS will automatically apply the AI function when the next forecast period is created. 


Subsidiaries use AI pattern

Subsidiaries want to use the AI prediction on multiple rows 


  1. Open Submit 
  2. Hover over the widget for the entity you want to use AI pattern
  3. Click on AI pattern. 



What happens to existing amounts

 

  • From the start date, AI Pattern adds adjustments so each day matches the prediction. This overrides manual entries and recurring flows from that date. The earlier amounts stay in the history.
  • Edits you make afterwards sit on top of the prediction.
  • Forecast status overview: Remove takes away all AI Pattern functions and amounts. Manual edits are kept.
  • Apply again after a removal to recreate the pattern.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

More in Cash Flow Forecast Premium

Still need help? Reach people who already know your configuration.

Submit a ticket