One-time Payment Import Requirements

There are two types of One-time Payment Imports:

After a successful import, all transactions are processed immediately and appear in the manage payments screen. (See Importing One-time Payments in Chapter 4 for more information about payment batches.)

You can locate the Customer ID for any customer, by viewing or editing a Customer Record. The Customer ID is located at the very top of the View Customer Details or Edit Customer Details screen, as shown:

customer_ID.jpg

 

You can also export your entire customer list, including the Customer ID for each customer. (See Exporting the Customer List in Chapter 6 for more information.)

One-Time Payment Import Requirements for Existing Customers

Required Fields

Optional Fields

Customer ID

Payment Amount
(enter as ‘0.00, as text, without the $)

Payment Type (ACH or CC)

ACH Type (PPD, CCD, TEL, WEB)
Used only if Payment Type = ACH. (See Authorizing Echeck (ACH) Transactions for how to select the appropriate ACH Type.)

Invoice #

PO #

Description

Payment Custom Fields

*NOTE: If you enter “CCD” as the ACH Type and there is no Company Name attached to the Customer Record the row will fail and the payment will not be processed.

 

noate.gif 

You can include any combination of one-time payments in a single one-time Payment import.

For example, a single file can include rows for: An ACH payment for an existing customer, an ACH payment for a new customer, a credit card payment for an existing customer, and a credit card payment for a new customer.

 

One-Time Payment Import Requirements for New Customers

Required Customer Fields

Optional Customer Fields

Required Payment Fields

Optional Payment Fields

First Name

Last Name  

Billing Address 1

Billing Address 2

City

State/Province

Zip/Postal Code

Country*

Company

Email

Alternate Email

Phone

Alternate Phone

Account #

Website

Shipping Address 1

Shipping Address 2

Shipping City

Shipping State

Shipping Zip

Shipping Country

Shipping First Name

Shipping Last Name

Shipping Company

Shipping Contact Phone

Shipping Contact Email

Notes

Customer Custom Fields

Payment Amount
(enter as ‘0.00, as text, without the $)

Payment Type (ACH or CC)

Invoice #

PO #

Description

Payment Custom Fields

If Payment Type = ACH, the following fields are required:

Account Type

•  Enter “Checking”

•  Enter “Savings”

Bank Name

Bank Account Number

Routing Number

ACH Type
(PPD, CCD, TEL, WEB)
(See Authorizing Echeck (ACH) Transactions for how to select the appropriate ACH Type)

If Payment Type = CC, the following fields are required:

Credit Card Number

Card Type

•  Enter “Visa"

•  Enter "Master"

•  Enter "AMEX"

•  Enter "Discover"

Expiration Date (MM/YY)

Billing Zip Code

*NOTE: If the Country field is unmapped or left blank, it will default to USA if a billing address is included. If you enter any required portion of the billing or shipping address (Address 1, City, State, Zip) all required portions of that address must be included or the row will fail.

**NOTE: If you enter “CCD” as the ACH Type and there is no Company Name provided for the customer, the row will fail and the payment will not be processed.

NOTE: The credit card added via a new customer payment row will be assigned as the default credit card. The bank account added via a new customer payment row will be assigned as the default bank account.

NOTE: You are required to provide receipts for all payments processed via ReceivablesPro.If you import an email address for the Customer, the system can do this for you. If you do not import an email address, be certain that you are collecting contact information and providing a receipt in some other way.

 

Next Section: Recurring Payment Import Requirements >