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
- Click the Upload Checks link in the Checks menu.
- Select the field delimiter for your file.
- Select the field positions for your file upload.
- Click the Browse button and select the file you want to upload.
- Click the Upload button.
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.
- 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.
|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