Settlement report Stripe mapping
Below is the mapping of Stripe’s settlement report to ours. This data is pulled from the Stripe
Journal type mapping:
payout_reconciliation.itemized.5 report.
| Settlement report | Stripe field? | Stripe report |
|---|---|---|
payment_service_transaction_reconciliation_id | Yes | payment_metadata[gr4vy_tx_sid] |
transaction_id | No | - |
payment_service_transaction_id | Yes | payment_intent_id |
payment_service_id | No | - |
payment_service_definition_id | No | - |
payment_service_display_name | No | - |
journal_type | Yes | Check journal type mapping table below |
raw_journal_type | Yes | reporting_category |
payment_service_transaction_created_at | Yes | charge_created_utc |
posted_at | Yes | available_on_utc |
processing_amount_plain | Yes | customer_facing_amount |
processing_currency | Yes | customer_facing_currency |
exchange_rate | Yes | Calculated field using the formula gross / customer_facing_amount |
currency | Yes | currency |
gross_credit_plain | Yes | gross (depends on reporting_category e.g charge) |
net_credit_plain | Yes | net (depends on reporting_category e.g charge) |
gross_debit_plain | Yes | gross (depends on reporting_category e.g refund) |
net_debit_plain | Yes | net (depends on reporting_category e.g refund) |
fee_markup_plain | Yes | Always null |
fee_interchange_plain | Yes | Always null |
fee_scheme_plain | Yes | Always null |
fee_total_plain | Yes | fee |
method | Yes | Standardized value of raw_method |
raw_method | Yes | payment_method_type |
scheme | Yes | Standardized value of raw_scheme |
raw_scheme | Yes | card_brand |
batch | Yes | automatic_payout_id |
report_id | No | - |
raw_report_ids | No | - |
ingested_at | No | - |
description | Yes | Always null |
transaction_external_identifier | No | - |
transaction_metadata | No | - |
report_payment_service_id | No | - |
report_payment_service_definition_id | No | - |
report_payment_service_display_name | No | - |
| Stripe raw journal type | Our journal type |
|---|---|
charge | settlement |
dispute | chargeback |
dispute_reversal | chargeback_reversal |
| any other value | other |
Fields marked as not a Stripe field are populated from our internal data and not
from the ingested payment service report.