Upload a payment file

Use payment files to create payment orders in bulk in the dashboard

In addition to the API and manual payment order creation in the dashboard, Numeral enables you to create payment orders by uploading a payment file in the dashboard. To upload a payment file, go to Payments > Payment orders > Upload payment file.

1. Uploading a payment file

By default, the payment file upload feature supports two formats:

  • Standard ISO 20022 pain.001 XML files
  • Numeral CSV template

If you have a custom file format that you would like to use, please contact us at [email protected]..

After you upload a payment file, the corresponding payment orders will be created asynchronously. You can close or refresh the page. After they have been created, payment orders will be visible on the Payment orders page.

2. Processing time

Number paymentsProcessing time
Up to 1,000<60 seconds
Up to 10,000~5 minutes
Up to 25,000~25 minutes

3. Numeral CSV template

ColumnsDescriptionAuthorised valuesMandatory
idThe ID of the payment. If filled, Numeral will check for duplicates before creating the paymentRecommended unique values like UUID-v4Recommended
typeThe type of the paymentsepa, sepa_instant, sepa_urgent, fps, bacs, swift, treasury, or target2
treasury_optionThe type of treasury paymentslocal, international, relocated, or safeguarding
confidentiality_optionUsed in case of a confidential paymentpayroll
fee_optionNetwork payment fee preference. Only applicable to Swift paymentsshared, originator, or receiver
directionThe direction of the paymentcredit or debit
amountThe amount of the payment, with decimalsAmount with decimals, e.g 149.99
currencyThe currency of the paymentISO 4217 currency codes, e.g. EUR or GBP
referenceThe message that will appear on the origin and destination account statements, with a maximum of 140 charactersString, up to 140 characters
purposeReserved, not used at the moment
requested_execution_dateThe requested execution date of the payment order. Only available for SEPA direct debit for now.Date format, yyyy-mm-dd, e.g., 2024-06-22
receiving_account_holder
_name
The account holder name of the receiving account
receiving_account_account
_number
The account number of the receiving accountIBAN or local account number format
receiving_account_bank
_code
The bank code of the receiving accountBIC / Swift code or local format (sort code)
receiving_account_countryThe country of the receiving accountISO 3166 country codesRecommended
receiving_account_cityThe city of the receiving accountRecommended
receiving_account_building
_number
The building number of the receiving account
receiving_account_street
_name
The street name of the receiving account
receiving_account_zip
_code
The zip code of the receiving account
receiving_account_region
_state
The region or state of the receiving account
direct_debit_mandate
_reference
The unique mandate reference. Only applicable in the case of direct debit paymentsMandatory for direct debit payments
direct_debit_mandate
_type
The mandate type. Only applicable in the case of direct debit paymentssepa_core, sepa_b2b, or bacs_debitMandatory for direct debit payments
direct_debit_mandate
_sequence
The mandate sequence. Only applicable to SEPA direct debit paymentsone_off, first, recurring, orlastMandatory for direct debit payments
direct_debit_mandate
_signature_date
The mandate type. Only applicable to SEPA direct debit paymentsDate format, yyyy-mm-dd, e.g., 2024-06-22Mandatory for direct debit payments
originating_account_holder
_name
The holder name of the receiving account. Only applicable to SEPA indirect paymentsMandatory for SEPA indirect or agency banking payments
originating_account_account
_number
The account number of the receiving account. Only applicable to SEPA indirect paymentsIBAN or local account numberformatMandatory for SEPA indirect or agency banking payments
originating_account_bank
_code
The bank code of the receiving account. Only applicable to SEPA indirect paymentsBIC / Swift code or local format (UK sort code)Mandatory for SEPA indirect or agency banking payments
originating_account_creditor
_identifier
The creditor identifier of the receiving account. Only applicable to indirect participants for direct debit paymentsSEPA Creditor Identifier (SCI) or UK Service User Number (SUN)Mandatory for direct debit SEPA indirect or agency banking payments
originating_account_countryThe country of the receiving account. Only applicable to SEPA indirect paymentsISO 3166 country codesMandatory for SEPA indirect or agency banking payments
originating_account_cityThe city of the receiving account. Only applicable to SEPA indirect paymentsRecommended for SEPA indirect or agency banking payments
originating_account_building
_number
The building number of the receiving account. Only applicable to SEPA indirect payments
originating_account_street
_name
The street name of the receiving account. Only applicable to SEPA indirect payments
originating_account_zip
_code
The zip code of the receiving account. Only applicable to SEPA indirect payments
originating_account_region
_state
The region or state of the receiving account. Only applicable to SEPA indirect payments
ultimate_originator_holder
_name
The holder name of the ultimate originating account, for regulation purposes
ultimate_originator_organization
_identification_bank_code
The BIC code of the ultimate originating account, for regulation purposes
ultimate_originator_organization
_identification_other
The identification or registration number of the ultimate originating account, for regulation purposes
metadataTechnical metadata related to this payment. See metadatametadata_key1
=value1
metadata_key2
=value2
custom_fieldsCustom field values related to the payment. See custom fieldscustom_field_key_1
=value1
custom_field_key2
=value2