What are the validation rules for my one-time batch payment template?
When completing your batch payment template, please ensure you follow the validation guidance below to avoid any errors when processing your payments.
| FIELD | VALIDATION RULES |
|---|---|
| Amount: | required, only numbers |
| Reason: | required, maximum 30 characters |
| Reference: | required, maximum 90 characters |
| CountryCode: | required, 2 characters ISO format |
| CurrencyCode: | required, 3 characters ISO format |
| FirstName: | required if CompanyName empty, maximum 35 characters |
| LastName: | required if CompanyName empty |
| CompanyName: | required if FirstName and LastName empty |
| Address: | required, maximum 255 characters |
| City: | required |
| PostCode: | required |
| State: | required for USA payments |
| BankAccountNumber: | required if IBAN and BankClabe empty |
| IBAN: | required if BankAccountNumber and BankClabe empty |
| BankClabe: | required if BankAccountNumber and IBAN empty |
| BankSortCode: | required if BanBIC and BankABA empty |
| BankBIC: | required if BankSortCode: and BankABA empty |
| BankABA: | required if BankSortCode and BankBIC empty |
| DefaultPaymentReason: | maximum 20 characters |
Please Note
- The remaining fields in the spreadsheet are not required but can be requested for recipients with specific country/currency combination
- Either BankAccountNumber or IBAN or BankClabe must be populated depending on the currency and country of recipient. Bank details must meet international format
- Either BankSortCode or BankBIC or BankABA must be populated depending on the currency and country of recipient. Bank details must meet international format
- You will be provided with a summary of failed payments, which will need to be corrected and submitted again.