|
ACH-2-Excel™ - Convert ACH-CTX files
to Excel
ACH-2-Excel also supports full CTX-EDI files.
Treasury Software provides the solution for banking
professionals and treasury managers who want to work with ACH (Automated
Clearing House) files in a Microsoft Excel environment.
ACH-2-Excel is an easy-to-use, affordable utility that converts
ACH files to comma delimited files (csv) which can be opened in
any version of Excel.
ACH-2-Excel - CTX/EDI parsing for EPN STP 820
To post remittance payments directly to Accounts Receivable, or
other in-house system, the Trading Partner version creates a separate
remittance file - also in a comma delimited (csv) format- that contains
key information from the following EDI segments.
This remittance detail file is in addition to the regular payments
file (see ACH-2-Excel home).
The remittance file is 'remittance' centric, not 'transaction' centric
and therefore produces a row for each remittance (see above).
Sample Files
For a full listing of fields, view the sample files
Original ACH-CTX file (input)
Parsed
Payments (output)
Parsed
Remittance detail (output)
Segment/fields
- ACH-2-Excel Trading Partner™ - CTX/EDI parsing for EPN STP
820:
|
ISA/IEA
|
GS/GE
|
ST/SE
|
ENT
|
BPR
|
N1 (Payee)
|
|
TRN
|
RMR
|
REF
|
DTM
|
ADX
|
N1 (Payer)
|
|