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.

  • ThuNgo Profile Picture
    978 on at
    RE: Advance bank Reconciliation (Reconcile after import)

    Hi,

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

    Thank you,

    Warm regards,

    Thu

  • Ding Li Profile Picture
    480 on at
    RE: Advance bank Reconciliation (Reconcile after import)

    Hi Ali,

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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,112 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,893 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans