Contents

    Exporting SEPA direct debit mandates

    Your task/initial situation

    SEPA direct debit is integrated into the invoice management of JTL-Wawi. You would like to export the SEPA direct debit mandate of an invoice, for example to import it into your banking software.
    1. Click on the Sales icon to go to the sales management in JTL-Wawi and go to Invoices.
    1. Select the desired invoice and click on the SEPA button. The SEPA direct debit dialogue boy opens.

    In this dialogue box, you can see the data sets for the selected invoice and export the direct debit mandates in SEPA XML format.

    Attention! Please make sure that a valid IBAN and BIC are saved for each customer. In addition, the Creditor ID must be stored in the company settings.
    1. In the General/Global export settings area, make further settings:

    Payment reference: The payment reference to be used for the direct debit. Click on the icon to go to the DotLiquid editor to customise this field.


    Collection date: The date on which the payment is collected.


    Export path: Storage location for the XML file.


    Mandate reference: Enter the mandate reference for the SEPA collection. This is usually the customer ID or invoice ID. Click on the icon to go to the DotLiquid editor to customise this field.


    Automatically mark invoices as paid: Sets the payment automatically for invoices that are exported for SEPA collection.


    Batch Booking: Enables the SEPA Batch Booking feature in the file. If you export multiple invoices in one file, this option will group them together in one entry in your bank account. You might have to contact your bank to have this option activated for your bank account.


    Recurring debit: Marks that this payment is a recurring debit, for example because of recurring payments for a subscription.


    1. After you have made all settings, click Export.

    The direct debit mandate has now been exported in SEPA XML format and saved under the export path you specified.