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

Multi-currency for bank statement import bank reconciliations

(6) Share

Report

Posted on by CU24021631-0

Hello.

I am looking to do a bank statement import for bank reconciliations. My bank is a UK bank operating in GBP and my D365 Business Central system entity is in USD local currency. When I do the statement import, it is setting the amount in USD. I tried setting my UK bank account card in GBP currency, thinking that during the bank statement import will import the lines in GBP and convert the amount to USD, but it is only taking it in USD. I have Currencies set up properly in D365 BC as well as the daily FloatRate job queue that have been operating fine in my Live BC environment. I am not sure if I need to update the Data Exchange mapping to an indirect table than table 274 for bank reconciliations as there is no currency field mapping to that table in the xml. I have also tried to import lines in the bank rec card, which still operates the same.

How can I get the amount to be acknowledged in GBP and then convert that amount to BC's USD local currency? Do I need an extension? Thank you very much in advance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

saroha varun 76 on at

Like (1)

Report

Here are some simple steps to help fix this issue:
1. **Bank Account Setup**: Make sure your UK bank account card is in GBP. Double-check just to be sure.
2. **Currency Exchange Rates**: Check the exchange rates in BC and make sure the FloatRate job queue is running correctly.
3. **Data Exchange Definition**: Adjust the Data Exchange Definition. Since table 274 doesn't have a currency field, map the currency from your bank statement to another table or use indirect mapping.
4. **Custom Extension**: If the standard setup doesn't work for you, create a custom extension:
- **New Table**: Create a new table to temporarily store imported bank statement lines with currency info.
- **Import Process**: Change the import process to bring bank statement lines into the new table.
- **Currency Conversion**: Convert amounts from GBP to USD using BC exchange rates.
- **Transfer Data**: After conversion, move the data to the Bank Account Reconciliation table (table 274).

example of how you might approach this in AL code but check with your techie before using this

table 50100 "Bank Statement Temp"
{
    DataClassification = ToBeClassified;

    fields
    {
        field(1; "Line No."; Integer)
        {
            DataClassification = ToBeClassified;
        }
        field(2; "Amount (GBP)"; Decimal)
        {
            DataClassification = ToBeClassified;
        }
        field(3; "Amount (USD)"; Decimal)
        {
            DataClassification = ToBeClassified;
        }
        // Add other necessary fields
    }
}

codeunit 50100 "Bank Statement Import"
{
    trigger OnRun()
    begin
        // Import logic to read the bank statement and populate the "Bank Statement Temp" table
        // Convert the amounts from GBP to USD
        // Transfer the data to the standard Bank Account Reconciliation table
    end;
}

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,453 Super User 2025 Season 2 on at

Like (2)

Report

When I do the statement import, it is setting the amount in USD.

What do you mean by this? A bank reconciliation is done in the currency of the bank. So if your bank card is GBP, the bank reconciliation won't have a currency code, but the assumption is that it's in GBP. There should be no conversion to the local currency.

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

Saif Ali Sabri 2,351 Super User 2025 Season 2 on at

Like (1)

Report
The issue is that Business Central (BC) is interpreting the imported bank statement amounts in the system's local currency (USD) instead of the bank account currency (GBP).
Solution:

Check Bank Account Setup:

Go to Bank Accounts and ensure the Currency Code for the UK bank account is set to GBP.

Verify Data Exchange Definition (DED):

Navigate to Data Exchange Definitions and check your mapping.

Table 274 (Bank Account Reconciliation Line) does not include a currency field, so BC assumes amounts are in the local currency (USD).

Modify Data Exchange Mapping:

If your bank statement file contains a currency field, modify the Column Mapping in your Data Exchange Definition to correctly map the Currency Code.

If the currency field is missing in the file, the system will assume amounts are in USD.

Use Bank Statement Currency Recognition:

If BC does not support multi-currency handling natively in bank reconciliation, you might need a customization (extension) to:

Read the currency from the imported file.

Convert the amounts using the exchange rate at the transaction date.

Alternative Workaround:

Manually adjust the amounts in the Bank Reconciliation journal by using the correct exchange rate before posting.

Or, if possible, ask your bank to provide statement files that include explicit currency information.

Conclusion:
Since Table 274 does not handle currency, a customization (extension) might be required to import amounts in GBP and convert them to USD properly. Alternatively, consider modifying your bank statement format or manually adjusting entries before posting.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,441 Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps: https://dynamicscommunities.com/community/groups/d365ugbc/forum/topic/multi-currency-for-bank-statement-import-bank-reconciliations

Was this reply helpful? Yes No