Vendor Bank Account Template

Excel template to import vendor bank accounts into Bevica Select, supporting payments and remittance details (where used).

Use this template to import Vendor Bank Accounts.

Vendors must already exist.

Before you start

You need:

• ​Excel Template Data Migration​
• ​Configuration Worksheet

When to use this template

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

Step-by-step

1

Export the template

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

2

Populate rows

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

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 vendor card.
2. Open Bank Accounts.
3. Confirm sort code, account number, and currency.

Field reference (template columns)

The template has the following fields:

Field ID / Name	Related Table	FieldType	Note
1 Vendor No.	(23) Vendor	Code 20 (Mandatory)	Unique vendor reference. If vendors are being imported from another system keep the same reference. The vendor must already exist in Bevica.
2 Code		Code 20 (Mandatory)	Unique reference for the vendors bank account, e.g. BACS.
3 Name		Text 100	Account Name
13 Bank Sort Code		Text 20 (Mandatory)	Ensure the Sort Code is 6 digits (with no -)
14 Bank Account No.		Text 30 (Mandatory)	Account no. must be 8 digits
16 Currency Code	(4) Currency	Code 10 (Mandatory)	Leave blank if the account is in your local currency.
17 Country/Region Code	(9) Country/Region	Code 10
24 IBAN	(1210) Swift Code	Code 50
25 SWIFT Code		Code 50
10550 Reference No.		Text 30	Used internally for reference and copied to BACS files if applicable.