The following table contains all ReceivablesPro import fields, in alphabetical order, along with field descriptions and value parameters. Note that all fields are not supported in all import types.
|
Field Name |
Description |
|
Account # |
The Account # field is for your use, and is designed for your own unique identifier for this customer. It is an optional field, and need not be used.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Account Type |
The type of bank account being entered. Acceptable values are “Checking” for a checking account or “Savings” for a savings account.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
A required field for all one-time payment and recurring payment data rows that include “ACH” as the Billing Type. Enter: • PPD-- Written: you have written authorization from your customer. • CCD-- Business: use this code for any business-to-business transaction. • TEL-- The transaction was authorized over the phone (one-time payments only). • WEB-- The transaction was authorized using and online form.
NOTE: These entries are Case Sensitive. ACH Type must be entered in all capital letters.
NOTE: If “CCD” is entered, a company name must be part of the new or existing Customer Record, or the payment/schedule will fail.
See Authorizing Echeck (ACH) Transactions for how to select the appropriate ACH Type.
Can be used in One-time Payment & Recurring Payment Imports. |
|
|
Alternate Email |
Enter a second email address for the customer in this optional field.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Alternate Phone |
Enter a second phone number for the customer in this optional field.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Bank Account Number |
The customer’s bank account number. Enter this value as a text field. It is required whenever a new bank account is included as part of data row.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Bank Name |
The name of the bank for which an account is being entered. This field is required whenever a new Bank Account is included as part of a data row.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Billing Address 1 |
An optional field for all data rows that do not include a Customer ID. This field is for the street address portion of the customer’s billing address.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Billing Address 2 |
An optional field for all data rows that do not include a Customer ID. This field is for the secondary address portion (such as a suite or apartment number) of the customer’s billing address.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Billing Frequency |
A required field for all Recurring Payment imports. This field defines the frequency on which the schedule will run. Valid values are: "DAILY" "WEEKLY" "EVERY OTHER WEEK" "FIRST OF MONTH" "SPECIFIC DAY OF MONTH" "LAST OF MONTH" "QUARTERLY" "SEMI ANNUALLY" "ANNUALLY"
Can be used in Recurring Payment Imports. |
|
Card Type |
The type of credit card being entered. This field is required whenever a new credit card is included as part of a data row.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
City |
An optional field for all data rows that do not include a Customer ID. This field is for the City portion of the customer’s billing address.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Company |
Optional field that can be used any time a data row contains values for a new customer. Enter the customer’s company name.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Country |
Optional field for all data rows that include a new Customer Record. Enter “USA” or “Canada.” If the field is left blank, the system will default it to “USA.”
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Credit Card Billing Zip |
The zip/postal code associated with the credit card. If a billing address is provided, this field will inherit that value. If no billing zip code is mapped, this field is required when a new credit card is included as part of a data row.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Credit Card Number |
The credit card number of the account being entered. This field is required whenever a new credit card is included as part of a data row.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
CustomerID |
The Customer ID is assigned by the system as a unique identifier when a new Customer Record is saved. When uploading one-time payments and recurring payment schedules, provide this value to utilize an existing Customer Record and saved payment information. If this field is NOT supplied, then ALL of the fields necessary to add a new customer and all payment account fields are required for the data row.
Can be used in One-time Payment & Recurring Payment Imports. |
|
Custom fields of all types (Text, Text Area, Checkbox, Drop-Down) attached to the Customer module are supported in all imports. Custom fields of all types attached to the Payments module are supported in Payment imports only.
For Text and Text Area fields, enter any text but do not use commas or hard returns; they will corrupt the import.
For Checkbox fields, enter “True” for checked, and enter “false” or leave the field blank for unchecked.
For Drop-Down fields enter the field value, NOT the display text, in your import file.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
|
Custom First Payment Amount |
When importing a recurring payment batch, this field is used to designate the amount of a custom payment made prior to the schedule start date. This is an optional field, but when used requires that Custom First Payment Date also be used.
Enter the value as a text field, with a format of 0.00—do not include a dollar sign, or format the field as currency.
Can be used in Recurring Payment Imports. |
|
Custom First Payment Date |
When importing a recurring payment batch, this field is used to designate the date of a custom payment made prior to the schedule start date. This is an optional field, but when used requires that Custom First Payment Amount also be used.
Enter the value as a text field, with a format of mm/dd/yyyy—do not format the field as a date.
Can be used in Recurring Payment Imports. |
|
Day of Month |
When a recurring payment schedule data row includes a Billing Frequency of “Specific Day of Month” this field is required to designate the exact date on which the schedule is to execute. Enter a number from 1-31.
Can be used in Recurring Payment Imports. |
|
Day of Week |
When a recurring payment schedule data row includes a Billing Frequency of “Weekly” or “Every Other Week” this field is required to designate the exact day of the week on which the schedule is to execute. Enter “Monday” “Tuesday” “Wednesday” “Thursday” “Friday” “Saturday” or “Sunday”
Can be used in Recurring Payment Imports. |
|
Description |
An optional field, providing a text area for your use to attach a message to a one-time payment or a recurring payment schedule. You cannot use hard returns in this field.
Can be used in One-time Payment & Recurring Payment Imports. |
|
|
An optional field for all data rows that do not include a Customer ID. This field is for the customer’s default email address—the one to which the system will send receipts and invoices.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
End Date |
When a recurring payment schedule data row includes a Schedule Type of “Bill Payment” this optional field is used to specify a defined end date for the schedule. If this field is left blank for a “Bill Payment” schedule, then the schedule will run indefinitely.
Enter the value as a text field, with a format of mm/dd/yyyy—do not format the field as a date.
Can be used in Recurring Payment Imports. |
|
Expiration Date |
The expiration date of the credit card account being entered. This field is required whenever a new credit card is included as part of a data row.
Enter the value as a text field, with a mm/yy format—don’t format the field as a date.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
First Name |
A required field for all data rows that do not include a Customer ID. This field is for the customer’s first name.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Invoice # |
An optional field for all one-time payment rows and all recurring payment rows. Use this field to assign an alpha-numeric invoice # to a payment or schedule.
Can be used in One-time Payment & Recurring Payment Imports. |
|
Item Description |
A required field, providing a text area for your use to describe your product or service. You cannot use hard returns in this field. Maximum 500 characters
Can be used in List Item Imports. |
|
Item Name |
A required field for List Item imports. A text field for the name of a product or service. Maximum 40 characters.
Can be used in List Item Imports |
|
Item Price |
A required field for List Item imports. Use this field to enter the unit price for the item. Enter a positive or negative numeric value with up to two decimal places. Do not include the “$”
Can be used in List Item Imports |
|
Last Name |
A required field for all data rows that do not include a Customer ID. This field is for the customer’s last name.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Notes |
An optional field, providing a text area attached to the Customer Record. You cannot use hard returns in this field.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Number of Payments |
When a recurring payment schedule data row includes a Schedule Type of “Payment Plan” this field is required to designate the number of payments in the plan. Enter a number from 1-99.
Can be used in Recurring Payment Imports. |
|
Payment Amount |
The amount of the one-time payment, or the amount of the recurring bill payment. Enter the value as a text field, with a format of 0.00—do not include a dollar sign, or format the field as currency.
Can be used in One-time Payment & Recurring Payment Imports. |
|
Payment Type |
A required field for all One-time Payment and Recurring Payment imports. The type of transaction being entered. Enter “ACH” to debit a bank account, enter “CC” to charge a credit card. NOTE: These entries are case sensitive. Payment Type must be entered in all capital letters. (For example, enter “ACH” not “Ach” or “ach.”)
Can be used in One-time Payment & Recurring Payment Imports. |
|
Phone |
An optional field for all data rows that do not include a Customer ID. This field is for the customer’s main phone number.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
PO # |
An optional field for all one-time payment rows and all recurring payment rows. Use this field to assign an alpha-numeric P.O. number to a payment or schedule.
Can be used in One-time Payment & Recurring Payment Imports. |
|
Routing Number |
The 9-digit routing number for the customer’s bank. Enter this value as a text field. It is required whenever a new bank account is included as part of data row.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Schedule Type |
A required field for all recurring billing schedule rows. Use this field to indicate the type of schedule being established. Enter “Bill Payment” or “Payment Plan.”
Can be used in Recurring Payment Imports. |
|
Shipping Address 1 |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. However, if a data row includes shipping address information, this field is required. Enter the street address portion of the customer’s shipping address.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Shipping Address 2 |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. This field is always optional. Enter the secondary address portion (such as a suite or apartment number) of the customer’s shipping address
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Shipping City |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. However, if a data row includes shipping address information, this field is required. Enter the city of the customer’s shipping address.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Shipping Company |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. This field is always optional. Enter the company name for the customer’s shipping address
Can be used in Customer, One-time Payment & Recurring Payment Imports |
|
Shipping Contact Email |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. This field is always optional. Enter the email address for the customer’s shipping contact.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Shipping Contact Phone |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. This field is always optional. Enter the phone number for the customer’s shipping address.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Shipping Country |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. However, if a data row includes shipping address information, this field will default to “USA” unless “Canada” is entered.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Shipping First Name |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. However, if a data row includes shipping address information, this field is required. Enter the first name of the shipping contact.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Shipping Last Name |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. However, if a data row includes shipping address information, this field is required. Enter the last name of the shipping contact.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Shipping State/Province |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. However, if a data row includes shipping address information, this field is required. Enter the state/province of the customer’s shipping address using the official U.S. Postal Service two-letter abbreviation for the state or province. For example, for Colorado you would enter “CO”
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Shipping Zip/Postal Code |
Entering shipping address information is always optional. It can be included for all data rows that do not include a Customer ID. However, if a data row includes shipping address information, this field is required. For U.S. addresses, enter a 5 digit zip code, as a text field—Do not format the field as a zip code. For Canadian addresses enter the postal code as a single text string, do not include any spaces or dashes.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Start Date |
A required field for all Recurring Payment imports. Use this field to designate the first date upon which a payment from the schedule is to be generated. You can enter the current date or any future date.
Enter the value as a text field, with a format of mm/dd/yyyy—do not format the field as a date.
Can be used in Recurring Payment Imports. |
|
State/Province |
An optional field for all data rows that do not include a Customer ID. This field is for the state/province portion of the customer’s billing address. Enter the official U.S. Postal Service two-letter abbreviation for the state or province. For example, for Colorado you would enter “CO”
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Total Due |
When a recurring payment schedule data row includes a Schedule Type of “Payment Plan” this field is required to designate the total amount due for the plan. The system will divide this amount by the Number of Payments to determine the Payment Amount.
Enter the value as a text field, with a format of 0.00—do not include a dollar sign, or format the field as currency.
Can be used in Recurring Payment Imports. |
|
Website |
This is an optional field for all data rows that do not include a Customer ID. Enter your customer’s website address. Enter in the format of www.somesite.com.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |
|
Zip/Postal Code |
An optional field for all data rows that do not include a Customer ID. This field is for the zip/postal code portion of the customer’s billing address. For U.S. addresses, enter a 5 digit zip code, as a text field—Do not format the field as a zip code. For Canadian addresses enter the postal code as a single text string, don’t include spaces or dashes.
Can be used in Customer, One-time Payment & Recurring Payment Imports. |