Account Import

Use the Account Import file to create and modify multiple accounts. With this import file, you can create, suspend, reactivate, and close accounts; update cardholder information; update account limits and settings; and update account hierarchy and MCC Groups. The Account Import file can contain up to 10,000 records.

File opens in a new window Account with Custom Fields Import Template

File opens in a new window Account without Custom Fields Import Template

These templates have built-in error checking capabilities you can use to verify that the data in your import file meets the PaymentNet requirements and make any necessary corrections before you submit the file for processing. Refer to the Instructions tab in the template for detailed information about how to use the validation features. If you are currently using a template that does not include error checking, you will need to download a new version of the template file, using one of the links above, and use it in place of your existing file.

Note: Even after the account data has been validated in the template, line item errors may be reported during the account import process. If this happens, copy each line that contains an error to a new import file, update these lines to fix the errors, and then import the new file (containing only the fixed line items) into PaymentNet. If you fix the line items in the original file and then import the same file again, a duplicate account will be created for each line that did not originally contain an error. For more information about line item errors, see Troubleshooting Import Errors.

The Account Import File Layout table outlines the requirements for entering your data into an Account Import template. To ensure a successful import, review the considerations outlined below before beginning the import. In addition, be sure to familiarize yourself with the guidelines found in General Import File Tips.

Once the Account Import file or Account Batch FTP file has been submitted, all the relevant fields (such as First Name on Card, Middle Initial, Last Name on Card, Hierarchy ID, Business Phone Number, and Email Address) are automatically entered in PaymentNet when the processor sends confirmation that the new account has been created. The new account can take up to 48 hours to be processed and available for use in PaymentNet.
If the Account Import file loads successfully with errors, the account has been created. Do not submit the import file again unless the error message instructs you to do so; otherwise, a second new account might be created.
To create a new employee who can log in to PaymentNet, enter an Employee Type of New, set Generate Login Information to 1, and specify a User ID for the employee.
MCC Group limits cannot be added or changed using the Account Import file; you must use the Account Detail - MCC Group Controls screen in PaymentNet.
Likewise, temporary account limits, MCC Group limits, and temporary MCCGs cannot be added or changed using the Account Import file; you must use the Account Detail - Temporary Controls screen in PaymentNet.
If you are creating a new account, custom field values are copied over from the template account by default. To leave these fields blank, set Blank Override to 1 (enabled) and leave the blank fields in the import file. To specify a new value, enter the value.
To change the hierarchy location of an account that is associated with an existing user ID, enter the new hierarchy location in the Hierarchy ID column of the Account Import file. PaymentNet will accept this as an update, and the account and its transactions will be moved to the new hierarchy node.
If an account has a status of Lost Or Stolen, Closed, or Purged, you cannot move it to the Unassigned hierarchy.
You cannot update an account if it is in Purged status.
If the duplicate hierarchy ID function is enabled, the hierarchy ID you enter must contain the full path, starting from the root and separating each of the nodes with a backslash (\). For example, you would enter the hierarchy of Root > Chicago > JPMC > Finance as Root\Chicago\JPMC\Finance
Leaving the Single Amount Limit field blank will remove the single amount limit if Blank Override is enabled.
When an MCC Group (MCCG) is updated for an account, the update overwrites any existing MCCGs that have an action value of Include, Exclude, or Blank.
Either the First Name on Card or Last Name on Card must be specified when the account is created. You cannot use an Account Import file to update the First Name on Card, but you can update the Last Name on Card as long as the First Name on Card exists.
If the option to synchronize account and employee email addresses is enabled for a hierarchy, updating the account email address via an Account Import file will also update the email address in the cardholder’s user profile and in all of the cardholder’s accounts.

To replicate the Authorization Limit fields of an existing account, you can use the export functionality on the Account List screen. First, modify the Account List screen to show the authorization limit fields. Then, export the template account data and copy and paste the fields into the Account Import file. This process ensures the limits are accurately updated when accounts are modified.

