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.
Here, you need to map and populate following fields in the interface:
Loan_Account_No__c
Return_Code__c
Stage__c (set to ‘Pre-Import’)
Transaction_Date__c
Bank_Reference_No__c (Optional)
Amount__c
Name (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:
Log in to your salesforce account.
Click Servicing Configuration.
Go to User and Data.
Go to Batch Jobs.
Go to Data Import.
Select Create a New Batch.
Select the Interface name
Note:Here, you must select ACH Return Transaction Interface.
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.
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.
Select the required Eligible Interface records.
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. |