Settlement report Cybersource mapping

This integration is currently in beta and the exact mapping of fields might still change.

Below is the mapping of Cybersource’s report to the settlement report. This data is pulled from the Cybersource’s Payment Batch Detail report.

Cybersource’s reconciliation is done via Payment Batch Detail reports which lack fee information and chargeback reporting. It’s therefore not possible to use the settlement report for full end to end reconciliation between Cybersource and a bank statement. It does allow for insights in which transactions have been sent for settlement or refunded.

Settlement report	Cybersource field?	Cybersource report
`payment_service_transaction_reconciliation_id`	Yes	`Request.MerchantReferenceNumber` (only when `ics_bill` in `Application.Name`)
`transaction_id`	No	-
`payment_service_transaction_id`	Yes	`Request.LinkToRequest`
`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	`Application.Name`
`payment_service_transaction_created_at`	Yes	Always `null`
`posted_at`	Yes	`Batch.BatchDate`
`processing_amount_plain`	Yes	`PaymentData.RequestedAmount`
`processing_currency`	Yes	`PaymentData.RequestedAmountCurrencyCode`
`exchange_rate`	Yes	Always `null`
`currency`	Yes	`PaymentData.CurrencyCode`
`gross_credit_plain`	Yes	`PaymentData.Amount` (only when `ics_bill` in `Application.Name`)
`net_credit_plain`	Yes	`PaymentData.Amount` (only when `ics_bill` in `Application.Name`)
`gross_debit_plain`	Yes	`(-1) * PaymentData.Amount` (only when `ics_credit` in `Application.Name`)
`net_debit_plain`	Yes	`(-1) * PaymentData.Amount` (only when `ics_credit` in `Application.Name`)
`fee_markup_plain`	Yes	Always `null`
`fee_interchange_plain`	Yes	Always `null`
`fee_scheme_plain`	Yes	Always `null`
`fee_total_plain`	Yes	Always `0`
`method`	Yes	Standardized value of `raw_method`
`raw_method`	Yes	`PaymentMethod.Type` or `PaymentMethod.WalletType` depending on what was used to calculate `method`
`scheme`	Yes	Standardized value of `raw_scheme`
`raw_scheme`	Yes	`PaymentMethod.CardType`
`batch`	Yes	`Batch.BatchID`
`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	-
`payment_service_modification_reference`	Yes	`Request.RequestID`
`payment_service_refund_reconciliation_id`	Yes	Always `null`

Notes

The posted_at value provided is only an approximation, as the Payment Batch Detail report does not report this value.
The method value is calculated from PaymentMethod.WalletType if it is not null. Otherwise, PaymentMethod.Type is used.

Journal type mapping

Cybersource raw journal type	Journal type
`ics_bill`	`settlement`
`ics_credit`	`refund`

Fields marked as not a Cybersource field are populated from internal data and not from the imported payment service report.

Overview

Insights

Monitoring & Alerting

Flow

Roles & Permissions

Reports

Settlement reports

SSO

Settlement report Cybersource mapping

Notes

Journal type mapping

​Notes

​Journal type mapping

Notes

Journal type mapping