Download Free Trial 2 Min Demo Contact Us
(866) 226-5732
Easily Create & Transmit ACH Files

You can import data files to create IAT transactions--just like any other type of transaction.

Knowledge of IAT

The IAT format is a fairly complex format compared to our other formats, such as CCD and PPD.  

For example, instead of four required fields for CCD and PPD (Name, Amount, ABA/Routing and Account number), there are over forty different fields required by IAT.

 

Add a Record - for single transactions

If you are not familiar with the complexities of IAT, we recommend that you use our 'Add a Record' interface which can walk you through the process:

IAT-AddARecord.jpg

IAT-AddARecord2.jpg

 

Importing a File - for single or multiple transactions

If you choose to import an Excel or CSV file, remember to map all fields!   All fields noted below are required to be mapped - even if they are empty (blank), or of $0.00 amount.

Failure to import all of the fields may result in the inability of ACH Universal to create a proper transaction; while other omissions may allow the transaction to be created, but ultimately the file may be rejected by the NACHA network.

If you use the mapping template 'International - IAT', we have pre-mapped the fields to match the template supplied with the Excel file 'International - IAT.xls'.
Of course, you can certainly map your own template.

 
IAT 

Mapping Fields

Below are screen shots of the fields as shown in the Sample account, along with Sample data.

We recommend using the file below as a template (included with ACH Universal):

C:\Users\Public\Treasury Software\Tutorial\ACHData\International - IAT.xls
 
Note: The data samples below indicate the range of data that can be imported.

IAT-ImportLast_01

IAT-ImportLast_02
IAT-ImportLast_03

IAT-ImportLast_04

IAT-ImportLast_05

IAT-ImportLast_06

IAT-ImportLast_07

IAT-ImportLast_08

IAT-ImportLast_09

Field references

Field Name

Sample Data

 

Description of data

Date

9/18/2009

 

Date format

Name

Joe Worker

 

Alphanumeric

Amount

($1,983.34)

 

Numeric/currency. Use standard sign protocols (positive DR; negative CR)

Receiver_ID_Number

Emp#8763

 

Alphanumeric

Originator_Name

Hershey USA

 

Alphanumeric

Originator_Street

4567 Kiss St.

 

Alphanumeric

Originator_City

Hershey

 

Alphanumeric

Originator_State

PA

 

Alphanumeric

Foreign_Exchange_Indicator

FF

 

Acceptable 2 position values: 'FF' (Fixed-Fixed);  'FV' (Fixed-Faviable);  or 'VF' (Variable-Fixed)

Originator_Status_Govt_Bank_TF

FALSE

 

Acceptable values: 'True' (Gov't entity) or 'False' (Bank or anyone else)

Foreign_Exchange_Rate

 

 

Alphanumeric. Note:  This is a nickname for ease of use, as the actual field is named Foreign Exchange Reference.

Foreign_Amount

$0.00

 

Numeric/currency

Originating_Currency

USD

 

Alphanumeric - must be valid abbreviation

Foreign_Exchange_Reference_Indicator

3

 

Acceptable values (one digit): '1' (Foreign Exchange Rate); '2' (Foreign Exchange Reference Number); or '3' (Space).  Describes content of Foreign_Exchange_Rate field. Tip: If Foreign Exchange Indicator is FF, then this entry should be '3' (space filled).

Outbound_Inbound_TF

0

 

Acceptable values (one-digit): '0' (zero - Outbound - originates in US); '1' (inbound - originates from international). Note: Do not confuse the origination with the cash DR/CR flow.

Receiver_Currency

USD

 

Alphanumeric - must be valid abbreviation

RDFI_ABA

81519361

 

Numeric

RDFI_Account

88776699

 

Numeric

Company_Entry_Description

Payroll

 

Alphanumeric

SEC_Code

IAT

 

Alphanumeric - must be valid abbreviation

Originator_Country

US

 

Alphanumeric

Originator_Zip

17033

 

Alphanumeric

Originator_ID_Number

227777777

 

Numeric

OFAC_Screening_Gateway

 

 

All users - leave blank unless specifically instructed. (For Gateway operators '0' indicates  a blocked party has not been found.  '1' Indicates a blocked party)

OFAC_Screening_Secondary

 

 

All users - leave blank unless specifically instructed. (For Gateway operators '0' indicates  a blocked party has not been found.  '1' Indicates a blocked party)

Foreign_Trace

Batch#2393

 

Alphanumeric

Transaction_Type_Code

SAL

 

Alphanumeric

Remittance

 

 

Alphanumeric.  Free form text that is inserted into the '17' records, a.k.a Remittance Information.

Receiver_Street

7654 Oak Dr

 

Alphanumeric

Receiver_City

Jericho

 

Alphanumeric

Receiver_State

NY

 

Alphanumeric

Receiver_Country

US

 

Alphanumeric

Receiver_Zip

11753

 

Alphanumeric

ODFI_Name

Bank of Hershey

 

Alphanumeric

ODFI_US_Foreign_TF

02

 

Acceptable values (two-digit): '01' US; '02' Foreign

ODFI_ABA

063000047

 

Alphanumeric

ODFI_Branch_Country_Code

US

 

Alphanumeric - must be valid abbreviation

RDFI_Name

Bank of Jericho

 

Alphanumeric

RDFI_US_Foreign_TF

01

 

Acceptable values (two-digit): '01' US; '02' Foreign

RDFI_Branch_Country_Code

US

 

Alphanumeric - must be valid abbreviation

Gateway_Operator

223092390

 

Numeric

How Can We Help You?

Call Us (866) 226-5732
Contact Us Online
Schedule a call

Some of our clients:

Testimonials >>