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

Bank statement import

(0) Share

Report

Posted on by Nirmala Karunarathna

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.

All responses (4)

Answers (0)

Suggested answer

Valentin Castravet 24,747 Super User 2024 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/
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.
Suggested answer

Dallefeld 11,425 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.
Suggested answer

ShanAbeywicrema 940 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