Bulk importing payments
Single payments can be created for multiple existing customers in bulk via a CSV import.
IMPORTANT: Please note that:
-
You cannot add new, or update details for existing customers into the payments import CSV. The upload will return an error.
-
There is a character limit of 100 characters per cell.
-
Click Payments
-
Select Import
-
Click Download template
-
Once downloaded, click the blue .csv link in the Export window to open
-
A link to download the export will also be emailed to you
-
-
Enter the payment amount, description, and charge dates* into the respective rows of the customers you wish to create payments for (columns G, I, and J). Please note: There is a character limit of 100 characters per cell.
-
Save the updated csv file
-
Return to your dashboard and click Choose file to upload your saved csv
-
Click Import payments
-
If there are any errors in your uploaded file, this will be highlighted on the Imports page. You will then be required to correct the errors and then re-upload the csv.
-
-
Once the upload has successfully validated, you will see confirmation of this on the Imports page.
-
Here, you can confirm that the payments you have created for each customer entry are correct via the Valid rows section at the bottom.
-
-
When you're ready, click Process payments.
If you now navigate to the Payments page of your dashboard via the blue menu on the left, you should see these payments available to view with a pending submission status.
* Entering charge dates
The charge date must be entered in the format YYYY-MM-DD.
You must enter a date that allows for sufficient pre-collection processing time; determined by the advance notice and payment submission deadline requirements of the payment scheme applicable to where your customer is based.
If you wish to collect the payment as soon as possible, you can instead leave the payment.charge_date (column J) field blank.
| COLUMN | COLUMN TITLE | REQUIRES INPUT / ACTION |
|---|---|---|
|
A |
mandate.id |
No |
|
B |
customer.id |
No |
|
C |
customer.given_name |
No |
|
D |
customer.family_name |
No |
|
E |
customer.company_name |
No |
|
F |
customer.email |
No |
|
G |
payment.amount |
Yes |
|
H |
payment.currency |
No |
|
I |
payment.description |
Optional |
|
J |
payment.charge_date |
Optional |
|
K |
payment.metadata.YOUR_CUSTOM_FIELD |
Optional |
Please note: Column K "payment.metadata.YOUR_CUSTOM_FIELD" needs to be given a unique name.
Handling accents in the bulk upload tool
If your customers' details contain accents or other special characters, you might experience issues when we run our automated checks.
This is because spreadsheet software like Excel by default doesn't understand the special characters in the file, so when you save it and upload it back to us, the special characters are corrupted, and the details no longer match up. This is because Excel doesn't handle what is called "UTF-8 encoding" properly.
On Excel on Windows, you can fix this by using the "Import Text File" tool to open the CSV file.
On Mac, Excel isn't able to open UTF-8 encoded files at all. You'll need to use alternative spreadsheet software (for example Apple's Numbers) or edit the CSV file carefully using a text editor.