Processing ACH returns

  • Updated

Processing ACH returns

Overview

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)

Process the records to reverse the payment

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. Log in 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

Here, you must select ACH Return Transaction Interface.

     8. Enter a suitable Batch Name.

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.

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.

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

Field reference

Field NameDescription
Data Migration Batch IDThis field remains blank, if the records are unbatched.
Interface nameThis field contains the name of the Interface. It can be Consolidated loan payment interface, Loan payment transaction interface or ACH Return Transaction interface.
Batch nameThis is the name of the Current batch. You can provide a unique name here.
Show/ refresh RecordsOn clicking this, you can see the related records for which a payment transaction has been made.
Process RecordsOn clicking this, the records that you select are processed.
Total RecordsThis 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.
UnbatchedThese 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.
CreatedA record is created when it is successfully processed.
FailedIf a record is not processed due to a validation failure or a run time error, the record will be marked as Failed.
PercentageThis is the percentage of records which were successfully processed.
Recent batchesThese are the batches which were recently viewed or processed.

In This Article