How to reconcile ACH returned
We have following scenario
e.g.
Two ACH payments were issued from AP; one is 70 USD and another 30 USD.
Next day we loaded Bank BAI file which has 100 USD as ACH debit.
So far good
A day later, bank sends ACH returned from the above batch; one payment was rejected USD 30
Now on the bank side, we have 100 usd as ACH issue and 30 USD(absolute value) as ACH returned
On the system side, we have 100 usd as AP ACH payment
We cannot reconcile now because totals dont match.
Please let me if there is any option to fix this issue.