Customer Bank Account Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Customer Bank Account Import

Column

Position

Field

Maximum Length

Format

Required

Description

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.

Prerequisites

Before using this import, the following must be set up: