Small and medium business | Business Central, N...

Bank statement - Data exchange definitions

(5) Share

Report

Posted on by STP

764

Hi all,

I'm going to setup the bank statement report in BC.

I've got the CSV file from the user, the file contents the transactions in multiple currencies.

How do I setup the bank statement in BC?

Should I

1. Create 3 records of data exchange definition

2. Assign them to the bank with the corresponding currencies

3. Given that, the user is supposed to spilt the csv file into 3 (against currency), and then load them into BC

Is it how it works?

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Valentin Castravet 32,208 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Yes, that's exactly how it would work.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints as well.

Dynamics 365 Business Central: Add more custom processing when importing Bank Statement (Bank Export/Import Setup) – Customization

https://yzhums.com/44582/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,965 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello ,

Business Central bank statements are single-currency per bank account, so you don’t set this up with multiple currencies in one import. The correct and supported approach is one bank account per currency, using one Data Exchange Definition per file format; BC cannot automatically split or process mixed-currency transactions in a single statement. If the CSV contains multiple currencies, the user (or an external step like Excel/Power Query) must split the file by currency and import each file into the corresponding bank account. Anything beyond that requires custom development.

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,898 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Based on the logic of Bank Reconciliation, it matches statement amount and amount from Bank ledger entry. It does not match Amount (LCY). So basically it matched Amount in all currencies with Amount in your statement. Now I assume that amounts in your statement are also in multiple transaction currency and are not LCY values.

If this is the case you just need to import the statement amount as Amount in transaction currency from your statement. Just do not import Amount in local currency from your statement.

This way you can do import of statement from single Data exchange definition setup.

Let me know if you have any queries on this.

Was this reply helpful? Yes No