Reporting Manual
Reporting Manual Version: 2.24 Contact details Simon Carmiggeltstraat 6-50 1011 DJ Amsterdam P.O. Box 10095 1001 EB Amsterdam The Netherlands T +31 20 240 1240 E [email protected] Table of Contents 1. Introduction...............................................................................................................................................................................................................................................................................................................................................5 2. Logging in to the Customer Area..................................................................................................................................................................................................................................................................................................6 2.1. Interactive Searching And Filtering.............................................................................................................................................................................................................................................................................6 3. Reports.........................................................................................................................................................................................................................................................................................................................................................8 3.1. Instant Reports.........................................................................................................................................................................................................................................................................................................................8 3.2. Conversion Reports................................................................................................................................................................................................................................................................................................................9 3.3. Risk Reports................................................................................................................................................................................................................................................................................................................................9 3.4. Subscription Reports..........................................................................................................................................................................................................................................................................................................10 3.4.1. Daily/Monthly Finance Report.......................................................................................................................................................................................................................................................................11 3.4.2. (External) Settlement Detail Report..........................................................................................................................................................................................................................................................11 3.4.3. Dispute Report........................................................................................................................................................................................................................................................................................................12 3.4.4. Payment Accounting Report............................................................................................................................................................................................................................................................................12 3.4.5. Received Payment Detail Report..................................................................................................................................................................................................................................................................12 3.5. Download Reports...............................................................................................................................................................................................................................................................................................................13 3.5.1. Accessing subscription reports via a URL...............................................................................................................................................................................................................................................13 3.5.2. Accessing subscription reports via CA.......................................................................................................................................................................................................................................................13 3.5.3. Automating Report Retrieval..........................................................................................................................................................................................................................................................................13 4. RSS Reports (Feeds)...........................................................................................................................................................................................................................................................................................................................15 5. Finance Report File Definition....................................................................................................................................................................................................................................................................................................16 5.1. Overview Tab...........................................................................................................................................................................................................................................................................................................................16 5.2. Payment Balance Tab.........................................................................................................................................................................................................................................................................................................17 5.3. Other Tabs.................................................................................................................................................................................................................................................................................................................................19 6. Matching Settlements using the Settlement Detail Report......................................................................................................................................................................................................................................20 6.1. Settlement Detail Report Line Items (Transaction Lines)............................................................................................................................................................................................................................21 6.2. Settlement Detail Report Transaction Fees..........................................................................................................................................................................................................................................................21 6.3. Deposit Correction Line....................................................................................................................................................................................................................................................................................................21 6.4. Invoice Correction Line.....................................................................................................................................................................................................................................................................................................21 6.5. Settlement Detail Report Transfer Line..................................................................................................................................................................................................................................................................21 6.6. Multi-currency Transactions...........................................................................................................................................................................................................................................................................................22 6.7. How to Match..........................................................................................................................................................................................................................................................................................................................22 7. Reading Your Invoice.........................................................................................................................................................................................................................................................................................................................23 7.1. How to Read Your Invoice................................................................................................................................................................................................................................................................................................23 7.2. Invoice Layout........................................................................................................................................................................................................................................................................................................................23 7.2.1. Invoice Summary Page........................................................................................................................................................................................................................................................................................23 7.2.2. Invoice Detail Page...............................................................................................................................................................................................................................................................................................24 8. Report Timing.......................................................................................................................................................................................................................................................................................................................................26 9. Frequently Asked Questions.........................................................................................................................................................................................................................................................................................................27 Appendix A: Settlement Detail Report File Format.............................................................................................................................................................................................................................................................28 Appendix B: External Settlement Detail Report File Format.........................................................................................................................................................................................................................................31 Appendix C: Dispute Report File Format...................................................................................................................................................................................................................................................................................34 Appendix D: Payment Accounting Report File Format.......................................................................................................................................................................................................................................................38 Appendix E: Received Payment Detail Report File Format.............................................................................................................................................................................................................................................41 2 / 43 Reporting Manual Changelog Version Date Changes 2.24 2015-03-18 • Added Notification of Fraud columns in the Daily Dispute Report 2.23 2014-11-05 • Added new Types to Appendix A and Appendix B 2.22 2014-05-05 • • • • • • 2.21 2014-01-29 • Corrected typo in Type field for Appendix A • Added note to Appendix A for changing data types per Type • Added Modification 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 field specifications in Appendices A-D 2.12 2013-06-11 • Updated example line items to reflect latest file format • Added Settlement Report and External Settlement Report to Appendix 2.11 2012-06-26 • Added Dispute Report 2.10 2011-12-23 • Added Deposit and Invoice correction lines to the Settlement Report explanation 2.03 2011-03-22 • Added information on multicurrency transactions in settlement report 2.02 2010-08-13 • Changed screenshots to reflect current default skin look & feel 2.01 2010-08-10 • Added changelog and audience sections • Manual reviewed for English and layout consistency 3 / 43 Reporting Manual Added new Type AuthorisationSchemeFee to Appendix A Corrected file naming convention for the External Settlement Detail Report Updated “type” field definition in Appendix B Updated file format for Appendix B Updated file format for Appendix C Updated shopper PAN description in Appendix E ADYEN CONFIDENTIAL INFORMATION Copyright (c) Adyen B.V. 2013 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. In other words, program your systems to only deliver products and/or services after receiving an explicit authorisation of the requested payment and NOT to deliver in situations where an explicit rejection is not received. Feedback The latest version of this document is available here: https://support.adyen.com/links/documentation You can provide feedback about this document by sending an email to the following address: [email protected] We appreciate your comments. 4 / 43 Reporting Manual 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. The most important types of reports that Adyen offers are: • Interactive searching and filtering in the customer area • Instant reports and graphs in the customer area for viewing or downloading • Subscription reports which are generated periodically • RSS Reports 5 / 43 Reporting Manual 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://catest.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. Interactive searching and filtering can be done via the Payment Search input box at the top right of the screen. See chapter 3 for more information on this topic. 2.1. Interactive Searching And Filtering In addition to initiating the interactive payment search from the home page, you may also search from the Payments screen: When to use: • finding single transactions • locating customer history • finding patterns visually The easiest way to find detailed information regarding transactions is to search in the CA. From the Payments screen you may filter the displayed results by clicking on the funnel next to the column headers. There are a number of filtering options available including the ability to search for all payments submitted during a specific time frame, a specific transaction status or a specific payment method, to name a few. 6 / 43 Reporting Manual A very powerful search function can be found under <search for payments> 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. 7 / 43 Reporting Manual 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. Instant Reports When to use: • to get a graphical transaction history overview • to get a quick downloadable report All of the reports and graphs in this section are generated in real-time using your transaction history. 1 1 Please note, the real-time reporting is run on a copy of the live database to ensure optimum performance of transaction processing. There may be a slight delay in data being made available to the reporting database but it is typically no more than a few seconds behind the LIVE database. You can check this on the home page under 'Backoffice up-to-date till'. 8 / 43 Reporting Manual 3.2. Conversion Reports When to use: • to get conversion data as it relates to country, platform, payment method and skins 3.3. Risk Reports When to use: • to get an understanding of your risk profile as it pertains to chargebacks 9 / 43 Reporting Manual 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. This process must be repeated for each report subscription. Reports cannot be downloaded from this page directly; once subscribed they will typically be generated overnight, CET, and will be available the day of its scheduled availability. There are a number of key reports that you may consider subscribing to. They are highly detailed and offer different views into your payment data as stored in the Adyen system. 10 / 43 Reporting Manual 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. The spreadsheet version of the report includes: • the data that is in the PDF version of the report • the open balances, at the time that the report was generated, broken down by payment methods and currency Reporting level Company and/or Merchant Account Level File naming convention Monthly: monthly_finance_report_YYYY_MM.[xls/ods/pdf] Daily: daily_finance_report_YYYY_MM_DD.[xls/ods/pdf] Document Format PDF and/or spreadsheet (ODS or XLS) File Format Please refer to Appendix A 3.4.2. (External) Settlement Detail Report This report is generated upon settlement of funds to your bank account, typically twice a week. This is a transaction level report that specifies the gross/net settlement amounts for captures, refunds and, where present, chargebacks. Fee totals and deposit corrections are also specified as well as the total amount settled. It is generally used for reconciliation purposes. Depending upon the service that you have enabled on your account, you may see either the Settlement Detail Report, External Settlement Detail Report or a combination of both. In the case of the External Settlement Detail Report, you will see a separate file per Acquirer. Reporting level Settlement Detail Report level: Merchant Account Level External Settlement Detail Report: Company Level File naming convention Settlement Detail Report: settlement_detail_report_batch_[batch#].[csv/tsv/xml] External Settlement Detail Report: external_settlement_detail_report_with_info_batch_[batch#]_[Acquirer]_YYYYMMDD. [csv/tsv/xml] Document Format Comma-Separated Values (CSV) Tab-Separated Values (TSV) XML & XML altermative (XML) File Format Settlement Detail Report: Please refer to Appendix A External Settlement Detail Report: Please refer to Appendix B 11 / 43 Reporting Manual 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, Notifications of Fraud, Notification 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. Payment Accounting Report A report of all the financial status changes, events and modifications on a given day for all payments including full bookkeeping and user auditing (audit for manual capture/cancel/refund and callcenter use or when using multiple web service users). This report is ideal if you want to maintain a copy of all available status changes in your own database to replicate Adyen's accounting data for financial reporting. Reporting level Company and/or Merchant Account Level File naming convention payments_accounting_report_YYYY_MM_DD.[csv/tsv] Document Format Comma-Separated Values (CSV) Tab-Separated Values (TSV) File Format Please refer to Appendix D 3.4.5. Received Payment Detail Report This report provides the details of all payments processed on a given day and includes all payments which were authorised, refused or ended in error. The report contains a high level of detail, including information not communicated via the notification system, such as fraud scoring, (bank) account information, etc. This report is ideal if you want to maintain a copy of all available data in your own database. Reporting level Merchant Account Levels File naming convention received_payments_report_YYYY_MM_DD.[csv/tsv] Document Format Comma-Separated Values (CSV) Tab-Separated Values (TSV) File Format Please refer to Appendix E 12 / 43 Reporting Manual 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.com/reports/download/Company/[yourcompanyaccountname]/ To identify the values for your Company and Merchant Account names, look at the left corner of the CA. The top-level name is your Company Account name, and under that name are your Merchant Account Names. The Adyen notification system will also send you a notification with the exact location of the report generated on a specific day. For example: https://ca-live.adyen.com/reports/download/MerchantAccount/SupportAdyen/settlement_detail_report_batch_121.csv 3.5.2. Accessing subscription reports via CA You may also access the reports from the Reports → Download tab in the CA. 3.5.3. Automating Report Retrieval The URLs above use HTTP authentication and can be used for automated retrieval. The username is always report@Company.[yourcompanyaccountname] and the password can be set under Settings -> Users. If you cannot use the “@” in the user name you can use the “%” character instead. An easy way to accomplish this from the command-line is to use wget: $ wget --http-user=report%Company.YCA --http-password=PWD --quiet --no-check-certificate https://ca-live.adyen.com/reports/download/MerchantAccount/YMA/REP Where: YCA = your company account 13 / 43 Reporting Manual 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 notification to your Notification server by a HTTPS post or SOAP message, just as you receive payment notifications. The status code is REPORT_AVAILABLE and the full download URL, defined above, is included in the notification. 14 / 43 Reporting Manual 4. RSS Reports (Feeds) A special type of report is available if you need up-to-the-minute information on your payment traffic, 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.[yourcompanyaccountname] You may fetch the RSS Feed from the following URL - substituting your merchant or company account names where indicated by [brackets]: https://ca-live.adyen.com/reports/rss/lasttxrss/MerchantAccount/[yourmerchantaccountname]/ https://ca-live.adyen.com/reports/rss/lasttxrss/Company/[yourcompanyaccountname]/ If you use the Company account the RSS Feed contains all transactions aggregated for the Company. Feeds are also present in the customer area. When you see the familiar orange RSS icon, you can use that to import the RSS feed directly into your browser. At present Adyen offers two RSS feeds: lasttxrss Number of payments (authorised, refused and total) per hour for the past 24 hours authorisedtxrss Yesterday's (and the day before yesterday's) total amount authorised per currency, number of transactions and average transaction value. 15 / 43 Reporting Manual 5. Finance Report File Definition 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. Overview Tab Field Name Description Account Type The value will be either “MerchantAccount” or “CompanyAccount” indicating the reporting level Account Code This will be either the your Company Account name or your Merchant Account name depending upon the reporting level Adyen Settlement Indicates the settled amount, in the primary settlement currency, for transactions where Adyen is in the money flow External Settlement Indicates the settled amount, in the primary settlement currency, for transactions where Adyen is not in the money flow Total in [Primary Settlement Currency] Indicates the total amount for the line item, in the primary settlement currency Row Definition Payments received on/in [Period] The total value of the payment requests received by the Adyen platform Payments authorised on/in [Period] The total value of the authorised payments for the reporting period Amount sent for settle on/in [Period] The value of the transactions that had the status SentForSettle during the course of the reporting period. By the end of the period some of these transactions may have a status Settled, SentForSettle or CaptureFailed. Amount sent for refund on/in [Period] The value of the transactions that had the status SentForRefund during the course of the reporting period. By the end of the period some of these transactions may have a status of Refunded, SentForSettle or RefundFailed. Total amount paid out on/in [Period] The total amount of the transactions that were settled to your bank account during the period. Total receivables from Adyen at end of [Period] Total of the Open captured balance, Open payable balance, and Deposit. Open captured balance (gross) The total value of the transactions that are in SentForSettle status at the end of the period. This is the gross amount. Open payable balance The total value of the transactions where Adyen has received the funds from the bank and is holding the funds until the next settlement batch. This is the net amount, minus the commission fees. Deposit The amount withheld by Adyen 16 / 43 Reporting Manual 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. Please note, due to variances in the exchange rate, the Opening Balance may not match the Closing Balance from the previous period. Field Name Description Count The number of transactions that make up the line item [Primary Settlement Currency] The three character ISO code for the Primary Settlement Currency. All amounts in this column are converted to this currency Check Exchange rates in this report are end of month, mid rates, these are shown on the ExchangeRates tab of the spreadsheet. For your convenience, multi-currency transactions are converted to the primary settlement currency using the end of month rates. Due to fluctuations in exchange rates during the month, there may be some valuation differences, these will be shown in this field. This is due to fluctuations in the exchange rates during the month. For the avoidance of doubt, this amount does not represent gains or losses due to currency conversion. Row Definition Received – Open Balance Shows the End Balance carried forward from the previous period Received – Received Payments received by the Adyen platform Received – Refused Payments that resulted in a refusal, either from the Adyen fraud tool or from the Acquirer Received – Error Payments that resulted in an error Received – Authorised Payments that resulted a successful authorisation Received – End Balance Payments where the last status for the reporting period is “Received” Authorised – Opening Balance Shows the End Balance carried forward from the previous period Authorised –Authorised Payments that resulted a successful authorisation Authorised –Cancelled Payments that were cancelled at the request of the merchant Authorised –Expired Payments for which a Capture request was not received and the system marks the transaction as Expired Authorised –SentForSettle Payments for which the Capture request was received. Transactions where Adyen is in the money flow are included here Authorised –SentForSettleExternally Payments for which the Capture request was received. Transactions where Adyen is not in the money flow are included here Authorised – End Balance Payments where the last status for the reporting period is “Authorised” Captured – Opening Balance Shows the End Balance carried forward from the previous period 17 / 43 Reporting Manual 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 confirmed that the Refund request has been successfully executed Captured –RefundFailed Payments for which the Acquirer declined the Refund request Captured – End Balance Payments where the last status for the reporting period is “SentForSettle” Captured Externally – Opening Balance Shows the End Balance carried forward from the previous period Captured Externally –SentForSettle Payments for which the Capture request was sent to the Acquirer Captured Externally – SettledExternally Payments for which the Capture request was sent to the Acquirer and Adyen is not in the money flow. Captured Externally –CaptureFailed Payments for which the Acquirer declined the Capture request Captured Externally –SentForRefund Payments for which the Refund request was sent to the Acquirer Captured Externally – RefundedExternally Payments for which the Acquirer has confirmed that the Refund request has been successfully executed Captured Externally –RefundFailed Payments for which the Acquirer declined the Refund request Captured Externally – End Balance Payments where the last status for the reporting period is “SentForSettle” Payable – Opening Balance Shows the End Balance carried forward from the previous period Payable – Settled Payments for which the Capture request was sent to the Acquirer and Adyen has received the funds Payable – Refunded Payments for which the Acquirer has confirmed that the Refund request has been successfully executed Payable – Fee already charged This is the transaction fee that Adyen has already deducted from the settlements during the month Payable – Chargeback Payments that have a final transaction status of Chargeback Payable – ChargebackReversed Payments that have a final transaction status of ChargebackReversed Payable – RefundedReversed Payments where the Issuer was unable to provide the refunded funds to their account holder and the funds have been returned to Adyen Payable – DepositCorrection Amount needed to adjust the deposit Payable – InvoiceDeduction The total amount of invoiced fees deducted from your settlement during the reporting period 18 / 43 Reporting Manual 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 funds are being held until the next settlement batch Deposit – Opening Balance Shows the End Balance carried forward from the previous period Deposit – End Balance Shows the updated deposit amount Commission – Settled The total payment method commission which is charged during the month on Settled. Commission – Refunded The total payment method commission which is charged during the month on Refunded. Commission – Chargeback The total payment method commission which is charged during the month on Chargebacked. Commission – ChargebackReversed The total payment method commission which is charged during the month on ChargebackReversed. Commission – ManualCorrected The total payment method commission which is charged during the month on ManualCorrecteds. Commission – Total commission The total amount of all commissions. Fee – Total Calculated This is the total Adyen transaction fee which is calculated during this month. You can calculate this yourself (Received + SentForRefund )* Your Adyen Transaction fee Check sum/multicurrency difference Exchange rates in this report are end of month, mid rates, these are shown on the ExchangeRates tab of the spreadsheet. For your convenience, multi-currency transactions are converted to the primary settlement currency using the end of month rates. Due to fluctuations in exchange rates during the month, there may be some valuation differences, these will be shown in this field. This is due to fluctuations in the exchange rates during the month. For the avoidance of doubt, this amount does not represent gains or losses due to currency conversion. 5.3. Other Tabs The other tabs in the spreadsheet contain the raw data used to calculate the summary data shown in sections 5.1 and 5.2. 19 / 43 Reporting Manual 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 fields 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 different. • The payment originates from ADYEN which is the Adyen Client Management Foundation that receives and settles your payments. • TX4313726XT is the internal Adyen reference and has no direct meaning to the merchant. • The batch number, batch 4 in this case, is the sequence number of the settlement, which started at 1 for the first settlement and increments with every settlement. • 1842.21 is the total amount of the settlement – this amount matches the payout amount in the Settlement Detail Report. The batch number in the settlement to your bank corresponds with the batch number in the Settlement Detail Report. For example: https://ca-live.adyen.com/reports/download/MerchantAccount/ [yourmerchantaccountname]/settlement_report_batch_4.csv The Settlement Detail Report itself consists of five sections: 1 Column descriptions (one line) 2 Transaction details (multiple lines) Company Account, Merchant Account, Psp Reference, Merchant Reference, Payment Method, Creation Date, TimeZone, Type, Modification Reference, Gross Currency, Gross Debit (GC), Gross Credit (GC), Exchange Rate, Net Currency, Net Debit (NC), Net Credit (NC), Commission (NC), Markup (NC), Scheme Fees (NC), Interchange (NC), Payment Method Variant, Reserved2, Reserved3, Reserved4, Reserved5, Reserved6, Reserved7, Reserved8, Reserved9, Reserved10 SupportAdyen,SupportAdyenDemo,1813702551707653,3vpzf7,visa,2013-06-03 11:26:49,BST,Settled,1713702551795048,GBP,,5.00,1,GBP,,4.88,,0.04,0.01,0.07,visacl assic,,,,,,,,, [...] 3 Transaction fees (one or multiple lines) 4 Corrections (one or multiple lines) 20 / 43 Reporting Manual SupportAdyen,SupportAdyenDemo,,,,2013-06-11 04:55:40,BST,Fee,Transaction Fees May 2013,EUR,,,,GBP,1.46,,,,,,,,,,,,,,, SupportAdyen,SupportAdyenDemo,,,,2012-05-10 05:37:03,CEST,DepositCorrection,Deposit Correction,EUR,,,,EUR,78.93,,,,,,,,,,,,,,, 5 Merchant Payout (one or multiple lines) SupportAdyen,SupportAdyenDemo,,,,2013-06-11 04:55:40,BST,MerchantPayout,"TX977148886XT batch 7, SupportAdyenDemo batch 7, SupportAdyenDemo",EUR,,,,GBP,22.50,,,,,,,,,,,,,,, 6.1. 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. SupportAdyen,SupportAdyenDemo,1813702551707653,3vpzf7,visa,2013-06-03 11:26:49,CET,Settled,1713702551795048,GBP,,5.00,1,GBP,,4.88,,0.04,0.01,0.07,visaclassic,,,,,, ,,, Here is an example of a chargeback line item: SupportAdyen,SupportAdyenDemo,1313642467023511,324959451,visa,2013-03-26 22:37:26,CET,Chargeback,2313642467170922,EUR,349.99,,1,EUR,357.49,,7.5,,,,visaclassic,,,,,,,, , 6.2. Settlement Detail Report Transaction Fees A transaction fee line item is included for each month where there are transactions present in the settlement batch. Here is an example of the transaction fee line item: SupportAdyen,SupportAdyenDemo,,,,2013-06-11 04:55:40,CET,Fee,Transaction Fees May 2013,EUR,,,,GBP,1.46,,,,,,,,,,,,,,, 6.3. Deposit Correction Line Adyen may require a deposit, this is filled by withholding settlements until the deposit amount is met. The deposit is a variable amount which may increase or decrease periodically due to changing risk figures. In this situation a DepositCorrection line item is included in the settlement report which can have a credit or debit amount to reflect the change in deposit amount: SupportAdyen,SupportAdyenDemo,,,,2012-05-10 05:37:03,CET,DepositCorrection,Deposit Correction,EUR,,,,EUR,78.93,,,,,,,,,,,,,,, 6.4. Invoice Correction Line At month end Adyen calculates the final invoice amount and the situation may arise where we have either charged you too much or too little, this can happen where you have tiered pricing. To correct this we book an InvoiceDeduction line item in the settlement report: SupportAdyen,SupportAdyenDemo,,,,2013-05-10 12:59:53,CET,InvoiceDeduction,Invoice 201111000553,EUR,,,,EUR,,250.22,,,,,,,,,,,,,, The 'Invoice 201111000553' refers to the Invoice number that is present in the Invoice of that month. The amount may appear in with the debit or credit columns. 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 field is the total amount paid out to your account, followed by the currency. 21 / 43 Reporting Manual 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.21 EUR to the SupportAdyenDemo merchant account and the value “TX4313726XT batch 4, SupportAdyenDemo” will be displayed on the bank statement. 6.6. Multi-currency Transactions If you have multiple settlement currencies, the Settlement Detail Report w ill contain a Merchant Payout line for each applicable settlement currency. If a settlement batch contains transactions with processing currencies other than the settlement currency, then these gross amounts are converted to the net amount in the settlement currency. For example, if your settlement currency is EUR but you also process payments in SEK, you will see both currencies and amounts in the reports, including the exchange rate used to convert the processing amount to the settlement amount. To find out which exchange rate has been used, please consult Adyen's daily Exchange Rate Report. 6.7. How to Match Depending on your implementation you may store one or more keys per transaction. This could be a merchant transaction identifier as generated by your system and passed to Adyen via the MerchantReference field, or it could be the Adyen generated PSP Reference. Adyen's reports contain both references so you can easily tie the report line items back to the individual transactions in your systems. We recommend automating the matching process; here are some steps you can take: • Checking your bank statements against the settlement records: ◦ Identify the line item in your bank statement that contains the TX...XT description and batch number ◦ Identify the corresponding Settlement Detail Report ◦ Verify the amount of the deposit matches the amount indicated in the Settlement Detail Report • Using the Settlement Detail Report line items, update each transaction in your system with the status as indicated in the Report; for example, settled, refunded or chargeback • Optional: ◦ You can choose to add a batch number field to your transaction table so that you can also reverse-lookup a transaction ◦ You may also choose to store the settled amount so you know the costs per transaction A fully automated system will leave no room for errors or 'lost transactions' and will make your bookkeeping system 100% correct as far as Adyen's transactions are concerned. 22 / 43 Reporting Manual 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 specification 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.10 per transaction and then decreasing as volume increases • The bank or card commissions which is a percentage and/or a fixed fee. In some cases these fees also decrease as volume increases Adyen typically settles funds to your bank account twice a week, this is the transaction amounts minus any refunds and/or chargebacks. Adyen uses net settlement meaning that all fees, as mentioned above, are already deducted from your settlement batch. The accompanying settlement reports contain a detailed calculation and justification. Because the actual fees per transaction depend on the total volume processed during a given month the 'intermediary' amounts deducted from the settlements can vary slightly from the actual amounts due. Only at the end of the month are we able to calculate the final amounts. Therefore an invoice always contains two 'totals': the amount already deducted and the final calculated amounts. The resulting difference is settled with your next batch using the Invoice Correction Line defined in section 6.4. 7.2. Invoice Layout Your invoice typically consists of at least two pages: • A header page which summarises last month's transaction fees and commissions • A detail page with tables for calculated and already deducted amounts, as explained above • Optionally, you may choose to have your invoice broken out by Merchant Account, in which case you will have an additional page per Merchant Account 7.2.1. Invoice Summary Page The screenshot below shows that there is difference between the amount deducted during the course of the month and the final calculated amount. The Still Due amount may 23 / 43 Reporting Manual be either positive or negative, the Payment instructions section will advise you of the next steps to correct any differences. In either case the difference will be rectified in the next settlement batch. Here are some of the causes of differences in calculated and collected fees: • Tiered pricing – during the month you will be charged at the lowest tier • For transactions that occur during the last few days of the month the transaction fee will be charged in the current month and the commission fees may be charged in the following month • Any changes to pricing during the month 7.2.2. Invoice Detail Page The second page contains a table that shows how the totals on the Summary page were calculated. The resulting amount in the bottom-right cell equals the Invoice Total excluding VAT. This is the result of the final calculation of transaction fees based upon tier and volume discounts If this column contains a '*' and not a fixed amount, the calculation is done on a pertransaction interchange-plus basis instead of using a fixed “blend” rate = Transaction Fees + Bank/Card Commission In this context “Blend” indicates that there is a fixed commission (either % or a fixed amount) for all transactions of this kind, as opposed to interchange-plus based pricing 24 / 43 Reporting Manual 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 final charges and don't use a volume tier discount this table is simpler than the 'calculated' table above. 25 / 43 Reporting Manual 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. 26 / 43 Reporting Manual 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 notification listener. Adyen offers 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. When will it be available? A: Subscription reports are generated nightly in batches so if you mark a report as active it will be available after the next schedule run time for that report type. 27 / 43 Reporting Manual 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. 3 Psp Reference N 16 This is Adyen's 16 digit unique reference number for the payment; it denotes the PSP reference for the original authorisation request. 4 Merchant Reference C X80 This is the reference number that was provided when initiating the payment request. 5 Payment Method C X30 The payment method type of the payment which was processed. For example: visa, mc, amex. 6 Creation Date 7 TimeZone D+” “+T A4 The timestamp of when the payment was received by the Adyen system. The format is YYYY-MM-DD HH:MM:SS, for example: 2012-0726 19:58:55. The time zone of the previous column. This is the ISO Code for the timezone which is set up on your company account: Customer Area >> Settings >> Company Settings >> Time Zone (BST, CET, CEST etc) 8 Type* A X50 The possible values are: Fee* MiscCosts* MerchantPayout* Refunded Settled Chargeback ChargebackReversed RefundedReversed DepositCorrection* InvoiceDeduction* MatchedStatement ManualCorrected AuthorisationSchemeFee* BankInstructionReturned InternalCompanyPayout EpaPaid BalanceTransfer PaymentCost SettleCost 28 / 43 Reporting Manual Position 9 Column Name Modification Reference* Data Type Description N 16 This is Adyen's unique 16 digit code child reference that is associated with the modification request (capture, refund, chargebacks, etc). This will be returned to you via the direct soap response of the modification request and the notification server. C X80* For the transfer line item (Type = 'AcquirerPayout') this field will contain the unique Acquirer settlement batch number, you will also find this on your bank statement for the deposit into your bank account. 10 Gross Currency* A3 C X80* 11 Gross Debit* F C X80* 12 Gross Credit* F C X80* 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. 13 Exchange rate FL The exchange rate used for converting the gross amount into the net amount. This will be 1 if you process and settle in the same currency. 14 Net Currency A3 The three character ISO code for the currency which was used for processing the payment (settlement currency). 15 Net Debit F The net debit amount; this is the amount submitted in the transaction request minus Acquirer fees. For example, 100.00. 16 Net Credit F The net credit amount; this is the amount submitted in the transaction request minus Acquirer fees. For example, 100.00. 17 Commission F The commission fee that was withheld by the acquirer. This should be the difference between the gross and net amounts. If the Acquirer provides the transaction information at the interchange level Adyen will split the commission into the Markup, Scheme Fees and Interchange. In this scenario column 17 will be empty and columns 18, 19, and 20 will be populated. If the Acquirer does not provide the transaction information at the interchange level Adyen will populate the total commission in column 17 and columns 18, 19, and 20 will be empty. 18 Markup F The fee charged by the Acquiring bank. This field will be empty if Acquirer does not provide the transaction information at the interchange level. 19 Scheme Fees F The fee which is charged by Visa / MC. This field will be empty if Acquirer does not provide the transaction information at the interchange level. 29 / 43 Reporting Manual Position Column Name Data Type F Description 20 Interchange The fee charged by the Issuing bank. This field will be empty if Acquirer does not provide the transaction information at the interchange level. 21 Payment Method Variant C X30 The subbrand of the payment method (if applicable) For example: visaclassic, visadebit, mccorporate. 22 Modification Merchant Reference C X80 This is the reference number that was provided when initiating the modification request. 23 Reserved3 Reserved for future enhancements 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. Numeric types: I - Integer (whole number) FL – Floating point number F - Fixed point number (for amounts, precision is based on the currency exponent) Character types: A - Text field (alpha characters only) N - Text field (numeric characters only, treat as text) AN - Text field (alphanumeric characters only) C - Text field (unicode character set) Other types: D - Date field (Format: YYYY-MM-DD) T - Time field (format: HH:MM:SS) Optionally a number following the type indicates the length of the field. A length indication preceded by “X” indicates there is no hard limit imposed on the length of the field and that the value should be taken as a practical guideline. * The Data Type changes depending upon the record Type. Where the Type is one of the following values ('Fee', 'MiscCosts', 'MerchantPayout', 'InvoiceDeduction', 'DepositCorrection') the Data Type changes to C X80. 30 / 43 Reporting Manual 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. 3 Psp Reference N In most instances, this is Adyen's 16 digit unique reference number for the payment; it denotes the PSP reference for the original authorisation request. For Unmatched transactions, this field may be populated with a reference from the Acquiring bank and the Data Type format may vary to match the format of the Acquiring bank. For the transfer line item (Type = 'AcquirerPayout') this field will contain the unique Acquirer settlement batch number, you will also find this on your bank statement for the deposit into your bank account. 4 Merchant Reference C X80 This is the reference number that was provided when initiating the payment request. 5 Payment Method C X30 The payment method type of the payment which was processed. For example: visa, mc, amex. 6 Creation Date 7 TimeZone D+” “+T A4 The timestamp of when the payment was received by the Adyen system. The format is YYYY-MM-DD HH:MM:SS, for example: 2012-0726 19:58:55. The time zone of the previous column. This is the ISO Code for the timezone which is set up on your company account: Customer Area >> Settings >> Company Settings >> Time Zone (BST, CET, CEST etc) 8 Type C X50 The possible values are: AcquirerPayout AdjustmentExternallyWithInfo SettledExternallyWithInfo ChargebackExternallyWithInfo ChargebackReversedExternallyWithInfo RefundedExternallyWithInfo SettledInstallmentExternallyWithInfo RefundedInstallmentExternallyWithInfo AdvancementCommissionExternallyWithInfo UnmatchedRefundedExternallyWithInfo UnmatchedSettledExternallyWithInfo UnmatchedChargebackExternallyWithInfo UnmatchedChargebackReversedExternallyWithInfo UnmatchedBatchExternallyWithInfo 31 / 43 Reporting Manual Position 9 Column Name Modification Reference Data Type N Description In most instances, this is Adyen's unique 16 digit code child reference that is associated with the modification request (capture, refund, chargebacks, etc). This will be returned to you via the direct soap response of the modification request and the notification server. For Unmatched transactions, this field may be populated with a reference from the Acquiring bank and the Data Type format may vary to match the format of the Acquiring bank. 10 Gross Currency A3 This is the three character ISO code for the currency which was used for processing the payment (transaction currency). 11 Gross Debit F The gross debit amount; this is the amount submitted in the transaction request. For example, 100.00. 12 Gross Credit F The gross credit amount; this is the amount submitted in the transaction request. For example, 100.00. 13 Exchange rate F The exchange rate used for converting the gross amount into the net amount. This will be 1 if you process and settle in the same currency. 14 Net Currency A3 15 Net Debit F The net debit amount; this is the amount submitted in the transaction request minus Acquirer fees. For example, 100.00. 16 Net Credit F The net credit amount; this is the amount submitted in the transaction request minus Acquirer fees. For example, 100.00. 17 Commission F The commission fee that was withheld by the acquirer. This should be the difference between the gross and net amounts. The three character ISO code for the currency which was used for processing the payment (settlement currency). If the Acquirer provides the transaction information at the interchange level Adyen will split the commission into the Markup, Scheme Fees and Interchange. In this scenario column 17 will be empty and columns 18, 19, and 20 will be populated. If the Acquirer does not provide the transaction information at the interchange level Adyen will populate the total commission in column 17 and columns 18, 19, and 20 will be empty. 18 Markup F The fee charged by the Acquiring bank. This field will be empty if Acquirer does not provide the transaction information at the interchange level. 19 Scheme Fees F The fee which is charged by Visa / MC. This field will be empty if Acquirer does not provide the transaction information at the interchange level. 20 Interchange F The fee charged by the Issuing bank. This field will be empty if Acquirer does not provide the transaction information at the interchange level. 32 / 43 Reporting Manual 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. 24 ARN C X50 Acquirer Reference Number, a unique number that tags a credit card transaction when it goes from the merchant's bank (The Acquiring Bank) through to the card scheme at the cardholder's bank (The Issuer). 25 Acquirer Reference C X80 The Acquirer's unique ID for the payment (if provided). 26 Modification Merchant Reference C X80 For modifications like capture or refund, the (optional) modification reference supplied by the merchant. 27 Reserved7/Installm ents Where installment transactions are applicable, this field will show the installment that this line item pertains to. For example, 6/9 to indicate that this is the 6th of 9 installments. For all other scenarios this field is reserved for future enhancements 28 Reserved8 Reserved for future enhancements 29 Reserved9 Reserved for future enhancements 30 Reserved10 Reserved for future enhancements Legend: See Appendix A: Settlement Detail Report File Format 33 / 43 Reporting Manual 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. 3 Psp Reference N 16 This is Adyen's 16 digit unique reference number for the payment; it denotes the PSP reference for the original authorisation request. 4 Merchant Reference C X80 This is the reference number that was provided when initiating the payment request. 5 Payment Method C X30 The payment method type of the payment which was processed. For example: visa, mc, amex. 6 Record Date D+” “+T The timestamp of when the dispute event took place as entered into Adyen's accounting system. The format is YYYY-MM-DD HH:MM:SS, for example: 2012-07-26 19:58:55. 7 Record Date TimeZone A4 The time zone of the previous column. This is the ISO Code for the timezone which is set up on your company account: Customer Area >> Settings >> Company Settings >> Time Zone (BST, CET, CEST etc) 8 Dispute Currency A3 Disputes don't have to be in the original transaction currency, but can be in the currency of the card holder. Also disputes can be of a lower value than the original transaction. This is the three character ISO code for the dispute amount currency. 9 Dispute Amount N 16 The dispute amount; for an explanation, see previous record. For example, 100.00. 10 Record Type C X50 The dispute accounting record type, e.g.: RequestForInformation NotificationOfChargeback Chargeback InformationSupplied ChargebackReversed NotificationOfFraud 11 Dispute PSP Reference 12 Dispute Reason 34 / 43 Reporting Manual N 16 C X256 This is Adyen's 16 digit unique reference number for the dispute. The dispute reason (free format) provided by the bank or payment method. Position 13 Column Name RFI Scheme Code Data Type Description C X30 The payment method scheme/institution which issued the code in the following column. E.g.: visa mc amex 14 RFI Reason Code C X30 The Request for Information reason code as provided by the bank or payment method. The mapping is defined by the scheme/institution (see previous column). This is blank if no RFI was issued. 15 CB Scheme Code C X30 The payment method scheme/institution which issued the code in the following column. E.g.: visa mc amex 16 CB Reason Code C X30 The Chargeback reason code as provided by the bank or payment method. The mapping is defined by the scheme/institution (see previous column). This may be blank if there is not formal coding for reasons (e.g. Some direct debits), in which case the “Dispute Reason” column should be consulted. 17 Notification of Fraud Scheme Code C X30 The payment method scheme/institution which issued the code in the following column. E.g.: 18 Notification of Fraud Reason Code C X30 19 Payment Date D+” “+T 20 Payment Date TimeZone A4 visa mc amex The Notification of Fraud reason code as provided by the bank or payment method. The mapping is defined by the scheme/institution (see previous column). The date of the original payment (authorisation) The time zone of the previous column. This is the ISO Code for the timezone which is set up on your company account: Customer Area >> Settings >> Company Settings >> Time Zone (BST, CET, CEST etc) 21 Payment Currency A3 22 Payment Amount F 23 Dispute Date 35 / 43 Reporting Manual D+” “+T The three character ISO code for the currency which was used for processing the payment. (may differ from the dispute currency in rare cases) The amount of the original payment (authorisation amount) The date the dispute was first entered into the system. This can be the date of the RFI Position 24 Column Name Dispute Date TimeZone Data Type A4 Description The time zone of the previous column. This is the ISO Code for the timezone which is set up on your company account: Customer Area >> Settings >> Company Settings >> Time Zone (BST, CET, CEST etc) 25 Dispute ARN C X50 Acquirer Reference Number, a unique number that tags a dispute when it goes from the merchant's bank (The Acquiring Bank). 26 User Name C X80 The user (interactive or webservice user) who performed the action resulting in the accounting record. If the record was created by an automated internal process the value “system” is used. 27 Risk Scoring I 28 Shopper Interaction A 30 The transaction type (values: Ecommerce, ContAuth, POS, Moto) 29 Shopper Name C X80 The name of the shopper/consumer as provided during the original transaction (if available) 30 Shopper Email C X256 The email address of the shopper/consumer as provided during the original transaction (if available) 31 Shopper Reference C X256 The supplied customer id/reference as supplied in the original transaction 32 Shopper PAN AN X80 The account number of the shopper/consumer. In case of card payments, the last four digits of the card number. 33 IBAN AN X80 The shopper full IBAN number. 34 BIC AN X80 The shopper full BIC number. 35 Shopper IP 36 Shopper Country A2 The ISO country code of the shopper (if available) 37 Issuer Country A2 The ISO country code of the issuer (if available) 38 Issuer ID 39 C X50 The total risk scoring value of the original payment The IP address (IPV4 or IPV6) of the shopper/consumer as provided during the original transaction (if available) AN 30 The unique identifier of the issuer. In case of card payments this will be the issuer BIN (first 6 digits of the card number). 3D Directory Response A1 For payments which were processed using 3D Secure (Secure Code / Verified by Visa), the directory response (values: Y,N,U,E) 40 3D Authentication Response A1 For payments which were processed using 3D Secure (Secure Code / Verified by Visa) and had directory response 'Y', the authentication response (values: Y,N,U,A,E) 41 CVC2 Response N1 The result passed back by the issuer after verifying the CVC2 (or CVV2/CID in case of Visa/Amex). 36 / 43 Reporting Manual Position Column Name Data Type N2 Description 42 AVS Response If AVS (Address Verification) was performed, the result of the AVS check. 43 Reserved 1 Reserved for future enhancements 44 Reserved 2 Reserved for future enhancements 45 Reserved 3 Reserved for future enhancements 46 Reserved 4 Reserved for future enhancements 47 Reserved 5 Reserved for future enhancements Legend: See Appendix A: Settlement Detail Report File Format 37 / 43 Reporting Manual 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. 3 Psp Reference N 16 This is Adyen's 16 digit unique reference number for the payment; it denotes the PSP reference for the original authorisation request. 4 Merchant Reference C X80 This is the reference number that was provided when initiating the payment request. 5 Payment Method C X30 The payment method type of the payment which was processed. For example: visa, mc, amex. 6 Booking Date D+” “+T The timestamp of when the event took place as entered into Adyen's accounting system. The format is YYYY-MM-DD HH:MM:SS, for example: 2012-07-26 19:58:55. 7 TimeZone A4 The time zone of the previous column. This is the ISO Code for the timezone which is set up on your company account: Customer Area >> Settings >> Company Settings >> Time Zone (BST, CET, CEST etc) 8 Main Currency A3 While the accounting record may move funds on multiple account “registers”, each record type has a primary register which can be seen as a summary of the record. We refer to this as the main amount. This is the three character ISO code for the main amount currency. 9 Main Amount N 16 The main amount; for an explanation, see previous record. For example, 100.00. 10 Record Type C X50 The accounting record type, e.g.: Received Authorised Refused SentForSettle Settled SentForRefund Refunded 11 Payment Currency 12 Received (PC) F The amount (in Payment Currency) debited or credited on the Received accounting register. 13 Authorised (PC) F The amount (in Payment Currency) debited or credited on the Authorised accounting register. 38 / 43 Reporting Manual A3 The three character ISO code for the currency which was used for processing the payment. 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). 17 Commission (SC) F The commission fee that was withheld by the acquirer (in Settlement Currency) If the Acquirer provides the transaction information at the interchange level Adyen will split the commission into the Markup, Scheme Fees and Interchange registers instead. 18 Markup (SC) F The fee charged by the Acquiring bank (in Settlement Currency). 19 Scheme Fees (SC) F The fee which is charged by e.g. Visa / MC (in Settlement Currency). 20 Interchange (SC) F The fee charged by the Issuing bank (in Settlement Currency). 21 Processing Fee Currency 22 Processing Fee (FC) 23 A3 The currency in which the processing (or gateway) fee is charged. F The amount (in Processing Fee Currency) charged on the Processing Fee accounting register. User Name C X80 The user (interactive or webservice user) who performed the action resulting in the accounting record. If the record was created by an automated internal process the value “system” is used. 24 Payment Method Variant C X30 The subbrand of the payment method (if applicable) For example: visaclassic, visadebit, mccorporate. 25 Modification Merchant Reference C X80 For modifications like capture or refund, the (optional) modification reference supplied by the merchant. 26 Reserved3 Reserved for future enhancements 27 Reserved4 Reserved for future enhancements 28 Reserved5 Reserved for future enhancements 29 Reserved6 Reserved for future enhancements 30 Reserved7 Reserved for future enhancements 31 Reserved8 Reserved for future enhancements 32 Reserved9 Reserved for future enhancements 39 / 43 Reporting Manual Position 33 Column Name Reserved10 Data Type Description Reserved for future enhancements Legend: See Appendix A: Settlement Detail Report File Format 40 / 43 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. 3 Psp Reference N 16 This is Adyen's 16 digit unique reference number for the payment; it denotes the PSP reference for the original authorisation request. 4 Merchant Reference C X80 This is the reference number that was provided when initiating the payment request. 5 Payment Method C X30 The payment method type of the payment which was processed. For example: visa, mc, amex. 6 Creation Date D+” “+T The timestamp of when the payment was created as entered into Adyen's system. The format is YYYY-MM-DD HH:MM:SS, for example: 2012-07-26 19:58:55. 7 TimeZone A4 The time zone of the previous column. This is the ISO Code for the timezone which is set up on your company account: Customer Area >> Settings >> Company Settings >> Time Zone (BST, CET, CEST etc) 8 Currency A3 9 Amount N 16 The amount of the payment (authorisation amount) 10 Type C X50 The record type, for this report alway the value “Payment” 11 Risk Scoring I 12 Shopper Interaction A 30 The transaction type (values: Ecommerce, ContAuth, POS, Moto) 13 Shopper Name C X80 The name of the shopper/consumer as provided with the transaction (if available) 14 Shopper PAN AN X80 The account number of the shopper/consumer. In case of card payments, the last four digits of the card number. For SEPA this field show the IBAN and BIC in the following format: IBAN/BIC. 15 Shopper IP 16 Shopper Country 17 Issuer Name 41 / 43 Reporting Manual C X50 A2 C X256 This is the three character ISO code for the payment currency. The total risk scoring value of the payment The IP address (IPV4 or IPV6) of the shopper/consumer as provided during the original transaction (if available) The ISO country code of the shopper (if available, calculated from IP if not supplied) The name of the issuing bank (if available) Position Column Name Data Type Description 18 Issuer ID AN 30 The unique identifier of the issuer. In case of card payments this will be the issuer BIN (first 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 final status of the payment. 22 Authorisation Code C X50 If the payment was not declined, the authorisation code. 23 Shopper Email C X256 The email address of the shopper/consumer as provided during the original transaction (if available) 24 Shopper Reference C X256 The supplied customer id/reference as supplied in the original transaction 25 3D Directory Response A1 For payments which were processed using 3D Secure (Secure Code / Verified by Visa), the directory response (values: Y,N,U,E) 26 3D Authentication Response A1 For payments which were processed using 3D Secure (Secure Code / Verified by Visa) and had directory response 'Y', the authentication response (values: Y,N,U,A,E) 27 CVC2 Response N1 The result passed back by the issuer after verifying the CVC2 (or CVV2/CID in case of Visa/Amex). 28 AVS Response N2 If AVS (Address Verification) was performed, the result of the AVS check. 29 Billing Street C X256 The street part of the billing address 30 Billing House Number / Name C X256 The house number or name part of the billing address 31 Billing City C X256 The city part of the billing address 32 Billing Postal Code / Zip Code C X30 The zip code or postal code part of the billing address 33 Billing State / Province C X256 The state or province of the billing address 34 Billing Country A2 35 Delivery Street C X256 The street part of the delivery address 36 Delivery House Number / Name C X256 The house number or name part of the delivery address 37 Delivery City C X256 The city part of the delivery address 42 / 43 Reporting Manual The ISO country code of the of the billing address 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. mccredit or visagold) 43 Reserved 3 Reserved for future enhancements 44 Reserved 4 Reserved for future enhancements 45 Reserved 5 Reserved for future enhancements 46 Reserved 6 Reserved for future enhancements 47 Reserved 7 Reserved for future enhancements 48 Reserved 8 Reserved for future enhancements 49 Reserved 9 Reserved for future enhancements 50 Reserved 10 Reserved for future enhancements A2 The ISO country code of the of the delivery address Legend: See Appendix A: Settlement Detail Report File Format 43 / 43 Reporting Manual
© Copyright 2024