Finance | Project Operations, Human Resources, ...

Import Bank Transactions to Finance and Operations

(0) Share

Report

Posted on by Jenny P

Hi!

I am confuse because there are many options to do import bank transaction to the system. As I found the set up the advanced bank reconciliation import process. See below details.

Set up.the import of ISO20022 bank statement

Set up import of MT940 bank statements

Set up the import of BAIS bank statement.

On another hand the other option The Advanced bank reconciliation feature where it implicate the electronic reporting that I do not see the tab into the finance and operations dashboard.

I just want to import the bank transactions (NATWEST) TO finance and operations in order to reconcile and save time therefore authomotise process.

Could you please someone can help me to find the effective way to import bank transaction to the finance and operations system.

Thank you

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

JamesT 341 on at

Like (0)

Report

Dear Jenny,

You need to speak to NatWest (assuming this is your bank) and find out of they provide Bank statement file either MT940/BAI2 or ISO20022 (Camt.053) format.

1) If they provide a file in one of these formats then you need to setup D365FO for import - learn.microsoft.com/.../configure-advanced-bank-reconciliation

2) If they don't provide a file in one of these formats, they instead provide in a different format, then you need to work with a Technical resource to use Electronic reporting to create a NEW format for importing the NATWEST bank statement file.

Regards

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jenny P,

As James mentioned, it is important for you to contact your bank to inquire about their preferred method of delivering bank statement files and the specific format they require. Currently, Microsoft repositories offer standard formats such as Camt053, MT940, and BAI2.

After receiving clarification from your bank, you can consider adopting one of these standard formats or explore the option of creating a customized format for importing bank statement files into D365FO.

Was this reply helpful? Yes No
Jenny P 21 on at

Like (0)

Report

Hi!

Thank you for the response,

I am in the process to setting up the MT940 file in order to reconcile the bank transactions but I could not set up the format as the data management tab is missing in the dynamics finance dashboard. The file has been provided from the bank so I just needed to set up the file. I do not know if this is something to do with the electronic reporting configuration or do I need a permission?

Thanks in advance

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jenny,

You need to import MT940 configuration from Microsoft repositories and then add the configuration on bank statement format.

The process is somehow a like Camt053, please check my blog on how to import the configuration and add the setup for import bank statement:

ISO20022 Payment in D365FO for Norway – Part 9 (Import Camt.053 file) – DynFOTech

Was this reply helpful? Yes No

Join the conversation

Community site session details

Import Bank Transactions to Finance and Operations

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Import Bank Transactions to Finance and Operations

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates