How-To Guide
7 min read

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

1

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.

Tip: You need the 'Merchant Report' user role to generate and download settlement reports. Contact your Adyen admin if the Reports section is not accessible.
2

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.

3

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.

4

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.

5

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.

Tip: Include the Batch Number column in your export. This is essential for matching transactions to bank deposits during reconciliation.
6

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.

Adyen Customer Area showing the report generation interface with options for automatic and manual report creation
Generated reports appear in the list where you can download CSV files directly.
7

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.

Warning: Adyen uses separate Gross Credit and Gross Debit columns. To calculate the net amount for a transaction, subtract Gross Debit from Gross Credit. Do not simply sum these columns.

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.

Next Step Once you have exported your settlements, use one of the converter tools below to transform your file.

Frequently Asked Questions

Adyen exports settlements as a CSV (Comma Separated Values) file, which can be opened in Excel or Google Sheets.
The file is usually downloaded to your browser's default Downloads folder. Check your Downloads folder or look for the download notification.