This guide explains how to format your Excel file correctly for batch payments in Xace. Following these guidelines will help ensure your 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
The 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
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
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
For GBP A valid UK account number for the specified sort code
For other currencies see further 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 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 valid ISO code (e.g., GB, US)
Purpose & PurposeCategory
Must use values from the predefined lists
Required for regulatory compliance
Valid Purpose and PurposeCategory Values
To ensure your batch file passes validation, use only the following values for the Purpose and PurposeCategory fields:
Valid Purpose Values
Deposit:
DepositIntra Company Payment:
IntraCompanyPaymentIntra Party Payment:
IntraPartyPaymentAgricultural Transfer:
AgriculturalTransferCommercial Payment:
CommercialPaymentPurchase Sale Of Goods And Services:
PurchaseSaleOfGoodsAndServicesSupplier Payment:
SupplierPaymentCharity Payment:
CharityPaymentCompensation Payment:
CompensationPaymentProperty Loan Repayment:
PropertyLoanRepaymentProperty Loan Settlement:
PropertyLoanSettlementPayment Of Insurance Claim:
PaymentOfInsuranceClaimLoan Repayment:
LoanRepaymentTrade Settlement Payment:
TradeSettlementPaymentPayment Of Fees:
PaymentOfFeesGift:
GiftInvoice Payment:
InvoicePaymentForeign Exchange:
ForeignExchangeSavings:
SavingsTax Payment:
TaxPaymentUtilities:
UtilitiesLottery Payment:
LotteryPaymentProperty Completion Payment:
PropertyCompletionPaymentProperty Deposit:
PropertyDepositProperty Loan Disbursement:
PropertyLoanDisbursementProperty Loan Refinancing:
PropertyLoanRefinancing
Valid PurposeCategory Values
Supplier Payment:
SupplierPaymentTrade Settlement Payment:
TradeSettlementPaymentPerson To Person Payment:
PersonToPersonPaymentIntra Company Payment:
IntraCompanyPaymentTrade:
TradeLoan:
LoanTax Payment:
TaxPaymentGovernment Payment:
GovernmentPaymentTreasury Payment:
TreasuryPaymentOther Payment:
OtherPayment
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 to complete the payment. If provided, all required fields must be fully completed.
IntermediaryName
IntermediaryBic
IntermediaryAba (For USD only)
IntermediaryAddress1
IntermediaryAddress2 (Optional)
IntermediaryTownCity
IntermediaryCountyState (Optional)
IntermediaryPostcode (Optional)
IntermediaryCountryCode
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