Downloading reports

Download reports and use them to perform tasks related to your finances.

Automate the process of downloading and parsing report data using a combination of our notifications service and HTTP GET requests or using SSH File Transfer Protocol (SFTP).

Reports and time zones

Because time zones influence the start and end of your report, be aware of how we generate reports before you start downloading and using them:

We generate reports at approximately 04:00 CET.

If you find new reports by crawling (instead of automating report downloads), make sure the crawling time frame extends beyond 04:00 CET in case reports are generated later.
Each report uses only one time zone and one currency.
Charts and consolidated reports are always based on the CET time zone.

For other reports, the time zone setting of your account determines the beginning and end of the reporting period, and thus the transactions that are included. It is possible to have various different time zone settings for your company account and merchant accounts, but keep in mind that the report uses the time zone setting of the account where you run the report.

You'll find the time zone setting in your Customer Area under Account > Account settings.

Report	Time zone
Account Updater results report	CET
Aggregate settlement details report	Account time zone ¹
Daily finance report	CET
Dispute transaction details report	Account time zone
External settlement detail report	Account time zone
MarketPay balance report	Account time zone
MarketPay payments accounting report	Account time zone
MarketPay payout report	Account time zone
Monthly finance report	CET
Monthly invoice	CET
Payment accounting report	Account time zone
Received payment details report	Account time zone
Settlement details report	Account time zone ¹

¹ The Settlement details report and the Aggregate settlement details report are generated approximately two hours after the payable closing time of your merchant account. An overview of all payable closing time settings per merchant account is available in your Customer Area on the company level, under Finance > Payout model.

Change the time zone

Changing the time zone for your account only has an effect for future reports, and might lead to an initial gap or overlap in reports. For these reasons, proceed as follows when you want to change your time zone setting:

Generate, download, and save your report(s).
Contact our Support Team and ask them to change the time zone setting for your account.
Generate and download the report(s) again.
Merge each old report with the corresponding new report and remove any duplicates.

Automate generating reports

You can choose Automatic generation to generate a report automatically and make it available in your Customer Area. You will also receive a notification with eventCode: REPORT_AVAILABLE. The reason field contains the URL where you can download the report, and the pspReference field contains the name of the report.

To automatically generate a report:

Log in to your Customer Area.
Go to Reports, and find the report that you want to subscribe to.
Select Automatic generation.
Select a report format (such as .CSV or .XSLX).

If prompted, schedule when you want to receive the report by selecting Add report schedule and do the following:

Select the Frequency of report generation:
- Daily - The report is generated each day at 04:00 CET and contains the previous 24 hours of data.
- Weekly - The report is generated each week on the selected day and contains the previous 7 days of data. For example, if scheduled on Wednesday, the report will contain data for Wednesday - Tuesday.
- Monthly - The report is generated on the selected day of the month and contains data for the previous calendar month.
Optionally enter your country code in The merchant country code(s) and also:
- Also display the store - Select Yes to display and No to not display the store.
- Also display the terminal Id - Select Yes to display and No to not display the terminal Id.
Select Schedule to create a new schedule for automatic report generation.

Automate downloading reports

You can use downloaded reports for reconciliation by importing them into your accounting, ERP, or business intelligence systems. For more information, refer to Automate payment reconciliation. For additional security, you can also encrypt your reports with your PGP Key.

You can only download a report after it is generated.

To automate report downloads:

Set up report notifications to inform your server that a new report has been generated.
Make a HTTP GET request to download the report.

Alternatively, you can download reports using SFTP.

Step 1: Set up notifications

Set up notifications HTTP callbacks (webhooks) sent to an endpoint on your server. For general information on notifications, refer to Set up notifications. After you set up notifications, you will receive a REPORT_AVAILABLE notification when a new report has been generated. This notification contains the following fields:
- pspReference – the file name of the report.
- reason – the URL used to download the report.

https://docs.adyen.com/reporting/downloading-reports#713702106

JSON
SOAP

{
   "live":"false",
   "notificationItems":[
      {
         "NotificationRequestItem":{
            "amount":{
               "currency":"EUR",
               "value":0
            },
            "eventCode":"REPORT_AVAILABLE",
            "eventDate":"2018-04-18T10:03:08+02:00",
            "merchantAccountCode":"[merchantAccountCode]",
            "merchantReference":"",
            "pspReference":"settlement_detail_report_batch_12.csv",
            "reason":"https:\/\/ca-test.adyen.com\/reports\/download\/MerchantAccount\/[merchantAccountCode]\/settlement_detail_report_batch_12.csv",
            "success":"true"
         }
      }
   ]
}

