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:

• RMR
• REF
• DTM
• ADX
• ISA/IEA
• GS/GE
• ST/SE
• ENT
• BPR
• TRN
• N1 (Payee)
• N1 (Payer)

Ready to license?

CTX-2-Excel license subscription, or-
CTX-2-Excel license one-time