Skip to main content

Batch Payments

Here you can learn more about Batch Payments in Xace, the available functionality and formats

M
Written by Mariia

Use the Batch Payments feature to send up to 1,000 payments at once by uploading a .csv, .xls, or .xlsx file. This feature is ideal for making multiple payments efficiently and ensures all transactions are processed simultaneously after successful validation.

Batch Payments option is not enabled by default. To activate this feature, please contact the Xace Operations team.

Once enabled, the Batch Payments option will appear under Payments for each activated account. If it does not show immediately, refresh the page (Ctrl + R / Cmd + R).


How it works

  1. Choose the payment validation format you will use for all entries in the file.

  2. Prepare your file with all required information.

  3. Upload your batch file for automatic validation.

  4. Fix any invalid entries (if needed) so that all payments pass validation.

  5. Once all entries are validated, submit the entire batch for processing.

Note: If you need to use multiple validation types, create and upload separate batch files.


Step 1. Select a validation format

Choose one payment validation mode. The selected mode applies to all payments in that file.

IBAN + BIC

With this validation method, payment destinations must be described using:

  • IBAN — International Bank Account Number

  • BIC — Bank Identifier Code (SWIFT)

Intermediary bank requirements

Intermediary bank details are optional.
However, if any intermediary information is provided, the following fields become required:

  • Intermediary Bank Name

  • Intermediary BIC/SWIFT

  • Intermediary ABA (for USD payments)

  • Intermediary Address Line 1

  • Intermediary Town/City

  • Intermediary Country Code


Step 2. Prepare and upload your batch file

Ensure the file matches the selected validation method. Guides and templates are available in your account under Templates and Guides:

This table shows the required fields for your payments based on the selected validation:

Field

Description

Example

Required

AccountHolderName

The name of the account holder

John Smith or ABC Company Ltd

Required

IsBusiness

Whether the recipient is a business (for international payments)

yes

Required

AddressLine1

First line of the payee address

123 Main Street

Required

AddressLine2

Second line of the payee address

Apartment 4B

Required

TownCity

Town or city of the payee

London

Required

CountyState

County or state of the payee

Greater London

Required

PostCode

Post code or zip code of the payee

EC1A 1BB

Required

CountryCode

Country code of the payee

GB

Required

Amount

Payment amount

100.00

Required

Reference

Payment reference shown to the recipient

Invoice 12345

Required

Purpose

Purpose of the payment

Goods

Required

PurposeCategory

Category of the payment purpose

GOODS

Required

Bic

Bank Identifier Code (SWIFT) for international payments

ABХХХХХ

Required

Iban

International Bank Account Number (for international payments)

GBХХХХХ

Required

Intermediary Details

Intermediary bank details are optional, but if any information is provided, the following fields must also be completed:

Optional

IntermediaryName

Name of the intermediary bank

Chase Bank

Required

IntermediaryBic

BIC/SWIFT code of the intermediary bank

CLRBGB22XXX

Required

IntermediaryAddress1

First line of the intermediary bank address

123 Bank Street

Required

IntermediaryTownCity

Town or city of the intermediary bank

New York

Required

IntermediaryCountryCode

Country code of the intermediary bank

US

Required

Example file layout (EUR template)

Header row (must match exactly):
AccountHolderName | AddressLine1 | AddressLine2 | TownCity | CountyState | PostCode | CountryCode | Amount | Reference | Purpose | PurposeCategory | IsBusiness | Iban | Bic

Here you can see the example:


Step 3. Review payment details and fix errors (if any)

Each payment in the batch must meet the payment scheme standards for the currency being sent. Some rows may need editing before you can submit the file for processing.

Also, check all the details, verify that the sums are correct, and proceed with the payment. You can do this by opening an individual payment to review full details before submission.


Step 4. Confirm via MULTI-FACTOR AUTHENTICATION (MFA)

For security, authorise the batch using your multi-factor authentication code. After that, you will see confirmation that the payment has been applied.


Excel format guide

This guide explains how to format your Excel file correctly for batch payments. Following these guidelines helps ensure payments are processed smoothly without validation errors.

Important note: For security and compliance reasons, the batch processing system requires the same information as the individual payee creation process.

This ensures:

  • All payments meet the same security and compliance standards

  • Each transaction contains complete beneficiary information

  • Proper validation can be performed on all payee details

  • Payments meet regulatory requirements

While this requires more upfront information, it ensures that all payments are processed securely and in compliance with financial regulations.

General requirements

  • File must be in XLSX format (product also accepts .csv / .xls where supported)

  • Must include the correct header row (first row) with exact field names

  • Maximum of 1,000 payments per file

  • All required fields must be present and correctly formatted

  • Sufficient account balance is required to process the batch

Validation rules

Note: These validation rules are identical to those applied when creating individual payees.

AccountHolderName

  • Must be 4–140 characters

  • May contain alphanumeric characters and select special characters

  • Will be cleaned of disallowed characters

  • Cannot contain excessive spaces (will be trimmed)

