Manual

Overview

Installation

Download SEPAApp simply by clicking here to download and save the file anywhere. Then extract the contents (it is a ZIP archive with the SEPAApp as well as the templates in CSV, ODF and Microsoft Excel ® format (.csv / .ods / .xls / .xlsx) into any directory on your computer. Start SEPAApp by double clicking on the file sepaapp.exe (Windows) or sepaapp.app (Mac) sepaapp.jar (Linux, Unix).

Direct debits

When starting SEPAApp the first tab is the one with the heading “Direct Debit” and it is already selected (Fig. 1 ).
SEPAApp_Direct_Debits_1-7-1
Fig. 1

Enter your own bank data

Now enter your own banking information in the fields:

  • Account holder: The first and last name or the business name of the account holder
  • IBAN: your IBAN (with or without spaces)
  • BIC: your BIC (with or without spaces)
  • creditors ID: Your creditors ID (you get your creditors ID from your bank.)
  • Debit Date: The date on which the debit is to be executed. This date must be in the future.
  • Debit Type: Here you have a choice between
    • SINGLE: A one-time debit, for example, a one-time purchase or a fee for a course.
    • FIRST: The first debiting in a series of withdrawals, eg the first membership fee, which is levied annually.
    • SEQUENCE: Another debiting in a series of withdrawals, eg the second or third membership fee, which is levied annually.

If you want to import the BIC of your direct debits, set the according checkbox to true.

To use express direct debits (COR1/D1-agreement) or business direct debits (B2B) set the according option field on the SEPAApp GUI. By default standard direct debits (CORE) are selected. This setting affects every direct debit in the generated SEPA XML file.

  • Choose pain-Format: Choose the (sub-)format according to your country and the requirements of your bank.
  • Show optional settings (see the follwing list of optional settings and Fig. 2)
  • optional Here you can choose a value for the field “Category Purpose”. Only choose a value, if you need that field (your bank may tell you).
  • optional Identification ID: This field is only relevant for example in Spain und may be filled with the Fiscal No. Leave it empty in all other cases!
  • optional Choice type of identification ID: Choose organisation (e.g. spanish Fiscal No. or irish OIN) or person (z.B. irish OIN). This choice is only relevant, if the field identification ID is used.
  • optional Checkbox timestamp without timezone: Choose this only if your bank need the timestamp within the SEPA XML file without timezone. This choice is only relevant for the (sub-)format pain.008.001.02.
  • optional Checkbox Generate Customer’s referenz automatically (EndToEndId): De-Select this checkbox, if you do not need a generated Id. This checkbox is selected by default, because many banks need this Id.
  • optional Checkbos: Read Customer’s referenz from import file (EndToEndId): Select this checkbox, if you want to import the id from file for each single (!) data row. This feature is only available for SEPAApp Pro!
  • optional Customer’s referenz (EndToEndId): Enter your manual id for all (!) data rows here. To enable this field both checkboxes above must be de-selected.
  • optional Checkbox Batch-Booking: De-Select this checkbox, if you need single-booking. This checkbox is selected by default.
  • optional Checkbox transaction no.: Select this checkbox, if you need a transaction no. (InstrId) for each transaction.

SEPAApp_1-7-1-Direct_Debits_options

Fig. 2

CSV file creation (with LibreOffice/OpenOffice)

If you want to use a CSV file to import your direct debits in SEPAApp, you can see here how the CSV file must be constructed. This is shown with LibreOffice / OpenOffice. You can also create the CSV file with any other program. If you want to work with the Excel format, then you can skip this part and read the next chapter. The CSV file must be in the following Fig. 1 shown columns. The number of lines is not limited – you can import any number of direct debits (rows) in SEPAApp. The columns contain:

  • Account holder: The first and last name or the business name of the account holder to be debited from his account.
  • IBAN: IBAN (with or without spaces), the account of which is to be debited.
  • OPTIONAL: BIC: BIC (with or without spaces), the account of which is to be debited. The according checkbox on the SEPAApp GUI must be set to true, if you want to use the BIC.
  • mandate reference number: The mandate reference no. is a unique number that identifies the direct debit. Note: The uniqueness will not be checked by SEPAApp!
  • Signature Date: The date on which the direct debit (Permission) has been issued. This date must be in the past.
  • Usage: The text that will appear when booking (on the bank statement).
  • Amount: The amount to be transferred.

direct_debit_CSV
Fig. 1

Save the file as a CSV file as shown in Fig 2 shown:

Screenshot of 2014-02-25 10:29:04 _edited
Fig. 2

Select in the dialog (Fig. 3), the semicolon (;) as the delimiter and uncheck the option “cell content as shown”.

Caution when selecting the character set:

  • In Windows, select the character set “Western Europe”
  • In Linux, select the character set “UTF-8”
  • In Mac OS, select the character set “UTF-8”

Otherwise, it may cause problems in the processing of special digits.

Screenshot of 2014-02-25 10:30:52 _edited
Fig. 3

You can download template files here: SEPAApp-template-directDebit (CSV) SEPAApp-template-directDebit_withoutBIC (CSV)

Excel file creation (with Microsoft Excel) / ODF file creation with LibreOffice / OpenOffice

If you want to use a CSV file to import your direct debits in SEPAApp, please read the previous chapter and then skip this. Use the included templates (within the downloaded zip file) for Excel 2003 (*.xls) or Excel 2007 or newer (*.xlsx) or LibreOffice / OpenOffice (ODF format: *.ods) to capture your direct debits and credit transfers. The advantage compared to CSV files is that you get assistance within the templates as the respective columns to be filled.

Hint: Do not delete header or example rows or eventually the not needed table in the template. Just insert your data – SEPAApp will automatically recognize your data.

Direct_Debit_Template
(Fig. 1)

You can download template files here: SEPAApp-Template (XLS) SEPAApp-Template (XLSX) SEPAApp-Template_without_BIC (XLS) SEPAApp-Template_without_BIC (XLSX) SEPAApp-Template (ODS) SEPAApp-Template_without_BIC (ODS)

Import CSV, ODF or Excel file into SEPAApp

Select in the following dialog (Fig. 1) your file with the direct debits and import this file by clicking on the button “Select File” ( Fig. 2 ).
SEPAApp_Direct_Debits_1-7-1
Fig. 1

sepaapp_open-dialog
Fig. 2

After importing the file SEPAApp shows you whether all data was successfully imported, or if there were errors ( Fig. 3).

SEPAApp_1-7-1-Direct_Debits_imported
Fig. 3

Generate SEPA file

You create the SEPA file by clicking on the button “Download SEPA XML file” (Fig. 1) and enter the file name of the SEPA XML file in the following dialog and “Save File” click on the button (Fig. 2).

SEPAApp_1-7-1-Direct_Debits_imported
Fig. 1

Hint: The button “Create SEPA file” will be enabled, after all mandatory fields on the GUI are filled – i.e. there are error messages – and a file with at least one valid data row was imported.

Dialog_Save_File
Fig. 2

After saving the file SEPAApp shows you whether the saving was successful or if there were errors (Fig. 3).

SEPAApp_1-7-1-Direct_Debits_saved
Fig. 3

Hint: Only successfully imported rows will be exported to the SEPA file. So please check the log messages according the imported rows before exporting a SEPA xml file!

Credit transfers

To generate credit transfers with SEPAApp, select after the start of the second tab with the heading “credit transfers” (Fig. 1), by clicking on it. This will open the view for transfers (Fig. 2 ).

SEPAApp_Direct_Debits_1-7-1
Fig. 1

SEPAApp_Credit_Transfers_1-7-1
Fig. 2

Enter your own bank data

Now enter your own banking information in the fields:

  • Account holder: The first and last name or the business name of the account holder
  • IBAN: your IBAN (with or without spaces)
  • BIC: your BIC (with or without spaces)
  • Execution Date: The date on which the credit transfer is to be executed. This date must be in the future.

If you want to import the BIC of your credit transfers, set the according checkbox to true.

  • Choose pain-Format: Choose the (sub-)format according to your country and the requirements of your bank.
  • Show optional settings (see the follwing list of optional settings and Fig. 3)
  • optional Here you can choose a value for the field “Category Purpose”. Only choose a value, if you need that field (your bank may tell you).
  • optional Identification ID: This field is only relevant for example in Spain und may be filled with the Fiscal No. Leave it empty in all other cases!
  • optional Choice type of identification ID: Choose organisation (e.g. spanish Fiscal No. or irish OIN) or person (z.B. irish OIN). This choice is only relevant, if the field identification ID is used.
  • optional Checkbox timestamp without timezone: Choose this only if your bank need the timestamp within the SEPA XML file without timezone. This choice is only relevant for the (sub-)format pain.001.001.03.
  • optional Checkbox Batch-Booking: De-Select this checkbox, if you need single-booking. This checkbox is selected by default.
  • optional Checkbox Generate Customer’s referenz automatically (EndToEndId): De-Select this checkbox, if you do not need a generated Id. This checkbox is selected by default, because many banks need this Id.
  • optional Checkbox: Read Customer’s referenz from import file (EndToEndId): Select this checkbox, if you want to import the id from file for each single (!) data row. This feature is only available for SEPAApp Pro!
  • optional Customer’s referenz (EndToEndId): Enter your manual id for all (!) data rows here. To enable this field both checkboxes above must be de-selected.
  • optional Checkbox Set debitor currency: Select this checkbox, if your bank needs this setting. This checkbox is not selected by default.
  • optional Checkbox express credit transfer (CCU/DTE): Select this checkbox, if you want to generate an express credit transfer. Caution, you bank needs to support that option. This checkbox is not selected by default. This choice is only relevant for the (sub-)format pain.001.003.03.
  • optional Checkbox transaction no.: Select this checkbox, if you need a transaction no. (InstrId) for each transaction.
  • optional Checkbox Payment Information Instruction: Select this checkbox, if you need a separate header (Payment Information Instruction) for each transaction. This choice is only relevant for the (sub-)format pain.001.001.03.
  • optional Checkbox National Payment CH with currency CHF: Select this checkbox, if want to generate a national payment in Switzerland. Hint: The currency will be set to CHF by SEPAApp no matter what is in the import file. This choice is only relevant for the (sub-)format pain.001.001.03.CH.02.
  • optional Checkbox set LclInstrm CORE: Select this checkbox, if want to set the according element in your SEPA XML file.This choice is only relevant for the (sub-)formats 001.03, 001.001.03.austrian.003, 001.03.CH.02.

SEPAApp_1-7-1-Credit-Transfers_options

Fig. 3

CSV file creation (with LibreOffice / OpenOffice)

If you want to use a CSV file to import your credit transfers in SEPAApp, you can see here how the CSV file must be constructed. This is shown with LibreOffice / OpenOffice. You can also create the CSV file with any other program. If you want to work with the Excel format, then you can skip this part and read the next chapter. The CSV file must be in the following Fig. 1 shown columns. The number of lines is not limited – you can import any number of credit transfers (rows) in SEPAApp. The columns contain:

  • Account holder: The first and last name or the business name of the account holder, should be transferred to their accounts.
  • IBAN: IBAN (with or without spaces) of the account to which is to be transferred.
  • OPTIONAL: BIC: BIC (with or without spaces) of the account to be transferred to. The according checkbox on the SEPAApp GUI must be set to true, if you want to use the BIC.
  • Usage: The text that will appear when booking (on the bank statement).
  • Amount: The amount to be transferred.

credit_transfer_CSV
Fig.1

Save the file as a CSV file as shown in Fig. 2:

Screenshot of 2014-02-25 10:29:04 _edited
Fig. 2

Select in the dialog (Fig. 3), the semicolon (;) as the delimiter and uncheck the option “cell content as shown”.

Caution when selecting the character set:

  • In Windows, select the character set “Western Europe”
  • In Linux, select the character set “UTF-8”
  • In Mac OS, select the character set “UTF-8”

Otherwise, it may cause problems in the processing of specail digits.

Screenshot of 2014-02-25 10:30:52 _edited
Fig. 3

You can download template files here: SEPAApp-template-creditTransfer (CSV) SEPAApp-template-creditTransfer_withoutBIC (CSV)

Excel file creation (with Microsoft Excel) / ODF file creation with LibreOffice / OpenOffice

If you want to use a CSV file to import your credit transfers in SEPAApp, please read the previous chapter and then skip this. Use the included templates (within the downloaded zip file) for Excel 2003 (*.xls) or Excel 2007 or newer (*.xlsx) or LibreOffice / OpenOffice (ODF format: *.ods) to capture your direct debits and credit transfers. The advantage compared to CSV files is that you get assistance within the templates as the respective columns to be filled.

Hint: Do not delete header or example rows or eventually the not needed table in the template. Just insert your data – SEPAApp will automatically recognize your data.

Credit_Transfer_Template

You can download template files here: SEPAApp-Template (XLS) SEPAApp-Template (XLSX) SEPAApp-Template_without_BIC (XLS) SEPAApp-Template_without_BIC (XLSX) SEPAApp-Template (ODS) SEPAApp-Template_without_BIC (ODS)

Import CSV, ODF or Excel file into SEPAApp

Select in the following dialog ( Fig. 1) your file with the direct debits and import this file by clicking on the button “Select File” ( Fig. 2 ).

SEPAApp_Credit_Transfers_1-7-1
Fig. 1

sepaapp_open-dialog
Fig. 2

After importing the file SEPAApp shows you whether all data were successfully imported, or if there were errors (Fig. 3).

SEPAApp_1-7-1-Direct_Debits_imported
Fig. 3

Generate SEPA file

You create the SEPA file by clicking on the button “Download SEPA XML file” (Fig. 1) and enter the file name of the SEPA XML file in the following dialog and “Save File” click on the button (Fig. 2 ).

SEPAApp_1-7-1-Direct_Debits_imported

Hint: The button “Create SEPA file” will be enabled, after all mandatory fields on the GUI are filled – i.e. there are error messages – and a file with at least one valid data row was imported.

Dialog_Save_File
Fig. 2

After saving the file SEPAApp shows you whether the save was successful or if there were errors (Fig. 3).

SEPAApp_1-7-1-CRedit_Transfers_saved
Fig. 3

Hint: Only successfully imported rows will be exported to the SEPA file. So please check the log messages according the imported rows before exporting a SEPA xml file!

Entering a license no.

Order your license no. here – You can get this comfortable by e-mail. Enter the license no afterwards in SEPApp: After clicking on the button “Enter license key” in Fig. 1, in the opening dialog window and confirm by clicking on the “OK” button (Fig. 2).

SEPAApp_1-7-1-Licensenumber

Fig. 1

 

sepaapp_license-dialog
Fig. 2

Command-line interface

This feature is only available for SEPAApp Pro!

Credit Transfers


SEPAApp.exe SCT [accountHolder] [IBAN] [BIC] [executionDate] [subformat] [flagForBICImport] [flagForEndToEndIdImport] [importFileName] [exportFileName]

  • Subformat = PAIN_001_001_03 or PAIN_001_003_03 or CBIPaymentRequest or PAIN_001_001_03_CH_02 or PAIN_001_001_03_AUSTRIAN_003 or PAIN_001_001_02
  • FlagBIC-Import = true OR false
  • FlagEndToEndId-Import = true OR false
  • Parameters with spaces must be set between quotation marks

Direct Debits


SEPAApp.exe SDD [accountHolder] [IBAN] [BIC] [collectionDate] [creditorId] [subformat] [flagForBICImport] [flagForEndToEndIdImport] [importFileName] [exportFileName]

  • Subformat = PAIN_008_001_02 OR PAIN_008_003_02 OR CBISDDReqLogMsg OR PAIN_008_001_02_CH_01 OR PAIN_008_001_02_AUSTRIAN_003
  • FlagBIC-Import = true OR false
  • FlagEndToEndId-Import = true OR false
  • Parameters with spaces must be set between quotation marks