Autoreconcile Bank Statements" ESS job keeps moving to retrying status during mass reconciliation

Summary:

Hi Team,

We have a bank account used for AP payments, and we are encountering a scenario with outstanding checks that are not cleared within the tolerance rule. After one or two months, these checks are cleared and appear in the bank statement. Once the bank statement is imported, statement lines are created. However, when we run the automatic reconciliation, these payments are not automatically reconciling.
This issue arises because our reconciliation rule is defined with matching criteria based on the date, reconciliation reference, and an amount tolerance rule set to 10 days before and after. These transactions are planned for extraction and mass reconciliation. However, when we submit the "Autoreconcile Bank Statement" along with a .csv file, the ESS job automatically moves to the retrying status, and the "Load Interface File for Import" program gets stuck in a paused status.