Skip to main content
This integration is in beta
Below is the mapping of Nuvei’s settlement report to the system. This data is pulled from Nuvei’s movement report. This report is imported on a daily basis and allows for full end to end reconciliation between a bank account and Nuvei’s payables. The report contains transaction level settlement information including fees, chargebacks and refunds. Nuvei reports on all movements of funds, also settlements that have occurred externally from the Nuvei platform. Since settlement data is imported that pertains to movements of funds in the Nuvei platform, line items where the settlement amount : 0 are filtered out. All journal types from the movement report are imported which by Nuvei standards are notated by the movement type and movement details. In the report these two columns are concatenated in the raw_journal_type column. Transactions with journal_type: settled are taken from the Nuvei raw_journal_type: sale-sale. In the Nuvei movement report the fees are deducted from the processing amount in the processing currency. In the report however the fees are provided in the settlement currency. Therefore the fees in the report are modified as fee * conversion rate.
Nuvei’s movement report needs to be scheduled via their dashboard to be able to import. Please follow their Back Office Operations - Reports guidelines on how to set up a new schedule for the Movement Report. Make sure to set the delivery type to SFTP. To be able to import the report please set the following naming convention: settlement-report-YYYY-MM-DD.csv.

​
Notes

  • payment_service_transaction_created_at is set to null since, unfortunately, no creation date of the transaction is given, only the posted_at date is available. It’s therefore not possible to see from the report on which date the original transaction took place on the Nuvei platform.
  • ABS() means absolute value transformation is applied to the original value

​
Journal type mapping

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