This integration is in beta

The Gr4vy settlement report 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 our dashboard. To set up these credentials, please go to the “Connections” tab, select your PayPal connector and navigate to the “Settlement” tab. Here you can enable settlement reporting, after which you will be prompted to fill out your SFTP username and password.

Below is the mapping of PayPal’s settlement report to Gr4vy’s. This data is pulled from the PayPal Settlement Report.

Gr4vy settlement reportGr4vy field?PayPal report
payment_service_transaction_reconciliation_id NoCustom Field
transaction_idYes-
payment_service_transaction_idNoAlways null
payment_service_idYes-
payment_service_definition_idYes-
payment_service_display_nameYes-
journal_typeNoCheck journal type mapping table below
raw_journal_typeNoTransaction Event Code | Transaction Debit or Credit
payment_service_transaction_created_atNoAlways null
posted_atNoTransaction Completion Date
processing_amount_plainNoGross Transaction Amount (only for refund and settlement)
processing_currencyNoGross Transaction Currency (only for refund and settlement)
exchange_rateNoAlways 1, unless settled in a different currency. In that case, it is calculated using Gross Transaction Amount presented in the two currencies
currencyNoGross Transaction Currency
gross_credit_plainNoGross Transaction Amount * exchange_rate (only when Transaction Debit or Credit = 'CR')
net_credit_plainNo(Gross Transaction Amount - Fee Amount) * exchange_rate (only when Transaction Debit or Credit = 'CR')
gross_debit_plainNoGross Transaction Amount * exchange_rate (only when Transaction Debit or Credit = 'DR')
net_debit_plainNo(Gross Transaction Amount + Fee Amount) * exchange_rate (only when Transaction Debit or Credit = 'DR')
fee_markup_plainNoAlways null
fee_interchange_plainNoAlways null
fee_scheme_plainNoAlways null
fee_total_plainNoFee Amount * exchange_rate
methodNoAlways 'paypal'
raw_methodNoAlways null
schemeNoAlways null
raw_schemeNoAlways null
batchNoAlways null
report_idYes-
raw_report_idsYes-
ingested_atYes-
descriptionNoAlways null
transaction_external_identifierYes-
transaction_metadataYes-
report_payment_service_idYes-
report_payment_service_definition_idYes-
report_payment_service_display_nameYes-

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 Gr4vy settlement report, with applied currency conversion derived from T0200 records. Their respective raw_journal_type values will be appended to a single raw_journal_type 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 typeGr4vy journal type
T0000 | CRsettlement
T0000 | DRrefund
T0001 | CRsettlement
T0001 | DRrefund
T0002 | CRsettlement
T0002 | DRrefund
T0003 | CRsettlement
T0003 | DRrefund
T0004 | CRsettlement
T0004 | DRrefund
T0005 | CRsettlement
T0005 | DRrefund
T0006 | CRsettlement
T0006 | DRrefund
T0007 | CRsettlement
T0007 | DRrefund
T0008 | CRsettlement
T0008 | DRrefund
T0009 | CRsettlement
T0009 | DRrefund
T0010 | CRsettlement
T0010 | DRrefund
T0011 | CRsettlement
T0011 | DRrefund
T0012 | CRsettlement
T0012 | DRrefund
T0013 | CRsettlement
T0013 | DRrefund
T0014 | CRsettlement
T0014 | DRrefund
T0015 | CRsettlement
T0015 | DRrefund
T0016 | CRsettlement
T0016 | DRrefund
T0017 | CRsettlement
T0017 | DRrefund
T0018 | CRsettlement
T0018 | DRrefund
T0019 | CRsettlement
T0019 | DRrefund
T0020 | CRsettlement
T0020 | DRrefund
T0021 | CRsettlement
T0021 | DRrefund
T0022 | CRsettlement
T0022 | DRrefund
T1107 | CRsettlement
T1107 | DRrefund
T1112 | CRsettlement
T1112 | DRrefund
T1113 | CRsettlement
T1113 | DRrefund
T1115 | CRsettlement
T1115 | DRrefund
T1117 | CRsettlement
T1117 | DRrefund
T1201 | CRchargeback_reversal
T1201 | DRchargeback
T1202 | CRchargeback_reversal
T1202 | DRchargeback
T1600 | CRsettlement
T1600 | DRrefund
T1602 | CRsettlement
T1603 | DRrefund
T1800 | CRsettlement
T1800 | DRrefund
T2201 | CRsettlement
T2201 | DRrefund
any other valueother

Fields marked as Gr4vy field are populated from our internal data and not from the ingested payment service report.