Advanced Bank Reconciliation using Excel

(1) Share

Report

Posted on by Sneha Mani

320

Hi Members,

Is it feasible to perform Advanced bank reconciliation using Excel format in D365 F&O? If so, kindly assist me in solving this.

Thanks in Advance,

Sneha

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Hana Xue Microsoft Employee on at

Like (1)

Report

Hi,
Finance supports three bank statement formats out of the box: ISO20022, MT940 and BAI2. You can check out the example in the links below:
Dynamics 365 for Operations – Import Bank Statement using BAI2 format - Microsoft Dynamics 365 Blog
Set up the advanced bank reconciliation import process - Finance | Dynamics 365 | Microsoft Learn
Best Regards,
Hana

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

No. That would require a customization.

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
As Frank said, it needs to be customized because Finance only supports three bank statement formats out of the box. If the answer is useful, please mark it as verified to help more people. Thanks in advance.
Best Regards,
Hana

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi,

Just as addition to others , You can import bank statement from excel file but it would require certain transformation which will lead to some technical help.

Now for customization you can explore the option based on electronic reporting.

Apart from that if you can prepare data manually in excel as per data entity format for bank statement, you can try that as well.

Was this reply helpful? Yes No
Deepak Agarwal 8,598 on at

Like (0)

Report

Hi Sneha,

Whats the business requirement, the bank reconciliation must be based on files received from bank and most of bank provides MT940 files.

Was this reply helpful? Yes No