Export Employee Expense Payments to a SEPA .Xml File

You can create a SEPA .xml file that contains employee expense payment information to be processed by a third-party software application. The SEPA (Single Euro Payments Area) .xml file format is commonly used in the Netherlands.

Prerequisites:
  • The bank from which you are making the payment must have the following setting on the Banks settings form in Settings > Cash Management > Banks:
    • On the Options tab, the Export to Text Format option must be set to SEPA.
    • On the SEPA File Format tab, there must be entries in the IBAN field (for the international bank account number) and in the BIC field (for the bank identification code).
  • The employees being paid must have entries in the IBAN and BIC fields in the SEPA section of the Accounting tab in the Employees hub.

To export employee expense check data to a SEPA .xml file:

  1. In the Navigation pane, select Cash Management > Employee Payments.
  2. Use the search fields at the top of the Employee Payments form to select an existing payment run that has been posted.
    The payment run includes the word Printed in its description in the search list.
  3. On the Printing and Numbering page of the form, on the toolbar of the Payments grid, click Export to Text.
    If any of the payees in the payment processing run or the bank from which the payments are made do not have an IBAN or BIC specified, you receive warning messages that ask whether you want to proceed with the Export to Text process.
    • If you click No, the process stops. You can populate the payees' or bank's IBAN and BIC fields, and then return to Employee Payments.
    • If you click Yes, the Export to Text process continues, but the .xml file will not contain the IBANs or BICs for the payees and/or bank.
  4. On the Download Payments to Text File dialog box, click Create File.