ACH2Excel is a utility included with ACH Universal used to convert an ACH file to an Excel spreadsheet (.xls). You can use it through ACH Universal or through the command line.
ACH2Excel through ACH Universal
Using ACH2Excel through ACH Universal is the most common method.
From the main menu, select File, then ACH File Conversion.
Click the and browse to the ACH file to be converted.
To do a quick conversion, click Done. This will convert the file and load it in Excel (as a csv value).
To specify file output options, click Output to open the Output tab (see below).
To output the conversion to a specific click, enable the Output to 'csv' file located in the directory checkbox, then click the button to browse to the appropriate directory.
To import the converted file into ACH Universal for further processing (such as an ACH Return File for Returns), enable the checkbox.
Click Done to create the file.
Command Line Options
BRCom.exe /ACCT="account" /ACH2 /SRCE="input file name" /OUTD="output file name"
/ACCT - specifies account by name
/ACH2 - specifies to use the ACH2Excel utility
/SRCE - specifies file to be used as input (using absolute positioning)
/OUTD - specifies file to be used as output (using absolute positioning)
Valid source files include ARC, CCD, CIE, CTX, DNE, ENR, POP, PPD, RCK, TEL, TRC, TRX, WEB, XCK. Note: Some formats may require further parsing.
Syntax Example
If Treasury Desktop was installed in the default location:
c:\Program Files\TreasurySoftware\BRCOM.exe /ACCT="sample" /ACH2 /SRCE="C:\transmit.txt" /outd="c:\testACHdetail.csv"
Reminder:
Turn on/off appropriate settings. From the main menu 'File', 'ACH File Conversion', 'Output' tab - unselect open in Excel afterwards.
Notes for all applications:
· The order of the parameters is not significant
· Capitalization is not significant
· When specifying a file name (SRCE), use the full file path and name within quotes. When using mapped drives, remember that the path should be centric/relative to the machine where Treasury Desktop is located, not the machine issuing the trigger/command.
· Place the account name in quotes.
Working with multiple users and multiple account:
Each command line trigger - will create an independent instance of the application. There is no limit to the number of instances.
If processing simultaneous command line requests, use different accounts (Sample1, Sample2, etc...) to minimize any record locking issues. If this is not an alternative, consider processing sequentially, or using our Control Panel.
For Web and Citrix based applications, please contact a Treasury Software support representative.