Settlement report Nuvei mapping
Below is the mapping of Nuvei’s settlement report to Gr4vy’s. This data is pulled from Nuvei’s movement report.
This report is ingested on a daily basis and allows for full end to end reconciliation between your 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 we’re ingesting settlement data that pertain to movements of funds in the Nuvei platform we are filtering out line items where the settlement amount : 0.
We will ingest all journal types from the movement report which by Nuvei standards are notated by the movement type and movement details.
In our report we concatenate these two columns in the raw_journal_type column.
Transactions with Gr4vy journal_type: settled will be 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 our report however we provide the fees in the settlement currency. Therefore we have modified the fees in the Gr4vy report as fee * conversion rate.
Nuvei’s movement report needs to be scheduled via their dashboard for Gr4vy to be able to ingest. 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. For us to be able to ingest the report please set the following naming convention: settlement-report-YYYY-MM-DD.csv.
| Gr4vy settlement report | Gr4vy field? | Nuvei report |
|---|---|---|
reconciliation_id | No | Client Unique ID |
transaction_id | Yes | - |
payment_service_transaction_id | No | Transaction ID (for Sale-Sales only) |
payment_service_id | Yes | |
payment_service_definition_id | Yes | - |
payment_service_display_name | Yes | - |
journal_type | Yes | - |
created_at | No | * |
posted_at | No | Movement Date |
processing_amount | No | Amount[Transaction] |
processing_currency | No | Currency[Transaction] |
exchange_rate | No | Conversion Rate |
currency | No | Settlement Currency |
gross_credit | No | Settlement Amount |
net_credit | No | Net Amount |
gross_debit | No | Settlement Amount |
net_debit | No | Net Amount |
fee.markup | No | Transaction Fee + Service Fee * Conversion Rate |
fee.interchange | No | Interchange Fee * Conversion Rate |
fee.scheme_fee | No | Scheme Fee * Conversion Rate |
fee_total | No | Settlement Amount - Net Amount * Conversion Rate |
method | No | Payment Method |
scheme | No | Payment Method (if Card Type is defined) |
batch | No | Batch ID |
raw_journal_type | No | {Movement Details}-{Movement Type} |
raw_report_id | Yes | - |
report_id | Yes | - |
ingested_at | Yes | - |
notes | No | - |
- Unfortunately no creation date of the transaction is given, only the
posted_atdate is available. It’s therefore not possible to see from our report on which date the original transaction took place on the Nuvei platform.
Fields marked as Gr4vy field are populated from our internal data and not from the ingested payment service report.