Finance | Project Operations, Human Resources, ...

How to cancel a bank transaction reconciliation?

(1) Share

Report

Posted on by SH-27040847-0

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)

Sort by

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thank you for sharing

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
SH-27040847-0 9 on at

Like (0)

Report
Copy link

Link copied!

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,633 Moderator on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
SH-27040847-0 9 on at

Like (0)

Report
Copy link

Link copied!

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,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Community member,

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

Was this reply helpful? Yes No