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.
- Open the forecast and select the row's cell.
- Open Recurring Cash Flow and switch on AI Pattern.
- 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.
- Set Prediction Start Offset. Actuals are kept up to the offset, and predictions follow.
- 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
- Open the template's commercial rows.
- 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)
- Only tagged rows with no child rows can use it.
- To use different settings for different currencies or entities, add identical rows, one per combination, and configure each separately.
Run the batch (first time)
- On the forecast overview, select one or more forecasts.
- Select AI Pattern → Apply from template.
- 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
- Open Submit
- Hover over the widget for the entity you want to use AI pattern
- 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.