Skip to main content

Beneficiary Bulk Upload Guide

Updated

Step 1: Navigate to Beneficiary Maintenance

  1. Log in to your Trumia account.
  2. Select Beneficiary Maintenance from the side menu.
  3. Click on the yellow + Add a New Beneficiary button.

Step 2: Select Beneficiary Upload

  1. On the Add a New Beneficiary page, choose Beneficiary Upload from the dropdown menu.
  2. Click Download File Template to obtain the file structure for bulk uploads.
  3. Rename the file using the structure Filename-MMM-YYYY (e.g., Partners-NOV-2024)

Step 3: Prepare the Bulk Beneficiary File

  1. Open the downloaded template in a spreadsheet application (e.g., Excel).
  2. Fill in the required information based on the column guide below.

CSV File Column Guide

Column Number Column Name Description Format / Example / Options
1 Network Type of transaction network. Peer to Peer, SEPA, Cross Border, LOCAL
2 Beneficiary Type Specifies whether the beneficiary is an individual or a company. Individual, Company
3 Beneficiary Name Full name of the beneficiary. Up to 35 alphanumeric characters and special characters: / - ? : ( ) . , ' +
4 Beneficiary Nick Name Optional nickname for the beneficiary. Up to 35 alphanumeric characters.
5 Beneficiary IBAN / Account Number Beneficiary's IBAN or account number. Minimum 4 and maximum 35 alphanumeric characters, no special characters.
6 Beneficiary Bank Code / Sort Code Bank or sort code associated with the beneficiary. Up to 12 alphanumeric characters, no special characters.
7 Bank Country Country where the beneficiary's bank is located. Use valid ISO country codes (e.g., FRA, AUT, DNK).
8 Beneficiary Address Line 1 First line of the beneficiary's address. Up to 35 alphanumeric characters and special characters.
9 Beneficiary Address Line 2 Second line of the beneficiary's address (optional). Up to 35 alphanumeric characters and special characters.
10 State / City State or city where the beneficiary resides. Up to 35 alphanumeric characters.
11 Country The beneficiary's country. Use valid ISO country codes (e.g., FRA, IND, DNK).
12 Intermediary Account Number Account number of the intermediary bank (if applicable). Up to 30 alphanumeric characters, no special characters.
13 Intermediary NCC National Clearing Code of the intermediary bank (if applicable). Up to 30 alphanumeric characters, no special characters.
14 Assign to Group Optional grouping for the beneficiary. Text or leave blank for the default group.

 

Step 4: Upload the Beneficiary File

  1. After preparing the file:
    • Drag and drop the file into the upload area or click Browse to locate it.
    • Ensure the file format is .csv, .xls, or .xlsx.
  2. Select the appropriate Template Type (if applicable).
  3. Click Submit to upload the file.

Step 5: Review and Finalise

  1. The system will validate the file and display errors, if any.
  2. If there are errors:
    • Download the error log for detailed information.
    • Fix the errors in the original file and re-upload.
  3. If the file is valid:
    • Review the beneficiaries added.
    • Confirm the upload.

Common Errors and Solutions

Refer to the specific error codes and solutions in the table below to address issues during file uploads:

Need Help?

If you encounter issues not covered here, contact the Support Team for assistance.

Related articles