Settlement report Braintree mapping

Below is the mapping of Braintree’s settlement data to the consolidated settlement report. This data is pulled from Braintree’s GraphQL API. Only the journal types for settled, refunded, and disputed transactions are taken into consideration. The below table shows which fields are queried and imported into the report.

Braintree’s reconciliation is done via batch level summary reports. Detailed transaction level reports that allow for reconciliation are not available for import. Fee information is not yet widely available and is therefore not included in the consolidated settlement report. In consequence, it is not possible to use the settlement report for full end to end reconciliation between Braintree and a bank statement. It does allow for insights in which transactions have been settled by Braintree.

Settlement report	Braintree field?	Braintree GraphQL fields for transactions	Braintree GraphQL fields for refunds	Braintree GraphQL fields for disputes
`payment_service_transaction_reconciliation_id`	Yes	`orderId`	`refundedTransaction[orderId]`	`transaction[orderId]`
`transaction_id`	No	-	-	-
`payment_service_transaction_id`	Yes	`id`	`refundedTransaction[id]`	`transaction[id]`
`payment_service_id`	No	-	-	-
`payment_service_definition_id`	No	-	-	-
`payment_service_display_name`	No	-	-	-
`journal_type`	Yes	Always `'settlement'`	Always `'refund'`	Check dispute journal type mapping table below
`raw_journal_type`	Yes	Always `'Transaction'`	Always `'Refund'`	`Dispute \| {type} \| {statusHistory[status]}`
`payment_service_transaction_created_at`	Yes	`createdAt`	`refundedTransaction[createdAt]`	`transaction[createdAt]`
`posted_at`	Yes	`disbursementDetails[date]`	`disbursementDetails[date]`	`statusHistory[timestamp]`
`processing_amount_plain`	Yes	`amount[value]`	`amount[value]`	Always `null`
`processing_currency`	Yes	`amount[currencyCode]`	`amount[currencyCode]`	Always `null`
`exchange_rate`	Yes	`disbursementDetails[exchangeRate]`	`disbursementDetails[exchangeRate]`	Always `null`
`currency`	Yes	`disbursementDetails[amount][currencyCode]`	`disbursementDetails[amount][currencyCode]`	`amountWon[currencyCode]` for chargeback reversals, `amountDisputed[currencyCode]` otherwise
`gross_credit_plain`	Yes	`statusHistory(SettledEvent)[amount][value] * disbursementDetails[exchangeRate]`	Always `0`	`amountDisputed[value]` for chargeback reversals, `0` otherwise
`net_credit_plain`	Yes	`disbursementDetails[amount][value]`	Always `0`	`amountWon[value]` for chargeback reversals, `0` otherwise
`gross_debit_plain`	Yes	Always `0`	`disbursementDetails[exchangeRate] * statusHistory(SettledEvent)[amount][value]`	`amountDisputed[value]` for chargebacks, `0` otherwise
`net_debit_plain`	Yes	Always `0`	`disbursementDetails[amount][value]`	`amountDisputed[value]` for chargebacks, `0` otherwise
`fee_markup_plain`	Yes	Always `null`	Always `null`	Always `null`
`fee_interchange_plain`	Yes	Always `null`	Always `null`	Always `null`
`fee_scheme_plain`	Yes	Always `null`	Always `null`	Always `null`
`fee_total_plain`	Yes	`gross_credit_plain` - `net_credit_plain`	`net_debit_plain` - `gross_debit_plain`	`amountDisputed[value] - amountWon[value]` for chargeback reversals, `0` otherwise
`method`	Yes	Standardized value of `raw_method`	Standardized value of `raw_method`	Standardized value of `raw_method`
`raw_method`	Yes	`paymentMethodSnapshot(CreditCardDetails)[origin][type]`	`paymentMethodSnapshot(CreditCardDetails)[origin][type]`	`transaction[paymentMethodSnapshot(CreditCardDetails)][origin][type]`
`scheme`	Yes	Standardized value of `raw_scheme`	Standardized value of `raw_scheme`	Standardized value of `raw_scheme`
`raw_scheme`	Yes	`paymentMethodSnapshot(CreditCardDetails)[brandCode]`	`paymentMethodSnapshot(CreditCardDetails)[brandCode]`	`transaction[paymentMethodSnapshot(CreditCardDetails)][brandCode]`
`batch`	Yes	`statusHistory(SettledEvent)[settlementBatchId]`	`statusHistory(SettledEvent)[settlementBatchId]`	Always `null`
`report_id`	No	-	-	-
`raw_report_ids`	No	-	-	-
`ingested_at`	No	-	-	-
`description`	Yes	Always `null`	Always `null`	`Reason: {processorResponse[reason]}` for chargebacks with a specified reason, `null` otherwise
`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	Always `null`	Always `null`	Always `null`
`payment_service_refund_reconciliation_id`	Yes	Always `null`	Always `null`	Always `null`

Disputes journal type mapping

Braintree dispute type	Braintree dispute status	Journal type
`CHARGEBACK`	`OPEN`	`chargeback`
`CHARGEBACK`	`WON`	`chargeback_reversal`
`PRE_ARBITRATION`	`OPEN`	`chargeback`
`PRE_ARBITRATION`	`WON`	`chargeback_reversal`
any other value	any other value	`other`

Fields marked as not being a Braintree 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 Braintree mapping

Disputes journal type mapping

​Disputes journal type mapping

Disputes journal type mapping