Creating a Recurring Payment Import File for Existing Customers

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, since you will be mapping these fields to ReceivablesPro system fields during the import process.

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)
NOTE: You can include as many fields as you like in the import file, but the system will only import data for the fields you map to ReceivablesPro system fields. This saves time when exporting data from another system, since you do not need to filter the data prior to importing the file into ReceivablesPro.

When importing recurring payment schedules for existing customers you cannot use the import to make changes to existing values in a Customer Record. Any changes you make to Customer Record fields will be ignored if you provide and map a Customer ID in your import row.

For example, if for Customer ID 1234 the system shows a first name of “Bobby,” you cannot change that to “Robert” by entering “Robert” in the “First Name” field of an existing customer Recurring Payment import file.

Only the following required and optional fields are available in Recurring Payment import files for existing customers. (See Recurring Payment Import Requirements in Appendix C for details.)

Required Fields

Customer ID
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, there must be a Company Name included in the Customer Record, or the schedule will fail.
Schedule Type: Enter “Bill Payment” or “Payment Plan.”
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” include “Day of Month” field. Enter a number between 1 and 31.
Schedule Start Date (mm/dd/yyyy)

Optional Fields

Invoice number
P.O. Number
Description
End Date (mm/dd/yyyy)-- for use with “Bill Payment” schedules only.
NOTE: If you do not enter an End Date for a Bill Payment schedule, the schedule will be entered with no end date—it will run indefinitely or until you manually suspend it.
Custom First Payment Amount and Custom First Payment Date (you must use both or neither.)

A sample existing customer Recurring Payment import file created in Excel is shown below:

NOTE: The First Name and Last Name columns are for reference purposes. They will not be mapped as part of the import into ReceivablesPro.

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.

Once you save an Excel file as a .csv file, it is very important that you do not open or edit the .csv file in Excel prior to importing it into ReceivablesPro. Doing this will corrupt the file and cause import errors.

If you need to make a change to the data in your Recurring Payment import file, open the Excel file, make any changes required, then use the “save as” function to save the edited file in .csv format.

Next >