web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Bank Statement Import
Small and medium business | Business Central, N...
Answered

Bank Statement Import

(8) ShareShare
ReportReport
Posted on by GS-17051342-0 360

I’m currently working on importing a CSV file from our bank into Business Central. I’m about 90% complete, but I’m running into a couple of issues on the final step and could use some guidance.

The CSV file provided by the bank has two separate columns—one for debits and one for credits. When I import the file, all credit amounts are coming in as zero, and the debit amounts are importing as positive values instead of negative.

Specifically, I’m trying to understand:

  • Why none of the credit amounts are being recognized during the import

  • Why the debit amounts are not coming in as negative values

Any insight into what might be causing this or how to adjust the import mapping would be greatly appreciated.

 
 
Bank CSV File
 
 
 
 
Business Central
 
 
 
 
Data Exchange Definition
 
 
 
Field Mapping
 
Categories:
Dynamics 365 Business Central
I have the same question (1)
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 32,319 Super User 2026 Season 1 on at
    The issue with credits not being imported is that in your statement the debit columns contain 0 instead of a blank cell when the debit amount is zero. Because of this, the system reads the 0 value first and imports that. That is why the first line is importing 0: it is reading the 0 from the debit column instead of skipping it and reading the 853.12 from the credit column. As far as I know, there is no out of the box solution for this. A developer would need to customize the import. Unless you can get a statement from your bank without the zeroes. 

    For debits not being imported as negative amounts, you need to set the Multiplier field on the Field Mapping page to -1.00:
     
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,322 Super User 2026 Season 1 on at
    Hi, hope the following can give you some hints.
    Dynamics 365 Business Central: Add more custom processing when importing Bank Statement (Bank Export/Import Setup) – Customization
     
    PS: Dynamics 365 Business Central Blog Series: Import and Export data
     
    Thanks.
    ZHU
  • Verified answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 2,898 Super User 2026 Season 1 on at
    Hi,
     
    If you can get Blank instead of 0 in the Debit and Credit columns, you can follow the below blog and do the setup.
     
     
    It will fail if 0 is there, as 0 is value and not blank. You can remove the 0s in CSV before importing.
    Alternatively you need to customize the Import codeunit to handle this.
     
    Regards,
    Dhiren.
     
     
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 13,316 Super User 2026 Season 1 on at
    Hello,
     
    This happens because in Bank Statement imports BC only uses one Statement Amount per line and does not flip signs automatically: you mapped both Debit and Credit columns to Statement Amount, so whichever mapping runs last overwrites the other (resulting in credits = 0), and debit values stay positive because BC assumes the file already provides the correct sign. The fix is to map only one Statement Amount and either use transformation rules (Debit × -1, Credit as-is) or handle it in the Mapping Codeunit (1248) by setting Statement Amount := -Debit when Debit ≠ 0 and Statement Amount := Credit otherwise—this is standard, expected behavior.
     
    Regards,
    Oussama Sabbouh
  • GS-17051342-0 Profile Picture
    GS-17051342-0 360 on at
     
    I like your way the best. Where do you get the multiplier field in your field mapping. As you can see in my photo. That option does not exist.
     
     
     
  • GS-17051342-0 Profile Picture
    GS-17051342-0 360 on at
     
    I found the multiplier by adding it using personalization. All looks good now.
     
     
     
  • Suggested answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 2,898 Super User 2026 Season 1 on at
    Hi,
     
    You need to bring the field out through Personalization or Profile Customization.
     
     
     
    I hope this helps.
     
    Regards,
    Dhiren

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,922 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,078 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 628 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans