File Upload Formats
Our system accepts payment files in
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.
The following table provides clarification on the fields contained in a payment file.
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.
Required when Type is AchCredit or AchDebit
The name of the person or company that has authorized the debit or credit to their account.
The amount of the payment.
0.00 if this is a prenote.
Optional, if no date is provided the current date will be used
The date the payment is scheduled to send.
The type of the payment.
AchDebit - Deduct money from the specified bank account
AchCredit - Send money to the specified bank account
Used to indicate whether or not the payment is a pre-note.
Values: TRUE, FALSE or blank
The nine digit routing number of the financial institution that the payment is being sent to.
The account number at the financial institution that the payment is being sent to.
The type of account at the financial institution that the payment is being sent to.
Values: GeneralLedger, BusinessChecking, BusinessSavings, PersonalChecking, PersonalSavings
Required when Type is AchDebit or AchCredit
The NACHA Standard Entry Class Code for the ACH payment.
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
Optional, recommended when EntryClass is WEB or TEL
Used to indicate additional information regarding TEL or WEB payments.
S - Authorization was for a single payment
R - Authorization was for a recurring payment
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.
This text will be included in the addenda record of an ACH transaction and may be shown on the receivers bank statement.
An optional description for the payment. This value is not used outside of the system.
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.