ACH2Excel™ - Convert your ACH files to Excel

ACH2Excel converts and extracts popular NACHA-ACH formatted files into a comma delimited (csv) format.

From this file ....

.... extract the information you need, in a format you can use

Treasury Software provides the solution for banking professionals and treasury managers who wish to work with ACH (Automated Clearing House) files in a Microsoft Excel environment.

ACH2Excel 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.


New release - Now incorporates Straight-Through-Processing for EPN STP 820. Creates a separate csv file for remittance information. more info...



Features/Benefits
· Easy to Use 'Point and Click' interface
· Wide variety of the most popular ACH file formats - ARC, CCD, CIE, CTX, DNE, ENR, POP, PPD, RCK, TEL, TRC, TRX, WEB, XCK
· Open the converted comma delimited file directly into Microsoft Excel
· Fully integrated as part of ACH Universal and the Treasury Desktop
· Parses addenda records directly into a separate field.
· Use to consolidate multiple ACH files into one file (Pro Plus and Trading Partner).

Automation
· Automate regularly scheduled conversions through the built-in Control Panel, and
· Control unattended operation from your existing solutions with our rich command-line interface (Pro Plus and Trading Partner)

ACH2Excel Pro™ Version
ACH2Excel Pro is included with Treasury Software's ACH Universal Pro.™ This version signs the amount column (debit vs. credit) based on the ACH transaction code, and provides all of the fields associated with each transaction, such as
· Date
· Amount
· Account number
· ABA/Routing number
· Individual name
· Individual ID
· Transaction code
· Descriptive Date (ACH Format)
· Addenda Record


ACH2Excel Pro Plus™ Version - Consolidates Multiple ACH Files
For advanced needs - like receiving multiple ACH files and consolidating them- full access to all fields is available with ACH2Excel Pro Plus. Click for list of additional fields



ACH2Excel Trading Partner™ Version - 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 posting file - also in a comma delimited (csv) format- that contains key information from the following EDI segments. Click for list of additional segments/fields:

Like all other versions of ACH2Excel, Trading Partner presents data in a tabular format. However, the additional file in Trading Partner is 'remittance' centric, not 'transaction' centric and therefore produces a row for each remittance.

About Treasury Software
Treasury Software is the leading provider of client-side file creation and transmission software for Positive Pay, ACH, BAI, bank reconciliation, credit card reconciliation, and custom cash management solutions.

Designated a Verified for Windows XP software application by Microsoft, Treasury Software is a Microsoft Certified Partner. Winner of the Gold Cup Award from CPA Software News, Treasury Software is recognized for its comprehensive customer support and easy-to-use, secure and cost effective solutions.

Additional fields included in the Pro Plus version of ACH2Excel:
· Trace ID
· Bank Discretionary
· Company Name
· Company Discretionary
· Company ID
· Class
· Company Entry Description
· Batch
· Originating DFI
· Immediate Destination
· Immediate Origin
· File Date (ACH format)
· File Time (ACH Format)
· File Modifier
· Immediate Destination Name
· Immediate Origin Name



Segment/fields - ACH2Excel Trading Partner™ - CTX/EDI parsing for EPN STP 820:
· ISA/IEA
· GS/GE
· ST/SE
· ENT
· BPR
· TRN
· N1 (Payer)
· N1 (Payee)
· RMR
· REF
· DTM
· ADX

Ordering is easy. Visit our online store.

Need more information?
Call toll free: 866-226-5732