What Payment (Bacs) Formats are Available?

What Formats are Available?

RSM InTime comes with a number of selectable payment file formats. These are listed below. The specification and an example of each are in attached documents.

Please click on the paper clip icon at the top of the screen for the full list of file specifications. 

You can select which Bacs formats you require via the System Administration "COG" on the menu bar and then selecting "Payment Methods" under the Invoicing & Payments section.

It is the clients responsibility to fully test all payment file formats prior to using in a LIVE environment -  typically by generating then making a test payment to a payee bank account.

If you have a format which we don’t currently list, we can build this for you and work is charged on a time cost basis. Please contact the RSM ESL support team for more information.

Base Currency Bacs FormatExample fileFile Specification and section
HSBCHSBC.txtBACS Standard 18 MIG Aug 2012.pdf
HSBC_V2 (same as HSBC but uses payment date in header2 instead of expiry date)HSBC.txtBACS Standard 18 MIG Aug 2012.pdf
LLOYDSLLOYDS.txtLloyds_10_File Formats.pdf

Page 37 Bacs Single

LLOYDS_V2 (same as LLOYDS but amount is formatted as decimal)LLOYDS_V2.txtLloyds_10_File Formats.pdf

Page 37 Bacs Single

LLOYDS_MULTI_STDLLOYDS_MULTI_STD.txtLloyds_10_File Formats.pdf

Page 43 Bacs Multiple Standard CSV

LLOYDS_FPSLLOYDS_FPS.txt
NATWEST_STANDARD_DOMESTICNATWEST_STANDARD_DOMESTIC.txt

NW Bankline import file layout guide - Bankline CSV format-1.pdf

Page 37 Standard domestic payment

BAKERTILLY_BUREAUBAKERTILLY_BUREAU.txtBACS Standard 18 MIG Aug 2012.pdf
BARCLAYS_BACSBARCLAYS_BACS.txtBACS Files for Barclays.pdf
RBS_DOMESTIC_BULK_PAYMENTRBS_DOMESTIC_BULK_PAYMENT.txt

RBS Bankline import file layout guide - Bankline CSV format.pdf

Page 51 Standard domestic bulk payment

NATWEST_ADHOC_BULK_PAYMENTNATWEST_ADHOC_BULK_PAYMENT.txt

NW Bankline import file layout guide - Bankline CSV format-1.pdf

Page 61 Ad hoc bulk payment

PAYAWAY_IP_DIRECTPAYAWAY_IP_DIRECT.txt
ALBACSALBACS.txtALBACS Standard File Formats.pdf (Standard 18 without headers/footers)
HANDELSBANKEN_BACSHANDELSBANKEN_BACS.txtHandlesBankencoin-user-guide.pdf -

Appendix 01 Bacs Instruction - File Specification

PAYAWAYPAYAWAY.txtPAYAWAY.txt
RBS_BSI_VBDRBS_BSI_VBD.txt

RBS_int_Fileupload_3.8i.pdf

Page 38 BSI VDB format

LLOYDS_SAGE_MULTI_CSVLLOYDS_SAGE_MULTI_CSV.csvLloyds_10_File Formats.pdf “Sage Bacs Multiple CSV” (Page 42).
SANTANDER CONNECTSANTANDER_CONNECT_2.txtSantander Connect bacs payment import specification.pdf
Standard_BACS_2STANDARD_BACS_2.txt

HSBC_XML_FPS

Note -

  •  FPS Payments must be in the same currency
  •  Payments must be made within the same country.
  • The agency account and payment recipient must have a Sort Code or Swift Code as well as an Account Number
HSBC_XML_FPS.txtHSBC_XML_FPS.pdf
CLYDESDALE_BACSCLYDESDALE_BACS.txt
LLOYDS_CSVLLOYDS_CSV.txt
METRO_BANKMETRO_BANK_TSV.txt

Metro_Bank_TSV.xslm

Macro enabled spreadsheet

AIBAIB.txtAIB_BACS_FORMAT_SPEC.docx
INPAYINPAY.csvN/A
INPAY_RESTPayment automatically transferred to InPayN/A
PTXPTX.txt

HSBC_XML_ACH

Note -

  • ACH Payments must be in the same currency
  • Payments must be made within the same country.
  • The agency account and payment recipient must have a Sort Code and Account Number
HSBC_XML_ACH_BACS.xml

Not international but is used for overseas in-country payments.

HSBC_XML_ACH.pdf

LLOYDS_MULTICURRENCYLLOYDS_MULTICURRENCY.txt

Lloyds_10_File Formats.pdf

Page 40 International example

LLOYDS_INTERNATIONALLLOYDS_INTERNATIONAL.txt
LLOYDSCOMMERCIALLLOYDSCOMMERCIAL.txt
NATWEST_INTERNATIONALNATWEST_INTERNATIONAL.txt

