Exporting payment information
You can export your payment data as a csv download to view in a spreadsheet form within Microsoft Excel or similar. A list of the information available via payments exports can be found in the reference section.
-
How to export payment data
-
Using the filtering option to filter your payment view before exporting
-
How to export payment data by customer
How to export payment data
-
Login to your GoCardless dashboard & navigate to the Payments page
-
Select the status of payments you wish to export
-
Click the Export button to initiate a csv download of your [filtered] payment information. An export generation window will open in the bottom right of your screen to track its progress. Once the download has completed the status dot will turn green.
-
Click the csv link to download it to your device
-
Once you’ve downloaded the export, click Dismiss to close the Export generation window
Using the filtering option to filter your subscription view before exporting
Using these filtering options, choose the date range of when payments were created (i.e. added to your dashboard) that you would like to export, along with their current status.
These statuses are broken down into:
-
Pending customer approval - We’re waiting for the customer to approve this payment
-
Customer approval denied - The customer has denied approval for the payment. You should contact the customer directly
-
Pending submission - The payment has been created, but not yet submitted to the banks
-
Submitted - The payment has been submitted to the banks
-
Cancelled - The payment has been cancelled
-
Confirmed - The payment has been confirmed as collected
-
Paid out - The payment has been included in a payout
-
Failed - The payment failed to be processed. Note that payments can fail after being confirmed if the failure message is sent late by the banks.
-
Charged back - The payment has been charged back
How to export payment data by customer
-
Find the customer you would like to export payments for via the Customers page in your dashboard and click on their name.
-
Make a note of the customer ID (this can be found at the top of the page and starts with CU..)
-
Use the ID and adjust the customer_id value of the following URL - https://manage.gocardless.com/payments?customer=customer_id
-
Paste the URL in your browser which should then take you to the customers payment page, where you can then click the Export button to initiate a csv download of the customer payment information. An export generation window will open in the bottom right of your screen to track its progress. Once the download has completed the status dot will turn green.
-
Click the csv link to download it to your device
-
Once you’ve downloaded the export, click Dismiss to close the Export generation window