<?xml version="1.0" encoding="UTF-16"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soap:Body>
        <sendNotification xmlns="http://notification.services.adyen.com">
            <notification>
                <live>true</live>
                <notificationItems>
                    <NotificationRequestItem>
                        <amount>
                            <currency xmlns="http://common.services.adyen.com">EUR</currency>
                            <value xmlns="http://common.services.adyen.com">0</value>
                        </amount>
                        <eventCode>REPORT_AVAILABLE</eventCode>
                        <eventDate>2018-04-18T10:03:08+02:00</eventDate>
                        <merchantAccountCode>[merchantAccountCode]</merchantAccountCode>
                        <merchantReference/>
                        <pspReference>settlement_detail_report_batch_12.csv</pspReference>
                        <reason>https://ca-test.adyen.com/reports/download/MerchantAccount/[merchantAccountCode]/settlement_detail_report_batch_12.csv</reason>
                        <success>true</success>
                    </NotificationRequestItem>
                </notificationItems>
            </notification>
        </sendNotification>
    </soap:Body>
</soap:Envelope>

Step 2: Download the report

Use TLS 1.2 when making GET requests.

Create a report API credential. Select a User type of Report user, and make sure that the Merchant Report Download role is assigned.
Set up basic authentication for your report API credential.
Download the report with an HTTP GET request. Include:
- The name of your report API credential, for example report@Company.[YourCompanyAccount],
- The basic authentication password for your report API credential.
- The URL from the reason field in the REPORT_AVAILABLE notification.

Here is how you would download the report for the API credential report@Company.[YourCompanyAccount]:

Merchant Account Reports:

$ wget --http-user='report@Company.[YourCompanyAccount]' --http-password='[BasicAuthPassword]' --quiet --no-check-certificate https://ca-test.adyen.com/reports/download/MerchantAccount/[YourMerchantAccount]/[ReportFileName]

Company Account Reports:

$ wget --http-user='report@Company.[YourCompanyAccount]' --http-password='[BasicAuthPassword]' --quiet --no-check-certificate https://ca-test.adyen.com/reports/download/Company/[YourCompanyAccount]/[ReportFileName]

Determine reports to download by parsing file names

You may not want to download every report that is generated. Parse the file name of the report to determine this. The following file naming conventions are used for our commonly downloaded reports:

Report type	File name format
Settlement details report	settlement_detail_report_batch_[Batch Number].csv Parameters: [Batch Number] – sequential number of the settlement batch
Aggregate settlement details report	settlement_report_aggregate_[yourAccountName]_[countrycode]_[additionalData]_[fromdate]_[untildate].csv Parameters: [yourAccountname] – Adyen company or merchant account name [countryCode] – First country code in case the report is limited to one or more merchant countries [additionalData] – Indicates whether aggregation by Store, Terminal, or both is enabled. Possible values: empty, "S", "T", or "ST". [fromdate] – The start date of report. Format: `yyyy-mm-dd` [untildate] – The end date of report. Format: `yyyy-mm-dd`
Payment accounting report	payments_accounting_report_[date].csv Parameters: [date] – the date for which the report is generated. Format: `yyyy_mm_dd`
Account Updater results report	account_updater_results__[additionalData]_[dateformat]_[fromdate]-[untildate].csv Parameters: [additionalData] - Indicates whether aggregation by Merchant, Acquirer, or Card scheme, or a combination of them, is enabled. Possible values: empty, M=Merchant, A=Acquirer, P=Card scheme. [dateformat] - Indicates the format of the selected date. M=month, W=Week number, D=Calendar day. [fromdate] – Start date of the report. Format: `yyyy-mm-dd` [untildate] – End date of the report. Format: `yyyy-mm-dd`
Dispute transaction details report	dispute_report_[date].csv Parameters: [date] – the date for which the report is generated. Format: `yyyy_mm_dd`

Encrypt report files (optional)

For additional security, you can optionally encrypt your report files with a PGP Key:

If you haven't already done so, generate a PGP key.
Register your PGP public key with Adyen, specifying Reports as the Purpose of the key.

All future generated reports will be encrypted with this PGP key.

Manually download a report

We recommend automating report downloads. For more information, see Automate downloading reports.

To download reports from your Customer Area, you need to have the Merchant Report role assigned to your user account. For more information on how to set this up, refer to User roles.

To download a report:

Log in to your Customer Area with your merchant-level account.
Go to Reports, and find the report that you want to download.
On the report page, enter a time-period for the generated report.

For the Settlement details report, enter a settlement batch number instead.
Click Generate.
After the report has generated, under Earlier generated reports, click the file name. The report will download.

Reports can take some time to process and generate.