👉 actuals.io
👉 contact us

Adyen

The Actuals Live connector for Adyen provides for the import of all Adyen transaction and payment details for reconciliation purposes on the Actuals Live platform. To achieve this, a reporting user needs to be created/used to download the payment accounting report on a daily basis. This report needs to be scheduled explicitly in Adyen’s user interface. The steps below illustrate how to setup the user, how to schedule the report and how to configure Actuals Live to collect the data periodically.

Company’s like Crisp, HelloPrint, Vanmoof and Tranzer already use this seamless integration within their finance and control setup. Are you next?

User access

To collect data from Adyen into Actuals Live, it is required that a report user is created in the Adyen environment. Typically a global user with global report access is aleady available in the account. This user has the value Reporting for User type name.

Adyen

Additionally a user can be created with this user type. Be sure to select the user type Reporting at the top. Be sure to copy / save the password for the new user as it is needed in the Actuals Live environment to setup the connection. Als be sure to save the user name, typically formatted as reporting_[XXX]@Company.[CompanyName]

Adyen

Update 2021 - credentials

Most accounts have been updated to show the menu below. In stead of creating a reporting user, API credentials should be clicked

Adyen

Click Add new credential and select Reporting user. Be sure to copy the password and to add all accounts to the user. As role be sure to select Merchant Report Download role. After saving, a user should be visible with an address like reporting_XXXX@Company.XXXX.

Update 2021 - separate user for downloading historical data

As the Adyen data integration depends on scheduled reports being available, we recommend creating a Actuals end user in the Adyen environment that can create and download historical data when needed. Note that this is a “regular” user and not a reporting user that only has access to the API. To create the user, take the following steps with an admin user he following 6 steps:

  1. Login via ca-adyen.com
  2. Go to Account > Users
  3. ‘Create new user’ on the right
  4. Add the the following details:
    a. Username: ActualsReportingUser
    b. Email: [Your Actuals contact]@actuals.io
  5. Select in the next screen: ‘company account and all associated merchant accounts’
  6. Select the following roles: General > Download reports, Generate Reports Merchant standard. If these are not available to you, please contact your Adyen admin.
  7. Complete the registration and share the credentials with Actuals.

Adyen

Schedule report

To schedule the payments and account report go to Finance > (Downloadable report >) Payment accounting. Click subsribe at the top to make sure Adyen makes the report availabe periodically. In the popup that appears, select CSV as format and click Save

Adyen

The button at the top of the page should have been changed from Subscribe to Unsubscribe. This indicates that the report is scheduled to be generated daily

Test / Validate

To validate that the setup has been completed successfully, open a browser in igcognito mode. Open a payments URL like this:

https://ca-live.adyen.com/reports/download/Company/[Company]/payments_accounting_report_[Date].csv

where Company is the name of you company (as used in the reporting user name) and Date is a date for which a payments report has been generated (formatted YYYY_mm_dd so 2021_07-28)

When opening the page username/password credentials are requested. Provide the reporting user name (reporting_[XXX]@Company.[CompanyName]) and the password that was created.

If the setup is correct, a CSV file will download with the payments details. If this is not correct, validate that

  • The url contains the correct company name
  • The url contains a date for which a payments report has been generated
  • The password is correct

Feel free to contact your Actuals contact for any question when the setup in Adyen cannot be completed succesfully.

Provide details in web app

To connect to the Adyen account the following parameters need to be provided to the source connection

  • Report URL. This can be either https://ca-test.adyen.com/ or https://ca-live.adyen.com/ based on the test or live environment that you want to collect data from
  • Account name: This value is used when login in on your Adyen account. It can also be found at the top right corner in the user interface. Be sure to use the account name and not a merchant ID
  • Username: as defined in the section User access, either a global reporting user can be used or a specifically created user can be used. Be sure to add the domain (e.g. `@Compamy.XXX`) to the username
  • Password: Similar to the username, should be stored when creating the account

To test the connection, submit the form and click test.

Result

If the connection is setup succesfully, the corresponding tile shows a green checkmark. Daily, typically between 2:00 and 5:00, data will be collected from Adyen and transformed as transactions in Actuals Live.