Skip to main content

Payment Bulk Upload Guide

Updated

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 clientservices@trumia.com.

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 Required?
1 Network Type of transaction network. Choose one of the options. Peer to Peer, LOCAL, Cross Border, SEPA Yes
2 Transaction Date (ddmmyyyy) The date of the transaction. ddmmyyyy (e.g., 24112024) Yes
3 Currency The currency of the transaction. EUR, GBP, DKK Yes
4 Amount The payment amount. Numeric value (e.g., 150.00) Yes
5 Beneficiary Type Indicates whether the beneficiary is an individual or a company. Individual, Company Yes
6 Beneficiary Name The name of the payment recipient (max 35 characters). Text (e.g., John Doe) Yes
7 Beneficiary Nick Name A nickname for the beneficiary. Text (e.g., JDoeNick) Yes
8 Beneficiary IBAN / Account Number The beneficiary's IBAN or account number.

Valid IBAN/Account Number (e.g., DE89370400440532013000)

 Yes
9 Beneficiary Bank Code / Sort Code The bank or sort code associated with the beneficiary's account

 Text (e.g., 32432/SXPYDEHH) Yes if Local or Cross Border
10 Bank Country The country of the beneficiary's bank.

Text (e.g., FRA, GIB, DNK) Yes if Local or Cross Border
11 Beneficiary Address Line 1 The first line of the beneficiary's address (max 35 characters). Text (e.g., 123 Main St.) Yes if Cross Border
12 Beneficiary Address Line 2 The second line of the beneficiary's address (max 35 characters). (Only required for Cross Border) Text (e.g., Suite 101) Yes if Cross Border
13 State / City The state or city of the beneficiary.  Text (e.g., Dunkirk) Yes if Cross Border
14 Country The beneficiary's country. Text (e.g., United States) Yes if Cross Border
15 Intermediary Account Number The intermediary bank account number for routing  Text or Numeric (e.g., WS3242435356) No
16 Intermediary NCC National Clearing Code for the intermediary bank  Text (e.g., WS1234) No
17 Reference Notes Notes or reference for the transaction. Text (e.g., Invoice 12345) No
18 Internal Reference Notes Internal notes related to the transaction. Text (e.g., Project Code 5678) No

 

Step 3: Upload and Validate

  1. Save your file in the required format (.csv, .xls).
  2. Upload the file on the Trumia platform by dragging it into the upload box or using the Browse button.
  3. Click Upload to validate the file.
  4. 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.

Related articles