Payment Bulk Upload Guide

Step 1: Navigate to the File Upload Section

1. Log in to your Trumia account.
2. Go to Funds Transfer from the main menu.
3. Choose Transfers via File Upload.

Step 2: Download and Fill the Template

1. On the file upload page, click Download File Template.
2. Rename the file using the structure Filename-MMM-YYYY (e.g., Salaries-NOV-2024)
3. Open the file in a spreadsheet application (e.g., Excel or Google Sheets).
4. Fill in the required columns using the instructions below:

CSV File Column Guide

Column Number	Column Name	Description	Format / Example / Options
1	Network	Type of transaction network. Choose one of the options.	Peer to Peer, LOCAL, Cross Border, SEPA
2	Transaction Date (ddmmyyyy)	The date of the transaction.	ddmmyyyy (e.g., 24112024)
3	Currency	The currency of the transaction.	EUR, GBP, DKK
4	Amount	The payment amount.	Numeric value (e.g., 150.00)
5	Beneficiary Type	Indicates whether the beneficiary is an individual or a company. Choose one of the options.	Individual, Company
6	Beneficiary Name	The name of the payment recipient. Maximum 35 Characters Long.	Text (e.g., John Doe)
7	Beneficiary Nick Name	A nickname for the beneficiary (optional).	Text (e.g., JDoeNick)
8	Beneficiary IBAN / Account Number	The beneficiary's IBAN or account number. P2P: TRUMIA Account LOCAL: UK/DK Account Cross Border: IBAN SEPA: IBAN	Valid IBAN/Account Number (e.g., DE89370400440532013000)
9	Beneficiary Bank Code / Sort Code	The bank or sort code associated with the beneficiary's account (Not required for P2P) (optional for SEPA)	Text (e.g., 32432/SXPYDEHH)
10	Bank Country	The country of the beneficiary's bank.	Text (e.g., Denmark)
11	Beneficiary Address Line 1	The first line of the beneficiary's address. Maximum 35 Characters Long.	Text (e.g., 123 Main St.)
12	Beneficiary Address Line 2	The second line of the beneficiary's address (optional). Maximum 35 Characters Long.	Text (e.g., Suite 101)
13	State / City	The state or city of the beneficiary.	Text (e.g., Dunkirk)
14	Country	The beneficiary's country.	Text (e.g., United States)
15	Intermediary Account Number	The intermediary bank account number for routing (if applicable).	Text or Numeric (e.g., WS3242435356)
16	Intermediary NCC	National Clearing Code for the intermediary bank (optional).	Text (e.g., WS1234)
17	Reference Notes	Notes or reference for the transaction.	Text (e.g., Invoice 12345)
18	Internal Reference Notes	Internal notes related to the transaction.	Text (e.g., Project Code 5678)

 

Step 3: Upload and Validate

1. Save your file in the required format (.csv, .xls, or .xlsx).
2. Upload the file on the Trumia platform by dragging it into the upload box or using the Browse button.
3. Select the correct template type (e.g., Single Debit or Multiple Debits).
4. Click Upload to validate the file.
5. Fix any errors flagged by the system and re-upload if needed.

Step 4: Review and Submit

1. Review the uploaded payment details for accuracy.
2. Click Submit to finalize the bulk payment.

Error Codes and Descriptions

Error Code	Solution
The beneficiary country is outside our supported jurisdiction.	Select a beneficiary country from the acceptable jurisdiction list.
Network name is not from acceptable list	Ensure the network is one of: Peer to Peer, LOCAL, SEPA, Cross Border.
Transaction Date should be current date in DDMMYYYY format	Enter the current date in DDMMYYYY format (e.g., 25112024).
Currency should be from the acceptable list	Use one of the acceptable currencies: EUR, GBP, DKK.
Transaction amount accepts value up to 2 decimals	Ensure the amount is a number with up to 2 decimal places (e.g., 150.75).
Beneficiary Type Should be Company or Individual	Enter "Company" or "Individual" as the beneficiary type.
Beneficiary Name accepts max 35 alphanumeric characters	Limit name to 35 characters and use only allowed special characters (/ - ? : ( ) . , ' +).
IBAN or Account Number accepts min 4 and max 35 alphanumeric characters	Ensure the IBAN/account number is between 4 and 35 alphanumeric characters without special characters.
Beneficiary Bank Code / Sort Code accepts max 12 alphanumeric characters	Enter a bank code or sort code with up to 12 alphanumeric characters, no special characters.
Bank Country should be from the acceptable list of country codes	Use a valid country code from the acceptable list.
Beneficiary Address Line 1 accepts max 35 alphanumeric characters	Limit Address Line 1 to 35 characters and use only allowed special characters.
Beneficiary Address Line 2 accepts max 35 alphanumeric characters	Limit Address Line 2 to 35 characters and use only allowed special characters.
State / City accepts max 35 alphanumeric characters	Limit State/City name to 35 characters and use only allowed special characters.
Intermediary Account Number accepts max 30 alphanumeric characters	Limit the intermediary account number to 30 alphanumeric characters without special characters.
Intermediary NCC accepts max 30 alphanumeric characters	Limit the NCC to 30 alphanumeric characters without special characters.
Reference notes accepts max 125 alphanumeric characters	Limit notes to 125 characters and use only allowed special characters.
Internal Reference Notes accepts max 125 alphanumeric characters	Limit internal notes to 125 characters and use only allowed special characters.
Transfer file upload Transaction amount exceeds user limit	Reduce the transaction amount or contact support for assistance.

 

Need Help?

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