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, ...
Answered

What is the purpose of cleared date and how to mark the date in check

(4) ShareShare
ReportReport
Posted on by 1,266
In Cash and bank management > Bank accounts 
 
1) choose a specified bank
2) select Manage payments >  Checks in the action pane.
 
Please advise what the cleared date is and how to set the date it.
 
Categories:
I have the same question (0)
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    26,449 Super User 2025 Season 2 on at
    Hi @J_Lee,
     
    it's related to this feature : 
     
    Update the Cleared date fields for reconciled documents when using advanced bank reconciliation
     
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • J_Lee Profile Picture
    1,266 on at
    Thank Mohamed.
     
    May you provide me more information how to update this field when doing bank reconciliation? I am no idea how it works .
     
     
     
  • Verified answer
    Abhilash Warrier Profile Picture
    6,079 Super User 2025 Season 2 on at
    Hey,

    Please find below explanation –

    What Is the Cleared Date?
    • It’s the date when a payment or transaction clears through the bank—essentially confirming that the money actually moved.
    • For checks, this is when the bank cashes them.
    • In D365, the cleared date is updated during Advanced Bank Reconciliation when a bank statement line matches a system transaction.
     
    How to Update the Cleared Date via Bank Reconciliation
    Prerequisites
    1. Advanced Bank Reconciliation must be enabled
      • Go to the Bank account > Reconciliation tab
      • Ensure “Use advanced bank reconciliation” is set to Yes
    2. Feature Management Setup
      • Enable the feature: “Update the Cleared date fields for reconciled documents when using advanced bank reconciliation”
    3. Import Your Bank Statement
      • File format: MT940 | BAI2 | ISO2****
      • Use Cash and bank management > Bank statement import
    4. Perform Reconciliation
      • Go to Bank account reconciliation workspace
      • Match the statement line to the check (or other transaction)
      • Once matched and posted, the Cleared date field on the payment/check will be updated with the bank transaction date from the statement.
    You can view or verify the cleared date by:
    • Navigating to the bank account → Manage payments > Checks
    • Selecting a check → Confirming the Cleared date field has a value

    If this helped, please mark it as "Verified" for others facing the same issue.
    Keep in mind that it is possible to mark more than one answer as verified.

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
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans