Process ACH Returns

  • Updated

Process ACH Returns

Let us say, you have authorized a bank to perform ACH Recurring transactions on your account such that all your bills are taken care of, every month. Suppose, there are NSF (Non-sufficient funds) in your account, the bank will send the ACH Return file to us. This file has a specific Return code.  In this case, the Return code would be R01 which stands for non sufficient funds. We will now re-adjust all the processes and apply NSF. Some of the reasons for ACH Returns can be Closed account, Invalid account number or frozen account to name a few. 

Consider a loan account where an ACH payment was made and processed by our system. 

Here, if the authorized bank returns the ACH file to us, this ACH return file (typically a .csv file) has to be uploaded in the system through dataloader.io or apex data loader. 

Note:

Here, you need to map and populate following fields in the interface:

Loan_Account_No__cReturn_Code__cStage__c (set to ‘Pre-Import’)Transaction_Date__cBank_Reference_No__c (Optional)Amount__cName (you can copy Bank Ref # or any other reference here)

Prerequisites

The following are the prerequisites to process the records to reverse the payment in your system:

  • ACH records are rejected or processing has failed.

Steps

Perform the following steps to process records to reverse the payment in your system:

  1. Login to your salesforce account.

  2. Click  Servicing Configuration.

  3. Go to User and Data.

  4. Go to Batch Jobs.

  5. Go to Data Import.

  6. Select Create a New Batch.

  7. Select the Interface name.

    Note:

    Here, you must select ACH Return Transaction Interface.

  8. Enter a suitable  Batch Name.

    Note:

    If the records for this particular ACH transaction are not present in the Eligible Interface Records, you can do so by uploading a .csv file using dataloader.io or apex data loader.

  9. Click  Show/ Refresh Records.

    Note:

    The fields Loan account number, Amount, Transaction date and the Return Code are the most important parameters in the Eligible interface records.

  10. Select the required  Eligible Interface records.

  11. Click  Process Records.

    Note:

    If the NSF fees is present in the loan's fee set, only then you can apply the NSF fees.

Field reference

Field Name Description
Data Migration Batch ID This field remains blank, if the records are unbatched.
Interface name This field contains the name of the Interface. It can be Consolidated loan payment interface, Loan payment transaction interface or ACH Return Transaction interface.
Batch name This is the name of the Current batch. You can provide a unique name here.
Show/ refresh Records On clicking this, you can see the related records for which a payment transaction has been made.
Process Records On clicking this, the records that you select are processed.
Total Records This is the sum of Eligible,Created, Failed records for the Current Batch.
Eligible A record is deemed eligible once it is in the Pre-Import stage. This record is yet to be processed.
Unbatched These records are not part of the Current batch. In order to make it a part of the Current batch, you have to process these un-batched records.
Created A record is created when it is successfully processed.
Failed If a record is not processed due to a validation failure or a run time error, the record will be marked as Failed.
Percentage This is the percentage of records which were successfully processed.
Recent batches These are the batches which were recently viewed or processed.

In This Article