Mass pay file validation NEW 5/23
While uploading mass payment files, you can validate the file's content to make processing more seamless and accurate. Validating mass pay files enables you to submit the file and then review the response file for errors and omissions. If data is missing or the format is incorrect, it will be highlighted in the response file. Correct errors, insert wallet IDs if required, and submit.
Note: This will save significant time in processing and getting the payments made.
Submission
Use the standard downloadable XLSX template to complete your mass pay submission -copy found HERE
Once your payments data is added, you can upload and validate the data in your submission file. The upload format can be Excel (XLSX) or CSV. The validation response file will always be a CSV file.
What is validated
The following mandatory fields are validated as existing and correctly formatted:
| Field Name | Validation | |
| Format | Checks for correctly formatted emails | |
| Wallet ID | Exist. Return Wallet IDs if doesn't exist. | If it doesn't exist (i.e. you leave it blank), then it returns all wallet IDs and descriptions. These can then be used in the final submission file. |
| Beneficiary Organization ID (SPNXXXXXXX) | Exist | Checks to see if it exists in the system. |
| Beneficiary Address | Exist | Only for payment method "Direct to Check." |
| Gift card SKU | Exist | Only for payment method "Direct to Digital Gift Card." |
Wallet ID's validation
One optional field used when sending mass payments is the specific wallet ID for the beneficiary you are sending to. A beneficiary may have many same currency wallets, but you want to send to a specific one, or they may have requested a specific one. In this case, you need to specify that specific wallet ID.
What if I don't know the wallet ID's?
If you do not know the wallet IDs for the beneficiary, you can retrieve them using this mass pay validation option. By leaving the wallet ID field blank, it will return the wallet IDs and descriptions. You can now choose the correct one and use it in the final submission.
Note: If you leave it blank during the final submission, the funds will be sent to the beneficiary's default wallet for that given currency.