Finance | Project Operations, Human Resources, ...

Bank statements imports with Electronic Reporting

(0) Share

Report

Posted on by CU30011428-0

I am trying to configure Electronic Reporting, and specifically, I need to import an MT940 format for bank statements in the system. When I do that I want the transactions from the statement to be created in d365 F&O, what do I need to set up and configure so I can get those transactions posted and reconciled?

Thanks

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Holly Huffman 6,554 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi there! Good morning, evening, or afternoon - depending on where you are :) Hope you are well today!

To configure Electronic Reporting (ER) for importing MT940 bank statements and ensure transactions are created, posted, and reconciled in Dynamics 365 Finance & Operations, follow these steps:

Set Up the Electronic Reporting Configuration

Navigate to Workspaces > Electronic Reporting.

Select the Microsoft configuration provider and open the repository.

Import the MT940 format configuration. If it's not available, you may need to download it from the Microsoft Dynamics Lifecycle Services (LCS) or create a custom configuration.

Configure the Bank Statement Format

Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Bank statement format.

Create a new format and select MT940 as the statement format.

Link the imported MT940 configuration to this format.

Set Up the Bank Account

Navigate to Cash and bank management > Bank accounts.

Open the relevant bank account and enable Advanced bank reconciliation.

Assign the MT940 format to the bank account under the reconciliation settings.

Import the Bank Statement

Go to Cash and bank management > Bank statement reconciliation > Bank statements.

Select Import statement, choose the bank account and MT940 format, and upload the statement file.

The system will process the file and create transactions based on the statement data.

Reconcile Transactions

After importing the statement, use the Bank reconciliation workspace to match the imported transactions with existing bank transactions in the system.

Post the reconciled transactions to finalize the process.

Test and Validate

Perform a test import with sample MT940 files to ensure the configuration works as expected.

Validate that the transactions are created correctly and reconcile without errors.

Was this reply helpful? Yes No
CU30011428-0 20 on at

Like (0)

Report
Copy link

Link copied!

@Holly Huffman

First of all, thank you so much for the detailed answer.

I already did that, but I have transactions that are not created in D365 so I can not match the transactions that I got from the import of the bank statement with transactions in the system. In that case is there a possibility to automatically create those or do I have to create those transactions manually in a journal and then match them?

Was this reply helpful? Yes No
Ramesh Kumar 7,547 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

As far as I know, you will need to reconcile and post the transaction manually, as the system won't handle it automatically. However, there are several third-party apps or tools available that can help automate the process.

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No