• File Formats


    Table of Contents


    1. File Formats

    1.1 Introduction

    This function allows you to create a payment batch by importing payments from an external file.

    Note: 10k is the maximum number of items in an import, which will be split into batches of 200. When importing a BACS Multiple batch, in any of the formats detailed below, and one of the beneficiary’s account details fails the modulus 11 check the item will be removed from the batch.

     File Formats 1 v2 


     

    Back to top

    1.2 File format type

    The following file formats are supported:

     

    • PFE-XML: All payment types can be imported with this format.
    • PFE-CSV: All payment types can be imported with this format.
    • Sage BACS multiple CSV: A CSV format used to create GBP BACS payments. Importing this file will create a single GBP BACS payment in a single batch.
    • Sage BACS Euro multiple CSV: Creates a Euro BACS payment.
    • BACS multiple standard CSV: A standard CSV format that creates a BACS payment
    • BACS multiple fixed width: A standard fixed width format that creates a BACS payment

    •  

     

    Back to top

    1.3 Valid BACS Characters

    The table below shows the characters that can be used in a BACS Multiple file. During import any lower-case characters will be converted to upper case and any characters not valid for BACS will be replaced with a space.

     

    Description Example/Range 
     Uppercase alphabeticA to Z
    Numerics0 to 9
    Space 
    Hyphen-
    Full stop.
    Ampersand&
    Solidus/

     

    Back to top

    1.4 File format definition

    Back to top

    1.4.1 PFE-XML

    For each payment type the field names are supplied along with associated basic validation rules and a PFE-XML sample extract.

    Domestic Chaps 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    Field Field Name Length Field Validation 
    1Payment TypeN/AMust be Chaps_GBP_Payment
    2Debit Sort Code6Mandatory. Must be six digits without hyphens. Debit Account Sort Code combination must exist in customer debit account list. 
    3Debit Account Number8Mandatory. Must be eight digits.
    Debit Account Number combination must exist in customer debit account
    list and must not be a multi-bank account.
    4Payment Currency3Mandatory. Must be GBP
    5Payment Amount16Mandatory. Max = 9,999,999,999.99 (0.01 less than 10 billion).
    6Payment Reference16Maximum 16 alpha-numeric characters
    7Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006)
    Greater than or equal to today but less than or equal to 61 days forward,
    including today.
    Must be a UK working day
    8Payment Details140Maximum of 140 alpha-numeric characters over a maximum of 4 separate lines
    9Information to Payee Bank210Maximum of 210 characters over a maximum of 6 separate lines
    10Advise Payeen/aTrue or False
    11Payee is a Bankn/aTrue or False
    12Beneficiary Account Number8Mandatory. Must be a standard UK bank account number
    13Beneficiary Sort Code6Mandatory. Must be a Standard UK bank account sort code
    14Beneficiary Name35Mandatory. Maximum of 35 characters.
    15Beneficiary’s Address105Maximum of 105 characters, over 3 lines.
    16Beneficiary’s Bank Name35Maximum of 35 characters.
    17Beneficiary’s Bank address105Maximum of 105 characters, over 3 lines


     An example is: 

    <PaymentList><Payment>

    <PaymentTypeField>Chaps_GBP_Payment</PaymentTypeField>

    <DebitSortCodeField>302556</DebitSortCodeField>

    <DebitAccountNumberField>11266760</DebitAccountNumberField>

    <PaymentCurrencyField>GBP</PaymentCurrencyField>

    <PaymentAmountField>100.00</PaymentAmountField>

    <PaymentReferenceNumberField />

    <ValueDateField>17-Jan-2006</ValueDateField>

    <PaymentDetailsField />

    <InformationToPayeeBankField />

    <AdvisePayeeField>False</AdvisePayeeField>

    <PayeeIsABankField>False</PayeeIsABankField>

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="11265260" SortCode="302556" Name="Mrs Helen Globaltest"

    Address="" BankName="" BankAddress="" />

    </BeneficiaryList>

    </Payment></PaymentList>

     

    Domestic BACS Single Beneficiary 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be Single_BACS_GBP_Payment
    2Debit Sort Code6Mandatory. Must be six digits without hyphens. Debit Account Sort
    Code combination must exist in customer debit account list.
    3Debit Account Number8Mandatory. Must be eight digits. 
    Debit Account Number combination must exist in customer debit
    account list and must not be a multi-bank account.
    4Payment Currency3Mandatory. Must be GBP
    5Payment Amount14Mandatory. Max = 999,999,999.99 (0.01 less than 1 billion)
    6Payment Reference18Maximum 18 alpha-numeric characters.
    7Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006)
    Must not be a UK non-working day.
    Minimum value date is three days forward including today if before
    BACS cut-off time and not including UK non-working days.
    8Beneficiary Account Number8Mandatory. Must be 8 digits.
    9Beneficiary Sort Code6Mandatory. Must be 6 digits.
    10Beneficiary Account Type Indicator1A single digit (0 to 9)
    11Beneficiary Name18Mandatory. Maximum 18 characters
    12Beneficiary’s Address105Maximum of 105 characters, over 3 lines.
    13Beneficiary’s Bank Name35Maximum of 35 characters.


    Note: During import any lower-case characters will be converted to upper case and any characters not valid for BACS will be replaced with a space.

     

    Example: <PaymentList><Payment>

    <PaymentTypeField>BACS_Payment</PaymentTypeField>

    <DebitSortCodeField>302556</DebitSortCodeField>

    <DebitAccountNumberField>11265668</DebitAccountNumberField>

    <PaymentCurrencyField>GBP</PaymentCurrencyField>

    <PaymentAmountField>9.00</PaymentAmountField>

    <PaymentReferenceNumberField>BACS TEST PAYMENT</PaymentReferenceNumberField>

    <ValueDateField>24-Nov-2005</ValueDateField>

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="11265260" SortCode="302556" Amount="9.00"

    AccountTypeIndicator="" Name="BACS TEST PYMT NAM" BankName="LLOYDS BANK PLC"

    PaymentReferenceNumber="BACS TEST PAYMENT" />

    </BeneficiaryList>

    </Payment></PaymentList>

     

    Domestic BACS Multiple Beneficiary 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be BACS_Payment
    2Debit Sort Code6Mandatory. Must be six digits without hyphens. Debit 
    Account Sort Code combination must exist in customer debit account list.
    3Debit Account Number8Mandatory. Must be eight digits.
    Debit Account Number combination must exist in
    customer debit account list and must not be a multi-bank account.
    4Payment Currency3Mandatory. Must be GBP
    5Payment Amount14Mandatory. Max = 999,999,999.99 (0.01 less than 1 billion)
    6Payment Reference18Maximum 18 alpha-numeric characters.
    7Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006)
    Must not be a UK non-working day.
    Minimum value date is three days forward including today
    if before BACS cut-off time and not including UK non-working days.
    8Beneficiary Account Number8Mandatory. Must be 8 digits.
    9Beneficiary Sort Code6Mandatory. Must be 6 digits.
    10Beneficiary Account Type Indicator1A single digit (0 to 9)
    11Beneficiary Name18Mandatory. Maximum 18 characters
    12Beneficiary’s Address105Maximum of 105 characters, over 3 lines.
    13Beneficiary’s Bank Name35Maximum of 35 characters.


     Note: During import any lower-case characters will be converted to upper case and any characters not valid for BACS will be replaced with a space.

     

    Example: <PaymentList><Payment>

    <PaymentTypeField>BACS_Payment</PaymentTypeField>

    <DebitSortCodeField>302556</DebitSortCodeField>

    <DebitAccountNumberField>11265668</DebitAccountNumberField>

    <PaymentCurrencyField>GBP</PaymentCurrencyField>

    <PaymentAmountField>109.00</PaymentAmountField>

    <PaymentReferenceNumberField>BACS TEST PAYMENT</PaymentReferenceNumberField>

    <ValueDateField>24-Nov-2005</ValueDateField>

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="11265260" SortCode="302556" Amount="9.00"

    AccountTypeIndicator="" Name="BACS TEST PYMT NAM" BankName="LLOYDS BANK PLC"

    PaymentReferenceNumber="BACS TEST PAYMENT" />

    <BeneficiaryItem AccountNumber="12345678" SortCode="309871" Amount="100.00"

    AccountTypeIndicator="" Name="A B Cixon" BankName="LLOYDS BANK PLC"

    PaymentReferenceNumber="Ben Reference" />

    </BeneficiaryList>

    </Payment></PaymentList>


     

    Domestic Internal Transfer 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be Internal_Transfer_GBP_Payment
    2Debit Sort Code6Mandatory. Must be six digits without hyphens. Debit
    Account Sort Code combination must exist in customer debit
    account list.
    3Debit Account Number8Mandatory. Must be eight digits.
    Debit Account Number combination must exist in customer
    debit account list and must not be a multi-bank account.
    4Debit Account currency3Mandatory. Currency associated to the debit account 
    number/ sort code combination
    5Payment Currency3Mandatory. Must be GBP
    6Payment Amount16Mandatory. Max = 9,999,999,999.99 (0.01 less than 10 billion)
    7Payment Reference16Maximum 16 characters
    8Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006)
    Must be a UK working day
    9Beneficiary Account
    Number
    8Mandatory. Must be a standard UK bank account number
    10Beneficiary Sort Code6Mandatory. Must be a Standard UK bank account sort code
    11Beneficiary Name35Mandatory. Maximum of 35 characters
    12Beneficiary’s Address105Maximum of 105 characters, over 3 lines.
    13Beneficiary’s Bank
    Name
    35Maximum of 35 characters.
    14Beneficiary’s Bank
    address
    105Maximum of 105 characters, over 3 lines


     

     Example: PaymentList><Payment>

    <PaymentTypeField>Internal_Transfer_GBP_Payment</PaymentTypeField>

    <DebitSortCodeField>302556</DebitSortCodeField>

    <DebitAccountNumberField>11266760</DebitAccountNumberField>

    <DebitAccountCurrencyField>GBP</DebitAccountCurrencyField>

    <PaymentCurrencyField>GBP</PaymentCurrencyField>

    <PaymentAmountField>100.00</PaymentAmountField>

    <PaymentReferenceNumberField />

    <ValueDateField>17-Jan-2006</ValueDateField>

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="11265260" SortCode="302556" Name="Mrs Helen Globaltest"

    BankName="" />

    </BeneficiaryList>

    </Payment></PaymentList>

     

     

    Euro Money Mover 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be Euro_MM_Payment
    2Debit Sort Code6Mandatory. Must be six digits without hyphens. Debit Account Sort
    Code combination must exist in customer debit account list.
    3Debit Account
    Number
    8Mandatory. Must be eight digits.
    Debit Account Number combination must exist in customer debit
    account list and must not be a multi-bank account.
    4Debit Account
    currency
    3Mandatory. Currency associated to the debit account number/ sort
    code combination
    5Payment Currency3Mandatory. Must be EUR
    6Payment Amount17Mandatory. Max = 9,999,999,999.99 (0.01 less than 10 billion)
    7Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006)
    Must be a Target working day
    8Intermediary Bank
    Name
    35Maximum of 35 characters
    If an intermediary details are entered but a BIC is not present this must
    be entered
    9Intermediary Bank
    Address
    105Maximum of 105 characters over a maximum of 3 separate lines
    If any intermediary details are entered but a BIC is not present this
    must be entered
    10Intermediary Bank
    SWIFT BIC
    11Valid BIC code
    The intermediary Bank SWIFT BIC must be valid for the payment to be
    STP.
    11Intermediary Bank
    Account Number
    34Maximum 34 characters
    12Payment Details140Maximum of 140 characters over a maximum of 4 separate lines
    13Charges3For payment to be STP this must be SHA
    14Special Instructions210Maximum of 210 alpha-numeric characters over a maximum of 6
    separate lines.
    If this field is populated then the payment is not STP
    15Pay on Application
    Details
    2929 alpha-numeric characters
    If this field is populated the type of identification to be used must be
    included.
    If this field is populated payment cannot be STP

     
    16Beneficiary
    Account Number
    34Maximum 34 characters. (IBAN).
    If this is populated then the pay on application indicator must be
    empty.
    This must be an IBAN for the payment to be STP.
    17Beneficiary Name35Mandatory. Maximum of 35 characters
    18Beneficiary Address105Maximum of 105 alpha-numeric characters over a maximum of 3
    separate lines.
    19Beneficiary Bank
    SWIFT BIC
    11Valid BIC
    A BIC must be entered if the payment is to go STP.
    If BIC is entered it must be Target addressable. (EU)
    Mandatory if beneficiary bank name and beneficiary bank address have
    not been included.
    20Beneficiary’s Bank
    Name
    35Maximum of 35 characters.
    Mandatory if no beneficiary BIC entered
    21Beneficiary’s Bank
    Address
    105Maximum of 105 alpha-numeric characters over a maximum of 3
    separate lines.
    Mandatory if no beneficiary BIC entered


    Example: <PaymentList><Payment>
    <PaymentTypeField>Euro_MM_Payment</PaymentTypeField>
    <DebitSortCodeField>309634</DebitSortCodeField>
    <DebitAccountNumberField>28000025</DebitAccountNumberField>
    <DebitAccountCurrencyField>EUR</DebitAccountCurrencyField>
    <PaymentCurrencyField>EUR</PaymentCurrencyField>
    <PaymentAmountField>100.00</PaymentAmountField>
    <ValueDateField>25-Jan-2006</ValueDateField>
    <IntermediaryBankNameField />
    <IntermediaryBankAddressField />
    <IntermediaryBankSwiftBICField />
    <IntermediaryBankAccountNumberField />
    <PaymentDetailsField />
    <ChargesField>SHA</ChargesField>
    <SpecialInstructionsField />
    <PayOnApplicationDetailsField />
    <BeneficiaryList>
    <BeneficiaryItem AccountNumber="FR9530002006930000766948W61" Name="MR AND MRS I J LLOYDS"
    Address="" BankSwiftBIC="CRLYFRPPXXX" BankName="Credit Lyonnais" BankAddress="19, Blvd des Italiens,
    Paris" />
    </BeneficiaryList>
    </Payment></PaymentList>

     

     

    Basic Euro Money Mover 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be Basic_Euro_MM_Payment
    2Debit Sort Code6Mandatory. Must be six digits without hyphens. Debit Account
    Sort Code combination must exist in customer debit account
    list.
    3Debit Account Number8Mandatory. Must be eight digits.
    Debit Account Number combination must exist in customer
    debit account list and must not be a multi-bank account.
    4Debit Account
    currency
    3Mandatory. Currency associated to the debit account number/
    sort code combination
    5Payment Currency3Mandatory. Must be EUR
    6Payment Amount6Mandatory. Up to and including €50,000
    7Payment Reference16Maximum 16 alpha-numeric characters
    8Value Date11Mandatory.
    DD-MMM-YYYY (i.e 01-Jan-2006)
    Must be a Target working day.
    Minimum value date is one day forward if before payments cut
    off time, two days forward if after payments cut off time
    9Payment Details140Maximum of 140 alpha-numeric characters over a maximum of
    4 separate lines
    10Charges3Must be ‘SHA’
    11Beneficiary Account
    Number
    34Mandatory. This must be a valid IBAN.
    12Beneficiary Name35Mandatory. Maximum of 35 characters
    13Beneficiary Bank
    SWIFT BIC
    11Mandatory. The entered BIC must match the entered IBAN. If
    the BIC does not match the IBAN the application will derive the
    BIC for the supplied IBAN and inform you via a validation
    message that the BIC they entered has been overwritten with a
    BIC related to the IBAN.
    14Beneficiary’s Bank
    Name
    35Maximum of 35 characters

     

    Example: <PaymentList><Payment>

    <PaymentTypeField>Basic_Euro_MM_Payment</PaymentTypeField>

    <DebitSortCodeField>309634</DebitSortCodeField>

    <DebitAccountNumberField>28000025</DebitAccountNumberField>

    <DebitAccountCurrencyField>EUR</DebitAccountCurrencyField>

    <PaymentCurrencyField>EUR</PaymentCurrencyField>

    <PaymentAmountField>100.00</PaymentAmountField>

    <ValueDateField>26-Jan-2006</ValueDateField>

    <PaymentDetailsField />

    <ChargesField>SHA</ChargesField>

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="FR9530002006930000766948W61" Name="MR AND MRS I J LLOYDS"

    BankSwiftBIC="CRLYFRPPXXX" BankName="Credit Lyonnais" BankAddress="19, Blvd des Italiens, Paris" />

    </BeneficiaryList>

    </Payment></PaymentList> 

      

     

      Euro Multi-Bank Money Mover 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be Multibank_Euro_MM_Payment
    2Debit Account Number8Mandatory. Must be 8 digits.
    Must be a multi-bank account
    3Debit Account Currency3Mandatory. Any 3 character Currency Code available within the
    Payments Service
    4Payment Currency3Mandatory. Must be EUR
    5Payment Amount21Mandatory. Max = 999,999,999,999.99 (0.01 less than 1000 billion)
    6Payment Reference16Maximum 16 characters.
    7Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006)
    8Intermediary Bank
    Name
    35Maximum 35 characters
    If any intermediary details are entered but a BIC is not present this must
    be entered
    9Intermediary Bank
    Address
    105Maximum 105 characters over a maximum of 3 lines
    If any intermediary details are entered but a BIC is not present this must
    be entered
    10Intermediary Bank
    SWIFT BIC
    11Valid BIC code
    If any intermediary details are present a valid BIC must be present to be
    STP
    11Intermediary Bank
    Account Number
    34Maximum 34 characters
    12Foreign Exchange Rate178 major units, decimal place and 8 minor units.
    13Foreign Exchange
    Reference
    16Max 16 characters.
    Can be entered without a corresponding rate
    An FX Reference and rate can be provided for this payment even if the
    currencies do not differ.
    14Charges3Mandatory. SHA, BEN, OUR
    15Remitter reference16Maximum of 16 alpha-numeric characters
    16Remittance Information140Maximum of 140 alpha-numeric characters over a maximum of 4
    separate lines
    17Clearing Code31Maximum 31 characters
    18Original Ordered
    Amount
    15Mandatory. Up to 15 digits including a decimal point.
    19Original Ordered
    Currency
    3Any 3 character Currency Code available within the Payments Service
    20Payee Country Code2Valid 2 character country code available within the Payments Service
    21Payment Authorisation35Maximum 35 characters
    22Charges Account
    Number
    34Maximum 34 characters
    23Regulatory Reporting
    Country Code
    2Valid 2 character ISO country code
    24Regulatory Reporting
    Country Code
    2Valid 2 character ISO country code
    25Regulatory Reporting
    Other Information
    105Max 105 characters over 3 lines. (Subtract 35 characters and one line
    for each of the above two items selected. Originating Country and
    Destination Country)
    26Transaction type
    Instruction Code
    4CHQB, NETS, RTGS or URGP
    27Settles A Trade
    Instruction Code
    n/aYes or No
    28Intra Company
    Instruction Code
    n/aYes or No
    29Other Information25Maximum 25 characters
    30Beneficiary Bank
    Clearing Code
    22 characters
    31Beneficiary Bank
    Country Code
    2Valid 2 character ISO country code
    32Beneficiary Bank Phone
    Number
    25Maximum 25 characters
    33Beneficiary Account
    Number
    34Maximum 34 characters (IBAN)
    34Beneficiary Name35Mandatory. Maximum of 35 characters
    35Beneficiary Address105Maximum of 105 alpha-numeric characters over a maximum of 3
    separate lines
    36Beneficiary Bank SWIFT
    BIC
    11Valid BIC
    Must cross-validate with other beneficiary field values
    37Beneficiary’s Bank
    Name
    35Maximum of 35 characters
    38Beneficiary’s Bank
    Address
    105Maximum of 105 alpha-numeric characters over a maximum of 3
    separate lines



    Example: <PaymentList><Payment>

     

    <PaymentTypeField>Multibank_Euro_MM_Payment</PaymentTypeField>

    < <DebitAccountNumberField>CLAIRE</DebitAccountNumberField>

    <DebitAccountCurrencyField>GBP</DebitAccountCurrencyField>

    <PaymentCurrencyField>EUR</PaymentCurrencyField>

    <PaymentAmountField>1,000.00</PaymentAmountField>

    <PaymentReferenceNumberField />

    <ValueDateField>09-Feb-2006</ValueDateField>

    <IntermediaryBankNameField />

    <IntermediaryBankAddressField />

    <IntermediaryBankSwiftBICField />

    <IntermediaryBankAccountNumberField />

    <PaymentDetailsField />

    <ChargesField>SHA</ChargesField>

    <RemitterReferenceField />

    <RemittanceInformationField />

    <ClearingCodeField />

    <DebitBranchNameField />

    <DebitAccountNameField>TEST CUSTOMER 2</DebitAccountNameField>

    <DebitAccountAddressField />

    <OriginalOrderedAmountField>1,000.00</OriginalOrderedAmountField>

    <OriginalOrderedCurrencyField>EUR</OriginalOrderedCurrencyField>

    <FXOriginalCurrencyField />

    <PayeeCountryCodeField>BE</PayeeCountryCodeField>

    <PaymentAuthorisationField />

    <ChargesAccountNumberField />

    <RROriginatingCountryCodeField />

    <RRDestinationCountryCodeField />

    <RROtherInformationField />

    <TransactionTypeInstructionCodeField />

    <SettlesATradeInstructionCodeField>False</SettlesATradeInstructionCodeField>

    <IntraCompanyInstructionCodeField>False</IntraCompanyInstructionCodeField>

    <OtherInformationField />

    <BeneficiaryBankClearingCodeKeyField />

    <BeneficiaryBankCountryCodeField>BE</BeneficiaryBankCountryCodeField>

    <BeneficiaryPhoneNumberField />

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="123456789" Name="TEST CUSTOMER" Address=""

    BankSwiftBIC="LOYDBEBBXXX" BankName="Lloyds Bank plc" BankAddress="Avenue de Tervuren 2,

    Brussels" />

    </BeneficiaryList>

    </Payment></PaymentList>

     

    Euro Internal Transfer 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be Internal_Transfer_Euro_Payment
    2Debit Sort Code6Mandatory. 6 digits
    Debit Ac Sort Code combination must exist in customer debit account list.
    Must be a Lloyds Bank account
    3Debit Account Number8Mandatory. 8 digits
    Debit Ac Sort Code combination must exist in customer debit account list
    and must not be a multi-bank account.
    Must be a Lloyds Bank account
    4Debit Account currency3Mandatory. Currency associated to the debit account number/ sort code
    combination
    5Payment Currency3Mandatory. Must be EUR
    6Payment Amount18Mandatory. Max = 999,999,999,999.99 (0.01 less than 1000 billion)
    7Payment Reference16Max 16 characters
    8Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006)
    Must be a UK working day
    9Foreign Exchange Rate156 major units, decimal place and 8 minor units.
    10Foreign Exchange
    Reference
    11Maximum 11 Chars
    Must be correctly formatted with either B, F or X followed by 10 digits.
    Or the letters AGREED
    Required if FX Rate has been provided.
    Only to be provided if the currencies differ.
    11Beneficiary Account
    Number
    8Mandatory. Must be a Lloyds Bank account. Must be a standard UK bank
    account number.
    12Beneficiary Sort Code6Mandatory. This must be an Lloyds Bank account
    13Beneficiary Name35Mandatory. Maximum 35 characters

     

    Example: <PaymentList><Payment>

    <PaymentTypeField>Internal_Transfer_Euro_Payment</PaymentTypeField>

    <DebitSortCodeField>309634</DebitSortCodeField>

    <DebitAccountNumberField>28000025</DebitAccountNumberField>

    <DebitAccountCurrencyField>EUR</DebitAccountCurrencyField>

    <PaymentCurrencyField>EUR</PaymentCurrencyField>

    <PaymentAmountField>100.00</PaymentAmountField>

    <PaymentReferenceNumberField />

    <ValueDateField>09-Feb-2006</ValueDateField>

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="27101308" SortCode="309634" Name="TEST CUSTOMER 2" />

    </BeneficiaryList>

    </Payment></PaymentList>

     

    International Money Mover 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be International_MM_Payment
    2Debit Sort Code6Mandatory. 6 digits
    Debit Account Sort Code combination must exist in customer debit
    account list.
    3Debit Account Number8Mandatory. 8 digits.
    Debit Account number combination must exist in customer debit
    account list and must not be a multi-bank account.
    4Debit Account currency3Mandatory. Currency associated to the debit account number/ sort
    code combination
    5Payment Currency3Mandatory. Any 3 character Currency Code available within the
    Payments service
    6Payment Amount21Mandatory.
    A) For currencies that require 0 decimal places the maximum value is
    99,999,999,999,999. B) For currencies that require 1 decimal place
    the maximum value is 9,999,999,999,999.9. C) For currencies that
    require 2 decimal places the maximum value is 999,999,999,999.99.
    C) For currencies that require 3 decimal places the maximum value is
    99,999,999,999.999.
    7Payment Reference16Maximum 16 alpha numeric characters
    8Destination Country
    Code
    2Valid 2 character ISO country code
    9Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006)
    Must be a working day in the country of the payment currency
    10Intermediary Bank
    Name
    35Maximum of 35 characters
    If any intermediary details are entered but a BIC is not present this
    must be entered
    11Intermediary Bank
    Address
    105Maximum of 105 characters over a maximum of 3 lines
    If any intermediary details are entered but a BIC is not present this
    must be entered
    12Intermediary Bank
    SWIFT BIC
    11Valid BIC code.
    If any intermediary details are present a valid BIC must be present to
    be STP
    13Intermediary Bank
    Account Number
    34Maximum 34 characters
    14Foreign Exchange Rate156 major units, decimal place and 8 minor units.
    15Foreign Exchange
    Reference
    11Maximum 11 Chars
    Must be correctly formatted with either B, F or X Followed by 10 digits.
    Or the letters AGREED
    Required if FX Rate has been provided.
    Only to be provided if the currencies differ.
    16Payment Details140Maximum of 140 characters over a maximum of 4 separate lines
    17Charges3for payment to be STP this must be SHA
    18Special Instructions210Maximum of 210 characters over a maximum of 6 lines
    If this field is populated the payment is not STP
    19Remittance Information140Maximum of 140 characters over a maximum of 4 separate lines
    20Payment On
    Application Details
    2929 alpha numeric characters.
    If populated must include the type of identification to be used.
    If this field is populated payment cannot be STP
    21Clearing Code50Maximum 50 characters
    22Beneficiary Account
    Number
    34Maximum of 34 characters (IBAN)
    If this is populated then the pay on application indicator must be empty.
     
    23Beneficiary Name35Mandatory. Maximum of 35 characters
    24Beneficiary Address105Maximum of 105 alpha-numeric characters over a maximum of 3
    separate lines
    25Beneficiary Bank SWIFT
    BIC
    11Valid BIC
    A BIC must be entered if payment is to go STP. If payment currency is
    EUR and BIC is entered it must NOT be Target addressable. (EU)
    Mandatory if beneficiary bank name and beneficiary bank address
    have not been included.
    26Beneficiary’s Bank
    Name
    35Maximum of 35 characters
    27Beneficiary’s Bank
    Address
    105Maximum of 105 alpha-numeric characters over a maximum of 3
    separate lines



     

     

    Example: <PaymentList><Payment>

    <PaymentTypeField>International_MM_Payment</PaymentTypeField>

    <DebitSortCodeField>309634</DebitSortCodeField>

    <DebitAccountNumberField>11609335</DebitAccountNumberField>

    <DebitAccountCurrencyField>USD</DebitAccountCurrencyField>

    <PaymentCurrencyField>USD</PaymentCurrencyField>

    <PaymentAmountField>100.00</PaymentAmountField>

    <ValueDateField>08-Feb-2006</ValueDateField>

    <IntermediaryBankNameField />

    <IntermediaryBankAddressField />

    <IntermediaryBankSwiftBICField />

    <IntermediaryBankAccountNumberField />

    <PaymentDetailsField />

    <ChargesField>SHA</ChargesField>

    <SpecialInstructionsField />

    <RemittanceInformationField />

    <PayOnApplicationDetailsField />

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="167895643" Name="MR AND MISS SMITH" Address=""

    BankSwiftBIC="CHASUS33XXX" BankName="JPMorgan Chase Bank" BankAddress="1 CHASE MANHATTAN PLZ,

    &#xD;&#xA;NEW YORK CITY" />

    </BeneficiaryList>

    </Payment></PaymentList>

     

    International Multi-Bank Money Mover 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be Multibank_International_MM_Payment
    2Debit Account Number8Mandatory. 8 digits. Must be a multi-bank account
    3Debit Account currency3Mandatory. Currency associated to the debit account number
    4Payment Currency3Mandatory. STP currencies only
    5Payment Amount21Mandatory
    A) For currencies that require 0 decimal places the maximum value
     is 99,999,999,999,999. B) For currencies that require 1 decimal place 
    the maximum value is 9,999,999,999,999.9. C) For currencies that 
    require 2 decimal places the maximum value is 999,999,999,999.99. 
    C) For currencies that require 3 decimal places the maximum 
    value is 99,999,999,999.999.
    6Payment Reference16Maximum 16 characters
    7Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006) 
    Must be a working day in the country of the payment
    8Intermediary Bank
    Name
    35Maximum of 35 characters If any intermediary d
    etails are entered but a BIC is not present 
    this must be entered
    9Intermediary Bank
    Address
    105Maximum of 105 characters over a maximum 
    of 3 lines If any intermediary details are 
    entered but a BIC is not present this must be entered
    10Intermediary Bank
    SWIFT BIC
    11Valid BIC code. If any intermediary details are 
    present a valid BIC must be present to be STP
    11Intermediary Bank
    Account Number
    35Maximum of 35 characters If any intermediary 
    details are entered but a BIC is not present 
    this must be entered
    12Payment Details140Maximum of 140 characters over a maximum of 4 separate lines
    13Charges3Mandatory SHA, Ben or OUR
    14Remitter Reference16Maximum of 16 characters
    15Remittance Information140Maximum of 140 characters or a maximum of 4 separate lines
    16Clearing Code31Maximum 31 characters
    17Original Ordered
    Amount
    15Mandatory. Up to 15 digits including a decimal point.
    18Original Ordered
    Currency
    3Valid 3 character Currency code available within the Payments
    service
    19Payee Country Code2Valid 2 character country code available within the Payments Service
    20Payment Authorisation35Maximum 35 characters
    21Charges Account
    Number
    34Maximum 34 characters
    22Regulatory Reporting
    Country Code
    2Valid 2 character country code
    23Regulatory Reporting
    Country Code
    2Valid 2 character country code available within the Payments Service
    24Regulatory Reporting
    Other Information
    105Max 105 characters over 3 lines. (Subtract 35 characters 
    and one line for each of the above two items selected. 
    Originating Country and Destination Country)
    25Transaction Type
    Instruction Code
    4CHQB, NETS, RTGS or URGP
    26Settles A Trade
    Instruction Code
    n/aYes or No
    27Intra Company
    Instruction Code
    n/aYes or No
    28Other Information25Maximum 25 characters
    29Beneficiary Bank
    clearing Code Key
    22 Characters
    30Beneficiary Bank
    Country Code
    2Valid 2 character country code available within the Payments Service
    31Beneficiary Phone
    Number
    25Maximum 25 characters
    32Beneficiary Account
    Number
    34Maximum 34 characters (IBAN)
    33Beneficiary Name35Mandatory. Maximum of 35 characters
    34Beneficiary Address105Maximum of 105 alpha-numeric characters over a maximum of 
    3 separate lines
    35Beneficiary Bank SWIFT
    BIC
    11Valid BIC Code
    36Beneficiary’s Bank
    Name
    35Maximum of 35 characters
    37Beneficiary’s Bank
    Address
    105Maximum of 105 alpha-numeric characters over a maximum of 
    3 separate lines


     

     

    Example: <PaymentList><Payment>

    <PaymentTypeField>Multibank_International_MM_Payment</PaymentTypeField>

    <DebitAccountNumberField>CLAIRE</DebitAccountNumberField>

    <DebitAccountCurrencyField>GBP</DebitAccountCurrencyField>

    <PaymentCurrencyField>USD</PaymentCurrencyField>

    <PaymentAmountField>1,000.00</PaymentAmountField>

    <PaymentReferenceNumberField />

    <ValueDateField>09-Feb-2006</ValueDateField>

    <IntermediaryBankNameField />

    <IntermediaryBankAddressField />

    <IntermediaryBankSwiftBICField />

    <IntermediaryBankAccountNumberField />

    <PaymentDetailsField />

    <ChargesField>SHA</ChargesField>

    <RemitterReferenceField />

    <RemittanceInformationField />

    <ClearingCodeField>021000021</ClearingCodeField>

    <DebitBranchNameField />

    <DebitAccountNameField>TEST CUSTOMER 2</DebitAccountNameField>

    <DebitAccountAddressField />

    <OriginalOrderedAmountField>1,000.00</OriginalOrderedAmountField>

    <OriginalOrderedCurrencyField>USD</OriginalOrderedCurrencyField>

    <FXOriginalCurrencyField />

    <PayeeCountryCodeField>US</PayeeCountryCodeField>

    <PaymentAuthorisationField />

    <ChargesAccountNumberField />

    <RROriginatingCountryCodeField />

    <RRDestinationCountryCodeField />

    <RROtherInformationField />

    <TransactionTypeInstructionCodeField />

    <SettlesATradeInstructionCodeField>False</SettlesATradeInstructionCodeField>

    <IntraCompanyInstructionCodeField>False</IntraCompanyInstructionCodeField>

    <OtherInformationField />

    <BeneficiaryBankClearingCodeKeyField />

    <BeneficiaryBankCountryCodeField>US</BeneficiaryBankCountryCodeField>

    <BeneficiaryPhoneNumberField />

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="123456789" Name="JP MORGAN CHASE MANHATTAN BANK"

    Address="" BankSwiftBIC="CHASUS33XXX" BankName="JPMorgan Chase Bank, National Ass" BankAddress="270

    PARK AVE, NEW YORK CITY" />

    </BeneficiaryList>

    </Payment></PaymentList>

     

    International Internal Transfer 

    The fields within each record must be presented in the order below, alternatively only the mandatory fields need to be completed and presented in the order below:

     

    FieldField NameLengthField Validation
    1Payment Typen/aMust be Internal_Transfer_International_Payment
    2Debit Sort Code6Mandatory. 6 digits
    Debit Account Sort Code combination must exist in customer debit
    account list.
    3Debit Account Number8Mandatory. 8 digits
    Debit Account Number combination must exist in customer debit
    account list and must not be a multi-bank account.
    4Debit Account currency3Mandatory. Currency associated to the debit account number/ sort
    code combination
    5Payment Currency3Mandatory. Any 3 character Currency Code available within the
    Payments Service
    6Payment Amount21Mandatory.
    A) For currencies that require 0 decimal places the maximum value is
    99,999,999,999,999. B) For currencies that require 1 decimal place
    the maximum value is 9,999,999,999,999.9. C) For currencies that
    require 2 decimal places the maximum value is 999,999,999,999.99.
    C) For currencies that require 3 decimal places the maximum value is
    99,999,999,999.999.
    7Payment Reference16Maximum 16 characters
    8Value Date11Mandatory. DD-MMM-YYYY (i.e 01-Jan-2006)
    Must be a UK working day
    9Beneficiary Account
    Number
    8Must be a standard UK bank account number.
    Must be a Lloyds Bank account.
    10Beneficiary Sort Code6Must be a Standard UK bank account sort code.
    Must be a Lloydsaccount.
    11Beneficiary Name35Mandatory. Maximum 35 characters
    12Beneficiary’s Bank
    Name
    35Maximum of 35 characters

     

     

    Example: <PaymentList><Payment>

    <PaymentTypeField>Internal_Transfer_International_Payment</PaymentTypeField>

    <DebitSortCodeField>309634</DebitSortCodeField>

    <DebitAccountNumberField>11609335</DebitAccountNumberField>

    <DebitAccountCurrencyField>USD</DebitAccountCurrencyField>

    <PaymentCurrencyField>USD</PaymentCurrencyField>

    <PaymentAmountField>1,000.00</PaymentAmountField>

    <PaymentReferenceNumberField />

    <ValueDateField>09-Feb-2006</ValueDateField>

    <BeneficiaryList>

    <BeneficiaryItem AccountNumber="12077027" SortCode="309634" Name="TEST CUSTOMER 2"

    BankName="" />

    </BeneficiaryList>

    </Payment></PaymentList>

    Back to top

    1.4.2 PFE-CSV (Import, Export, Archive)

    The PFE-CSV format is used as one of a choice of PFE import formats, in order to import payment instructions into the application, as an export format, used to export payment instructions and also as a format for payment archive.

    The CSV does not have a structure (like XML) which demands values to be optional or mandatory. If a value is not specified, a comma must exist to show that the column is empty. The empty data is then simply placed into the relevant fields and the payment is then validated (which displays the error messages).

    BACS Multiple Payments: Please note that in the case of a BACS Multiple payment, there will be a line for the entire payment (starting ‘BACS’) and a single line for each Beneficiary (see example). 

    Information relating to the entire payment will be contained in the ‘BACS’ line in the CSV file and information relating to each individual beneficiary will be contained in the ‘BEN’ line in the CSV file. The beneficiary line will not contain debit account information or value dates etc., the only fields populated will be BACS Multiple beneficiary specific. 

    For payments that have multiple FX rates, the first FX rate and reference will be included in the main line for the payment under the FX Rate and FX Reference fields. Any other FX rates or references will be included on subsequent lines with the moniker (first field) set to ‘FX’. 

    As far as possible, the field data in the import file should contain characters that are valid for that field of the payments. Invalid characters will be imported however the payment will fail validation. Since this is a comma separated file commas should not be included in the contents of a field. If commas are included then the file format for that line will be invalid and the record will be rejected, For multiple line fields such as addresses user can use the new line character “\n” within the CSV import file.

    Note: All the fields listed below are in the order they will be in the CSV file.

    For all payment types

    • Payment Type (See Payment Type Field Values )
    • Payment PFE-Reference
    • Debit Sort Code
    • Debit Account Number
    • Debit Account Currency
    • Payment Currency
    • Cur Equiv of GBP Indicator
    • Payment Amount
    • Country Drawn From
    • Destination Country Code
    • Value Date
    • PrePositioned
    • Beneficiary Account Number
    • Beneficiary Sort Code
    • Beneficiary Credit Amount
    • Beneficiary Type of Account Indicator
    • Beneficiary Name
    • Beneficiary Address
    • Beneficiary Bank SWIFT BIC
    • Beneficiary Bank Name
    • Beneficiary Bank Address
    • Intermediary Bank SWIFT BIC
    • Intermediary Bank Account Number
    • Intermediary Bank Name
    • Intermediary Bank Address
    • FX Reference
    • FXRate
    • Payment Details
    • Charges
    • Special Instructions
    • Information to Payee Bank
    • Advise Payee
    • Payee is a Bank
    • Payment Reference
    • Beneficiary Payment Reference
    • Remittance Information
    • Remitters Name
    • Remitters Address
    • Pay on Application Details
    • Clearing Code
    • Debit Branch Name
    • Debit Account Name
    • Debit Account Address
    • Original Ordered Amount
    • Original Ordered Currency
    • Beneficiary Bank Clearing Code Key
    • Beneficiary Bank Country Code
    • FX Original Currency
    • Payee Country Code
    • Payment Authorisation
    • Charges Account Number
    • Originating County Code
    • Destination Country Code
    • Other Regulatory Reporting Information
    • Transaction Type Instruction Code
    • Settles A Trade Instruction Code
    • Intra Company Instruction Code
    • Beneficiary Phone Number

    Payment Type Field Values

    • Ben (for a beneficiary line – multiple beneficiary payment)
    • Chaps_GBP_Payment
    • BACS_Payment
    • BACS_Single_Payment
    • Internal_Transfer_GBP_Payment
    • Euro_MM_Payment
    • Basic_Euro_MM_Payment
    • Multibank_Euro_MM_Payment
    • Internal_Transfer_Euro_Payment
    • International_MM_Payment
    • Multibank_International_MM_Payment
    • Internal_Transfer_International_Payment
    Domestic example’s (see key on next page)

     
    BACS Single:

     
    Single_BACS_GBP_Payment,,112233,11223344,,GBP,,100.00,,,26-Jan-2009,,12345678,123456,,,Beneficiary
    Name,,,,,,,,,,,,,,,,,Payment Reference,,,,,,,,,,,,,,,,,,,,,,,,

     
    BACS Multiple

     
    BACS_Payment,,112233,11223344,,GBP,,200.00,,,26-Jan-2009,,,,,,,,,,,,,,,,,,,,,,,Remitter Reference,,,,,,,,,,,,,,,,,,,,,,,,
    Ben,,,,,,,,,,,,12345678,123456,100.00,,Beneficiary Name,,,,,,,,,,,,,,,,,,Beneficiary Reference,,,,,,,,,,,,,,,,,,,,,,,
    Ben,,,,,,,,,,,,12345678,123456,100.00,,Beneficiary Name,,,,,,,,,,,,,,,,,,Beneficiary Reference,,,,,,,,,,,,,,,,,,,,,,,
    Note: 200.00 must equal the sum of the payments in the file.

     
    CHAPS Payment:

     
    CHAPS_GBP_Payment,,112233,11223344,,GBP, ,100.00,,, 26-Jan-2009,,12345678,123456,,,Beneficiary Name
    ,,,,,,,,,,,Beneficiary Reference,,,,,,Remitter Reference,,,,,,,,Your Account Name ,,,,,,,,,,,,,,,,

     
    DataField NameLengthField Validation
    112233Debit Sort Code6Mandatory. 6 digits
    Debit Account Sort Code combination must exist in
    customer debit account list.
    11223344Debit Account Number8Mandatory. 8 digits
    Debit Account Number combination must exist in
    customer debit account list and must not be a multi-bank
    account.
    26-Jan-2009Value Date11Mandatory. DD-MMM-YYYY (e.g. 01-Jan-2006)
    Must be a working day in the country of the payment
    currency
    Beneficiary
    Name
    Beneficiary Name18/35Mandatory.
    Maximum of 18 characters for BACS
    Maximum of 35 characters for CHAPS
    12345678Beneficiary Account No8Mandatory. 8 Digits
    Beneficiary’s Account Number
    123456Beneficiary Sort Code6Mandatory. 6 digits
    Beneficiary’s Sort Code
    100.00Payment Amount21Mandatory.
    A) For currencies that require 0 decimal places the
    maximum value is 99,999,999,999,999. B) For currencies
    that require 1 decimal place the maximum value is
    9,999,999,999,999.9. C) For currencies that require 2
    decimal places the maximum value is 999,999,999,999.99.
    C) For currencies that require 3 decimal places the
    maximum value is 99,999,999,999.999.
    Remitter
    Reference
    Remitter Reference16-18Optional.
    Maximum of 16 characters for CHAPS
    Maximum of 18 characters for BACS Multiple
    Beneficiary
    Reference
    Beneficiary Reference18/140Optional.
    Maximum of 18 characters BACS.
    Maximum of 140 characters or a maximum of 4 separate
    lines.


     Euro example (STP) 
     

    Basic_Euro_MM_Payment,,112233,11223344,,EUR,,100.00,,,26-Jan-2009,,FRxxxxxxx,,,, Beneficiary Name

    ,,BNPAFRPPTAS,,,,,,,,,Beneficiary Reference,SHA,,,,,Remitter Reference,,,,,,,,,,,,,,,,,,,,,,,,
    Euro_MM_Payment,,302571,00031942,,EUR,,100.00,,,26-Jan-2009,, FRxxxxxxx,,,, Beneficiary Name
    ,,BNPAFRPPTAS,,, ARTIITM1003,0987654321,BANCO SEC,,,,Beneficiary Reference,SHA,,,,,Remitter
    Reference,,,,,,,,,,,,,,,,,,,,,,,,

     
    DataField NameLengthField Validation
    112233Debit Sort Code6Mandatory. 6 digits
    Debit Account Sort Code combination must exist
     in customer debit account list.
    11223344Debit Account 
    Number
    8Mandatory. 8 digits 
    Debit Account Number combination must exist in 
    customer debit account list and must not be a multi-bank 
    account.
    26-Jan-2009Value Date/Execute Date11Mandatory. DD-MMM-YYYY (e.g. 01-Jan-2006) 
    Must be a working day in the country of the payment 
    currency
    Beneficiary
    Name
    Beneficiary Name35Mandatory
    Maximum of 35 characters
    FRxxxxxxBeneficiary Account No34Mandatory
    IBAN Number
    100.00Payment Amount21Mandatory. A) For currencies that require 0 decimal places 
    the maximum value is 99,999,999,999,999. B) For currencies 
    that require 1 decimal place the maximum 
    value is 9,999,999,999,999.9. C) For currencies 
    that require 2 decimal places the maximum 
    value is 999,999,999,999.99. 
    C) For currencies that require 3 decimal places 
    the maximum value is 99,999,999,999.999.
    BNPAFRPPTASSWIFT/BIC Code11Mandatory
    Maximum 11 characters
    SHACharges3Mandatory
    SHA – Charges are split
    BEN – Beneficiary Pays All Charges
    OUR – Remitter Pays All Charges
    Remitter
    Reference
    Remitter Reference35Optional
    Maximum of 35 characters
    Beneficiary
    Reference
    Beneficiary Reference140optional
    Maximum of 140 characters or a maximum of 4 separate
     lines
    ARMTIITM1003Intermediary SWIFT/BIC11Optional
    Maximum of 11 characters
    0987654321Intermediary Account Num34Optional
    Maximum of 34 characters
    BANCO SECIntermediary Bank Name35Optional
    Maximum of 35 characters

     
    International example (STP) 
     

    International_MM_Payment,,112233,11223344,,USD,,100.00,,,26-Jan-2009,,1234567890,,,, Beneficiary Name ,,BNPAFRPPTAS,,,ARTIITM1003,0987654321,BANCO SEC,,,,Beneficiary Reference,SHA,,,,,Remitter

    Reference,,,,,,,,,,,,,,,,,,,,,,,,

     

     

    DataField NameLengthField Validation
    112233Debit Sort Code6Mandatory. 6 digits
    Debit Account Sort Code combination must exist in
    customer debit account list.
    11223344Debit Account Number8Mandatory. 8 digits
    Debit Account Number combination must exist in customer
    debit account list and must not be a multi-bank account.
    USDCurrency3Mandatory
    Credit Currency in ISO Format
    100.00Payment Amount21Mandatory.
    A) For currencies that require 0 decimal places the maximum
    value is 99,999,999,999,999. B) For currencies that require 1
    decimal place the maximum value is 9,999,999,999,999.9. C)
    For currencies that require 2 decimal places the maximum
    value is 999,999,999,999.99. C) For currencies that require 3
    decimal places the maximum value is 99,999,999,999.999.
    26-Jan-2009Value Date11Mandatory. DD-MMM-YYYY (e.g. 01-Jan-2006)
    Must be a working day in the country of the payment
    currency
    Beneficiary NameBeneficiary Name35Mandatory
    Maximum of 35 characters.
    1234567890Beneficiary Account No34Mandatory
    Account Number
    BNPAFRPPTASSWIFT/BIC Code11Mandatory
    Maximum 11 characters
    SHACharges3Mandatory
    SHA – Charges are split
    BEN – Beneficiary Pays All Charges
    OUR – Remitter Pays All Charges
    Remitter ReferenceRemitter Reference35Optional
    Maximum of 35 characters
    Beneficiary ReferenceBeneficiary
    Reference
    140Optional
    Maximum of 140 characters or a maximum of 4 separate
    lines
    ARTIITM1003Intermediary
    SWIFT/BIC
    11Optional
    Maximum of 11 characters
    0987654321Intermediary
    Account Num
    34Optional
    Maximum of 34 characters
    BANCO SECIntermediary Bank
    Name
    35Optional
    Maximum of 35 characters

                     

     

     
    Back to top

    1.4.3 Other Formats

    Sage BACS Multiple CSV

    This import format is that used when the customer exports information from the Sage accounting package and is formatted as a variation on the comma separated, enclosed in double quotes and variable length (CSV) format.

    Each credit record within the import file is contained on a separate line (separated by a carriage return/line feed combination) and each field within a record must be separated by a comma. In addition and optionally each field within a record may be enclosed in double quotes.

    The fields within each record must be presented in the order: Payee Sort Code, Payee Account Number, Payee Account Name, Reference, and implied decimal Amount.

     

    FieldField NameLengthBACS Multiple field and validation
    1Payee Sort Code6 or 8Mandatory. Must be six digits without hyphens or 8 digits with.
    2Payee account number8Mandatory. Must be eight digits.
    3Payee account name18 or lessMandatory. If longer than 18 characters it will be truncated.
    4Reference18 or lessThe reference that will normally appear on the beneficiary’s statement.
    If longer than 18 characters it will be truncated.
    5Amount11 or lessMandatory. Up to 11 digits with an explicit decimal point.

     

    Note: During import any lower-case characters will be converted to upper case and any characters not valid for BACS will be replaced with a space.

    An example is: “10-12-10”,”00123456”,”PAYEE 1”,”REF 1”,1000.00

    “101210”,”00123456”,”PAYEE 1”,”REF 1”,1000.00

    101210,00123456,PAYEE 1,REF 1,1000.00

     

     

      BACS Multiple Standard CSV 

    This import format is the “normal” comma separated variable length (CSV) format.

    Each credit record within the import file is contained on a separate line (separated by a carriage return/line feed combination) and each field within a record is separated by a comma. In addition you have the option that each field within a record may be enclosed in double quotes.

    The fields within each record must be presented in the order: Payee Sort Code, Payee Account Number, Payee Type of Account, Payee Bank/Branch, Payee Account Name, Reference and amount. The field’s length and validation are as follows:

     

    FieldField NameLengthBACS Multiple field and validation
    1Payee bank sort code6 or 8Mandatory. Must be six digits without hyphens or 8 digits with.
    2Payee account number8Mandatory. Must be eight digits.
    3Payee Type of Account1Mandatory. Will usually be '0'.
    4Payee bank/branch18 or lessIf longer than 18 characters it will be truncated.
    5Payee Account name18 or lessMandatory. If longer than 18 characters it will be truncated.
    6Reference18 or lessThe reference that will normally appear on the beneficiary’s
    statement. If longer than 18 characters it will be truncated.
    7Amount11 or lessMandatory. Up to 11 digits plus an explicit decimal point.


     

     

    Note: During import any lower-case characters will be converted to upper case and any characters not valid for BACS will be replaced with a space.


     

    Examples are:

    101210,00123456,0,BARCLAYS CITY ROAD,PAYEE 1,REF 1,1000.00

    10-12-10,00123456,0,BARCLAYS CITY ROAD,PAYEE 1,REF 1,1000.00

    ”101210”,”00123456”,”0”,””,”PAYEE 1”,”REF 1”,”1000.00

    101210,00123456,0,”BARCLAYS CITY ROAD”,”PAYEE 1”,”REF 1”,1234.00

     


     BACS Multiple Fixed Length 

    This import format is a legacy Lloyds Bank format included to facilitate customer migration from Lloydslink to PFE.

    The file to be imported must be in text format, with no header and no trailer, containing nothing but fixed length BACS standard layout records, each terminated by a carriage-return line-feed pair. The fields and format are as follows:

     

    Field No.Field NameFixed LengthEnd PositionMapping to BACS Multiple field and validation
    1Beneficiary bank sort
    code
    66Mandatory. Must be six digits
    2Beneficiary bank
    account number
    814Mandatory. Must be eight digits
    3Type of account code115Any digit (0-9). If not a digit, it will default to 0 in BACS Multiple
    record.
    4Transaction code217Must be 99 or the transaction is ignored.
    5Originating sorting
    code number
    623The contents of this field will be ignored, but it must be present.
    6Originating account
    number
    831The contents of this field will be ignored, but it must be present.
    7Free format435The contents of this field will be ignored, but it must be present.
    8Amount11 right-justified46Mandatory. Must be 11 digits zero-filled from the left with no
    decimal point.
    9User's name1864The contents of this field will be ignored, but it must be present.
    10Beneficiary reference1882 
    11Beneficiary name18100Mandatory.
    12BACS processing day
    of data record
    6106The contents of this field will be ignored and it will usually not be
    present at all, the record terminating after field 11.


     Note: During import any lower-case characters will be converted to upper case and any characters not valid

    for BACS will be replaced with a space.

     


     Example fixed length file:

    1 2 3 4 5 6 7 8 9

    123456789012345678901234567890123456789012345679012345678901234567890123456789012345678901234567890

    20304000357967099 00000148973 MYSON INV2387 SCIMITAR SERVICES

    30942801264196099 00000049628 MYSON INV2643 RUDDSPRINT

    40924200065111099 00000004125 MYSON INV2245 THOMPSON IND

    70324503366789099 00000043897 MYSON INV2410 RORY AND ADAMS

    88003304567822099 00008137680 MYSON INV2519 LETCHFORD PAPER

    Note: In the example above the numbering is provided as a guide and should not be included in the file itself.

    If a record is not exactly 100 characters long (or 106 if the optional field 12 is included) then the transaction will be rejected.


     

    Back to top

    1.5 Beneficiary account data import file formats.

    There are two types of file formats for importing beneficiary account data they are as follows:

    CSV

    XML

    CSV Format

     

    Field No.Field NameFixed LengthValidation
    1Type Mandatory. ‘Beneficiary’ only.
    2Name50Mandatory. Maximum 50 characters.
    3Account Number50Mandatory. Maximum 50 characters
    4Bank clearing code50Maximum 50 characters
    5Currency3Any 3 character ISO currency code
    6Account Holder200Mandatory. Maximum of 200 characters
    7Account Holder
    Address
    200Maximum of 200 characters
    8Is Lloyds Bank Account10 (False) or 1 (True)
    9Bank Name200Maximum of 200 characters
    10Bank Country2Any 2 character ISO country code
    11Bank BIC11A valid BIC Code
    12Bank Address200Maximum of 200 characters.


     

     

    Example:

    Beneficiary, Georges Current Account,00658058, 309634, USD, George Washington, 1600 Pennsylvania Avenue, 0,Bank of America, US, LOYDGB2LXXX, Barclay House


     

    XML Format

     

    Field No.Field NameFixed LengthValidation
    1Type Mandatory. ‘Beneficiary’ only.
    2Name50Mandatory. Maximum 50 characters.
    3Account Number50Mandatory. Maximum 50 characters
    4Bank clearing code50Maximum 50 characters
    5Currency3Any 3 character ISO currency code
    6Account Holder200Mandatory. Maximum of 200 characters
    7Account Holder
    Address
    200Maximum of 200 characters
    8Is Lloyds Bank Account10 (False) or 1 (True)
    9Bank Name200Maximum of 200 characters
    10Bank Country2Any 2 character ISO country code
    11Bank BIC11A valid BIC Code
    12Bank Address200Maximum of 200 characters.

     

    Example:

    <AccountList>

    <Account>

    <AccountTypeField >Beneficiary</AccountTypeField >

    <AccountNameField> Georges Account </AccountNameField>

    <AccountNumberField >00658058 </AccountNumberField>

    <BankClearingCodeField >309634 </BankClearingCodeField>

    <CurrencyField > USD </CurrencyField>

    <AccountHolderField >George Washington</AccountHolderField>

    <AccountHolderAddressField>1600 Pennsylvania Avenue </AccountHolderAddressField>

    <IsLloydsAccountField >0 </IsLloydsAccountField>

    <BankNameField > Bank of America </ BankNameField>

    <BankCountryField>US</BankCountryField>

    <BankBICField>LOYDGB2LXXX</BankBICField>

    <BankAddressField > Barclay House </BankAddressField >

    </Account>

    </AccountList>


     

     

    Back to top
10/28/2021 10:20:09 PM