Questions? Call us!
(866) 226-5732



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



Can't find what you need? Contact us online or at 866-226-5732
© Treasury Software Corp. 1999 - 2012. All rights reserved.