Reporting Manual Version: 2.22 Contact details Simon Carmiggeltstraat 6-50 1011 DJ Amsterdam P.O. Box 10095 1001 EB Amsterdam The Netherlands T +31 20 240 1240 E support@adyen.
Table of Contents 1. Introduction............................................................................................................................................................................................................................................................................................................................................... 5 2. Logging in to the Customer Area...........................................................................................................
Changelog Version Date Changes 2.22 2014-05-05 • • • • • • 2.21 2014-01-29 • Corrected typo in Type feld for Appendix A • Added note to Appendix A for changing data types per Type • Added Modifcation Merchant Reference to Appendix A 2.20 2013-12-11 • Manual updated to conform to Adyen brand guidelines 2.15 2013-09-16 • Added Payment Accounting Report / Dispute Report / Received Payment Detail Report to Appendix • Reworked feld specifcations in Appendices A-D 2.
Audience This is a technical manual aimed at IT personnel involved in integrating merchants' systems with those at Adyen. General Tips/Warnings Defensive Programming Adyen strongly recommends the use of “defensive programming” when integrating with the Adyen Services. This implies that automated decisions programmed into your systems should be defaulted to non-delivery of products and services.
1. Introduction Integrating Adyen's reporting is an easy process and provides a wealth of information for producing Business Intelligence. It is recommended that merchants, at a minimum, automate the retrieval and processing of the transaction-level subscription reports listed in section 6 Subscription Reports into their own database as part of their initial integration.
2. Logging in to the Customer Area To login to the Customer Area (CA) use https://ca-live.adyen.com/ for the LIVE environment and https://ca-test.adyen.com/ for the TEST environment. Please contact Adyen Support or your Account Manager if you have problems logging in. Upon logging into the CA, you will see a screen similar to the following: Reports can be accessed through the Reports menu option to the left of the screen.
A very powerful search function can be found under in the top-right corner. Here you can search for fraud scores, email addresses, order amounts, the last four digits of a card number, and many other data elements that you provided in the payment session, for example: • your Merchant Reference • the Adyen PSP number • shopperCountry:FR Click on the binoculars and then [help] to review more information regarding search criteria and tips.
3. Reports Adyen provides a number of reports at both the Company and Merchant Account levels. This section can be reached by clicking on the Reports menu on the left side in the customer area. Please note, the order of the individual report line items is not guaranteed and is subject to change. 3.1.
3.2. Conversion Reports When to use: • to get conversion data as it relates to country, platform, payment method and skins 3.3.
3.4. Subscription Reports When to use: • to activate your subscription to daily and/or monthly reports • to activate your subscription to settlement reports These reports are called subscription reports because you can subscribe to them, after which they will be generated periodically for separate retrieval. To activate subscriptions on reports please select the desired format and set the Status to active. Click on the Save button to keep your settings.
3.4.1. Daily/Monthly Finance Report This report is often referred to as the CFO-to-go report as it provides an overview of payment activity for the reporting period. The PDF version of the report includes: • a summary of the most relevant positions, such as payments received, sentforsettled and settled, as well as merchant payout and receivables from Adyen, including their composition • the payment method breakdown, merchant payouts, open balances (at the end of the reporting period), etc.
3.4.3. Dispute Report This report provides a list of all the payment dispute events that have occurred in the previous 24 hours. This includes events such as: Request For Information, Notifcation of Chargeback, Information Supplied and Chargebacks. Reporting level Merchant Account Level File naming convention dispute_report_YYYY_MM_DD.[csv/tsv] Document Format Comma-Separated Values (CSV) Tab-Separated Values (TSV) File Format Please refer to Appendix C 3.4.4.
3.5. Download Reports Once you have subscribed to the reports, they can be accessed in two ways. 3.5.1. Accessing subscription reports via a URL The generated reports can be downloaded from the following URL - substituting your merchant or company account names where indicated by [brackets]: https://ca-live.adyen.com/reports/download/MerchantAccount/[yourmerchantaccountname]/ https://ca-live.adyen.
Where: YCA = your company account YMA = your merchant account PWD = the password REP = the report name e.g. payment_report_batch_18.csv Please note, when new reports are published ,you will receive a notifcation to your Notifcation server by a HTTPS post or SOAP message, just as you receive payment notifcations. The status code is REPORT_AVAILABLE and the full download URL, defned above, is included in the notifcation.
4. RSS Reports (Feeds) A special type of report is available if you need up-to-the-minute information on your payment trafc, refusal rate and fraud scores. This report can be inserted in software that is RSS-enabled such as mail clients, web browsers or dedicated RSS readers. When to use: • get real-time transaction updates on your desktop • follow fraud scores There is a separate user for the RSS Report: rss@Company.
5. Finance Report File Defnition The Daily and Monthly Finance reports provide an overview of payment activity for the reporting period and is generated in your Primary Settlement Currency. 5.1.
5.2. Payment Balance Tab This tab provides you with a snapshot at the end of the reporting period so you know the exact value of the transactions at each status. The table groups together the line items for both the reporting period and the Year To Date (YTD)/Month To Date (MTD), up to and including the reporting period. All amounts are converted to the Primary Settlement Currency.
Field Name Description Captured –SentForSettle Payments for which the Capture request was sent to the Acquirer Captured –Settled Payments for which the Capture request was sent to the Acquirer and Adyen has received the funds Captured –CaptureFailed Payments for which the Acquirer declined the Capture request Captured –SentForRefund Payments for which the Refund request was sent to the Acquirer Captured –Refunded Payments for which the Acquirer has confrmed that the Refund request has been succes
Field Name Description Payable – MerchantPayout Total amount of funds settled to your bank account Payable – MerchantPayoutFailed The total amount of settlements to your bank that have failed during the reporting period Payable – ManualCorrected The total amount of any manually corrected funds, such as discounts Payable – Other Any miscellaneous bookings which have been placed in your Payable batch Payable – End Balance Payments where the last status for the reporting period is “Settled” and fund
6. Matching Settlements using the Settlement Detail Report Payments are settled periodically to your bank account, where you will see a statement line like the following: 28-24-2013 By 1323.94.782 ADYEN Add EUR 1842.21 TX4313726XT batch 4, [yourmerchantaccountname] The felds have the following meaning: • 1323.94.782 is Adyen's Dutch settlement bank account. Depending on the country and currency of settlement this number may be diferent.
5 Merchant Payout (one or multiple lines) 6.1. SupportAdyen,SupportAdyenDemo,,,,2013-06-11 04:55:40,BST,MerchantPayout,"TX977148886XT batch 7, SupportAdyenDemo batch 7, SupportAdyenDemo",EUR,,,,GBP,22.50,,,,,,,,,,,,,,, Settlement Detail Report Line Items (Transaction Lines) For every transaction there is a line item that describes the status of the transaction and why it was included in the settlement batch. For example, Settled or Refunded.
6.5. Settlement Detail Report Transfer Line This is the line item that indicates the transfer of funds to your bank account. The Net Debit feld is the total amount paid out to your account, followed by the currency. SupportAdyen,SupportAdyenDemo,,,,2013-06-11 04:55:40,CET ,MerchantPayout,"TX977148886XT batch 7, SupportAdyenDemo batch 7, SupportAdyenDemo",EUR,,,,GBP,22.50,,,,,,,,,,,,,,, In this example Adyen has paid out 1842.
7. Reading Your Invoice Invoicing is typically run at the Company Account level but if you needs require it, it can also be run at the Merchant Account level. Your monthly invoice contains a full specifcation of the costs of payment processing for that month. 7.1. How to Read Your Invoice Every regular transaction can include two cost types: • Adyen's transaction fees per transaction, typically starting at EUR 0.
The Still Due amount may be either positive or negative, the Payment instructions section will advise you of the next steps to correct any diferences. In either case the diference will be rectifed in the next settlement batch.
The 'already deducted' table on page 2 of your invoice contains the total charges already deducted from earlier settlements. These amounts are also present in the settlement reports so you can verify the charges. As they are only estimates of the fnal charges and don't use a volume tier discount this table is simpler than the 'calculated' table above.
8. Report Timing The timing for the Received Payment Detail and Payment Accounting reports can be changed so that they are generated at midnight of the company's timezone. For eaxmple, if your company account is set to EST, these reports will be generated at midnight EST. The Settlement Detail Report is generated when Adyen initiates a Payout to your bank account(s). For all other reports, the report generation process is initiated at 04:00 CET and cannot be changed.
9. Frequently Asked Questions Q: Can I receive reports automatically by email? A: To receive reports by email please implement the desired functionality in your notifcation listener. Adyen ofers no support to send reports by email directly. This has to be implemented by your integration partner or IT department. Q: I queued a report. When will it be available? A: Typically queued reports will be available within 5 to 10 minutes, depending on the length of the queue. Q: I marked a report as active.
Appendix A: Settlement Detail Report File Format Position Column Name Data Type Description 1 Company Account C X80 The static name of your company account within the Adyen system. 2 Merchant Account C X80 The static name of the merchant account that was used to process the original payment request. The report may contain line items for multiple merchant accounts.
Position 10 Column Name Gross Currency* Data Type A3 C X80* 11 Gross Debit* F C X80* 12 Gross Credit* F C X80* Description This is the three character ISO code for the currency which was used for processing the payment (transaction currency). The gross debit amount; this is the amount submitted in the transaction request. For example, 100.00. The gross credit amount; this is the amount submitted in the transaction request. For example, 100.00.
Position Column Name Data Type Description 24 Reserved4 Reserved for future enhancements 25 Reserved5 Reserved for future enhancements 26 Reserved6 Reserved for future enhancements 27 Reserved7 Reserved for future enhancements 28 Reserved8 Reserved for future enhancements 29 Reserved9 Reserved for future enhancements 30 Reserved10 Reserved for future enhancements Legend: Reports are generated using UTF-8 encoding.
Appendix B: External Settlement Detail Report File Format Position Column Name Data Type Description 1 Company Account C X80 The static name of your company account within the Adyen system. 2 Merchant Account C X80 The static name of the merchant account that was used to process the original payment request. The report may contain line items for multiple merchant accounts.
Position 9 Column Name Modifcation Reference Data Type N Description In most instances, this is Adyen's unique 16 digit code child reference that is associated with the modifcation request (capture, refund, chargebacks, etc). This will be returned to you via the direct soap response of the modifcation request and the notifcation server.
Position Column Name Data Type Description 21 Payment Method Variant C X30 The payment method sub-type of the payment which was processed. For example: visa classic, mc, amex. 22 Acquirer C X80 The name of the Acquirer that processed the original payment. For example: Cielo, Redecard. 23 MID C X50 The merchant ID from the Acquirer that was used for processing the payment.
Appendix C: Dispute Report File Format Position Column Name Data Type Description 1 Company Account C X80 The static name of your company account within the Adyen system. 2 Merchant Account C X80 The static name of the merchant account that was used to process the original payment request. The report may contain line items for multiple merchant accounts.
Position Column Name Data Type Description 13 RFI Reason Code C X30 The Request for Information reason code as provided by the bank or payment method. The mapping is defned by the scheme/institution (see previous column). This is blank if no RFI was issued. 14 CB Scheme Code C X30 The payment method scheme/institution which issued the code in the following column. E.g.
Position Column Name Data Type Description 27 Shopper Email C X256 The email address of the shopper/consumer as provided during the original transaction (if available) 28 Shopper Reference C X256 The supplied customer id/reference as supplied in the original transaction 29 Shopper PAN AN X80 The account number of the shopper/consumer. In case of card payments, the last four digits of the card number.
Appendix D: Payment Accounting Report File Format Position Column Name Data Type Description 1 Company Account C X80 The static name of your company account within the Adyen system. 2 Merchant Account C X80 The static name of the merchant account that was used to process the original payment request. The report may contain line items for multiple merchant accounts.
Position Column Name Data Type F Description 14 Captured (PC) The amount (in Payment Currency) debited or credited on the Captured accounting register. 15 Settlement Currency A3 The three character ISO code for the currency which was used when settling the payment. 16 Payable (SC) F The amount (in Settlement Currency) debited or credited on the Payable accounting register (i.e. funds which will be paid out to your bank account).
Position 33 Column Name Reserved10 Data Type Description Reserved for future enhancements Legend: See Appendix A: Settlement Detail Report File Format 39 / 42 Reporting Manual
Appendix E: Received Payment Detail Report File Format Position Column Name Data Type Description 1 Company Account C X80 The static name of your company account within the Adyen system. 2 Merchant Account C X80 The static name of the merchant account that was used to process the original payment request. The report may contain line items for multiple merchant accounts.
Position Column Name Data Type Description 18 Issuer ID AN 30 The unique identifer of the issuer. In case of card payments this will be the issuer BIN (frst 6 digits of the card number). 19 Issuer City C X80 The city of the issuer (if available) 20 Issuer Country A2 The ISO country code of the issuer 21 Acquirer Response A X30 The normalised response from the acquirer. Not necessarily the fnal status of the payment.
Position Column Name Data Type Description 38 Delivery Postal Code / Zip Code C X30 The zip code or postal code part of the delivery address 39 Delivery State / Province C X256 The state or province of the delivery address 40 Delivery Country 41 Acquirer Reference C X256 Reference number for the transaction provided by the acquirer 42 Payment Method Variant C X30 The payment method sub-brand, or the main payment method if not available (e.g.