Finance | Project Operations, Human Resources, ...

convert excel to ISO20022

(1) Share

Report

Posted on by christos orfaneas

Hello everybody,

I need some help, is there any mechanism in dynamics 365 that can convert an excel formatted bank statement to a format (ISO20022, MT940, and BAI2) that advance bank reconciliation can define? is there any tutorial for this?

thx in advance

Christos Orfaneas

I have the same question (0)

All responses (2)

Answers (0)

christos orfaneas 10 on at

Like (0)

Report

RE: convert excel to ISO20022

Honestly thx for your interest Ludwig,

What I need is a mechanism which I will import a bank statement and this mechanism will recognize which journal are already posted, which are missing and if everything is ok to define the bank account as reconciled.

At this moment I have read and follow the article docs.microsoft.com/.../set-up-advanced-bank-reconciliation-import-process and I thought that the advanced bank reconciliation is the app that I need, but for the app is necessary statements to be at these formats ISO20022, MT940, and BAI2.

Thx in advance

Christos Orfaneas

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: convert excel to ISO20022

Hello Christos,

If you want to import the Excel data into the bank statement form then you don't need a prior transformation but can make use e.g. of electronic reporting. Is this what you try to do?

Best regards,

Ludwig

Was this reply helpful? Yes No