Skip to main content

Notifications

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

Bank statement import

Posted on by 245

Does anyone know how to map credit debit amount fields for bank statement import in Business Central? 
There is only statement amount field to map in data exchange definition. 

pastedimage1672983735567v1.png

pastedimage1672983831055v2.png

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,747 Super User 2024 Season 2 on at
    Bank statement import
    I wrote a blog post here about setting up bank statement imports and in my example I have a separate credit and debit field.
     
  • Suggested answer
    LS-28101658-0 Profile Picture
    LS-28101658-0 2 on at
    Bank statement import
    In the Field mapping screen you can use Multiplier field, which is hidden by default. With this you can map both credit and debit to statement amount.
  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Bank statement import

    It is typical for banks to give you two columns when we really need just one for the amount. I would reach out to your bank to see if there is another option for one column. If not, you will need to combine the values into one column before you import.

  • Suggested answer
    ShanAbeywicrema Profile Picture
    ShanAbeywicrema 940 on at
    RE: Bank statement import

    Just try to adjust your excel file, instead of two column for debit and credit, maintain one column for +,-

    Amount
      1,000.00
    -    500.00
    -    250.00
         200.00
           10.00

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans