For the complete documentation index, see llms.txt. This page is also available as Markdown.

SEPA Direct Debit Mandate Import

Use this template to import customer DD mandate information. These records are needed in order to produce Direct Debit files from Bevica.

Before you start

Start here:

When to use this template

The customer DD mandate template is a pre-formatted spreadsheet with the fields you need to create customer DD mandates in order to process direct debit collections. You can access the template from the Configuration Worksheet page, Customer DD Mandates line.

Step-by-step

1

Export the template

  1. Open Configuration Worksheet.

  2. Select the Customer DD Mandates line.

  3. Select ExcelExport to Template.

2

Populate rows

  1. Create one row per mandate.

  2. Make sure the customer exists.

  3. Make sure the customer bank account exists.\n

3

Import and apply

  1. Select ExcelImport from Template.

  2. Fix any errors in the preview.

  3. Select Apply Data.

4

Verify

  1. Open the customer.

  2. Confirm the mandate is available for direct debit processing.

Field reference (template columns)

The template has the following fields:

Field ID / Field Name
Related Table
Field Type
Note

1 ID

Code 35 (Mandatory)

The DD mandate ID.

2 Customer No.

Customer (18)

Code 20 (Mandatory)

The customer must already exist.

3 Customer Bank Account No.

Customer Bank Account (287)

Code 20 (Mandatory)

The customer's bank account code that you created when importing customer bank accounts, e.g. DD.

4 Valid From

Date (No)

5 Valid To

Date (No)

6 Date of Signature

Date (Mandatory)

Date the DD mandate was signed. DD collections cannot be taken unless this field is populated.

7 Type of Payment

Option (Mandatory)

Set to Recurrent or One-Off.

8 Blocked

Boolean (No)

9 Expected No. of Debits

Integer (Mandatory)

Must be greater or equal to 1. To be used in conjunction with 'Ignore Exp. Number of Debits'.

10 Debit Counter

Integer (Mandatory)

Number of DDs already collected. Use in conjunction with 'Expected No. of Debits' and 'Ignore Exp. Number of Debits'.

12 Closed

Boolean (No)

13 Ignore Exp. Number of Debits

Boolean (No)

Set this if the DD Counter can go above the 'Expected No. of Debits'.

Last updated

Was this helpful?