How-To Guide
6 min read

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

1

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.

2

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.

3

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.

4

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.

Tip: The Payment Accounting Report is ideal for tracking the full lifecycle of each payment. Use it alongside the Settlement Details Report if you need both event-level and settlement-level reconciliation.
5

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.

Adyen Customer Area Generated reports list showing downloadable CSV report files
Click the report name in the Generated reports list to download the CSV.
6

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.

Warning: This report shows events, not settlements. A single payment may have multiple rows (authorization, capture, refund). Do not sum amounts without first filtering by Event Code to avoid double-counting.

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.

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

Frequently Asked Questions

Adyen exports payment accounting 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.