Below is the mapping of Stripe’s settlement report to Gr4vy’s. This data is pulled from the Stripe payout_reconciliation.itemized.5 report.

Gr4vy settlement reportGr4vy field?Stripe report
reconciliation_idNopayment_metadata[gr4vy_tx_sid]
transaction_idYes-
payment_service_transaction_idNopayment_intent_id
payment_service_idYes-
payment_service_definition_idYes-
payment_service_display_nameYes-
journal_typeNoreporting_category
raw_journal_typeNoreporting_category
created_atNocharge_created_utc
posted_atNoavailable_on_utc
processing_amountNocustomer_facing_amount
processing_currencyNocustomer_facing_currency
exchange_rateNoCalculated field using the formula gross / customer_facing_amount
currencyNocurrency
gross_creditNogross (depends on reporting_category e.g charge)
net_creditNonet (depends on reporting_category e.g charge)
gross_debitNogross (depends on reporting_category e.g refund)
net_debitNonet (depends on reporting_category e.g refund)
markupNo-
interchangeNo-
scheme_feeNo-
commissionNofee
methodNopayment_method_type
schemeNocard_brand
batchNoautomatic_payout_id?
raw_report_idYesRaw file name from Stripe
report_idYes-
ingested_atYes-
notesNo-

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