Settlement report PayPal mapping

This integration is in beta

Ingesting settlement reports for PayPal makes use of the PayPal settlement report. This report is created every 24 hours. Journal types are specified by the transaction event code (T-code) in PayPal in combination with the movement of the funds, either being DR (debit) or CR (credit). For example, the T-code T1201 with the movement DR is mapped to chargeback, while the same T-code with the movement CR is mapped to chargeback_reversal. To configure settlement reporting, a PayPal SFTP needs to be set up on the PayPal side. Please follow the guidance on how to enable the SFTP. After the SFTP is enabled, the credentials of the SFTP need to be filled out in the PayPal connector configuration in the dashboard. To set up these credentials, please go to the “Connections” tab, select the PayPal connector and navigate to the “Settlement” tab. Here settlement reporting can be enabled, after which prompts are provided to fill out the SFTP username and password. Below is the mapping of PayPal’s settlement report to the consolidated settlement report. This data is pulled from the PayPal Settlement Report.

Settlement report	PayPal field?	PayPal report
`payment_service_transaction_reconciliation_id`	Yes	`Custom Field`
`transaction_id`	No	-
`payment_service_transaction_id`	Yes	Always `null`
`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	`Transaction Event Code \| Transaction Debit or Credit`
`payment_service_transaction_created_at`	Yes	Always `null`
`posted_at`	Yes	`Transaction Completion Date`
`processing_amount_plain`	Yes	`Gross Transaction Amount` (only for `refund` and `settlement`)
`processing_currency`	Yes	`Gross Transaction Currency` (only for `refund` and `settlement`)
`exchange_rate`	Yes	Always `1`, unless settled in a different currency. In that case, it is calculated using `Gross Transaction Amount` presented in the two currencies
`currency`	Yes	`Gross Transaction Currency`
`gross_credit_plain`	Yes	`Gross Transaction Amount` * `exchange_rate` (only when `Transaction Debit or Credit = 'CR'`)
`net_credit_plain`	Yes	(`Gross Transaction Amount` - `Fee Amount`) * `exchange_rate` (only when `Transaction Debit or Credit = 'CR'`)
`gross_debit_plain`	Yes	`Gross Transaction Amount` * `exchange_rate` (only when `Transaction Debit or Credit = 'DR'`)
`net_debit_plain`	Yes	(`Gross Transaction Amount` + `Fee Amount`) * `exchange_rate` (only when `Transaction Debit or Credit = 'DR'`)
`fee_markup_plain`	Yes	Always `null`
`fee_interchange_plain`	Yes	Always `null`
`fee_scheme_plain`	Yes	Always `null`
`fee_total_plain`	Yes	`Fee Amount` * `exchange_rate`
`method`	Yes	Always `'paypal'`
`raw_method`	Yes	Always `null`
`scheme`	Yes	Always `null`
`raw_scheme`	Yes	Always `null`
`batch`	Yes	Always `null`
`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	`Transaction ID`
`payment_service_refund_reconciliation_id`	Yes	`Custom Field`
`refund_external_identifier`	No	-

Notes

Transactions with different currency and processing_currency values are presented as multiple rows in the PayPal report. They are merged into a single row in the settlement report, with applied currency conversion derived from T0200 records. Their respective raw_journal_type and payment_service_modification_reference values are concatenated to a single value in the merged row.
Non-customer facing journal types may have columns defaulting to 0 or empty strings.

Journal type mapping

PayPal raw journal type	Journal type
`T0000 \| CR`	`settlement`
`T0000 \| DR`	`refund`
`T0001 \| CR`	`settlement`
`T0001 \| DR`	`refund`
`T0002 \| CR`	`settlement`
`T0002 \| DR`	`refund`
`T0003 \| CR`	`settlement`
`T0003 \| DR`	`refund`
`T0004 \| CR`	`settlement`
`T0004 \| DR`	`refund`
`T0005 \| CR`	`settlement`
`T0005 \| DR`	`refund`
`T0006 \| CR`	`settlement`
`T0006 \| DR`	`refund`
`T0007 \| CR`	`settlement`
`T0007 \| DR`	`refund`
`T0008 \| CR`	`settlement`
`T0008 \| DR`	`refund`
`T0009 \| CR`	`settlement`
`T0009 \| DR`	`refund`
`T0010 \| CR`	`settlement`
`T0010 \| DR`	`refund`
`T0011 \| CR`	`settlement`
`T0011 \| DR`	`refund`
`T0012 \| CR`	`settlement`
`T0012 \| DR`	`refund`
`T0013 \| CR`	`settlement`
`T0013 \| DR`	`refund`
`T0014 \| CR`	`settlement`
`T0014 \| DR`	`refund`
`T0015 \| CR`	`settlement`
`T0015 \| DR`	`refund`
`T0016 \| CR`	`settlement`
`T0016 \| DR`	`refund`
`T0017 \| CR`	`settlement`
`T0017 \| DR`	`refund`
`T0018 \| CR`	`settlement`
`T0018 \| DR`	`refund`
`T0019 \| CR`	`settlement`
`T0019 \| DR`	`refund`
`T0020 \| CR`	`settlement`
`T0020 \| DR`	`refund`
`T0021 \| CR`	`settlement`
`T0021 \| DR`	`refund`
`T0022 \| CR`	`settlement`
`T0022 \| DR`	`refund`
`T1107 \| CR`	`settlement`
`T1107 \| DR`	`refund`
`T1112 \| CR`	`settlement`
`T1112 \| DR`	`refund`
`T1113 \| CR`	`settlement`
`T1113 \| DR`	`refund`
`T1115 \| CR`	`settlement`
`T1115 \| DR`	`refund`
`T1117 \| CR`	`settlement`
`T1117 \| DR`	`refund`
`T1201 \| CR`	`chargeback_reversal`
`T1201 \| DR`	`chargeback`
`T1202 \| CR`	`chargeback_reversal`
`T1202 \| DR`	`chargeback`
`T1600 \| CR`	`settlement`
`T1600 \| DR`	`refund`
`T1602 \| CR`	`settlement`
`T1603 \| DR`	`refund`
`T1800 \| CR`	`settlement`
`T1800 \| DR`	`refund`
`T2201 \| CR`	`settlement`
`T2201 \| DR`	`refund`
any other value	`other`

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

​Notes

​Journal type mapping

Notes

Journal type mapping