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 Format	Example file	File Specification and section
HSBC	HSBC.txt	BACS Standard 18 MIG Aug 2012.pdf
HSBC_V2 (same as HSBC but uses payment date in header2 instead of expiry date)	HSBC.txt	BACS Standard 18 MIG Aug 2012.pdf
LLOYDS	LLOYDS.txt	Lloyds_10_File Formats.pdf Page 37 Bacs Single
LLOYDS_V2 (same as LLOYDS but amount is formatted as decimal)	LLOYDS_V2.txt	Lloyds_10_File Formats.pdf Page 37 Bacs Single
LLOYDS_MULTI_STD	LLOYDS_MULTI_STD.txt	Lloyds_10_File Formats.pdf Page 43 Bacs Multiple Standard CSV
LLOYDS_FPS	LLOYDS_FPS.txt
NATWEST_STANDARD_DOMESTIC	NATWEST_STANDARD_DOMESTIC.txt	NW Bankline import file layout guide - Bankline CSV format-1.pdf Page 37 Standard domestic payment
BAKERTILLY_BUREAU	BAKERTILLY_BUREAU.txt	BACS Standard 18 MIG Aug 2012.pdf
BARCLAYS_BACS	BARCLAYS_BACS.txt	BACS Files for Barclays.pdf
RBS_DOMESTIC_BULK_PAYMENT	RBS_DOMESTIC_BULK_PAYMENT.txt	RBS Bankline import file layout guide - Bankline CSV format.pdf Page 51 Standard domestic bulk payment
NATWEST_ADHOC_BULK_PAYMENT	NATWEST_ADHOC_BULK_PAYMENT.txt	NW Bankline import file layout guide - Bankline CSV format-1.pdf Page 61 Ad hoc bulk payment
PAYAWAY_IP_DIRECT	PAYAWAY_IP_DIRECT.txt
ALBACS	ALBACS.txt	ALBACS Standard File Formats.pdf (Standard 18 without headers/footers)
HANDELSBANKEN_BACS	HANDELSBANKEN_BACS.txt	HandlesBankencoin-user-guide.pdf - Appendix 01 Bacs Instruction - File Specification
PAYAWAY	PAYAWAY.txt	PAYAWAY.txt
RBS_BSI_VBD	RBS_BSI_VBD.txt	RBS_int_Fileupload_3.8i.pdf Page 38 BSI VDB format
LLOYDS_SAGE_MULTI_CSV	LLOYDS_SAGE_MULTI_CSV.csv	Lloyds_10_File Formats.pdf “Sage Bacs Multiple CSV” (Page 42).
SANTANDER CONNECT	SANTANDER_CONNECT_2.txt	Santander Connect bacs payment import specification.pdf
Standard_BACS_2	STANDARD_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.txt	HSBC_XML_FPS.pdf
CLYDESDALE_BACS	CLYDESDALE_BACS.txt
LLOYDS_CSV	LLOYDS_CSV.txt
METRO_BANK	METRO_BANK_TSV.txt	Metro_Bank_TSV.xslm Macro enabled spreadsheet
AIB	AIB.txt	AIB_BACS_FORMAT_SPEC.docx
INPAY	INPAY.csv	N/A
INPAY_REST	Payment automatically transferred to InPay	N/A
PTX	PTX.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_MULTICURRENCY	LLOYDS_MULTICURRENCY.txt	Lloyds_10_File Formats.pdf Page 40 International example
LLOYDS_INTERNATIONAL	LLOYDS_INTERNATIONAL.txt
LLOYDSCOMMERCIAL	LLOYDSCOMMERCIAL.txt
NATWEST_INTERNATIONAL	NATWEST_INTERNATIONAL.txt	NW Bankline import file layout guide - Bankline CSV format-1.pdf Page 43 International payment
NATWEST_INTERNATIONAL_AGENCY_IBAN	NATWEST_INTERNATIONAL_AGENCY_IBAN	This will use the Agency IBAN rather than the bank account number.
BARCLAYS_MT103	BARCLAYS_MT103.txt	BIB 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.txt	HSBC_XML_PRIORITY.pdf
WISE_PAYMENT_FORMAT	WISE_PAYMENT_FORMAT.txt .
HANDELSBANKEN_INTL	HANDELSBANKEN_INTL.txt
CSV	Used 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.txt	Faster_payment_file_template_v2.4
International Bacs Format	Example file	File 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.xml	HSBC_XML_SEPA.pdf
CPA_005	CPA_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 XML	HSBC_ACH_XML.txt	MENA-MEABASIC MIG.pdf
LLOYDS_MULTICURRENCY	LLOYDS_MULTICURRENCY.txt	Lloyds_10_File Formats.pdf Page 40 International example
LLOYDS_INTERNATIONAL	LLOYDS_INTERNATIONAL.txt
NATWEST_INTERNATIONAL	NATWEST_INTERNATIONAL.txt	NW Bankline import file layout guide - Bankline CSV format-1.pdf Page 43 International payment
NATWEST_INTERNATIONAL_AGENCY_IBAN	NATWEST_INTERNATIONAL_AGENCY_IBAN	This will use the Agency IBAN rather than the bank account number.
BARCLAYS_MT103	BARCLAYS_MT103.txt	BIB 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.txt	HSBC_XML_PRIORITY.pdf
HANDELSBANKEN_INTL	HANDELSBANKEN_INTL.txt
CSV	Used 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	RBS_INTERNATIONAL SAMPLE FILE.txt
HSBC Poland	PL_ACH_XML_V3.txt
HSBC Canada	CA_ACH_XML_V3.txt
FP-BBAN	FP-BBAN.txt
FP-IBAN	FP-IBAN.txt

Browser not supported