Customer Bank Account Template

Excel template to import customer bank accounts into Bevica Select for payment automation scenarios (where enabled).

Use this template to import Customer Bank Accounts.

You typically need these records for SEPA Direct Debit. They’re also useful for customer reporting.

Before you start

You need:

• ​Excel Template Data Migration​
• ​Configuration Worksheet

When to use this template

Export it from Configuration Worksheet on the Customer Bank Accounts line.

Customers must already exist.

Step-by-step

1

Export the template

1. Open Configuration Worksheet.
2. Select the Customer Bank Accounts line.
3. Select Excel → Export to Template.

2

Populate rows

1. Create one row per customer bank account.
2. Format Customer No. as Text in Excel.
3. Use a consistent Code (for example DD).

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 a customer card.
2. Open Bank Accounts.
3. Confirm the code and IBAN/BIC values.

Field reference (template columns)

The template has the following fields:

Field ID / Name	Related Table	FieldType	Note
1 Customer No.	(18) Customer	Code 20 (Mandatory)	The customer must already exist.
2 Code		Code 20 (Mandatory)	Enter a unique reference for this customer bank account, e.g. DD.
3 Name		Text 100	The name of the bank account.
13 Bank Branch No.		Text 20	The customer's sort code.
14 Bank Account No.		Text 30	The customer's bank account no.
24 IBAN		Code 40 (Mandatory)	The customer's bank account IBAN.
25 SWIFT Code		Code 20 (Mandatory)	The customer's bank account Swift/BIC code.