Machine Learning in the Cashflow Forecast
Our Cashflow Forecasting tool allows the user to make predictions on GL Accounts and Debtors Invoices via our Machine Learning (ML) Algorithms.
Note: When using any Machine Learning functionality, these models represent only our Best Estimate based on your data.
No machine learning computation can be taken as a guarantee of what will happen in reality.
General Ledger Accounts
The General Ledger Account Machine Learning looks for two things to determine if a pattern exists:
- Is the pattern regular in Time (approx. the same days between payments)?
- Is the pattern regular in Amount (approx. same movement to/from account)?
To fill a GL Row (with one or more GL Accounts), right click the Row Header, and select Fill from ML.
If the above criteria are met, the row will populate with the predicted values, otherwise an error will appear notifying the user that a model could not be created.
If the above criteria are met, the row will populate with the predicted values, otherwise an error will appear notifying the user that a model could not be created.
The General Ledger Machine Learning also shows what we call the ML Health metric - a measure of how close to accurate we judge the algorithm to be.
This metric colours the ML-generated cells based on the accuracy - Green being a very good estimate, gradiating to Orange as a less good estimate.
Note: An orange cell is not 'bad' predictions, as 'bad' data would result in no ML prediction being made at all.
Debtors Transactions
The Debtors transactions Machine Learning looks at each customer's payment patterns over a range of invoice values, and looks for a pattern in these payments.
This pattern can be applied to the Debtors Invoices in your cashflow forecast by right-clicking the "Debtors Transactions" cell and clicking "Adjust Using ML"
The Debtor Invoices are then moved to the date that the algorithm assesses that the invoice will be paid, and can be adjusted manually if need be.
You can also restore invoices to "pre-ML" by right clicking and choosing Restore Invoices to Due Date.
Note: Invoices created or synced into Forecast.Live after this button is clicked will not have Machine Learning applied to them - we recommend re-applying Machine Learning to the Debtors row every day or two to have the most up to date information.
Need more information?
Pop us a support ticket to Support@Plus.Live
Related Articles
The Cashflow Screen functionality
Once you've setup your first Cashflow (see this KB article HERE) you'll be presented with this screen: Let's explain this in more detail. Important: With the exception of the Column Headers and Bank Row, all of the below items have additional ...Setting up your First Cashflow Schedule
Setting up a Cashflow within Forecast.Live is easy! In fact, because we’ve created a Data Connector between your Accounting and Forecast.Live, the real time Cashflow Forecast is ALSO QUICK to roll out. Important: To generate a Cashflow, ...Upcoming Forecast Email
This email is for the financial manager that wants an easy to visualize look at their week or fortnight to come, and a breakdown by General Ledger Groups. This relies on a Cashflow Forecast being set as the Focus Forecast. Setup Email - the recipient ...The Control Center Forecast Widget
This new view allow a user to quickly view their upcoming Cashflow based on their Focus Forecast (as set from the Cashflow Forecast screen). There are three major elements in the widget: Daily Movement - the total movement across all Rows, Debtor, ...Weekly and Daily Forecast Views
Forecast.Live's Cashflow Forecaster allows each Forecast to default to a Daily or Weekly view. To do this, head to the Default View pull down menu (in the Forecast Setup area) ad set the appropriate setting Forecast Settings -> Add/Edit/Copy Forecast ...