Customer Bank Account Import Format

A

1

Paying Customer Code

12

Character

Yes

Enter a valid customer code for a customer set up as a paying customer.

Note The combination of the paying customer code, routing number, and bank account number must be unique.

B

2

ABA Routing Number

20

Integer

No

Enter the bank's routing number for the customer's bank account.

Note The combination of the paying customer code, routing number, and bank account number must be unique.

C

3

Bank Account Number

20

Integer

Yes

Enter the paying customer's account number.

Note The combination of the paying customer code, routing number, and bank account number must be unique.

D

4

Bank Account Name

40

Character

No

Enter the name of the account holder for the bank account.

E

5

IBAN

40

Character

No

Enter the International Bank Account Number (IBAN) for the customer's bank account.

F

6

Bank Code

12

Character

No

Enter a valid bank code for the customer's bank account. For information on setting up bank codes, see Bank Code Maintenance.