How-to: Import a Payment File

File Upload Formats

Our system accepts payment files in .xls, .xlsx, and .csv formats.

Related Files

PaymentFile-Sample.xlsx - This example file shows you what the payment file should look like.

PaymentFile-Empty.xlsx - This is an empty file that you can use for uploading your payments.

Fields

The following table provides clarification on the fields contained in a payment file.

Field	Required	Description
MerchantId	Always	The unique Id of the originating Merchant to associate this transaction with. This value will be provided to you when your Merchant account is setup.
Name	Required when Type is AchCredit or AchDebit	The name of the person or company that has authorized the debit or credit to their account.
Amount	Always	The amount of the payment. 0.00 if this is a prenote.
SendDate	Optional, if no date is provided the current date will be used	The date the payment is scheduled to send.
Type	Always	The type of the payment. Values: AchDebit - Deduct money from the specified bank account AchCredit - Send money to the specified bank account
IsPrenote	Optional	Used to indicate whether or not the payment is a pre-note. Values: TRUE, FALSE or blank
RouteNumber	Always	The nine digit routing number of the financial institution that the payment is being sent to.
AccountNumber	Always	The account number at the financial institution that the payment is being sent to.
AccountType	Always	The type of account at the financial institution that the payment is being sent to. Values: GeneralLedger, BusinessChecking, BusinessSavings, PersonalChecking, PersonalSavings
EntryClass	Required when Type is AchDebit or AchCredit	The NACHA Standard Entry Class Code for the ACH payment. Values: CCD - Use this code for all ACH payments to business accounts PPD - Use this code for debits to personal accounts when authorization was provided by signed agreement or when sending a credit to a personal account TEL - Use this code for debits to personal accounts when oral authorization was obtained over the telephone WEB - Use this code for debits to personal accounts when authorization was obtained in accordance with the requirements for internet-initiated entries
AchPaymentTypeCode	Optional, recommended when EntryClass is WEB or TEL	Used to indicate additional information regarding TEL or WEB payments. Values: S - Authorization was for a single payment R - Authorization was for a recurring payment
IdentificationNumber	Optional	Typically this indicates an account number or identifier in your system associated with this payment. The value in this field may be shown on the receivers bank statement.
AchAddendaText	Optional	This text will be included in the addenda record of an ACH transaction and may be shown on the receivers bank statement.
Description	Optional	An optional description for the payment. This value is not used outside of the system.
ExternalId	Optional	Can be used to store a unique identifier for this payment from another system. Comparisons are case-insensitive. This value must be unique to all payments submitted for the related MerchantId.