I want to create a Fixed Import Map

    1. Hover over the Manage payments link then select Import Map to display the Import map screen.

      On the Import map page you will be able to see and manage your existing import maps.

    2. Select Add from the bottom of the screen.
    3. Select Fixed from the Map type drop-down. Find further information about map types on our page what are Fixed and Delimitated files.

      Step 1
    4. Select your Payment type from the dropdown.

      Fixed Step 2
    5. Import as this option will be available if you are creating an Import map for International Payments or Inter Account Transfer. Select Payment from the dropdown menu to continue.
    6. Fixed file properties, the mapper will request certain fields to be completed when preparing the file to be imported. Depending on the type of payment you will be importing, the following fields will need to be completed.

      Fixed Step 3
      • Map name: choose a memorable name for the import map up to 35 characters long.
      • Description: enter a short description for the import map.
      • Start Import at Row: choose the row in the file that you want to be the first row of your import. You should keep the import row at ‘1’ unless you want to skip the first transactions on the file. For example, if you have five rows of payments on the file, and you set this field as ‘2’, the first row will be skipped and the remaining four will be imported.
      • Maximum record length: enter the maximum character length each field will have in your imported file.
    7. Data Format details

      Fixed Step 4  

      The mapper will also request details regarding the format of the imported file. The fields that appear will depend on the type of payment you are importing.
      • Date format: select the format relevant to the file you want to import, M for month digits, D for date digits and Y for year digits. Example: 20-12-2015 (DD-MM-YYYY). This is only required for certain payment types.
      • Date separator: select the relevant date separator for the file you are importing. Available options are dash (-), full stop(.) and forward slash (/).This is only required for certain payment types.
      • Number of decimal places: select the amount of decimal places required for the selected currency. For the majority of currencies this will be 2.
      • Decimal separator: Decimal separator: enter the character of the decimal separator -Note you must enter either Number of decimal places or the decimal separator, you no not need both
      •  Header, Body and Trailer indicators: these fields are for reference only, and do not need to be complete.
      • Non-urgent: This option will only appear for Euro payments. Choose how you want to identify non-urgent payments in the Urgent/Non-urgent field of your file. The default setting is EURSEPA. Non-Urgent payments will be sent through SEPA (Single euro payment area) Credit Transfer and the earliest available value date will be the next business day.
      • Urgent: This option will only appear for Euro payments. Choose how you want to identify urgent payments in the Urgent/Non-urgent field of your file. The default setting is EURURG. Urgent payments for Euro payments can have a same day value date.
    8. At the bottom of the screen you’ll see a table similar to the one below. The available fields will be determined by the payment type that you have selected and you will be able to select/unselect these fields ticking the active box at the left of each field. Fields marked with an * are mandatory and will need to be ticked to become active.

      Fixed Step 5  

      You will always need to select the mandatory fields for the payment type or your import will fail.
      • Active – A tick mark in this field indicates that a field in the file should be imported, matched with existing data or set with a default value in Commercial Banking Online.
      • Field name – the name of the field in Commercial Banking Online. The values in this column will depend on the payment type you are importing.
      • Start position –indicates the starting point of the field (in characters, measured from the start of the file)
      • End position – indicates the ending point of the field (in characters, measured from the start of the file)
      • Match – this option will be greyed out as it will not be relevant at this stage.
      • Default value – this is the value that will automatically appear if a value is not supplied in the file.
      • Supported Special characters – Details can be found here
      For more information on the fields and their purpose, please refer to the ‘I want to create a payment’ page and choose the relevant payment type.
    9. Click Save at the bottom of the Screen. You will get a confirmation screen showing that your Import map has been successfully created.

      Delimited Step 6
    10. Click Close to return to the Import map screen.

How helpful is the information on this page?

Important legal information

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: 0207 626 1500.

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority under Registration Number 119278.

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.

Lloyds Banking Group includes companies using brands including Lloyds Bank, Halifax and Bank of Scotland and their associated companies. More information on Lloyds Banking Group can be found at www.lloydsbankinggroup.com