ACH Universal can easily create an ACH Return File from an ACH File.
This help page contains instructions if you are receiving an ACH file and need to create an ACH Return file. If your data is already in Excel or a csv file - follow our template and mappings.
To create ACH Return files you need the Enterprise platform-Processor edition of ACH Universal.
1. Create a new account to work in.
From the main menu select File > New > Create an account - and then complete the wizard.
Note: In this example, we named the account 'Returns'.
2. Default the account to create ACH Return files
From the program Home Page, click ACH File Setup, then next.
Enter your header information here.
Note: If you don't have your header information, you can skip this and come back at any time. It is not needed to create a file, but of course - you'll need to enter it before sending to the FRB or your processor.
When finished, select 'Advanced Setup - Access all setup options' to enable the 'Next' button to continue. Click Next.
Select 'Returns (uses original class)'. Click Next, then Finish.
3. Prepare sample/test data
On the Home tab, click ACH-2-Excel.
On the form, select an ACH file to convert. Once selected, allow the conversion to continue.
A spreadsheet will open with the converted data. Format column H (Trace number) as a number to avoid the values being displayed in Exponential Notation.
For this sample, add a column to the rightmost field - and enter return codes.
Note: Enter the 'R' plus a leading digit if applicable. For example, for Insufficient Funds, enter R01 as below.
Save the file as an Excel file.
4. Set your mappings.
Click on Import Transactions to start the wizard.
Select the Excel file you just saved in the previous step and click Next.
In the upper right corner, select the mapping template 'ACH NACHA Returns'
Note: If you are on build 1024 or earlier, follow the mapping steps at our legacy mapping.
Warning: There is a similar named template called 'ACH Returns', depending on your version - you can use this as well.
Also check the 'Save as default'
This mapping template is used for a variety of purposes, so we're going to modify it now for our use.
We're going to unmap four fields. To unmap a field, click on the field.
First click on fields F3 and F4 to unmap them. Your screen should now look like:
Field F5 should be mapped 'Name'. Map this if needed.
Scroll to fields F31 and F32 and unmap them.
Now, we're going to map three fields.
Select field F32 and from the drop down list select Bank_Account_Number.
Select field F33 and select ABA_Routing_Number.
Click on the 'Show all field selections' (see red arrow below)
Select field F34 and select ReturnNOC_Code
Click Next, Next and Finish to import and most importantly - to save your mappings.
Common mapping question:
Q: Amount - Why didn't we map field 2 for amount?
A: This field is signed. We already had field 26 mapped which is unsigned - as the transaction code will supply the debit/credit information.
Note: There are multiple amount fields for different purposes.
5. Create a test ACH Return File
From the Home page - click on the Go To Create ACH File Page - and then click on Create (see below).
1. Simply prepare the data file as above in step 3. All other work has been saved.
Note: Of course, your returns will only be a subset of the entire file. Delete the records within Excel that do not need to be returned.
This would be a good time to backup your work. Click File > Backup.
Reminder: To create ACH Return files you need the Enterprise platform-Processor edition of ACH Universal.