Bank Reconciliation Tool not matching entries even after using Bank Clearance

ERPNext
,
1

Question:
I’m facing an issue where entries that I clear using Bank Clearance do not disappear from the Bank Reconciliation Tool.

Here is what I observed:

  1. When I clear vouchers from Bank Clearance, the clearance date gets updated, but the same entries still appear in the Bank Reconciliation Tool.

  2. In the “Select Vouchers to Match” popup, only vouchers with blank clearance dates appear.
    The vouchers that I already cleared do not show in the list.

  3. Even when I choose Action → Add / Update Bank Transaction for a statement line, ERPNext shows a “Matched” message, but the entry still does not disappear.

  4. It seems that Bank Clearance only sets the clearance date, but the system still expects reconciliation to happen through the Bank Reconciliation Tool.

  5. Bank statement lines that have no matching Payment Entry also show the same “Matched” popup, which makes the behavior confusing.

My Questions:

  1. Is this the expected behavior of ERPNext?

  2. Should matching always be done only through the Bank Reconciliation Tool and not via Bank Clearance?

  3. Why does ERPNext show a “Matched” message even when no actual match happened?

  4. For bank entries that exist in the statement but not in ERPNext, what is the correct workflow?

  5. How should we handle entries that were cleared earlier but are still visible in the tool?

Any guidance on the correct process flow or if I’m misunderstanding something will be helpful.

2

I believe this is the correct behavior. If you want entries to show and be reconciled in Bank Reconciliation tool then do not mark them as cleared in Bank Clearance.

Stick to marking items as cleared via Bank Reconciliation.

I’m not sure what you mean in number 3.

For bank entries in the statement but not in ERPNext you’d create either a matching Journal Entry or Payment Entry then match it or use the “create voucher” function in Bank Reconciliation.

If you want to match an item in Bank Reconciliation that’s not showing up, you’ll want to remove the clearance date from Bank Clearance, the match it in Bank Reconciliation.

Only entries that have not been marked as cleared will show in Bank Reconciliation.

1 Like