What Payment (BACs) Formats are Available?
- Mark Holland (Unlicensed)
- Hitesh Sud
- Former user (Deleted)
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 | 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 -
| HSBC_XML_FPS.txt | HSBC_XML_FPS.pdf |
| CLYDESDALE_BACS | CLYDESDALE_BACS.txt | |
| LLOYDS_CSV | LLOYDS_CSV.txt | |
| METRO_BANK | METRO_BANK_TSV.txt | 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 -
| HSBC_XML_ACH_BACS.xml | Not international but is used for overseas in-country payments. |
| LLOYDS_MULTICURRENCY | LLOYDS_MULTICURRENCY.txt | 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 -
| 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 -
| 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 -
| HSBC_XML_SEPA.txt | Euro to Euro Payments |
| HSBC_XML_SEPA_FORMAT_ILA | HSBC_XML_SEPA_FORMAT_ILA.xml | |
| CPA_005 | CPA_005.txt | |
| US_ACH_XML_V3 | US_ACH_XML_V3 | |
HSBC_XML_ACH Note -
| Not international but is used for overseas in-country payments. | |
| HSBC ACH XML | HSBC_ACH_XML.txt | MENA-MEABASIC MIG.pdf |
| LLOYDS_MULTICURRENCY | LLOYDS_MULTICURRENCY.txt | 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 -
| 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 | ||
| HSBC Poland | PL_ACH_XML_V3.txt | |
| HSBC Canada | CA_ACH_XML_V3.txt |