Forecast payment date

Hello everyone. I would like to predict the payment dates of the invoices issued to my customers.

For each customer I have, simplifying, a database with issue date, invoice number, payment due date, amount, payment date.

Obviously there are historical invoices and invoices that will expire in the future.
Of the latter I would like to predict when the customer will pay.

Any suggestions on which approach to use in knime? Any similar examples for reference?
Thank you
Joe

Hello Joe,

It seems that your use case can be addressed using Time Series models like AIRMA or LSTM, but it can get quite complex.

My recommendation would be to use Random Forest, a decision tree algorithm that can handle both numerical and categorical features such as issue date, invoice number, and amount. You can train the model on your historical payment data, and it would be able to predict payment dates for new invoices based on the input features.

Alternatively, you can use Neural Networks with Keras, and train the model to predict payment delay days based on input features. You may need to perform some feature engineering, especially since your input features contain datetime data. I suggest transforming these values into numbers that represent the difference in issue date vs payment date, etc.

I hope this helps. Let me know if you have any questions.

Best regards,
Jinwei

2 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.