> ## Documentation Index
> Fetch the complete documentation index at: https://docs.gr4vy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

<Note>
  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.
</Note>

| 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`               |

<Note>
  Fields marked as not being a **Braintree field** are populated from
  internal data and not from the imported payment service report.
</Note>