Dashboard reports

The Dashboard reports contain a complete list of all the transactions made with the payment methods assigned to your merchant account. You have the possibility to search for specific payments using different criteria, to see the details of the payment invoice and fees, and to export your payments into an XLS file. These reports can be exported from GlobalPay Dashboard.

For more information regarding Dashboard reports, please visit our dedicated section: GlobalPay Merchant Dashboard.

Transactional reports

The transactional reports generated can be uploaded periodically on our SFTP server where you can download them from and process them automatically. Please request login details from technicalsupport-s2p@nuvei.com.

The transactional reports are available in CSV format. By default these reports are generated every Friday (weekly) but upon request the frequency can be changed to daily.

Below there are examples of transactional reports in CSV format:

  1. All transactions initiated, no matter the status of the payment: MerchantDemo_ATTEMPTS_2018_07_07;The generated transactional report contains transactions with all the statuses we process for your merchant account.
  2. The transactions with Success status: MerchantDemo_SUCCESS_2018_07_07;In case a transaction was exported with a status (any status except Success), but at a later time the status changed to Success (and only Success), GlobalPay will notify again the payment with the success status and the payment will be exported in a separate report (the format is the same) and the report filename ends in “_success”.1 Transactional report</p

    The transactional report file with Success transactions contains the following information:

    Id
    Id
    Definition
    GlobalPay transaction ID, a unique number that identifies the transaction in the GlobalPay system.
    Type
    int
    Regex
    ^\d{1,12}$
    – GlobalPay transaction ID, a unique number that identifies the transaction in the GlobalPay system;

    MerchantTransactionID
    MerchantTransactionID
    Definition
    Merchant Transaction ID, a number that uniquely identifies a transaction in your system.
    Type
    string
    Regex
    ^[0-9a-zA-Z_-]{1,50}$
    – Merchant Transaction ID, a number that uniquely identifies a transaction in your system;

    InputDateTime
    InputDateTime
    Definition
    Date and time when the transaction was created in GlobalPay system.
    Type
    datetime
    – Date and time when the transaction was created in GlobalPay system;

    Status
    Status
    Definition
    The status of the transaction. It can have the following values: Open, Success, Cancelled, Failed, Expired, Authorized.
    Type
    string
    – The status of the transaction. It can have the following values: Open, Success, Cancelled, Failed, Expired, Authorized;

    MerchantAmount
    MerchantAmount
    Definition
    The amount of the transaction.
    Type
    int
    Regex
    ^\d{1,12}$
    – The amount of the transaction;

    MerchantCurrency
    MerchantCurrency
    Definition
    The currency in which the transaction was initiated. Format is according to ISO 4217, a three-letter code.
    Type
    string
    Regex
    ^[A-Z]{3}$
    – The currency in which the transaction was initiated;

    MethodID
    MethodID
    Definition
    The ID of the payment method.
    Type
    int
    Regex
    ^([0-9]{1,10})$
    – The ID of the payment method;

    ReportedByBOTOperatorDate
    ReportedByBOTOperatorDate
    Definition
    The date when the transaction was exported in a SFTP/CSV file.
    Type
    datetime
    – The date when the transaction was exported in a SFTP/CSV file;

    CapturedAmount
    CapturedAmount
    Definition
    The payment‘s captured amount.
    Type
    int
    Regex
    ^\d{1,12}$
    – The payment‘s captured amount;

    MethodName
    MethodName
    Definition
    The name of the payment method used.
    Type
    string
    – The name of the payment method used;

    PaymentStateDefID
    PaymentStateDefID
    Definition
    The ID of the payment status. It can have the following values: 1 - Open, 2 - Success, 3 - Cancelled, 4 - Failed, 5 - Expired, 9 - Authorized.
    Type
    int
    – The ID of the payment status;

    SpecificDetails
    SpecificDetails
    Definition
    Specific details provided.
    Type
    string
    – Specific details provided;

    ReconciliationProviderID
    ReconciliationProviderID
    Definition
    A payment identification ID used at the provider’s end.
    Type
    int
    – A payment identification ID used at the provider’s end;

    ProviderTransactionID
    ProviderTransactionID
    Definition
    Internal ID used for payment notification within our system.
    Type
    int
    – Internal ID used for payment notification within our system;

    MerchantAlias
    MerchantAlias
    Definition
    Your merchant alias in our system.
    Type
    string
    – Your merchant alias in our system;

    MerchantSiteID
    MerchantSiteID
    Definition
    GlobalPay website ID, a unique number that identifies the website in the GlobalPay system.
    Type
    int
    Regex
    ^\d{1,12}$
    – The ID of your site in our system;

    MerchantSiteAlias
    MerchantSiteAlias
    Definition
    Site alias, an alternative name that identifies the website in the GlobalPay system.
    Type
    string
    Regex
    ^.{1,255}$
    – Your site alias in our system;

    RootProviderTransactionID
    RootProviderTransactionID
    Definition
    The transaction ID from the provider.
    Type
    int
    – The transaction ID from the provider;

    Country
    Country
    Definition
    Customer‘s country. Format is according to ISO-3166-1 alpha-2, a two-letter code.
    Type
    string
    Regex
    ^[a-zA-Z]{2}$
    – When available, it containts the customer billing country.

    3.  

  3. The list of refunds: MerchantDemo_REFUNDS_2018_07_07;1 Refunds report

    The refunds report file contains the following information:

    Id
    Id
    Definition
    GlobalPay Refund ID, a unique number that identifies the refund in the GlobalPay system
    Type
    int
    Regex
    ^\d{1,12}$
    – GlobalPay Refund ID, a unique number that identifies the refund in the GlobalPay system;

    RefundRequestDate
    RefundRequestDate
    Definition
    Date and time when the refund was created in GlobalPay system
    Type
    datetime
     – Date and time when the refund was created in GlobalPay system;

    EntryDate
    EntryDate
    Definition
    Date and time when the refund was created in GlobalPay system
    Type
    datetime
     – Date and time when the refund was created in GlobalPay system;

    MethodName
    MethodName
    Definition
    The name of the payment method used
    Type
    string
     – The name of the payment method used;

    Customer
    Customer
    Definition
    When available, the Customer Name is being displayed in this field
     – When available, the Customer Name is being displayed in this field;

    MerchantTransactionID
    MerchantTransactionID
    Definition
    Merchant Transaction ID, a number that uniquely identifies a transaction in your system
     – Your Merchant Transaction ID – can be used for reconciliation;

    Amount
    Amount
    Definition
    The amount of the refund in the currency in which the refund was initiated
     – The amount of the refund in the currency in which the refund was initiated;

    Currency
    Currency
    Definition
    The currency in which the refund was initiated
     – The currency in which the refund was initiated;

    ToBeInvoiced
    ToBeInvoiced
    Definition
    if a fee is applied against the refund or not
     – if a fee is applied against the refund or not;

    PaymentID
    PaymentID
    Definition
    ID of the initial payment for which the refund was made
     – ID of the initial payment for which the refund was made;

    TrxDate
    TrxDate
    Definition
    The data and time when the initial transaction was initiated in our system (UTC)
     – The data and time when the initial transaction was initiated in our system (UTC);

    OtherDetails
    OtherDetails
    Definition
    Any other additional information
    ;

    Merchant
    Merchant
    Definition
    Your merchant alias in our system
    Type
    string
     – Your merchant alias in our system;

    SiteID
    SiteID
    Definition
    GlobalPay website ID, a unique number that identifies the website in the GlobalPay system.
    Type
    int
    Regex
    ^\d{1,12}$
     – The ID of your site in our system;

    RefundType
    RefundType
    Definition
    The type of refund: Native, SEPABankTransfer, SWIFTBankTransfer, ManualSupportWorkNoInfo, SEPABankTransferNoInfo, SWIFTBankTransferNoInfo, LocalBankTransfer, LocalBankTransferNoInfo, ManualSupportWorkDetailsNeeded, LocalBankTransfer2API
     – the type of refund: https://docs-apm.nuvei.com/category/refunds-api/refund-types/;

    PayerEntity
    PayerEntity
    Definition
    The source of the refund entity (usually Smart2Pay entity)
     – the source of the refund entity (usually Nuvei entity);

    PayerAccount
    PayerAccount
    Definition
    Smart2Pay Account, when applicable
     – Nuvei Account, when applicable;

    PayerBIC
    PayerBIC
    Definition
    Smart2Pay BIC, when applicable
     – Nuvei BIC, when applicable;

    Country
    Country
    Definition
    Customer‘s country. Format is according to ISO-3166-1 alpha-2, a two-letter code.
    Type
    string
    Regex
    ^[a-zA-Z]{2}$
     – When available, it contains the customer billing country;

    ReconciliationProviderID
    ReconciliationProviderID
    Definition
    A payment identification ID used at the provider’s end
     – The transaction ID from the provider.

    4.  

  4. The list of refunds for SmartCards payment method: MerchantDemo_SMARTCARDS_REFUNDS_2018_07_07.

    1 SmartCards Refunds report

    The SmartCards refunds report file contains the following information:

    ID
    ID
    Definition
    A unique number that identifies the refund in the Smartcards system
    Type
    int
    Regex
    ^\d{1,12}$
     – a unique number that identifies the refund in the Smartcards system;

    MerchantAlias
    MerchantAlias
    Definition
    Your merchant alias in our system
    Type
    string
     – Your merchant alias in our system;

    MerchantSiteAlias
    MerchantSiteAlias
    Definition
    Your site alias in our system
    Type
    string
     – Your site alias in our system;

    MerchantSiteID
    MerchantSiteID
    Definition
    The ID of your site in our system
    Type
    string
     – The ID of your site in our system;

    MerchantTransactionID
    MerchantTransactionID
    Definition
    Merchant Transaction ID, a number that uniquely identifies a transaction in your system.
    Type
    string
    Regex
    ^[0-9a-zA-Z_-]{1,50}$
     – Merchant Transaction ID, a number that uniquely identifies a transaction in your system;

    InputDateTime
    InputDateTime
    Definition
    Date and time when the transaction was created in GlobalPay system.
    Type
    datetime
     – Date and time when the refund was created in the Smartcards system;

    InitialPaymentID
    InitialPaymentID
    Definition
    ID of the initial payment for which the refund was made
     – ID of the initial payment for which the refund was made;

    MerchantAmount
    MerchantAmount
    Definition
    The amount of the refund
     – The amount of the refund;

    MerchantCurrency
    MerchantCurrency
    Definition
    The currency in which the refund was initiated
     – The currency in which the refund was initiated;

    Status
    Status
    Definition
    The status of the refund. It can have the following values: Open, Success, Failed.
    Type
    int
     – The status of the refund. It can have the following values: Open, Success, Failed;

    MethodName
    MethodName
    Definition
    The name of the payment method used
     – The name of the payment method used;

    ProviderTransactionID
    ProviderTransactionID
    Definition
    Internal ID used for payment notification within our system.
    Type
    int
     – The transaction ID from the provider;

    RefundType
    RefundType
    Definition
    The type of refund: Native - is the only one available at the moment
     – the types of refund: https://docs-apm.nuvei.com/category/refunds-api/refund-types/;

    ReportedByBOTOperatorDate
    ReportedByBOTOperatorDate
    Definition
    The date when the transaction was exported in a SFTP/CSV file
    Type
    datetime
     – The date when the transaction is exported in a SFTP/CSV file;

    Bookdate
    Bookdate
    Definition
    Bookdate
     – The date when the transaction is reported by the bank.

