Dynamics Community Forum Thread Details

Hi everyone,

I am working with Advanced Bank Reconciliation (ABR) in Dynamics 365 Finance, and I am importing BAI2 files into the Bank Statement Lines (left grid). I am seeing a consistent issue across all transactions, not just specific codes.

Every transaction imported from the BAI2 file is appearing in the wrong debit/credit column in the Bank Statement Lines.

What I Have Verified

The BAI2 file is correct and matches the bank’s statement
The bank’s debit/credit direction is correct
No customizations exist on the ER format
The issue is only on the left grid (Bank Statement Lines)
The right grid (D365 bank transactions) is correct
Matching rules are not the issue
This is happening for all imported transactions, not just one code

My Question

When we import a BAI file should it or should it not mirror the Bank Statement? Should the bank statement mirror the bank statement lines? Meaning if the bank debited my account for $200 for a check that was paid, and gave me a credit of $1800 that came in my account as an ACH payment. In the BAI File the $200 is a Transaction code of 475 (Check Paid debit) by the bank and $1800 is a Transaction Code of 169 (ACH Credit Received) in the Bank statement lines? Should it be a mirror/replica of my actual bank statement.

If in the Bank Statement the Bank has the $200 in the debit column and $1800 in the Credit column - Where should they be in my Bank Statement Lines (In the RECONCILIATION WORKSHEET - Left Side GRID) ???

The left grid (Bank Statement Lines) is meant to represent exactly what your bank is reporting to you — it is the bank's view of your account, not the accounting/GL view.

Why is D365 reversing the debit/credit direction for ALL BAI2 transactions during import?

Is this caused by:

Incorrect debit/credit logic in the standard Electronic Reporting (ER) BAI2 model mapping?
A known issue with the default BAI2 configuration?
A mismatch between Microsoft’s assumed DR/CR ranges and the bank’s actual BAI2 coding?
A defect in the “Advanced bank reconciliation statement model → BAI2 format” mapping?