- Prepare migration data
- Download the bulk change csv template
- Upload the completed bulk change csv template
- Convert a CSV spreadsheet for Excel or Numbers
Prepare migration data
To migrate your existing bank debit clients into GoCardless, we need to recreate their authorisations (mandates) in our system. To do this, we need their information.
IMPORTANT: For privacy and data security reasons, we cannot obtain your clients' data from your previous payment provider on your behalf. As the controller of their data, you will need to obtain this information and upload it into GoCardless so that we can complete their set-up. This will ensure that their service and payment cycle can continue seamlessly, with no action required on their part.
The data required to set up your customers in GoCardless varies depending on where they, or more specifically, their bank accounts, are located. Each bank debit scheme imposes requirements on what information is necessary to set up a bank debit authorisation on a bank account in their country/region of operation.
Please note: We provide country (or region) specific csv templates that include columns for all the data we require for your customers in each case. These can be downloaded via your GoCardless account import tool once made accessible to you by your Onboarding Manager. To obtain the csv template earlier, please ask them to send it to you directly.
Download the bulk change csv template
-
Open the Import Tool within your dashboard via manage.gocardless.com/imports
-
Click Import
-
Select the option that corresponds to the bank debit scheme and currency your customers’ payments are collected in
-
Click Download template for [bank debit scheme] mandates (CSV) in step 1
Once the download is complete, open the file to find the required data field columns ready for your client’s information to be added.
Please note: The spreadsheet must be set to Text format to ensure the data saves in the correct format and can be validated via our Import Tool. Please see below for a guide on how to do this in Microsoft Excel (Windows) and Numbers (Mac).
Upload the completed bulk change csv template
The final step in the client migration process is to import your clients’ data into GoCardless to recreate their authorisations (mandates).
Follow these steps to complete the import process:
- Open the Import Tool within your dashboard via manage.gocardless.com/imports
- Click Import
- Select the Migrate [bank debit scheme] mandates (Cur.) option that matches the csv data file you wish to upload
- Click Choose file in step 3
- Select the saved data file from your computer or device
- Tick the checkbox to confirm that you have agreed the bulk change with your previous payments provider and have informed your clients of the change in provider
- Click Upload and review your import (any errors will be highlighted to you in red)
- Once the file has been validated, click Import
Our Customer Onboarding team will be notified that you have completed the import process. They will then review the information before completing the final step and confirming completion with you.
Convert a CSV spreadsheet for Excel or Numbers
A bulk change CSV spreadsheet must be set to Text format to ensure the data saves in the correct format and can be validated via our Import Tool.
Excel (Microsoft):
This guide will explain how to change your CSV spreadsheet format for Excel (Microsoft):
-
Click the arrow in the top left of the spreadsheet to select all cells
-
Right-click anywhere within the selected area and select Format Cells
-
Select Text from the options in the left column and hit OK
Numbers (Mac):
This guide will explain how to change your CSV spreadsheet format for Numbers (Mac):
-
Click the circle in the top left of the spreadsheet to select all cells
-
Click on Cell in the options on the right (next to Table)
-
Under Data Format, select Text from the dropdown menu