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

Bank statement import

(0) Share

Report

Posted on by Nirmala Karunarathna

275

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)

Suggested answer

ShanAbeywicrema 948 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 193 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

LS-28101658-0 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 30,066 Super User 2025 Season 2 on at

Like (1)

Report

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.

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