Client migration data requirements (Bacs)

A, B, C

Customer.given_name & customer.family_name OR customer.company_name

Enter either customer given name + surname OR company name.

If your previous provider exported your customers' full names in a single cell per whole name, rather than splitting between given name and family name, you can use the text to columns function in Excel to separate. 

Example: John & Smith OR John’s Gym Ltd

D

customer.email

A valid email address is required for each customer so that they receive notifications from GoCardless about their payments. If you are planning to send your own notifications to your customers, please speak with your Account Executive.

Example: john.smith@example.com

E, F, G, H, I, J

• Customer.address_line1

• Customer.address_line2

• customer.address_line3

• customer.city

• customer.postal_code

• customer.country_code

BACS require an address to be stored against a customer's Direct Debit mandate. Address line 1 and City are required fields. Postcodes can be entered with or without spaces. The country code should be listed as a two character reference only. For UK addresses, use GB.

Example: 65 Goswell Road, London, EC1V 7EN, GB

K

customer.phone_number

(Optional) 

Example: +44 20 8338 9540

L

bank_account.account_holder_name

This is separate to the 'name' entry fields, since account holder name can differ from the individual (e.g., it could include a middle name) or company name.

Example: John Smith

M

bank_account.account_number

A GBP bank account must be used for Bacs Direct Debit payments. 8 characters in standard format.

Example: 55779911

N

bank_account.branch_code

6 character format. This can be entered with or without hyphens / spaces e.g. 200000, 20-00-00, and 20 00 00 will all work.

Example: 200000

O

bank_account.metadata.bank_custom_key

(Optional) - Use this field to add a custom reference for your customer if required. This will be assigned to your bank account within your dashboard and is a searchable field.

Example: JAM12251

P

customer.metadata.custom_reference

(Optional) - Use this field to add a custom reference for your customer if required. This will be assigned to your customer within your dashboard and is a searchable field.

Example: GYM441231

Q

mandate.metadata.mandate_custom_key

(Optional) - Use this field to add a custom reference for your customer if required. This will be assigned to your mandate within your dashboard and is a searchable field.

Example: WIL12251

R

customer.language

This will determine the language of customer notifications.

Example: en