Settlement invoice reports

    The Settlement invoice reports are a great tool that allows you to verify each transaction and activity in detail, including:

  • Any type of fee that applies at transaction level is reported with great granularity;
  • Information about all the payment methods traded are available in only one report;
  • The report is the confirmation that the payout to you has been made and thus can be reconciled with the entry into the bank account.

Settlement invoice reports are available in XLS, PDF and CSV format. The settlement invoices reports are generated depending on the settlement cycle of each payment method.

Examples of our standard weekly and monthly settlement cycles are provided below:

    Weekly settlement cycle

    The settlement invoice follows our standards weekly settlement cycle, which means that all transactions processed from Friday (day 1) – Thursday (day 7) period, and settled to Nuvei (before and after day 7) are invoiced and settled to your account on the following Tuesday (day 12):

  • Transactions period: Friday, May 18th, 2018 00:00 UTC (day 1) – Thursday, May 24th, 2018 23:59 UTC (day 7);
  • Invoice date: Tuesday, May 29th (day 12).
    Monthly settlement cycle

    The settlement invoice follows our standards monthly settlement cycle, which means that all transactions processed from July 1st to July 31st period, and settled to Nuvei (before and after July 31st) are invoiced and settled to your account between August 20 – 25th:

  • Transactions period: July 1st, 2018 00:00 UTC (day 1) – July 31st, 2018 23:59 UTC (last day of the month);
  • Invoice date: August 20 – 25th.

