web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Advance bank Reconciliation (Reconcile after import)

(0) ShareShare
ReportReport
Posted on by

Hi Everyone,

I am trying to import MT940 bank statement and perform advance bank reconciliation in D365F&O. I start my process by importing the bank statement using the import statement functionality in the bank statement form. Notice that while I perform this task I check box "Reconcile after import" to Yes. I want to ensure that the system validates and performs the matching after the statement are imported.

Image

The statements are imported successfully but only the first statement is validated and matched. The remaining statements are not validated and matched.

Image

If you look at the reconciliation worksheet, the system successfully performs the bank reconciliation for the first statement only.

Image

Why is D365 not validating and matching the remaining statements?

Also, when I try to import MT940 bank statement with Check box "Reconcile after import" to No the statements are imported successfully. Then I select and validate each statement and create the reconciliation worksheet. I run the matching rules on the reconciliation sheet and all the transaction are matched and the status of the bank statements changes from validated to Matched.

Image

I wanted to know why the system is not validating and matching all the bank statement when I try to import the file with "Reconcile after Import" as Yes.

I have the same question (0)
  • Ding Li Profile Picture
    480 on at

    Hi Ali,

    do you have any customization on this process? Can you reproduce the same issue using Contoso?

  • ThuNgo Profile Picture
    978 on at

    Hi,

    Did you able to solve this issue? I also faced the same on testing environment.

    Thank you,

    Warm regards,

    Thu

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans