##Configuration Before enabling settlement reporting for your Adyen connector please follow the below steps. Some fields in our settlement report are not in the default Adyen settlement report and need to be configured via the Adyen portal. The following fields need to be added: Booking date, Booking Date TimeZone and metadata. To add the columns to the Adyen report follow the documentation here. Please follow the below column configuration.
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
Modification Merchant Reference
Batch Number
Reserved4
Reserved5
Reserved6
Reserved7
Reserved8
Reserved9
Reserved10
Booking Date
Booking Date TimeZone
Metadata
It’s important to set up the columns in order and these are the minimum columns we need. If you wants to add more columns, these should be placed after the last column mentioned here.
Once that is set up, a report user needs to be created. The report user is created via the Adyen developers dashboard, please follow the documentation here. The report user follows a naming convention like report_123456@Company.Gr4vyInc. Please fill out the whole name, not just the report_123456 part, and provide the basic auth password in the dashboard. It is important to use the Basic Auth key pair when configuring the report user in our dashboard, and not the API key. This needs to be filled out in the settlement tab in the connector configuration page. Adyen configuration ##Fields Mapping
This integration is in beta
Below is the mapping of Adyen’s settlement report to ours. This data is pulled from the Adyen settlement_detail_report report.
Settlement reportAdyen field?Adyen report
payment_service_transaction_reconciliation_idYesMerchant Reference or Metadata[gr4vy_tx_sid]
transaction_idNo-
payment_service_transaction_idYesPsp Reference
payment_service_idNo-
payment_service_definition_idNo-
payment_service_display_nameNo-
journal_typeYesCheck journal type mapping table below
raw_journal_typeYesType
payment_service_transaction_created_atYesCreation Date with Time Zone UTC offset applied
posted_atYesBooking Date, with Booking Date Time Zone UTC offset applied
processing_amount_plainYesGross Credit (GC) if Settled Type, Gross Debit (GC) if Refunded Type
processing_currencyYesGross Currency
exchange_rateYesExchange Rate
currencyYesNet Currency
gross_credit_plainYesGross Credit (GC) * Exchange Rate or Net Credit (NC) for non-customer facing journal types
net_credit_plainYesNet Credit (NC)
gross_debit_plainYesGross Debit (GC) * Exchange Rate or Net Debit (NC) for non-customer facing journal types
net_debit_plainYesNet Debit (NC)
fee_markup_plainYesMarkup (NC)
fee_interchange_plainYesInterchange (NC)
fee_scheme_plainYesScheme Fees (NC)
fee_total_plainYesCommission (NC) or Gross Credit (GC) * Exchange Rate - Net Credit (NC) if Settled Type or Net Debit (NC) - Gross Debit (GC) * Exchange Rate if Refunded Type
methodYesCalculated from Payment Method or Payment Method Variant
raw_methodYesPayment Method or Payment Method Variant depending on which was used to calculate method
schemeYesCalculated from Payment Method or Payment Method Variant
raw_schemeYesPayment Method or Payment Method Variant depending on which was used to calculate scheme
batchYesBatch Number
report_idNo-
raw_report_idsNo-
ingested_atNo-
descriptionYesContains raw Time Zone and Booking Date Time Zone values
transaction_external_identifierNo-
transaction_metadataNo-
report_payment_service_idNo-
report_payment_service_definition_idNo-
report_payment_service_display_nameNo-

Notes

  • payment_service_transaction_created_at and posted_at have been converted to UTC using Time Zone and Booking Date Time Zone respectively, which are time zone abbreviations. As these time zone abbreviations can be ambiguous, the applied UTC offset to these timestamp columns may not be accurate. Please refer to the description for the raw values used.
  • Non-customer facing journal types may have columns defaulting to 0 or empty strings.

Journal type mapping

Adyen raw journal typeOur journal type
Chargebackchargeback
ChargebackReversedchargeback_reversal
Refundedrefund
SecondChargebackchargeback
Settledsettlement
any other valueother
Fields marked as not being an Adyen field are populated from our internal data and not from the ingested payment service report.