Below there are examples of Settlement invoice reports in all supported formats:

The XLS and PDF files are sent by e-mail to a group of people in your organization. Please send an e-mail to technicalsupport-s2p@nuvei.com and inform which people should be receiving this e-mail.

    The XLS file of each settlement invoice contains details about the successful transactions invoiced per payment method and per SiteID, the fees applied per payment method for each SiteID and the general Nuvei account fees. The information appears on separate sheets, as follows:

  • SettlementInvoice = a summary of all information listed in the settlement invoice;
  • Payments = total gross amounts (transactions) you processed via different payment methods and total refunds;
  • Transaction Fees = the fees charged for transactions processed  (according to the signed agreement);
  • Different sheets with transactions processed via a specific payment method (one for each). All payment methods sheets contain certain details per transaction to reconcile them with your system (e.g. PaymentID, InputDateTime, Amount, Currency, Status, Exchange rate, Amount in EUR).
  • Enquiries|Refunds|Reversed|CFTs = details about refunds, payment enquiries, chargebacks, etc.
  • Preapprovals|Mandates = details about preapprovals and mandates.

The CSV files are uploaded on an SFTP server where you can download them from and process them automatically. Please request login details from technicalsupport-s2p@nuvei.com.

1 Settlement invoice report

The Settlement invoice report file contains the following fields:

  • GPaymentId
    GPaymentId
    Definition
    The ID of the payment in Europay system (can be empty if you are using GlobalPay).
    Type
    int
    – ID of the payment in Europay system (can be empty if you are using GlobalPay);
  • PaymentId
    PaymentId
    Definition
    GlobalPay transaction ID, a unique number that identifies the transaction in the GlobalPay system.
    Type
    int
    Regex
    ^\d{1,12}$
    – ID of the payment in GlobalPay system;
  • Type
    Type
    Definition
    Describes the entry type:
    - Entries depending on a transaction (row has GPaymentID and/or PaymentID): Payment, Refund, Chargeback, Chargeback Reversal, Enquiry;
    - Generic entries: Monthly fee, Account Setup Fee, Account Opening Fee, Account Closing Fee, Account and Transactions Fee VAT, Repatriation Fee, IOF, etc.;
    Type
    string
    – Describes the entry type:
    1. Entries depending on a transaction (row has GPaymentID and/or PaymentID): Payment, Refund, Chargeback, Chargeback Reversal, Enquiry;
    2. Generic entries: Monthly fee, Account Setup Fee, Account Opening Fee, Account Closing Fee, Account and Transactions Fee VAT, Repatriation Fee, IOF, etc.;
  • PaymentMethodName
    PaymentMethodName
    Definition
    The name of the payment method used for the current transaction.
    Type
    string
    – The name of the payment method used for current transaction;
  • CustomerName
    CustomerName
    Definition
    When available, the Customer Name is being displayed in this field.
    Type
    string
    – When available, the Customer Name is being displayed in this field;
  • MerchantName
    MerchantName
    Definition
    Your merchant alias in our system.
    Type
    string
    – Your merchant alias in our system;
  • MerchantId
    MerchantId
    Definition
    Your Merchant Transaction ID – can be used for reconciliation.
    Type
    string
    – Your Merchant Transaction ID – can be used for reconciliation;
  • GtId
    GtId
    Definition
    Oobsolete ID that is not used anymore
    – obsolete ID that is not used anymore;
  • IssuerName
    IssuerName
    Definition
    When available, this field contains the name of the buyer bank.
    Type
    string
    – When available, this field contains the name of the buyer bank;
  • IdealTrxId
    IdealTrxId
    Definition
    For iDeal transactions only, it contains the ID of the transaction from the provider.
    Type
    int
    – For iDeal transactions only, it contains the ID of the transaction from the provider;
  • Country
    Country
    Definition
    Customer‘s country. Format is according to ISO-3166-1 alpha-2, a two-letter code.
    Type
    string
    Regex
    ^[a-zA-Z]{2}$
    – When available, it containts the customer billing country;
  • InputDateTime
    InputDateTime
    Definition
    The data and time when the transaction was initiated in our system (UTC).
    Type
    datetime
    – The data and time when the transaction was initiated in our system (UTC);
  • Amount
    Amount
    Definition
    The amount of the transaction in the currency in which the transaction was initiated
    Type
    int
    Regex
    ^\d{1,12}$
    – The amount of the transaction in the currency in which the transaction was initiated;
  • Currency
    Currency
    Definition
    The currency in which the transaction was initiated. Format is according to ISO 4217, a three-letter code.
    Type
    string
    Regex
    ^[A-Z]{3}$
    – The currency in which the transaction was initiated;
  • Status
    Status
    Definition
    The status of the transaction. Can be one of: Open, Success, Captured, Paid, Partially Captured, Failed, Cancelled, Expired, Dispute Lost, Dispute Won.
    Type
    string
    – The status of the transaction. Can be one of: Open, Success, Captured, Paid, Partially Captured, Failed, Cancelled, Expired, Dispute Lost, Dispute Won.
  • ExchangeRate
    ExchangeRate
    Definition
    The exchange rate used to convert from Currency to Settlement Currency (Reference Currency).
    – The exchange rate used to convert from Currency to Settlement Currency (Reference Currency);
  • CalculatedAmount
    CalculatedAmount
    Definition
    The amount of the transaction in the Settlement Currency (Reference Currency).
    Type
    int
    Regex
    ^\d{1,12}$
    – The amount of the transaction in the Settlement Currency (Reference Currency);
  • ReferenceCurrency
    ReferenceCurrency
    Definition
    Your settlement currency for the current transaction. Format is according to ISO 4217, a three-letter code.
    Type
    string
    Regex
    ^[A-Z]{3}$
    – Your settlement currency for the current transaction;
  • PaymentMethodFee
    PaymentMethodFee
    Definition
    The payment method fee charged for the current transaction.
    – The payment method fee charged for the current transaction;
  • TransactionFeePerSuccess
    TransactionFeePerSuccess
    Definition
    The transaction fee that is applied for successful transactions (completed).
    – The transaction fee that is applied for successful transactions (completed);
  • TransactionFeePerAttempt
    TransactionFeePerAttempt
    Definition
    The transaction fee that is applied for each successful and unsuccessful transaction processed through Smart2Pay.
    – The transaction fee that is applied for each successful and unsuccessful transaction processed through Smart2Pay;
  • IssuedFee
    IssuedFee
    Definition
    An additional transaction fee used for specific payment methods
    – An additional transaction fee used for specific payment methods;
  • LocalVatFee
    LocalVatFee
    Definition
    The local value-added tax (VAT) applied for Payment Method Fee and/or for transaction’s value for specific countries, depending on the case.
    – The local value-added tax (VAT) applied for Payment Method Fee and/or for transaction’s value for specific countries, depending on the case;
  • VAT
    VAT
    Definition
    Value-added tax (VAT) charged by Smart2Pay for PaymentMethodFee, TransactionFeePerSuccess, TransactionFeePerAttempt and Account Fees according to EU Vat regulations if necessary – field currently not used, but the information is available as additional rows at the bottom of the file.
    – Value-added tax (VAT) charged by Nuvei for PaymentMethodFee, TransactionFeePerSuccess, TransactionFeePerAttempt and Account Fees according to EU Vat regulations if necessary – field currently not used, but the information is available as additional rows at the bottom of the file;
  • InvoiceNumber
    InvoiceNumber
    Definition
    The number of the invoice
    – The number of the invoice;
  • InvoiceDate
    InvoiceDate
    Definition
    The date the invoice was issued
    Type
    datetime
    – The date the invoice was issued.
  • SpecificDetails
    SpecificDetails
    Definition
    Specific details provided.
    Type
    string
    – Specific details provided;