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?
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.
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]
Most accounts have been updated to show the menu below. In stead of creating a reporting user, API credentials should be clicked
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.
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:
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
The button at the top of the page should have been changed from
Unsubscribe. This indicates that the report is scheduled to be generated daily
To validate that the setup has been completed successfully, open a browser in igcognito mode. Open a payments URL like this:
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
Feel free to contact your Actuals contact for any question when the setup in Adyen cannot be completed succesfully.
To connect to the Adyen account the following parameters need to be provided to the source connection
To test the connection, submit the form and click test.
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.