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

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.