Secure Payments Payment Profile Import

Introduction

Occasionally, you may have a large batch of payment profiles that you need to enter into Secure Payments. Entering each payment profile manually is not only time-consuming, but it could lead to entry errors. Instead, you can add large quantities of payment profiles with ease by using the Secure Payments import tool. 

To maintain PCI compliance, this tool is unique to Secure Payments; payment profile data should only be input or uploaded here. For this reason, there is no payment profile import tool in LoanPro's Loan Management System.

In this article, we will explain how to import payment profile information using Secure Payment's import tool.

Multi-Factor Authentication

The first step to importing payment profile data is setting up multi-factor authentication. This requires a smart phone and an app. If you don’t already have a multi-factor authentication app, we recommend using Google Authenticator. If you have multi-factor authentication set up already, you can skip this step and head to Creating the Import File.

Secure Payments is a PCI-compliant product and requires that you use multi-factor authentication if you are importing credit/debit card data. However, Secure Payments will walk you through the setup. To set up multi-factor authentication, you will first be asked to enter your Secure Payments username and password.

If you haven't set multi-factor authentication up, navigate to Profile > MFA Settings.

These fields should be auto-filled for you. Next, click 'Submit'. Now, you will be shown a QR code that you can scan to add Secure Payments to your current multi-factor authentication app.

Scanning the QR code with a smart phone should prompt your authenticator app to open. Enter the code from your app and click 'Submit'. Now, you will be able to import payment profile information.

Creating an Import File

Import page within Secure Payments. In the top right corner of the page, a box highlights the 'i' icon that pulls up templates.

The easiest way to create an import file is to use the template file we provide. To download the template file, click the 'more information' icon highlighted in red in the image above.

The pop-up window for downloading template import files. There are three tabs: Checking Account, Bank Card, and Transaction Update.

Clicking the 'more information' icon will display a window like shown above. This window has three tabs at the top for importing checking account, bank card, and transaction update information. These tabs provide instructions and provide a download link for the import sample files. We recommend using these to ensure your information is formatted correctly. You can download each template file within the windows, but you can also download them below:

Download the Checking Account file

Download the Bank Card file

Download the Transaction Update file

Each sample file is a .csv file formatted like this:

An excel sheet with fields listed at the tops of each column. The fields are listed in the table below this image.

The first row of the sample file includes the available headers. The second row contains example information for all the required fields.

The available fields for the Bank Account import file are as follows:

Field

Notes

profile_id

account number

routing number

eft branch number

This is only for Canadian bank accounts.

eft institution number

This is only for Canadian bank accounts.

bank name

address

This is the address that the account holder has on file with the bank.

city

2 letter state code

This will be a two-letter province code for Canadian accounts.

zipcode

This will be a postal code for Canadian accounts.

3 letter country code

When you import bank accounts into Secure Payments, the import does not validate the routing numbers; it simply checks to make sure they are nine digits long.

The available fields for the Bank Card import file are as follows:

Field

Notes

profile_id

cardholder name

expiration date

Formatted as MM-YYY.

card number

address

This is the address the account holder has on file with the bank.

city

2 letter state code

This will be a two-letter province for Canadian accounts.

3 letter country code

Each row in the file represents one payment profile. Once you have entered the information for the payment profiles you want to import, save the file. Then, back in Secure Payments, click the large plus icon to import your newly saved file.

The data you enter into your import files may include leading zeros. These are pieces of data that have numbers that begin with zeros, such as an ID like "00045789". Excel tends to drop the zeros in this data since it thinks you won't need them. If you would like Excel to keep your leading zeros, our Keeping Leading Zeros on Your Import and Export Files article will explain how to do so.

Importing a File

To import your file, first choose whether the file you are uploading contains bank account or credit/debit cards from the “File type” drop-down. You can also specify who will be notified when the import is validated and completed using the "Notification Email Address" field. 

If you select "Address on account", the notification email will be sent to the email associated with your Secure Payments account. If you select "Custom", another field will appear where you may enter the email address where you would like to receive the notifications. Once you have specified which file to upload, enter the MFA code generated from your multi-factor authentication app. Finally, click 'Save' to finish.

When you finish your upload, you will receive a message notifying you that the upload was successful. You should now see your upload in the list of historical imports.

If there are any errors in your file, the file will not be able to be verified. If error occurs, the upload will display "No" under the Verified column. You will also receive an email notifying you that the import validation failed. This email will contain a file with a list of all errors in your import file. You can also download this error file by selecting the download icon in the Verify File column. If your file contains errors, you may fix the errors and download the file again.

If the file is error free, complete the import process by clicking the cloud icon to upload it.


How did we do?


Powered by HelpDocs (opens in a new tab)