ReceivablesPro import files must be in .csv (comma delimited text) format or pipe delimited text format. All fields, including date fields, must be formatted as text fields. All credit card account numbers must also be entered without any dashes or spaces.
You can use column headers in your file if you like. (You can also upload files without headers.) You do not need to use the ReceivablesPro field names in your header row. Use field names you will easily recognize, as you will be mapping these fields to ReceivablesPro system fields during the import process.
|
Do not use commas in any of the fields when creating a .csv import file. Doing so will corrupt your data and cause values to be mapped to the wrong fields. For example, you should never enter a company name as “ABC Company, Inc.” Instead, enter “ABC Company Inc.” |
For more information on proper formatting of ReceivablesPro import files, see Appendix C: Import Requirements. (For details specific to Recurring Payment imports, see Recurring Payment Import Requirements in Appendix C).
When creating new customers and recurring payment schedules via an Import file you can include any fields available in the Customer Record, as well as all fields available for entering Recurring Billing and Payment Plan schedules. (For a complete list and description of all fields available in a new customer Recurring Payment import see Customer Import Requirements in Appendix C)
The following fields are required for all Recurring Payment import files containing new customers:
First Name
Last Name
NOTE: You are required to provide receipts
for all scheduled payments processed via ReceivablesPro,
and to provide your customer a schedule confirmation as well as notifications
for any material changes made to the payment schedule. 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 receipts and notifications in some
other way.
Payment Type (Enter “ACH” or “CC”)
If Payment Type
= “ACH” then ACH Type is also a required field. Enter “PPD” “CCD”
or “WEB.” (See Authorizing Echeck (ACH) Transactions
for more information on ACH Types.)
NOTE: If you enter “CCD” as the ACH
Type, you must also enter a Company Name for the customer, or
the schedule will fail.
Payment account information fields as follows:
Credit Card Accounts
Credit Card Number (no dashes or spaces)
Card Type: Enter "AMEX" or “Visa" or "Master" or “Discover."
Expiration Date (MM/YY)
Billing Zip / Postal Code
Bank Accounts
Account Type: Enter “Checking” or “Savings”
Bank Name
Bank Account Number
Routing Number
If “Bill Payment” enter payment Amount.
If “Payment Plan” enter Total Due and Number of Payments.
Frequency: Enter “Daily” or “Weekly” or “Every Other Week” or “First of Month” or “Last of Month” or “Specific Day of Month” or “Quarterly” or “Semi Annually” or “Yearly.”
For “Weekly” and “Every other Week” include “Day of Week” field. Enter “Monday” or “Tuesday” or “Wednesday” or “Thursday” or “Friday” or “Saturday” or “Sunday.”
For “Specific Day of Month” also include “Day of Month” field. Enter a number between 1 and 31.
Schedule Start Date (mm/dd/yyyy)
The easiest way to create and save your Recurring Payment import file is to create it in Excel then export it as a .csv file. To do this, use the “save as” function in Excel, and select “comma delimited csv” as the file type.
