How to create ACH Files from Excel/csv files

If you can create an Excel or csv file with your customer's, employee's and vendor's banking information,
you can perform a simple Basic Excel Import.

If you don't have this information - not an issue.
Use our Profiles Feature to hold your customer's, employee's and vendor's banking information.

Basic Excel Import
If you can create an Excel or csv file with at least these four fields, you can perform a basic import.
--Amount
--Name
--Bank Account Number
--ABA Routing Number

Of course, you can import additional fields such as date, ID Number, SEC code, etc...

Importing with Profiles

If your Excel file doesn't have the banking information - not an issue.
All you need are two columns in your Excel file:
--Amount
--Name (or ID Number)

The system can perform a lookup for each line in your Excel file and merge it with the banking information that you have previously stored securely in ACH Universal.

You can populate your profiles in ACH Universal by importing Excel or csv files and/or manually entering them. Bank Account Numbers are encrypted when stored and we keep a full audit trail.

 

 

 

Easily Import Excel files

From the ACH Universal Home Screen, start the Excel Import Wizard by clicking on the icon below.

The Wizard enables you to select a file or 'copy and paste' from a file open in Excel. You can then review your records and check your control totals.You can repeat the process if you have multiple files.

 

 

Create an ACH File

Once you've imported your Excel file(s), you can review the summary totals and/or the detailed transactions will be included in the ACH file.
Upon a succesful review, you can create the ACH File.

 

 

 

Your ACH File

Upload your ACH File directly to your bank.

Send email notifications to your vendors and customers

Automatically email the full check stub remittance information to your vendors and customers.
Works with Microsoft Outlook, Gmail, or any email server.
ACH Universal's email feature requires either Corporate or Advanced edition.

 

 

Documentation and Videos

Ready to get started?
View our Getting Started pages - help and videos.

All data is located on your computer - no volume or transaction fees

ACH Universal is unique in that it is not a service that charges a transaction fee, but it is ACH software installed at your location, enabling you to create an unlimited number of ACH files.

The ACH file is created at your location and is transmitted directly to your bank.

Our ACH software is always located locally on your network, regardless of your licensing selection (One-time traditional or subscription).

Security and Access Control

 

Security in ACH Universal includes:

• Database Encryption (AES-256)
• Password Protection
• Full Audit Trail
• Automated Backups
• SQL Server Security
• Segregation of Duties
• SSH-FTP encrypted transmission

To read more on the security, please click here.

Easy to use, but don't take our word for it - Create an ACH File Now!
Download a full free working trial of our ACH Software to test with your bank

Looking to create EFT files for Canada?
ACH Universal now also supports the Canadian EFT 005, 1464 byte format.