How to automatically reverse the Receipt by matching to NSF/Reversal Statement Line

Hi All,

We are using automatic receipt fro Direct Debit. Once receipts are sent for collection to bank, some of the receipts are rejected by bank due to non sufficient funds. We are capturing such transaction in bank statement upload with Bank Transaction Code as NSF. We want to match these lines with Remitted receipts and expect system to automatically reverse the receipts. We not want to manually reverse the receipt first then reconcile.

Can the process of reversal of remitted receipt be automated through bank reconciliation process.

Best Regards,

Anil