Beneficiary Bulk Upload Guide

Important Note

To ensure that these payments are processed correctly we have limited this function to only be available on Maker and Checker set ups. If you are currently set up as Straight Through Processing, please contact us on [e-mail].

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

 

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
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.

Need Help?

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