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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Advanced Bank Reconciliation - The date in the bank statement is not matching From date / To date

(0) ShareShare
ReportReport
Posted on by 12

I currently have the Advanced bank reconciliation set to Yes. After imported the bank statement to D365, I noticed the date in the bank statement is not matching with From date / To date in D365.

Any help is greatly appreciated.  

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at
    RE: Advanced Bank Reconciliation - The date in the bank statement is not matching From date / To date

    So what's your question? You still want to reconcile those transactions?

    If yes you can either manually select those transaction and reconcile or set a reconciliation rule with grace period and reconcile.

  • Uy Pham Profile Picture
    12 on at
    RE: Advanced Bank Reconciliation - The date in the bank statement is not matching From date / To date

    I still want to reconcile those transactions.

    The date on statement ID is correct, but the From date / To date are one day behind. For example, the statement ID shows as 2022-01-10T0001:00Z while the From date 1/9/2022 7:01:00PM.

    I am not sure if this have anything to do with Time Zone Setting (current set as Auto).

    I was able to manually do the reconciliation without any issue. The concern is when it closes to month-end period.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 582 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans