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:

• Customer Bank Accounts
• Configuration Worksheet
• Excel Template Data Migration

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 Excel → Export 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 Excel → Import 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'.