Export to Text Feature for Bank Codes

Use the Export to Text feature in the Accounts Payable and Employee Expenses applications to create a .txt or .xml file that contains payment information to be processed by a third-party software application.

You can use this feature if:

  • Another company generates your vendor or employee expense payments with the accounts payable, employee expense, and check information that you provide in a .txt or .xml file.

  • You want to import payment information into banking software. This process supports the electronic funds transfer requirements of many international banks.

The files that you create with the Export to Text feature are used for DPS accounts payable and employee expense payments. They are not used for DPS payroll and employee expense direct deposit or accounts payable EFT processing. These payment types use the NACHA file format, which you set up on the NACHA File Format tab in Banks Settings.

Set up the Export to Text feature in Settings > Accounting > Banks. In the Export to Text Format field on the Bank Codes tab, select the format type to use for the files that are generated during the export-to-text process for a bank. If you select a user-defined or SEPA format type, you must enter additional information on the User Defined File Format tab or the SEPA tab of the Bank Codes form.

The SEPA (Single Euro Payments Area) format is commonly used in European countries. This format produces an XML file that contains the SEPA service level code. You can also use the SEPA format for other service level codes, such as SDVA, URGP, or NURG. To use the SEPA format for other service level codes, after the XML file is generated in the export-to-text process, edit the XML document and replace the SEPA service code level with another code.

If you use multiple companies, you must set up Export to Text file information for bank codes for each company in your enterprise.