Overview

Treasury Software makes it easy to import transactions using Excel spreadsheets or CSV files. This guide walks you through the steps, best practices, and troubleshooting tips to ensure a smooth import experience.

Whether you are a small business, bank, or corporate treasury team, this feature saves time, reduces errors, and integrates seamlessly with your existing workflows.

Table of Contents

1. Supported File Formats
2. Preparing Your File for Import
3. Step-by-step Import Process
4. Common Issues and Solutions
5. Frequently Asked Questions (FAQs)

Create an ACH/Nacha File in 4 easy steps:

1. Create a new account in ACH Universal Online
2. Complete the ACH Setup 
3. Import and map an Excel or CSV file
4. Create an ACH/Nacha file

Supported File Formats

• Excel (.xlsx, .xls)
• CSV (.csv)

Preparing Your File for Import

• Ensure column headers match Treasury Software's required fields (e.g., Name, Bank Account Number, ABA Routing Number, Amount)
• Remove blank rows and unnecessary formatting
• Save your file in Excel or CSV format

Step-by-Step Import Process

1. Create an Account/Database in ACH Universal Online:

Click on the + sign next to "ACCOUNTS" on the left navigation bar>Name the account (optional to add the last 4 digits of the bank account number)>Create

If you will be originating ACH transactions from more than one bank account, you will want to create a new account (database) in our software for each bank account originating ACH files.

2. Complete the ACH Setup:

Click on the darkest green tile with the wrench icon: "ACH Setup"

Fill in the ACH File Header Info

Select the Standard Entry Class Code

Save Changes

Click on the Advanced Setup Tab

Check the auto-populated entries match your bank's specifications (information may be shortened and field lengths are truncated - that's okay 👌)

Change the default effective date if necessary.                                                                                                     Note: including and mapping a date on your import file will override this effective date setting. 

NOTE:  If working with a smaller bank or credit union, you may need to set up this page differently as the file will be passed (by your bank) to the Federal Reserve Bank for processing.  Ask your bank representative.

Most users can click "Save Changes" to complete.

However, if your bank requires a balanced file or offset record, click "Offset Record."

3. Import and Map an Excel or CSV File:

Create a master Excel or CSV import template. This can be exported from your accounting package by running a report from a date range. At a minimum, your Excel or CSV import must contain:

Name

ABA Routing Number (column formatted as "text" to allow for leading zeros)

Bank Account Number (column formatted as "text" to allow for leading zeros)

Amount

Note: You have the option to store banking data within Treasury Software in profiles. 

*See 'Importing Profiles.'

Importing Transactions:

Click on the light green Import Transactions tile from the homepage. 

Select 'Click to Upload' or drag and drop a CLOSED file or 'copy and paste' the fields from an open Excel/CSV.

Mapping:

Initially, none of the columns are mapped, and the column headers will be displayed as 'Skip-Not Needed' with a red 'x' 

Click the drop-down arrow to name each field (You may choose to skip optional fields)

In a typical scenario, you will need to include and map the following required fields in any order:

•Name

•Bank_Account_Number

•ABA_Routing_Number

•Amount or Amount_Reverse_Sign*
*Negative amounts decrease your balance and represent payments going out to employees or vendors.  Positive amounts increase your balance and typically represent collections coming in from customers. 

If you are making payments out (e.g., to vendors or employees), and the amounts on your imported spreadsheet are positive numbers, you will map the column 'Amount Reverse Sign' to ensure payments are going out.  Payments out are credits (you are crediting your vendors' accounts).

Here are other, optional fields you MAY want to include:

•Date (Mapping a date will override the default date of 'Next Day'.)

•ID Number (Some banks require an ID number)

•ACH_Email_Address  (The email feature requires our corporate version).

•Checking or Savings

When all the necessary columns are mapped, click 'Next' to continue.

View Import:

This screen will display a list of the importable rows and invalid rows.
Please confirm your control totals, counts, and date range. 

To review the list of importable or invalid rows, click on the “+” sign as shown below.

The invalid rows section will list all rows that will not be imported into ACH Universal. 

The software will automatically mark header rows, footer rows, summation lines, and blank lines as invalid.

Once you have verified the importable information is accurate, click 'Complete Import.'

The last import screen will appear

Click 'Go to ACH File Creation Page' or 'Back to ACH Universal' if you want to cancel the import process. 

4. Create an ACH File:

Create Your ACH file by clicking 'Create File'

Click on the small editing pencil to change the name and or date on the file. 

Download the file.

You can open the downloaded file to view it or save it in an alternate location. 

Remember the file has been created but still needs to be uploaded to your bank.
Your bank will provide you with instructions for transmitting the file.

Common Issues and Solutions

• Problem: File won’t upload.
  Solution: Check file format and remove special characters. 
• Problem: Data mismatch after import.
  Solution: Verify column mapping before importing. 
• Problem: Duplicate transactions.
  Solution: Use Treasury Software’s duplicate detection feature.

Frequently Asked Questions (FAQs)