Below is the mapping of Adyen’s settlement report to Gr4vy’s. This data is pulled from the Adyen settlement_detail_report report.

Gr4vy settlement reportGr4vy field?Adyen report
reconciliation_idNoMerchant Reference or Merchant Order Reference
transaction_idYes-
payment_service_transaction_idNoPayment service Reference
payment_service_idYes
payment_service_definition_idYes-
payment_service_display_nameYes-
journal_typeNoType
raw_journal_typeNoType
created_atNoCreation Date
posted_atNoBooking Date
processing_amountNoGross Credit
processing_currencyNoGross Currency
exchange_rateNoExchange Rate
currencyNoNet Currency
gross_creditNoCalculated field using the formula Gross Credit * Exchange Rate
net_creditNoNet Credit
gross_debitNoGross Debit
net_debitNoNet Debit
markupNoMarkup (NC)
interchangeNoInterchange (NC)
scheme_feeNoSchemes Fees (NC)
commissionNoCommission (NC)
methodNoPayment Method
schemeNoPayment Method Variant
batchNoBatch Number
raw_report_idYesRaw file name from Adyen
report_idYes-
ingested_atYes-
notesNo-

Fields marked as Gr4vy field are populated from our internal data and not from the ingested payment service report.