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

Mistakenly deselected cleared transactions from the already reconciled bank statement.

(1) ShareShare
ReportReport
Posted on by 92

Hello, 

Hope someone can help me on this matter.

One of our users mistakenly clicked the 'Deselect all cleared' option in the already reconciled bank statement when he wanted to cancel the bank statement.

Once he clicked the 'Deselect all cleared' button in the 'Account reconciliation (Reconciled)' menu, all the reconciled transactions have been disappeared from the reconciled menu.

2023_2D00_04_2D00_06_5F00_17_2D00_28_2D00_25.png

In the bank transactions list, the above-uncleared transaction appeared as follows.

Reconciled - Yes

Cleared date - empty

2023_2D00_04_2D00_06_5F00_17_2D00_35_2D00_36.png

He has canceled this bank statement through the 'Cancel bank statement menu, but since the reconciled transactions have already been uncleared from the statement, the cancellation option did not apply to the transactions properly.

2023_2D00_04_2D00_06_5F00_17_2D00_33_2D00_18.png

Now the user wants to cancel this transaction and re-do the bank reconciliation correctly.

But since this transaction is not showing in the bank statement anymore, can someone suggest you a method to change this reconciled transaction to an unreconciled transaction?

Thank you!

I have the same question (0)
  • Suggested answer
    Hana Xue Profile Picture
    Microsoft Employee on at
    RE: Mistakenly deselected cleared transactions from the already reconciled bank statement.

    Hi Anthikala,

    If you have reconciled a transaction in error or deleted a previously reconciled transaction, you can undo the previous account reconciliation. When you undo a reconciliation, all transactions for that period return to an unreconciled status.

    Questions and discussions on how to undo reconciliation are mentioned in the link below, you can check:

    How to Undo Reconciliation in D365 - Dynamics 365 Finance Forum Community Forum

    Best Regards,

    Hana

  • Anthikala Profile Picture
    92 on at
    RE: Mistakenly deselected cleared transactions from the already reconciled bank statement.

    Hello Hana,

    Thank you for your suggestion.

    Unfortunately, I have already tried all the options mentioned in the article you provided.

    In my case, the user has deselected all the cleared transactions in the already reconciled bank statement.

    Because of this reason, the status of the bank transactions is shown as 'Reconciled' but have not been 'Cleared'.

    Also, the bank transactions are not shown under the 'Transactions' of the bank statement.

    Due to the above reasons, the cancellation of the bank statement didn't work for this problem.

    For now, we have decided to escalate this problem to Microsoft.

    Thank you!

  • Dangar Profile Picture
    on at
    Mistakenly deselected cleared transactions from the already reconciled bank statement.
    Hi Anthikala,
    hope all good.
     
    is there any input you received for this issues? we are facing the same issues in our client.
    it would be great and help full for us to know about this.
     
    Thanks :) 
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,619 Super User 2025 Season 2 on at
    Mistakenly deselected cleared transactions from the already reconciled bank statement.
    You most likely need a developer to write a custom script to undo the "Deselect all cleared" action.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 588 Most Valuable Professional

#3
Sumit Singh Profile Picture

Sumit Singh 544

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans