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

Bank statement import

(0) Share

Report

Posted on by Nirmala Karunarathna

291

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.

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

ShanAbeywicrema 954 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 235 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

LS-28101658-0 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,800 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

I wrote a blog post here about setting up bank statement imports and in my example I have a separate credit and debit field.

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