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 Smart2Pay (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 Smart2Pay (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 support@smart2pay.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 Smart2Pay 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 support@smart2pay.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 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;
  • 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;