Today, our ACH team manually processes all ACH exception items. We are trying to create an exception file to update the account numbers and re-run the batch to post all transaction after we submit the file.
For example, we have the daily ACH file that posts. Items in that file with incorrect account numbers are placed in a return ACH file. ACH and accounting are working on creating a 3rd file - the repost file and want all 3 files to balance at the end of the day when all is said and done. What do we explain to our software developers in order to automate our ACH exception process? We're receiving 100-200 items on the exception report daily and it consumes a considerable amount of time.
Other issues we've seen with our current testing with ACH exception batches is that Symitar rejects partial mortgage payments and loan payoffs if the amount is greater than the loan balance.
Any advice is appreciated.