Finance | Project Operations, Human Resources, ...

How to cancel a bank transaction reconciliation?

(1) Share

Report

Posted on by Community member

In D365FO how can we cancel a bank transactions reconciliation that was done from the bank transactions side and not from the bank statement side?

The reconciliation was done this way because the transactions were only found on the D365FO side.

The reconciliation was done in the following way (an example we made now in the test system to show how we did this):

1) From bank transactions, we selected the bank transactions (Debit and Credit) that should be reconciled, then went to /Reconcile transactions/

2) Then, the two transactions were marked as reconciled

Where can we undo this reconciliation?

What we have tried:

1) Select one of the reconciled transaction and go to Reconciliation relations. This shows only empty lines because this has no bank statement relation:

2) Go to the bank transactions for one of the reconciled bank transaction, and there go to tab Bank transactions, both the field /Cleared/ and /Reconciled/ are YES, and cannot be changed from there (greyed field):

I have the same question (0)

All responses (7)

Answers (0)

Mohamed Amine Mahmoudi 26,428 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Thank you for sharing

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
Thank you for sharing, it will help a lot of people on the forum, besides, it would be better if it was written as a blog, because too many posts in the forum can sometimes overwhelm it. And please mark it as verified as this is an experience post and not a question.
Best Regards,
Hana

Was this reply helpful? Yes No
Community member 9 on at

Like (0)

Report

Hi Hana, thank you for your response. This is a question I am having, the question I have (and the problem) is the following:

In D365FO how can we cancel a bank transactions reconciliation that was done from the bank transactions side and not from the bank statement side?

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (1)

Report

You may need a developer to write a custom script to uncheck these items. You can reverse a reconciliation if it's done via the Bank account reconciliation process but even that wasn't possible until Microsoft provided that enhancement a few years ago.

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
I agree with Frank, if you want to achieve your needs you have to consider customization.
Best Regards,
Hana

Was this reply helpful? Yes No
Community member 9 on at

Like (0)

Report

The solution suggested from Frank was the way we went to solve the issue (I wasn't able to mark his answer for some reason), we had our developer create a customization that unchecks the reconciled transactions on the bank transactions page and that solved our issue.

Thank you for your replies and help.

Was this reply helpful? Yes No
Layan Jwei 8,116 Super User 2025 Season 2 on at

Like (0)

Report

Hi Community member,

Frank's answer will be marked as verified now. Thanks for coming back to us.

Was this reply helpful? Yes No