Converting Excel to MT940 every month using some Third-party tool is cumbersome, we believe that Microsoft can add more flexibility to customer by adding more formats to ABR statement ER formats.

This request stems from the challenges our customers are facing when attempting to convert Excel bank statements to MT940 format for importing into Dynamics 365 system.

As you are aware, our customers rely on the efficiency and accuracy of their financial data integration with D365. However, a recurring issue has emerged where Excel bank statements, which are commonly provided by banks, need to be converted into the MT940 format before they can be imported into Dynamics 365 system. This conversion process can be cumbersome and error-prone for many of our users.

To address this challenge, we are exploring the possibility of creating a seamless solution that would allow our customers to directly import Excel-based bank statements into D365 without the need for manual MT940 conversion. Specifically, we are interested in:

• Deriving existing ABR Statement model, MT940 mapping, and MT940 format into Excel, ensuring that all relevant data fields, relationships, and formatting are preserved.

• Establishing a standardized Excel format that aligns with the requirements of our system, making it easier for our customers to import their bank statements without errors.

We believe that this enhancement would significantly improve the user experience for our customers and reduce the complexity.