Finance | Project Operations, Human Resources, ...

Reconciled bank transactions with "cleared date" but "reconciled" set to no

(1) Share

Report

Posted on by CU31030643-0

Hello,

In D365 FINOPS > Cash and Bank > Bank Accounts > Select a bank account > Unreconciled transactions,

on this screen, I can see some bank transactions with a CLEARED DATE populated, while the RECONCILED field is empty.

Could you please explain in which cases this is possible?

For me, both fields should be linked: if a Cleared Date is populated, then Reconciled should always be set to Yes.

I believe this may explain some issues in certain electronic reports showing unreconciled transactions, depending on whether they are based on the Cleared Date column or the Reconciled column.

thanks!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Sort by

CU09041219-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I believe the response to this is that the Cleared Date appears when an individual transaction has been reconciled, but the bank reconciliation itself has not yet been marked as reconciled. In essence, the transaction has been matched, but it has not yet been "posted".

Was this reply helpful? Yes No
Suggested answer

CU14081927-1 7 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This happens when the individual transaction has been reconciled, but the the set of reconciliation hasn’t be marked as completed

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 1,613 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @CU31030643-0,

In D365 Finance, Cleared and Reconciled represent two different stages of the bank reconciliation process.

Cleared indicates that the transaction has appeared on the bank statement and has been matched/confirmed in the system. When you mark a transaction as cleared (either manually or via bank statement import), the system records the Cleared date, which reflects when the transaction was confirmed by the bank.

Reconciled indicates that the bank reconciliation process has been fully completed. This status is only updated to Yes when the bank statement (or reconciliation worksheet) is finalized and posted, meaning all included transactions have been reviewed and reconciled.

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
Suggested answer

Shubham Das 52 on at

Like (1)

Report
Copy link

Link copied!

Hi,

I agree to the above comments. Cleared is only applicable if the Transaction in the system matches the Bank Statement. Reconcile is only checked if we select the transactions (which makes unreconciled balances as 0) and then click on reconcile. Reconcile is specific to the entire statement whereas clear is specific to a single transaction on the statement.

Thanks,

Shubham

Was this reply helpful? Yes No