Overview

ACH Universal Online allows users to import payment and recipient information directly from an Excel or CSV file, eliminating the need to manually enter records one at a time.

This guide explains how to create a properly formatted Excel or CSV file for ACH Universal imports, including required columns, formatting considerations, and best practices for successful ACH file creation.

Table of Contents

1. Overview
2. Benefits of Excel or CSV imports
3. Create your Spreadsheet
4. Import the file into ACH Universal Online
5. Common Formatting Requirements
6. Frequently Asked Questions (FAQs)

Benefits of Using Excel or CSV Imports

Importing payment data from Excel can help organizations:

• Reduce manual data entry
• Eliminate duplicate work
• Process large payment batches
• Import accounting or ERP exports
• Improve ACH payment or collection accuracy
• Speed up payroll and accounts payable workflows

Create Your Excel or CSV Spreadsheet

Create a spreadsheet in Microsoft Excel containing the payment information you wish to import.

Typical fields may include:

Use a separate column for each field.

Important:

• Do not merge cells
• Avoid special formatting
• Save the file to an accessible location
• Close and reopen the file if desired to verify formatting

Import the Excel or CSV File into ACH Universal Online

To import your file:

1. Open ACH Universal Online
2. Click on the 'Import Transactions' tile
3. Either 'click to upload' and navigate to the correct import file or 'click to paste' and paste the transactions data directly from the Excel or CSV file
4. Map spreadsheet columns to ACH Universal fields (you will only need to do this the first time)
5. Validate imported records
6. Save the imported data
7. Generate your ACH file

Review all imported records before uploading file to your financial institution for processing

Common Formatting Requirements

Routing Numbers

• Must contain 9 digits
• Should not include any spaces or special characters

Account Numbers

• Do not use dashes unless required by the receiving bank
• Verify account length and accuracy

Dollar Amounts

• Use standard numeric values
• Remove currency symbols where possible

Dates

Use a consistent date format throughout the file

Frequently Asked Questions (FAQs)

1. Can I import payroll information?

Yes. Many organizations use ACH Universal imports for direct deposit payroll processing.

2. Can I import vendor payments?

Yes. Imports are commonly used for accounts payable and vendor payment file creation.

3. What if my import file comes from another accounting system?

Many accounting systems can export a spreadsheet or CSV files that can be modified and imported into ACH Universal Online.

Need Help?

Still have questions? Contact Treasury Software Support or visit www.treasurysoftware.com for personalized assistance.