SortCode (GBP only)

  • Must be exactly 6 digits

  • Can be formatted with or without hyphens (e.g. 123456 or 12-34-56)

  • Must be a valid UK sort code

AccountNumber

  • GBP: A valid UK account number for the specified sort code

  • Other currencies: See currency-specific details below

Iban

  • Must be a valid IBAN format for the target country

  • Will be validated through the banking system

Bic

  • Must be a valid BIC/SWIFT code

  • Usually 8 or 11 characters

For USD payments

  • ABA: 9-digit routing number required for domestic payments

  • Account Number: Format varies based on bank

  • BIC/SWIFT: Required for international payments

  • IBAN: Alternative to ABA + Account Number

  • Bank Country Code: Required for ABA or BIC based payments

For CAD payments

  • Institution Number: 3 digits required for domestic payments

  • Transit Number: 5 digits required for domestic payments

  • Account Number: 7–12 digits required for domestic payments

  • IBAN + BIC: Alternative for international payments

  • Bank Country Code: Required for domestic payments

For Multi-Currency (MCC) payments

  • IBAN: Preferred for most currencies

  • BIC: Required for all MCC payments

  • Account Number: Alternative to IBAN

Amount

  • Must be a positive number

  • Use a decimal point for fractional amounts (e.g. 100.50)

  • Do not include currency symbols

Reference

  • GBP: Must be 6–18 characters

  • EUR: Can be up to 140 characters

  • Cannot contain disallowed characters: ! $ % ^ & * ( ) + | ~ = ` [ ] : " ; ' < > ? , . /

  • Only allowed special characters are hyphens, periods, underscores, and ampersands (-, ., _, &)

  • Cannot have more than one special character in sequence

  • Cannot have more than two numbers in sequence

Address fields

  • AddressLine1: 1–50 characters, required

  • AddressLine2: 1–35 characters, required

  • TownCity: 1–35 characters, required

  • CountyState: Required

  • PostCode: Required (format depends on country)

  • CountryCode: Required; must be a valid ISO code (e.g. GB, US)

Purpose & PurposeCategory

  • Must use values from the predefined lists

  • Required for regulatory compliance

IsBusiness

  • Must be either "yes" or "no" (case insensitive)

Intermediary bank details (optional)

Intermediary bank details are optional and only needed if the destination bank requires an intermediary. If provided, all required fields must be fully completed:

  • IntermediaryName

  • IntermediaryBic

  • IntermediaryAba (USD only)

  • IntermediaryAddress1

  • IntermediaryAddress2 (optional)

  • IntermediaryTownCity

  • IntermediaryCountyState (optional)

  • IntermediaryPostcode (optional)

  • IntermediaryCountryCode


Valid purpose and purposeCategory values

To ensure your batch file passes validation, use only the following values.

Valid Purpose values:

Label

Value to enter in file

Deposit

Deposit

Intra Company Payment

IntraCompanyPayment

Intra Party Payment

IntraPartyPayment

Agricultural Transfer

AgriculturalTransfer

Commercial Payment

CommercialPayment

Purchase Sale Of Goods And Services

PurchaseSaleOfGoodsAndServices

Supplier Payment

SupplierPayment

Charity Payment

CharityPayment

Compensation Payment

CompensationPayment

Property Loan Repayment

PropertyLoanRepayment

Property Loan Settlement

PropertyLoanSettlement

Payment Of Insurance Claim

PaymentOfInsuranceClaim

Loan Repayment

LoanRepayment

Trade Settlement Payment

TradeSettlementPayment

Payment Of Fees

PaymentOfFees

Gift

Gift

Invoice Payment

InvoicePayment

Foreign Exchange

ForeignExchange

Savings

Savings

Tax Payment

TaxPayment

Utilities

Utilities

Lottery Payment

LotteryPayment

Property Completion Payment

PropertyCompletionPayment

Property Deposit

PropertyDeposit

Property Loan Disbursement

PropertyLoanDisbursement

Property Loan Refinancing

PropertyLoanRefinancing


Valid PurposeCategory values:

Label

Value to enter in file

Supplier Payment

SupplierPayment

Trade Settlement Payment

TradeSettlementPayment

Person To Person Payment

PersonToPersonPayment

Intra Company Payment

IntraCompanyPayment

Trade

Trade

Loan

Loan

Tax Payment

TaxPayment

Government Payment

GovernmentPayment

Treasury Payment

TreasuryPayment

Other Payment

OtherPayment


Excel formatting tips

Format cells correctly:

  • Format Sort Code and Account Number cells as TEXT to preserve leading zeros (domestic payments only)

  • Format IBAN cells as TEXT to preserve the full format

  • Format Amount cells as NUMBER with appropriate decimal places

Create a template:

  • Download the example template provided and modify it rather than creating from scratch

  • Keep the header row exactly as provided in the template

Validate before uploading:

  • Double-check all account details and references

  • Ensure all required fields are completed

  • Verify that special characters are valid

Did this answer your question?