How to Export Payment Accounting from Adyen (2026 Guide)
Follow these steps to export your Adyen payment accounting 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 go to ca-live.adyen.com. Sign in with your Adyen credentials and switch to the merchant account for which you want to generate the report. You need the 'Merchant Report' user role to access this report type.
Navigate to the Reports section
In the left navigation menu, click 'Reports'. You will see the Report overview page listing all available report types. You can use the dropdown menu to filter by report category or search for 'Payment accounting report' in the search bar.
Select the Payment Accounting Report
From the report list, find and click on 'Payment accounting report' under the Name column. This report provides an event-based view of the payment lifecycle, showing each event (authorization, capture, refund, chargeback) as a separate row. This is useful for accrual-based accounting.
Generate a new report
Click 'Manage report' and then select 'Manual (generate once)'. Enter the date range or specific settlement batch you want to include. Choose which merchant accounts to include in the report. Click 'Generate report' to start processing.
Download the CSV file
Once the report is generated, it will appear in the 'Generated reports' list. Click on the file name or the download icon to save it. The default file format is CSV. The report includes PSP Reference, Merchant Reference, Payment Method, Booking Date, Event Code, Amount, Currency, Fee Amount, and Fee Currency.
Verify the report data
Open the CSV in a spreadsheet and review the Event Code column, which indicates the type of event for each row (AUTHORISATION, CAPTURE, REFUND, CHARGEBACK, etc.). Confirm that the Booking Date range matches your request and that Amount and Fee Amount columns are correctly populated.
Required Payment Accounting Fields
| Field | Type | Description | Example |
|---|---|---|---|
| Psp Reference | Text | Adyen's unique transaction ID | 8825408195441178 |
| Booking Date | Date | Date event was booked | 2025-01-15 |
| Event Code | Choice | Payment event type | CAPTURE |
| Amount | Currency | Event amount | 100.00 |
| Currency | Text | Amount currency (ISO 4217) | USD |
Your Adyen export must include these fields for successful conversion.