CSV File Format
Before uploading a payment data file, you need to ensure that the CSV file contains the following columns:
Column Name | Column Description | Mandatory (Yes or No) |
---|---|---|
Account ID | Used to specify the payee account ID. | Yes |
Match Type | Used to specify the match type using which you want to match the payment. | Yes (Conditional) Note: This data is required when the match
value is specified.
|
Match Value | Used to specify the entity (such as bill, contract, and so
on) against which you want to match the payment. Note:
If you specify a match type where the entity type is set to Account, the match value should not be provided. The payee account ID is derived from the payment data record. If the payee account ID is not available in the payment data record, it is derived using the payee account identifier type and identifier value. The system then derives the unpaid bills of the payee account using the manual distribution algorithm attached to the respective match type. If you specify a match type where the entity type is set to Statement, the match value should not be provided. The statement ID is derived from the payment data record. The system then derives the unpaid bills of the statement using the manual distribution algorithm attached to the respective match type. |
Yes (Conditional) Note: This data is required when the match
type is specified.
|
Tender ID | Used to specify the payment tender ID. Note: If the tender
ID is same for two or more payment records, the system will create
multiple payments against one tender. In other words, there will be
multiple payments which are created through the payment event.
|
Yes |
Tender Amount | Used to specify the tender amount. Note:
You must not specify the value less than or equal to 0. The precision specified for the tender amount must not exceed the decimal places defined for the currency in the system. |
Yes |
Payment Amount | Used to specify the amount paid through the tender. Note:
You must not specify the value less than or equal to 0. The precision specified for the payment amount must not exceed the decimal places defined for the currency in the system. |
Yes |
Date Received | Used to specify the date when the payment is made. Note: You
must specify the date in the MM/DD/YYYY format.
|
Yes |
Bank Account | Used to specify the external source ID which is associated with the tender source. | Yes |
Payment Type | Used to specify the type of tender through which the payment is made. | Yes |
Check Number | Used to specify the check number if the payment is made through check. | No |
Currency | Used to specify the currency in which the payment is made. Note: If the currency is not specified, it is set to the payor account's
invoice currency.
|
No |
External Reference Id | Used to specify the external reference ID which is associated with the tender source. | No |
Account ID Type | Used to specify the account identifier type. | Yes (Conditional) Note: This data is required when the account
identifier is specified.
|
Account Identifier | Used to specify the account for which the payment is made. | Yes (Conditional) Note: This data is required when the account
identifier type is specified.
|
Payment Char Type1, Payment Char Type2, ......, Payment Char Type5 | Used to indicate the characteristic that must be defined for the payment. | Yes (Conditional) Note: This data is required when the characteristic
value is specified.
|
Payment Char Value1, Payment Char Value2, ......, Payment Char Value5 | Used to specify the value for the characteristic type. | Yes (Conditional) Note: This data is required when the characteristic
type is specified.
|
MICR ID | Used to specify the MICR code. | No |
Payor ID | Used to specify the payor account ID. Note: If the payor account
ID is not specified, the payor account ID is set to the payee account
ID assuming that the payor and payee are the same.
|
No |
Statement ID | Used to specify the statement ID for applying payments at the statement level. | Yes (Conditional) Note: This data is required when the Statement
ID is specified.
|
If a payment data file contains column names other than those mentioned in the above table, the system will not upload the payment data file.
The system considers the payment data file for upload only when the payment data file is parsed without any errors and contains less than 1000 payment records.