Questions? Call us!
(866) 226-5732



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)


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