When migrating existing bank debit clients over to GoCardless, certain information is required in order to recreate your clients’ authorisations (mandates) in our system. These requirements vary according to the country (or region) your clients, or more specifically their bank accounts, are located in.
To view the data requirements and formatting examples for a country or region, please scroll down or select from the table below.
| Australia (BECS) | Eurozone (SEPA) | United Kingdom (Bacs) |
| Canada (PAD) | New Zealand (BECS NZ) | United States of America (ACH) |
| Denmark (Betalingsservice) | Sweden (Autogiro) |
|
COLUMN |
DATA |
EXAMPLE |
|
A |
customer.given_name |
John |
|
B |
customer.family_name |
Smith |
|
C |
customer.company_name |
John's Gyms Ltd |
|
D |
customer.email |
john.smith@example.com |
|
E |
bank_account.account_holder_name |
John Smith |
|
F |
bank_account.account_number |
123456789 |
|
G |
bank_account.branch_code |
200000 |
|
H |
customer.metadata.custom_reference |
GYM441231 |
|
I |
customer.language |
en |
|
COLUMN |
DATA |
EXAMPLE |
|
A |
customer.given_name |
John |
|
B |
customer.family_name |
Smith |
|
C |
customer.company_name |
John’s Gyms Ltd |
|
D |
customer.email |
john.smith@example.com |
|
E |
customer.language |
en |
|
F |
bank_account.account_holder_name |
John Smith |
|
G |
bank_account.account_number |
0123456 |
|
H |
bank_account.branch_code |
00063 |
|
I |
bank_account.bank_code |
0036 |
|
J |
customer.metadata.custom_reference |
WIL12251 |
|
COLUMN |
DATA |
EXAMPLE |
|
A |
customer.given_name |
William |
|
B |
customer.family_name |
Svensson |
|
C |
customer.company_name |
William’s Jeans |
|
D |
customer.email |
william@example.com |
|
E |
customer.danish_identity_number |
0101701234 |
|
F |
bank_account.account_holder_name |
William Svensson |
|
G |
bank_account.account_number |
123456789 |
|
H |
bank_account.bank_code |
7000 |
|
I |
customer.metadata.custom_reference |
WIL12251 |
|
J |
customer.language |
da |
|
COLUMN |
DATA |
EXAMPLE |
|
A |
customer.given_name |
Jean |
|
B |
customer.family_name |
Dupont |
|
C |
customer.company_name |
Jean's Shop |
|
D |
customer.email |
jean.dupont@example.com |
|
E |
bank_account.account_holder_name |
Jean Dupont |
|
F |
bank_account.iban |
FR1420041010050500013M02607 |
|
G |
amendment.original_mandate_reference |
REFNMANDATE |
|
H |
amendment.original_creditor_id |
FR123OTHERBANK |
|
I |
amendment.original_creditor_name |
Existing DD Provider |
|
J |
customer.metadata.custom_reference |
JEAN441231 |
|
K |
customer.language |
fr |
|
COLUMN |
DATA |
EXAMPLE |
|
A |
customer.given_name |
Billy |
|
B |
customer.family_name |
Jean |
|
C |
customer.company_name |
James's Jeans |
|
D |
customer.email |
billy.jean@example.com |
|
E |
customer.language |
en |
|
F |
customer.phone_number |
+64 4 817 9999 |
|
G |
customer.address_line1 |
Flat 12 |
|
H |
customer.address_line2 |
Half Moon Bay (suburb) |
|
I |
customer.city |
Auckland |
|
J |
customer.postal_code |
2012 |
|
K |
customer.country_code |
NZ |
|
L |
bank_account.account_holder_name |
Billy Jean |
|
M |
bank_account.account_number |
1234567-00 * |
|
N |
bank_account.branch_code |
0123 |
|
O |
bank_account.bank_code |
01 |
|
P |
customer.metadata.custom_reference |
JAM12251 |
* Please note: in column M (bank_account.account_number) a hyphen must be added between the account number and suffix, as outlined in the example above.
|
COLUMN |
DATA |
EXAMPLE |
|
A |
customer.given_name |
William |
|
B |
customer.family_name |
Svensson |
|
C |
customer.company_name |
William’s Jeans |
|
D |
customer.email |
william@example.com |
|
E |
customer.swedish_identity_number |
670919-9530 |
|
F |
bank_account.account_holder_name |
William Svensson |
|
G |
bank_account.account_number |
00000055839825746 |
|
H |
bank_account.branch_code |
500 |
|
I |
customer.metadata.custom_reference |
WIL12251 |
|
J |
customer.language |
sv |
|
COLUMN |
DATA |
EXAMPLE |
|
A |
customer.given_name |
John |
|
B |
customer.family_name |
Smith |
|
C |
customer.company_name |
John's Gyms Ltd |
|
D |
customer.email |
john.smith@example.com |
|
E |
customer.address_line1 |
65 Goswell Road |
|
F |
customer.address_line2 |
|
|
G |
customer.address_line3 |
|
|
H |
customer.city |
London |
|
I |
customer.postal_code |
EC1V 7EN |
|
J |
customer.country_code |
GB |
|
K |
bank_account.account_holder_name |
John Smith |
|
L |
bank_account.account_number |
55779911 |
|
M |
bank_account.branch_code |
200000 |
|
N |
customer.metadata.custom_reference |
GYM441231 |
|
O |
customer.language |
en |
United States of America (ACH)
|
COLUMN |
DATA |
EXAMPLE |
|
A |
customer.given_name |
John |
|
B |
customer.family_name |
Smith |
|
C |
customer.company_name |
John's Gyms Ltd |
|
D |
customer.email |
john.smith@example.com |
|
E |
customer.language |
en |
|
F |
customer.address_line1 |
1600 Pennsylvania Ave NW |
|
G |
customer.city |
Washington |
|
H |
customer.region |
DC |
|
J |
customer.postal_code |
20500 |
|
K |
customer.country_code |
US |
|
L |
bank_account.account_holder_name |
John Smith |
|
M |
bank_account.account_number |
2715500356 |
|
N |
bank_account.bank_code |
026073150 |
|
O |
bank_account.bank_type |
checking |
|
P |
mandate.payer_ip_address |
8.8.8.8 |
|
Q |
customer.metadata.custom_reference |
WIL12251 |