Powerful PAINConverter
With SEPA-Transfer you can easily convert your SEPA XML files (according to ISO20022) between the different PAIN subformats. This way you are flexible if your bank works with a different PAIN subformat than you. Our powerful PAINConverter is the solution.
How our PAINConverter works
SEPA-Transfer quickly converts your SEPA XML files into another PAIN format and thus functions as a PAIN converter.
Import from different file formats
Import your files in the pain formats pain.001.001.02, pain.001.002.03 or pain.001.003.03 (credit transfers) as well as pain.008.002.02 and pain.008.003.02 (direct debits).
You can also easily import your payment data from Excel or CSV file.
Export with new pain format
Then use SEPA Transfer to export XML files in the desired pain formats pain.001.001.03 or pain.008.001.02.
Alternatively, you can also forward SEPA payments directly to the bank in a FinTS-compliant bundle.
Try it out for yourself: Test SEPA Transfer 30 days free of charge (without registration!).
What is the SEPA PAIN fromat?
For the communication between customer and bank, the message type PAIN format is relevant, which is part of the comprehensive ISO 20022 standard. Here there are the formats pain.001 for credit transfers and pain.008 for direct debits.
The name of the format is supplemented by a version number. Since 2016, the versions pain.001.001.03 for credit transfers and pain.008.001.02 for direct debits are valid.
The SEPA XML format explained
SEPA XML is a uniform file format that is mandatory for credit transfers and direct debits in the European payments area (SEPA). In doing so, the SEPA XML format helps to standardize and simplify payment transactions throughout Europe by structuring information and data according to a defined standard.
The same format is also used for EBICS, a multibank-capable standard for the transmission of payment transaction data via the Internet.
How to create SEPA XML files
Banks require payment data in SEPA XML format in order to process them. The format is intended for exchange between computer systems and cannot be meaningfully created without software support.
With SEPA-Transfer, we offer an easy way to convert payment data from various sources into SEPA XML. To do this, create your bookings for a SEPA Credit Transfer or SEPA Direct Debit and then select the operation "Create SEPA XML file" in the "Import/Export" ribbon.
Next, a window will open where you can once again get a complete overview of your bookings and specify the file path for your XML export.
With one click you can then use SEPA-Transfer to create your payment data in SEPA XML format.
How to convert Excel to SEPA XML?
Do you already keep your payment-related data in an Excel file like .xlsx or in a CSV file? You can easily convert the data from Excel to SEPA XML with SEPA-Transfer.
Show transcription
[On Screen: Intro: the SEPA-Transfer logo with the tagline “Transfer payment data: Excel to SEPA XML converter”.]
With SEPA-Transfer, you can easily convert payment data available in an Excel file into the SEPA XML format.
[On Screen: An Excel sheet named “Payment Data” with the columns Recipient, First name, Amount, IBAN, and Purpose.]
To do this, first prepare your payment data by naming the columns appropriately to make the import into SEPA-Transfer easier.
[On Screen: SEPA-Transfer Enterprise Edition with the Import/Export ribbon; the SEPA-Transfer Import Wizard opens with steps for file type, file path, transaction type, number of transactions, columns, error handling and start import.]
Next, open SEPA-Transfer. Select Import/Export. Click on Import File and select the desired Excel file. Select the booking type and the SEPA-Transfer account to be used. In the preview, you already get a first look at the payment data you are about to import into the program.
[On Screen: In the “Select columns” step, the Excel columns are mapped to SEPA fields such as Recipient, IBAN, BIC, Purpose, Amount, End-to-end ID, Execution date and SEPA Purpose Code, with a live data preview.]
Once you have named the columns appropriately, SEPA-Transfer takes care of the column assignment. Additional fields or errors can be easily adjusted via drop-down. Finally, click on “Execute Import” and all your payment data is stored in SEPA-Transfer.
[On Screen: The message “Import completed successfully” offers the options Send transactions, Export to SEPA XML file, and Edit transactions; the current bookings are shown in a list with an edit form (recipient, IBAN, BIC, amount, purpose, execution date).]
Check the individual entries in the current bookings for correctness. Then you can start exporting the payment data into the SEPA XML format.
[On Screen: The “Export to SEPA XML” dialog lists the transactions and offers options such as transaction type (bank transfer or direct debit), the output path and consolidation settings; a folder picker selects the output directory.]
Select Import/Export again and here “Create SEPA XML file”. Here you can select the open bookings you want to convert to SEPA, either all together or individually. Select the desired output directory and click OK. The conversion is already completed. You can now continue working with your payment data in SEPA XML format.
[On Screen: A “File export” dialog confirms that the transactions were exported successfully and offers to open the file, open the folder, or return to SEPA-Transfer; a wizard step handles invalid transactions.]
One more tip: right after the import, you can also export your payment data to the SEPA XML format with just one click. That way you save even more time with SEPA-Transfer.
[On Screen: Closing screen: “SEPA-Transfer — SEPA Payments With Just One Click”, with a “30 Days Free Trial” button.]
Click on the operation "Import Excel file" under "Import/Export", select the Excel file and let the import wizard guide you through the data import. After the successful import, you can then perform an export as SEPA XML directly via the wizard. Alternatively, you can also follow the path described above to export as XML.
The Excel import also helps to create collective payments. In addition to the import of Excel files, you can also import payment data directly from your database with the Enterprise Edition.
Try SEPA-Transfer yourself
Try SEPA Transfer for yourself with our free 30-day trial.
SEPA-Transfer Small Business Edition
