Merge ACH Files quickly and automatically with Treasury Software's ACH-Merge.
The source / individual files can be from any system or bank, they do not have to be from ACH Universal.
ACH Merge associates key batch information with each record, enabling you to recreate the transactions - and their batch header records - exactly as they were. This is not simply a stitch and copy utility.
1. Click on ACH File Setup Wizard and enter the information for the file header if you haven't done so already. This information will be used to create the '1' File Header and '9' File Control/Footer record.
2. On the Home tab, click on ACH-Merge to open the ACH-Merge window.
3. Enter the folder containing containing the individual ACH files.
4. Note the location as to where you want the consolidated ACH file to be created.
5. Click Merge.
Note: The software may minimize into a background operation during this process. This is normal and to be expected.
6. View the file!
Process complete! Confirm activity in reports.
--a. Activity Receipt Reporting - File level
--b. Unimportable Records report - record level
--c. Import Logs and Transmittal Logs
a. Activity Receipt Reporting - File level
You can receive a popup activity receipt at the file level (see below), which can be displayed at the end of each ACH Merge.
It will list all files in that folder and whether they were successfully imported.
Why would a file show as 'False' (skipped / not included in the consolidated file)?
The system will import only ACH files in conformity to NACHA standards. Non-standard ACH files may have transactions excluded - or even skipped in their entirety (depending on the issue) - from the consolidated file.
To turn on the activity receipt, select the main menu Automation tab* > Software Integration Kit > scroll down to ACH Merge (Group 16) and highlight the row. Click on Add/edit. In the popup window, select the Reports tab and fill in as needed. Additional documentation for setting the Activity Receipt Report.
* If you are still testing in the Sample account, use the 'Samples' tab as opposed to the 'Automation' tab.
b. Unimportable Records report - record level
After the ACH Merge, you can run the 'Unimportable Records' report to help locate any exceptions if there is an issue with control totals from the activity receipt (noted above) or the Import and Transmittal logs (see below).
--Do not use the 'Unimportable Records - Last Import' report, as this will only provide you with information from the last individual source file.
--The 'Unimportable Records' report will only contain records from importable files ('Success') which may have been filtered out. Records from files that failed the import process, such as Excel files, or defective ACH files, etc... will not be listed.
c. Import Logs and Transmittal Logs
You can check your control totals for the records successfully imported from the individual source files at 'Import Logs' (displayed below) and for the file created at 'Transmittal Logs'.
How do I edit/delete some of the records after importing the ACH Files, but before creating the consolidated file?
You will not use the ACH-Merge automation utility, but instead import the ACH files using through the main interface.
Then you can edit/delete the records.
When completed, you can create the consolidated file from the Create ACH file page.
Note: If the batch headers (5 records) all contain the same company and ID information, you can perform this with an ACH Universal Corporate license. However, if the company and ID information is different, you will need an ACH Universal Processor license.
Does ACH-Merge handle IAT records?
No, ACH-Merge has been designed to handle transactions with up to one addenda record. While the vast majority of our clients are using it for PPD and CCD Standard Entry Class codes, we recommend as with any application - fully testing before moving into production.
Can I use the Sample account for ACH Merge?
No, do not use the sample account as it can reset to conform to the tutorial. Please create a user account at File > New Account.
ACH Merge isn't merging a file. Why not?
Please confirm that your file is in a valid text format by opening it in Notepad or similar application.
Once loaded, click File > Save As and confirm that the Encoding is set to ANSI. If it is not in the correct encoding, contact the entity that provided you with the file.
If the file is in a proper text (ANSI) file, test the file using our ACH-2-Excel utility. From the Home tab, select 'ACH-2-Excel' and select the file. As ACH Merge uses the same parsing engine as ACH-2-Excel - if the file cannot be parsed, it cannot be processed.
Note: A poorly formatted transaction not adhering to NACHA standards may invalidate the entire file. Contact the entity that provided you with the file.
If you imported an ACH file manually - not through the wizard/automation, please check the mapping template used during the import process. You can also run an Untransmitted Records report to review the records which have been imported, but not yet included in a file.
Of course, please contact our support team at any point if you are unable to complete the ACH Merge process.