How to Export Settlements from Adyen (2026 Guide)
Follow these steps to export your Adyen settlements as a CSV file. Once exported, you can use any of our converter tools to transform the data for your target system.
Export Steps
Log in to the Adyen Customer Area
Open your browser and navigate to ca-live.adyen.com (or ca-test.adyen.com for test data). Sign in with your Adyen credentials and complete any two-factor authentication. Make sure you switch to the correct merchant account if you manage multiple accounts.
Navigate to the Settlement Details report
In the left navigation menu, click 'Reports', then select 'Settlement details' from the list of available report types. This is Adyen's primary reconciliation report and contains transaction-level detail for each settlement batch.
Check for previously generated reports
Under 'Generated reports', you will see a list of reports that have already been created, either automatically or manually. If a report for your desired period already exists, you can download it directly by clicking on its name. Adyen typically auto-generates settlement reports for each batch.
Generate a new report if needed
If you need a report for a specific date or batch, click 'Manage report' and select 'Manual (generate once)'. Choose which merchant accounts to include: current account only, all accounts, or specific accounts. Under 'Data filtering', select either a specific date or a single settlement batch number.
Configure report columns (optional)
Adyen allows you to customize which columns appear in the report. You can add columns for fee breakdowns (Commission, Markup, Scheme Fees, Interchange), shopper information, or card details. Click the column configuration option to adjust the report layout before generating.
Generate and download the CSV
Click 'Generate report' to create the file. Once processing is complete, the report will appear in the 'Generated reports' list. Click the report name or the download icon to save the CSV file. The default format is CSV, but TSV and XLS are also available.
Verify the settlement data
Open the CSV file in a spreadsheet application. The report contains separate Gross Debit and Gross Credit columns rather than a single net amount. Verify that the Batch Number links correctly to your bank deposits and that the fee breakdown columns (Commission, Markup, Scheme Fees, Interchange) sum to the total deductions.
Required Settlements Fields
| Field | Type | Description | Example |
|---|---|---|---|
| Merchant Account | Text | Adyen merchant account identifier | AcmeECOM |
| Psp Reference | Text | Adyen's unique transaction ID (16-character alphanumeric) | 8825408195441178 |
| Creation Date | Date/Time | Transaction creation date/time | 2025-01-15T14:30:00+00:00 |
| Type | Choice | Transaction type | Settled |
Your Adyen export must include these fields for successful conversion.