|
CTX-2-Excel™ - Convert ACH-CTX files
to Excel
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.
CTX-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.
CTX-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
- CTX-2-Excel™ - CTX/EDI parsing for EPN STP
820:
|
ISA/IEA
|
GS/GE
|
ST/SE
|
ENT
|
BPR
|
N1 (Payee)
|
|
TRN
|
RMR
|
REF
|
DTM
|
ADX
|
N1 (Payer)
|
Ready to license?
CTX-2-Excel license page
|