Please note the following restrictions on account limits:

The Credit Limit for an account cannot exceed the credit limit of the overall Central Bill Account.
If cash advance is available at the Central Bill Account level, the Cash Advance Limit for an account cannot exceed $2500 per cycle.
The Cash Advance Limit and the Daily Amount Limit cannot be greater than the Credit Limit.
The Daily Transaction Limit cannot be greater than the Monthly Transaction Limit.
The Single Amount Limit cannot be greater than the Daily Amount Limit.
Users can set Cycle Limits or Monthly Limits, but not both. If both authorization limits are included in the file, PaymentNet ignores the Monthly Limits.

Account Import File Layout
Column	Name	Description	Required	Valid Codes
A	Account Number	For new accounts, this column indicates the template account or the account that is being replicated. For an account update, this column indicates the account being updated.	Yes	Must be: 16-digit account number
B	Employee Type	This column indicates whether the account is being created for a new PaymentNet user or an existing user. Note that PaymentNet does not require a user ID for every account. For example, you might issue a card to an individual who is not going to log in to PaymentNet or require a user ID. In this case, you would enter an Employee Type of “None.”	Yes for Add No for Update	Valid values are: New: The employee does not have a PaymentNet user ID. Also, to allow the employee to log in, enter a 1 in the Generate Login Information field. Existing: The employee has a PaymentNet user ID. Use this option to add a new account or modify an existing account for a user within your scope of view. None: No user ID is associated with the account.
C	User ID	The PaymentNet user ID (if any) that is tied to the account. PaymentNet does not require a user ID for every account. In this case, the Employee Type of “None” must be used.	Yes for Add No for Update	Must be: Alphanumeric Between 6-20 characters No spaces or special characters
D	Generate Login Information	Generates PaymentNet login information to send to SiteMinder. SiteMinder is a third-party application that validates login information. SiteMinder stores and maintains the required user information associated with each account and passes that information to the appropriate PaymentNet application section. Once a request is sent to SiteMinder, it cannot be sent again.	No, unless you want to provide login credentials for the employee	Valid values are:: 0: No login credentials will be generated. 1: Login credentials will be generated so that the cardholder can log in to PaymentNet.
E	Hierarchy ID	The hierarchy ID to which the account is associated	Yes for Add No for Update	Must be: Alphanumeric 20 characters max for organizations that do not use the duplicate hierarchy ID function 508 characters max for organizations that use the duplicate hierarchy ID function
F	Status	Account status	No	Valid values are: Active Suspended Closed When Card Delivery is specified, valid values are: New Active Suspended
G	Reason	Reason associated with the “Closed” account status	No for Add Yes for Update with Status of “Closed”	Valid value is: 1: Account closed online by APC/Admin
H	Prefix	Prefix associated with the cardholder’s name	No for Add Not allowed for Update	Must be: Alphanumeric 4 characters max
I	First Name on Card	Cardholder’s first name as displayed on the card	Either First Name on Card or Last Name on Card is required for Add. Not allowed for Update	Must be: Alphanumeric Uppercase Maximum of 21 characters combined for the First Name on Card, Middle Initial, and Last Name on Card fields Space and dash are the only special characters allowed in this field.
J	Middle Initial	Cardholder’s middle initial	No for Add Not allowed for Update	Must be: Alphanumeric 1 character max Uppercase Space and dash are the only special characters allowed in this field.
K	Last Name on Card	Cardholder’s last name as displayed on the card	Either First Name on Card or Last Name on Card is required for Add. Not allowed for Update if First Name on Card is not specified for the account	Must be: Alphanumeric Uppercase Maximum of 21 characters combined for the First Name on Card, Middle Initial, and Last Name on Card fields Space and dash are the only special characters allowed in this field.
L	Suffix	Suffix associated with the cardholder’s name	No	Must be: Alphanumeric 4 characters max
M	Second Row of Embossing	Information embossed on the physical card below the name. If left blank, this value defaults from the template account.	No Not allowed for Update	Must be: Alphanumeric 21 characters max for MasterCard 19 characters max for Visa
N	Date of Birth	Cardholder’s date of birth (must be at least 18 years of age)	Yes for Add (either Date of Birth or Mother’s Maiden Name required) No for Update	Must be: mm/dd/yyyy format
O	SSN/SIN/Tax ID	Cardholder’s Social Security Number, Social Insurance Number, or Tax Identification Number Also known as Access Code 1.	Yes for Add No for Update	Must be: Numeric 9 characters exactly (without dashes) or 11 characters exactly (with dashes) For Joint & Several or Corporate Liability programs, only the last 4 SSN/SIN/Tax ID digits are required; however, 9 digits total must be entered. In these instances, use the format 900-00-1234, where 1234 are the last four digits of the SSN/SIN/Tax ID.
P	Mother’s Maiden Name	Maiden name of the cardholder’s mother Also known as Access Code 2.	Yes for Add (either Date of Birth or Mother’s Maiden Name required) No for Update	Must be: Alphanumeric 4 characters max
Q	Cardholder Address Line 1	Cardholder Address Line 1	Yes for Add No for Update	Must be: Alphanumeric 30 characters max
R	Address Line 2	Cardholder Address Line 2	No	Must be: Alphanumeric 30 characters max
S	City	Cardholder’s City	Yes for Add No for Update	Must be: Alphanumeric 25 characters max
T	State/Province	Cardholder’s State/Province	Yes for Add No for Update	Must be: Alphabetic 2 characters exactly
U	ZIP/Postal Code	Cardholder’s Zip/Postal Code	Yes for Add No for Update	Must be: If Country is USA, 5 or 9 numeric characters exactly If Country is CAN, up to 7 alphanumeric characters
V	Country	Cardholder’s Country	Yes for Add No for Update	Must be: Alphabetic Valid values are: USA for United States CAN for Canada
W	Statement Address Line 1		Not used	Leave this column blank
X	Address Line 2		Not used	Leave this column blank
Y	City		Not used	Leave this column blank
Z	State/Province		Not used	Leave this column blank
AA	ZIP/Postal Code		Not used	Leave this column blank
AB	Country		Not used	Leave this column blank
AC	E-Mail Address	Cardholder’s business email address	Yes for new accounts	Must be: Alphanumeric 50 characters max Must contain the @ sign No spaces allowed Supported special characters are < > / \| space \
AD	Business Phone	Cardholder’s business phone number	Yes if Mobile Phone is not specified	Must be: Numeric Exactly 10 characters when you create or modify an account using the ########## format. Exactly 12 characters when you create or modify an account using the ###-###-#### format.
AE	Mobile Phone	Cardholder’s mobile phone number	Yes if Business Phone is not specified	Must be: Numeric Exactly 10 characters when you create or modify an account using the ########## format. Exactly 12 characters when you create or modify an account using the ###-###-#### format.
AF	Custom Field 1\| Custom Field 2\| Custom Field 3	Custom fields associated with the account The header row needs to be updated with the names of the account custom fields. Custom fields need to be updated to reflect the account custom fields set up in PaymentNet.	No If custom fields are not used, the column header row and each cell in the column must be left blank.	Must be: Pipe delimited Unlimited Note: If you are not providing a value for the custom fields, you must enter a dash (-) for each blank value separated by the pipe character (\|). For example: -\|-\|-
AG	Notes	Notes or comments entered by the user and associated with the account	No	Must be: Alphanumeric 2000 characters max
AH	Employee ID	Employee ID sent to the processor	No	Must be: Alphanumeric 20 characters max Supported special characters are: ~ ‘ ! @ # $ % ^ & * () - _ = + \ \| } ] { [ ‘ “ ; : / ? . ,
AI	Cost Center	Cost Center ID associated with the account	No	Must be: Alphanumeric 10 characters max
AJ	VIP	Designates whether or not the account has VIP status	No	Valid values are: 0: Not VIP status 1: VIP status
AK	International	Designates whether the address is a non-U.S. or non-Canadian address Note: PaymentNet does not currently use this field.	No	Valid values are: 0: Not an international address 1: International address
AL	Credit Limit	Credit limit for the account If left blank, this value defaults from the template account.	Yes for new accounts	Must be: Numeric 7 characters max No spaces or commas
AM	Cash Advance Limit	Cash advance limit for the account If left blank, this value defaults from the template account. The individual cash advance limit must not exceed 2500 per cycle.	No	Must be: Numeric 7 characters max No spaces or commas
AN	Monthly Transaction Limit	Monthly transaction limit for the account If left blank, this value defaults from the template account.	No	Must be: Numeric 3 characters max No spaces or commas
AO	Monthly Amount Limit	Monthly amount limit for the account If left blank, this value defaults from the template account.	No	Must be: Numeric 7 characters max No spaces or commas
AP	Cycle Transaction Limit	Cycle transaction limit for the account If the Monthly Transaction Limit is entered, the Cycle Transaction Limit is not allowed. If left blank, this value defaults from the template account.	No	Must be: Numeric 3 characters max No spaces or commas Greater than zero
AQ	Cycle Amount Limit	Cycle amount limit for the account If the Monthly Amount Limit is entered, the Cycle Amount Limit is not allowed. If left blank, this value defaults from the template account.	No	Must be: Numeric 7 characters max No spaces or commas Greater than zero Less than or equal to the Central Bill Credit Limit
AR	Daily Amount Limit	Daily amount limit for the account If left blank, this value defaults from the template account.	No	Must be: Numeric 7 characters max No spaces or commas
AS	Daily Transaction Limit	Daily transaction limit for the account If left blank, this value defaults from the template account.	No	Must be: Numeric 3 characters max No spaces or commas
AT	Single Amount Limit	Single amount limit for the account If left blank, this value defaults from the template account.	No	Must be: Numeric 7 characters max No spaces or commas
AU	Other Transaction Limit	Other transaction limit for the account Either the Other Transaction Limit is specified, or the Other Amount Limit and the Other Refresh Date are specified. If left blank, this value defaults from the template account.	No	Must be: Numeric 3 characters max No spaces or commas
AV	Other Amount Limit	Other amount limit for the account Either the Other Transaction Limit is specified, or the Other Amount Limit and the Other Refresh Date are specified. If left blank, this value defaults from the template account.	No	Must be: Numeric 7 characters max No spaces or commas Greater than zero Must also specify valid Other Refresh Date and Other Number of Days values
AW	Other Number of Days	Number of days that variable velocity checks can be used If left blank, this value defaults from the template account.	Yes, if the Other Transaction Limit or Other Amount Limit is used	Must be: Numeric 3 characters max Greater than zero
AX	Other Refresh Date	Date that the variable (Other) velocity counter starts Either the Other Transaction Limit is specified, or the Other Amount Limit and the Other Refresh Date are specified. If left blank, this value defaults from the template account.	Yes, if Other Transaction Limit or Other Amount Limit is used	Must be: mm/dd/yyyy format
AY	MCC Group 1	Merchant Category Code Group associated with the account A maximum of nine MCCGs can be associated with an account. Each MCCG is treated as an individual field in the input file. If left blank, this value defaults from the template account.	Yes for Add No for Update	Must be: Alphanumeric 10 characters max Exists in the organization Unique in the import file Unique for the account
AZ	MCC Group Action 1	Indicates whether the specified MCCG is included in the account or excluded from the account. Each MCC Group has a MCC Group Action associated with it. Each MCC Group Action is treated as an individual field in the input file. If left blank, this value defaults from the template account.	Yes, if the corresponding MCC Group is specified	Valid values are: I: Include E: Exclude
BA	MCC Group 2	See AY	See AY	See AY
BB	MCC Group Action 2	See AZ	See AZ	See AZ
BC	MCC Group 3	See AY	See AY	See AY
BD	MCC Group Action 3	See AZ	See AZ	See AZ
BE	MCC Group 4	See AY	See AY	See AY
BF	MCC Group Action 4	See AZ	See AZ	See AZ
BG	MCC Group 5	See AY	See AY	See AY
BH	MCC Group Action 5	See AZ	See AZ	See AZ
BI	MCC Group 6	See AY	See AY	See AY
BJ	MCC Group Action 6	See AZ	See AZ	See AZ
BK	MCC Group 7	See AY	See AY	See AY
BL	MCC Group Action 7	See AZ	See AZ	See AZ
BM	MCC Group 8	See AY	See AY	See AY
BN	MCC Group Action 8	See AZ	See AZ	See AZ
BO	MCC Group 9	See AY	See AY	See AY
BP	MCC Group Action 9	See AZ	See AZ	See AZ
BQ	Rush Card Delivery	Indicates whether or not a rush delivery is requested for the card. Can only be used for new accounts.	No	Valid values are: Y or y: Rush card delivery is requested N or n: Rush card delivery is not requested This column can only be used if rush card delivery is enabled for your organization.
BR	Card Delivery	Address ID or delivery site code where the card is to be shipped	No	Must be: Numeric 5 characters max
BS	Full First Name	Cardholder’s legal first name	Yes for new Individual accounts; No for new Department accounts. No for Update	Must be: Alphanumeric Uppercase Maximum of 21 characters combined for the Full First Name and Full Last Name fields
BT	Full Last Name	Cardholder’s legal last name	Yes for new Individual accounts; No for new Department accounts. No for Update	Must be: Alphanumeric Uppercase Maximum of 21 characters combined for the Full First Name and Full Last Name fields
BU	Country of Citizenship	Cardholder’s country of citizenship	No	Must be: Alphabetic Valid values are: Any valid 3-letter ISO Country Code
BV	Primary Home Address 1	Cardholder’s primary home Address Line 1	Yes for new Individual accounts; No for new Department accounts. No for Update	Must be: Alphanumeric 30 characters max
BW	Primary Home Address 2	Cardholder’s primary home Address Line 2	No	Must be: Alphanumeric 30 characters max
BX	Primary Home Address City	Cardholder’s primary home address city	Yes for new Individual accounts; No for new Department accounts. No for Update	Must be: Alphanumeric 25 characters max
BY	Primary Home Address State/Province	Cardholder’s primary home address state or province	Yes for new Individual accounts; No for new Department accounts. No for Update	Must be: Alphabetic 2 characters exactly
BZ	Primary Home Address Zip/Postal Code	Cardholder’s primary home address ZIP or postal code	Yes for new Individual accounts; No for new Department accounts. No for Update	Must be: If Country is USA, 5 or 9 numeric characters exactly If Country is CAN, up to 7 alphanumeric characters
CA	Primary Home Address Country	Cardholder’s primary home address country	Yes for new Individual accounts; No for new Department accounts. No for Update	Valid values are: USA for United States CAN for Canada
CB	Type of Account	Cardholder account type	Yes for Add No for Update	Valid values are: I for Individual D for Department For a Department account, completed values for these fields are not included in the import: Full First Name Full Last Name Country of Citizenship Home Street Address Home Street Address Line 2 Home Address City Home Address State/Province Home Address Zip/Postal Code Home Address Country
CC	Add/Update	Indicates whether the record is for creating a new account or for updating an existing account.	Yes	Valid values are: Add: Create a new account Update: Modify an existing account
CD	Blank Override	Specifies whether or not to replace existing values with null values when import file columns are blank. Blank Override is applicable on these fields: Custom Fields Notes E-mail Business Phone Mobile Phone Cost Center Employee ID Cash Advance Limit Monthly Transaction Limit Daily Amount Limit Daily Transaction Limit Single Amount Limit	Yes	Valid values are: 0: Retain the existing value if the corresponding field is left blank 1: Overwrite the existing value with a null value if the corresponding field is left blank