Upload Checks
Pro-Logo.png

The Upload Checks page enables you to send a file of ACH transactions to be processed by PayTrace.

If you wish to process checks and you are not already signed up for this feature, please contact your Merchant Service Provider or PayTrace Support at moc.ecarTyaP|troppuS#moc.ecarTyaP|troppuS.

How to Use This Page

  1. Click the Upload Checks link in the Checks menu.
  2. Select the field delimiter for your file.
  3. Select the field positions for your file upload.
  4. Click the Browse button and select the file you want to upload.
  5. Click the Upload button.

NOTE:
An error will be emailed to the administrative email address(es) on your account if errors prevent any of the check transactions from being processed.


Detailed Help

Links

Download the default check import template
Download a check template in .csv format that can be used to upload products.
View the check import data definitions
View a .pdf file that lists the data definitions for each field.

Data Definitions

Name Description Format Length Required
Transaction_Type Must be one of the following transaction types: Sale, StrFwd, or Refund. Alphabetic 4, 6 YES
Amount Dollar amount of the transaction. Must be a positive number. Numeric 1-12 YES
Customer_ID A valid customer ID of a customer in your customer database. Required field, if checking and routing number is empty. Alpha-numeric 1-25 YES 1
Checking_Account Customer's checking account number must be a valid number for the account where the funds should be deposited or debited. Numeric 20 YES 2
Routing_Number Routing number of the bank that manages the customer's checking account. Must be a valid 9-digit number. Numeric 9 YES 2
Invoice Invoice is the identifier for this transaction in your accounting or inventory management system. Alpha-numeric 1-50 NO
Billing_Name Name that appears on the account. Alphabetic 1-50 YES
Billing_Address Address of the customer is delivered. Alpha-Numeric 1-50 NO
Billing_Address_2 Second line of the address for the customer. Alpha-Numeric 1-50 NO
Billing_City City the customer. Alphabetic 1-50 NO
Billing_State The state of the customer. Alphabetic 2 4 NO
Billing_Zip The ZIP Code of the customer. Numeric 5, 9 NO
Shipping_Name Name of the person to which the product will be delivered. Alphabetic 1-50 NO
Shipping_Address The Address to which the product will be delivered. Alpha-numeric 1-50 NO
Shipping_Address_2 Second line of the Address to which the product will be delivered. Alpha-numeric 1-50 NO
Shipping_City City to which the product will be delivered. Alphabetic 1-50 NO
Shipping_County County to which the product will be delivered. Alphabetic 1-50 NO
Shipping_State The state to which the product will be delivered. Alphabetic 2 4 NO
Shipping_ZIP ZIP Code to which the product will be delivered. Numeric 5, 9 NO
Email_Address Customer's email address to which the sales receipt may be sent. Alpha-numeric 7-50 YES 3
Email_Receipt Must be set to Y if a receipt should be emailed to the Email_Address and your email address. Values of N or null indicate no receipt should be emailed. Alphabetic 1 NO
Description Optional text describing the transaction, products, customers, or other attributes of the transaction. Alpha-Numeric 1-255 NO
Customer_Field1 Value of the first customer discretionary data type. ? ? ?
Customer_Field2 Value of the second customer discretionary data type. ? ? ?
Customer_Field3 Value of the third customer discretionary data type. ? ? ?
Customer_Field4 Value of the fourth customer discretionary data type. ? ? ?

1 Customer_ID is only required when the transaction will be processed against an existing customer in your customer database.
2 Checking Account and Routing Numbers are required fields when Customer_ID is empty or invalid.
3 Email_Address is required when Email_Receipt is set to Y.
4 2-character country codes may be included by placing a ':' between state and country. For example, 'OR:US' would represent Oregon, USA. Country codes may be found at http://www.iso.org/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/listen1.html

Other Information

Comma Delimited file
Comma Delimited definition Wikipedia Definition of Comma Delimited
Tab Delimited file
Tab Delimited definition Wikipedia Definition of Tab Delimited