File Conversion Software

Create bank EFT files from a variety of accounting and payroll packages

FileMaker

Bank's Electronic Funds Transfer (EFT) file formats can be onerous to create if your accounting or payroll application does not support the specific format you require. Even finding the specification for the file format can at times be difficult.

FileMaker supports a wide variety of file formats. It can convert from an accounting or payroll file format into the format required by your bank's EFT application. We have already developed templates for dozens of bank file formats including Bacs, Winbits, HSBC, Royal Bank of Scotland (Royline), Barclays business Master to name but a few. Without a means of converting file formats, you are often left with no choice other than to manually enter the data into the bank's EFT application. This can be both time consuming and tedious but it is also prone to error.

Once the appropriate filters are set up in FileMaker, it becomes a one button operation to make your file when you need it, completely avoiding the time consuming task of manually entering data into the Bank's payment software. Many accounting software packages do not provide a comprehensive set of file formats for transferring data from the accounts package into your bank's payment software. Often the only option you have is to manually rekey the payments. FileMaker performs conversions from one file format to another.

Bank/Organisation EFT Format Description
Bacs Bacs Standard 18 Although you must use Bacs Approved Software to send payments and direct debits directly to Bacs, the Standard 18 format has been widely adopted by many organisations as a standard for Electronic Funds Transfer. It has fixed format data records with a number of header records and trailer records.
Bank of Ireland WINBITS
Bank of Ireland Business Online
Bank of Scotland BOBS SEF
Bank of Scotland CHOBS
Bank of Scotland Normal Domestic Payments
Barclays Bank Business Master CSV File Format.
Clydesdale Bank Telebank CSV File Format.
Clydesdale Bank Business Online
Danske Bank Faster Payments
Danske Bank Local UK Payments
HSBC Hexagon BACS HSBC Hexagon Local Bacs Payments.
HSBC HSBCnet HSBCnet file format.
Lloyds Lloyds Link
National Irish Bank
Natwest Bankline
Northern Bank of Ireland Telebank CSV file format.
Royal Bank of Scotland RBS Bankline
Yorkshire Bank Telebank CSV file format.

FileMaker summary

  • Makes it easy to convert an accounting or payroll file format to your bank or EFT file format
  • Creates files in the correct format for most Banks Payment Software
  • Template available for many accounting and payroll software applications
  • Easy to use interface to generate bank files from non-standard accounting packages
  • User licences include helpdesk support
  • Able to integrate with BankCheck to modulus check bank details on input

We keep our customers happy with our range of affordable, easy to use solutions. We can help you too. Why not call us on 01355 272641 for a free demo?

Mosaic Software logo
Support is available 9am-5pm, Monday to Friday excluding bank holidays. We also have out of hours support available in case of emergency.
Contact Us
Support
Glossary