Connecting Data to the Online Forms Builder

The Data Manager takes you to a page where you can upload a batch or enter a single record. Each record represents the payment related information which your customer can access using a lookup (E.g: invoice no., customer ID, etc.) when they visit your website to make a payment. The data you upload can include attachments with the option for password protection. This process can be manual (as shown below), or automated using our Web services.

To add an attachment to your upload file, include the name of the file in the CSV file. When first saved that attachment file will be displayed in red. After you upload the actual file attachment as a Zip file the file name text will switch to blue indicating that the file is attached. You can upload one or many file attachments and they will sync up with the correct file names so your customers get the correct attachments.

Example: Your customer Bob Smith enters his Account Number in the Online Form and is presented with any outstanding items (that you connected) for payment.

And if Bob tries to pay later than the due date a PAST DUE AMOUNT is included automatically based on the dates and past due amounts you set.

In addition to adding or uploading a file, you can convert the CSV file to a Zip file (for larger files).

Uploading Form Data information into the system must be in the form of a CSV file. Please use the following tips to make sure the file is in the proper format.

- The file must be a CSV file
- A link to a sample file is included in the 'Upload Data List' pop-up window
- First row must contain header information as show below:

  • Lookup Field1 - 50 character max
  • Lookup Field2 - 50 character max
  • Description - 120 character max
  • Amount - valid numeric value with 2 decimal places
  • Start Date - data in MM-DD-YYYY format
  • End Date - data in MM-DD-YYYY format
  • Pastdue Date - data in MM-DD-YYYY format
  • Pastdue Amount - valid numeric value with 2 decimal places
  • File Name - 20 character max
  • File Password - 20 character max
  • Password Hint - 20 character max
  • SMS Phone Number

Here is an example of a single record imported file:

In this example the customer coming to make a payment would enter 1234 in Lookup1 to quickly find their account and see that they owe $50.00 for a Service Fee.

Note: This feature also is a good way to only accept payments of someone on your Data List by limiting access to the secure payments page.

See more on creating a Data Form.


Have more questions? Submit a request


Please sign in to leave a comment.