How Can We Help?

payACH Import

You are here:
< Back

payACH allows for the import of different types of files: ACH-file, Comma-Delimited file, Gold-Leaf, and Fixed-Width Files.

For Comma-Delimited and Fixed-Width files, the system is expecting the following pieces of information:

  • Batch Number (Batch name can be selected after the system detects the type of file); The batch number can be found by pressing the “View Batch Headers” button in payACH and looking to the far right column for the batch number.
  • Location Number: Can be a reference number field; defaults to “0” if not provided; up to 15 characters long.
  • Savings/DDA: Savings(“S”) or DDA flag; any value other than the letter “s” will default to checking. This value is 1 character long.
  • ABA Number (9-digit bank routing number); if not provided, the system default to 123456788.
  • Account Number (up-to 17-digit bank number)
  • Amount (a 2-digit decimal number); If the value is “P”, it will designate the transaction as a Prenote. If the amount is less than 0.00, the system will designate it as a “debit” against the bank account holder, otherwise, it will be a credit to the bank account holder. If the amount does not contain a decimal, the system will divide by 100, assuming you provided a non-decimal number.
  • Name (25 character value)
  • Any Addenda data (up to 80 characters)

The Comma-Delimited import does not recognize quotes around a text field (such as Name where a value of Last Name, First Name in quotes would cause an import error). The CSV import should not include a header line.

How to find the Batch Number in PayACH
How to find the Batch Number in payACH – View Batch headers

Once you know your batch number (which is optional, the import process will allow you to define which batch to import into), you can create your import file. Here is an simple example CSV file created in Microsoft Excel:

Excel with a sample CSV layout

Now, to import the file, return to the payACH home screen and click on the “ACH Entry” menu on the upper left of the home screen. Then select the Import File option.

Image to show the location of the import program

This now starts the application Import32.exe. It will start and ask for a file to import.

File Select of a Test File

Once selected, the system will attempt to detect what type of file was provided and if successful, it will show the type of file and the import options.

You will now see the first line of the CSV file and are presented with a list of text boxes and field number identification – for example, column 1 (the first column) is listed as the Batch Number field. Notice you can press the three dots and it will ask you which batch to import into. If you did not have the batch number field in the CSV file, clear the value and adjust the other columns. You can save and load your previous CSV column ordering by clicking on the File Menu and selecting either Save Settings or Load Settings. By default, the system is looking for a .set file to load from. The above image shows the first row of the CSV as headers but there is no mechanism to skip this row. Please remove the column headers.

Here is an example where we move the Batch number to column 7and loaded a “Settings” file to adjust the columns:

Once you finish the adjustments to the settings, press Continue. If there are records in the existing batch, it will ask if you wish to delete everything or append to the existing batch. Please select your choice.

Once the import process finishes, you will get a success message:

Clicking into the batch, you should see the records imported into the payACH application.