NW Bankline import file layout guide - Bankline CSV format-1.pdf

Page 43 International payment

NATWEST_INTERNATIONAL_AGENCY_IBANNATWEST_INTERNATIONAL_AGENCY_IBANThis will use the Agency IBAN rather than the bank account number. 
BARCLAYS_MT103BARCLAYS_MT103.txtBIB MT103 File Format Guide.pdf

HSBC_XML_PRIORITY

Note -

  • Payment recipient must have a valid Sort Code or Swift Code as well as a valid Account Number or IBAN.
  • The agency account must have a Sort Code and Account Number
  • The payment recipient must have street 1, town, postcode and country
  • The agency must have street 1, town, postcode and country
HSBC_XML_PRIORITY.txtHSBC_XML_PRIORITY.pdf
WISE_PAYMENT_FORMATWISE_PAYMENT_FORMAT.txt.
HANDELSBANKEN_INTLHANDELSBANKEN_INTL.txt
CSVUsed if we don't have your Bacs format so you can do payment manually.

LLOYDS_FASTER_PAYMENTS_FORMAT

Note -

  • Payment recipient must have a valid Sort Code or Swift Code as well as a valid Account Number or IBAN.
  • The agency account must have a valid Sort Code and valid Account Number
LLOYDS_FASTER_PAYMENTS_FORMAT.txtFaster_payment_file_template_v2.4
International Bacs FormatExample fileFile Specification and section

HSBC_XML_SEPA_FORMAT

Note -

  • SEPA Payments must be EUR to EUR transactions
  • The payment recipient must have a SWIFT code and an IBAN number

HSBC_XML_SEPA_FORMAT_V3 uses the same specification but has some field variations.

HSBC_XML_SEPA.txt

Euro to Euro Payments

HSBC_XML_SEPA.pdf

HSBC_XML_SEPA_FORMAT_ILA

HSBC_XML_SEPA_FORMAT_ILA_V3 uses the same specification but has some field variations.

HSBC_XML_SEPA_FORMAT_ILA.xmlHSBC_XML_SEPA.pdf
CPA_005CPA_005.txt
US_ACH_XML_V3 US_ACH_XML_V3 

HSBC_XML_ACH

Note -

  • ACH Payments must be in the same currency
  • Payments must be made within the same country.
  • The agency account and payment recipient must have a Sort Code and Account Number

HSBC_XML_ACH_BACS.xml

Not international but is used for overseas in-country payments.

HSBC_XML_ACH.pdf

HSBC ACH XMLHSBC_ACH_XML.txtMENA-MEABASIC MIG.pdf
LLOYDS_MULTICURRENCYLLOYDS_MULTICURRENCY.txt

Lloyds_10_File Formats.pdf

Page 40 International example

LLOYDS_INTERNATIONALLLOYDS_INTERNATIONAL.txt
NATWEST_INTERNATIONALNATWEST_INTERNATIONAL.txt

NW Bankline import file layout guide - Bankline CSV format-1.pdf

Page 43 International payment

NATWEST_INTERNATIONAL_AGENCY_IBANNATWEST_INTERNATIONAL_AGENCY_IBANThis will use the Agency IBAN rather than the bank account number. 
BARCLAYS_MT103BARCLAYS_MT103.txtBIB MT103 File Format Guide.pdf

HSBC_XML_PRIORITY

Note -

  • Payment recipient must have a valid Sort Code or Swift Code as well as a valid Account Number or IBAN.
  • The agency account must have a Sort Code and Account Number
  • The payment recipient must have street 1, town, postcode and country
  • The agency must have street 1, town, postcode and country
HSBC_XML_PRIORITY.txtHSBC_XML_PRIORITY.pdf
HANDELSBANKEN_INTLHANDELSBANKEN_INTL.txt
CSVUsed if we don't have your Bacs format so you can do payment manually.

BOI_XML_SEPA_CREDIT_TRANSFER

(This format is for EUR to EUR transactions only).

BOI Credit Transfer PAIN.001 example.xml

BOI Credit Transfer PAIN.001 File Spec V1.3.pdf

This format is for EUR to EUR transactions only.

Fields that are configurable via the Payment Methods settings:

GrpHdr -InitgPty - Id: <SUN> 

You can configure multiple SUNs if required.

PmtInf - CdtTrfTxInf - RmtInf: <Payment Reference>

If the payment referenc includes the text [INV_NUM] it will include the associated invoice numbers in the Payment reference. This will be truncated if longer than the maximum 140 characters.

RBS_INTERNATIONAL


HSBC PolandPL_ACH_XML_V3.txt
HSBC CanadaCA_ACH_XML_V3.txt
FP-BBANFP-BBAN.txt
FP-IBANFP-IBAN.txt