I want to import payments

  • Video Tutorial 

    How to Import Payments in Commercial Banking Online

    Duration: 02:46

  • Step-by-step guide

    Download our step-by-step guide on how to import a payment

  • You can import payments into Commercial Banking Online by using XML, CSV or fixed width.  You can use importing for all the types of payments available in Commercial Banking Online. If a payment is imported or not approved  before the cut-off time it will  be rejected. In order to submit a payment after its cut-off time please enter a future date.

    • Please note payment cut off time variations for file import; click here for payment cut off times.
    • A payment file imported into Commercial Banking Online can have a maximum of 1,000 entries, except when you initiate Bacs payments as single credit/debit when the limit is 500 transactions.
    • Each imported file must have a unique name or it will not be accepted.
    • In order to process payments correctly, certain special characters in the Beneficiary Name and Beneficiary Reference are replaced with spaces in the import process. When the payment data is cleansed in this way, an error appears in the report to notify you even though the file has imported correctly. When importing payments using CSV, if you want to include a comma (,) in a Beneficiary name or any of the reference fields, the name or reference needs to be included in double quotes eg “Brown, Smith & Jones”.


    1. Hover over the Manage payments link then select Import Payment to display the Import screen.
    2. In the Format section select the payment type and format of the file that you want to import from the list.

      You can use Multiple format if the CSV you are importing contains different payment types. The Multiple format option cannot support Bacs bulk payments.

      Import Map List

    3. Select the Import method you want to use:

      Import Map Screen 2

      • Payment import – after the file has been imported each payment will be displayed as an individual record in the Payments management screen.
      • File import - if the import file has multiple payments in it they will be combined in to one record in the Payment management screen. If this method is selected all payments in the import file will need to have the same Transaction date. File import can be used for International payments if the payment is for the same currency e.g. USD to USD or they include FX exchange & Contract ID
    4. If your User is set up to allow you to access Confidential imports you will be asked if you want to make this report Confidential:
      • Yes - the file will be imported confidentially so only users who have access to confidential payments will be able to view the payment details in the Payment management screen.
      • No - all users with the appropriate role entitlement will be able to see the payments that have been imported.
    5. In the File Import Section click on the Browse button to select the file you want to import.

      The file you are importing should have a unique reference which has not been used for a previous upload.
    6. Select Import to start importing your payments.
    7. A pop-up will confirm the File Name, File Size and Job ID, click the X in the top right-hand corner to close. The file import will continue to run in the background
    8. To view the status of your imported file, access the Import History report, found within the Manage Payments screen. This report will list imported payments files and will provide the status for the imported files.   To view the import file select View from the Actions dropdown. The report will provide the status of the imported file and will provide details of any errors encountered when uploading the file If a file has not imported successfully.
    9. Once your file has successfully imported into Commercial Banking Online you will see one or multiple new records in the Payment management screen.


    Confidential Imports

    Commercial Banking Online lets you import certain payments confidentially, so that only some users can see the payment. This is particularly useful when paying salaries, for example.

    Users must be enabled to make and view confidential payments. This can be done by selecting the confidential payments checkbox when creating a User or when editing an existing User.

    All users who are enabled to make and view confidential payments can view all confidential payments made by themselves and other users.

    When importing a payment file, users who have confidential payments enabled can select whether they want that file to be treated as confidential or not.

    Confidential payment files can only be approved by users who have confidential payments enabled.

    Once the payment has been made, the details will be visible to users with the right permissions on the Bank Account Summary, Balance and Transaction reporting and payment advices.

    Import Template

     The templates below detail the information required to import payments into Commercial Banking Online:


    Payment type  CSV Template  XML  XML Sample
    Faster Payments Download Guide Download  
    CHAPS Download Guide Download
    Inter Account Transfer Download Guide Download
    Bacs Download Guide Download
    International payments Download Guide Download
    Euro Urgent Download Guide Download
    Euro Non-urgent Download    
    *Multiple Payments Download    

    *This CSV Import file allows you to combine all payment types in to one file, rather than importing a separate file for each individual payment type. If the file contains cross currency payments that need a rate then it must be imported as a payment import rather than a file import.

    This file also lets you import Bacs single payments, this can be done by duplicating the Bacs row within the file for each individual payment. The Bacs singles can debit the same account or multiple different accounts.

How helpful is the information on this page?

Calls may be monitored or recorded in case we need to check we have carried out your instructions correctly and to help improve our quality of service.

Lloyds Bank plc Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone: 020 7626 1500.

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority under registration number 119278.

We subscribe to the Lending Code; copies of the Code can be obtained from www.lendingstandardsboard.org.uk.

Eligible deposits with us are protected by the Financial Services Compensation Scheme (FSCS). We are covered by the Financial Ombudsman Service (FOS). Please note that due to FSCS and FOS eligibility criteria not all business customers will be covered.