Skip to content

Transactions and Reconciliations

Notice

Regarding the information features available in the transactions and reconciliations screens of SIBS Backoffice you can have the following features available:

 

  • Add a search filter;
  • Add several search filters;
  • Save a filtered search;
  • Check transaction details;
  • Download/export transaction lists;
  • Check reconciliation operations;
  • Check events and audits.

In the chapters available below you will be able to seek information regarding each feature.

Add a search filter

In the “Payments” menu > “Payment Operations” you can see all the transactions in real-time or you can also filter transactions based on several criteria.

General filters

The general filters available in the page are:

Date

This filter allows you to filter per period of time.

You must define the start and end date, or one of the default periods of time:

  • Today
  • 24 hours
  • 30 days

Store

You can also filter transactions by “Store”. The available stores will be visible on filter field.

POS

This filter allows you to filter by POS terminal and you can filter by up to ten different POS terminals.

POS type

This filter allows you to filter by the type of terminal used for transactions (e.g. mPOS, smartPOS).

Notification

The result page only shows transactions up to 30 days.

Filter based on other criteria

In order to filter based on other criteria you can insert one or more filters in the “Other Filters” field.

The available transaction filters are the following:

FieldValue
AcquirerChoose an option
e-Commerce authenticationChoose an option
ChannelChoose an option
CardEditable
Maximum FeesEditable
Minimum FeesEditable
Client e-mailEditable
Operator emailEditable
EATChoose an option
Payment EntityEditable
Split DeliveryChoose an option
StatusChoose an option
Merchant operation IDEditable
Transaction ID in the channelEditable
Authorisation ID/ARNEditable
Authorised Payment IDEditable
DCC indicatorChoose an option
Fallback indicatorChoose an option
BrandChoose an option
Authentication methodChoose an option
Payment methodChoose an option
Data Retrieval ModeChoose an option
Payment methodChoose an option
Maximum Gross AmountEditable
Minimum Gross AmountEditable
Exact Gross AmountEditable
Exact Net AmountEditable
Maximum Net AmountEditable
Minimum Net AmountEditable
OperationChoose an option
Terminal PeriodEditable
Express QR CodeChoose an option
RecurringChoose an option
MB ReferenceEditable
SystemChoose an option
MB WAY Mobile PhoneEditable
Authorization TypeChoose an option
Card TypeChoose an option
MIT TypeChoose an option
MIT Transaction TypeChoose an option
Offline TransactionChoose an option
Maximum Deferred AmountEditable
Minimum Deferred AmountEditable

Add several search filters

While carrying out a search you can choose a filter in the “Other Filters” and then press the “+” button, as shown in the picture below.

The selected filter will move to the search line. You can add other filters using this same method until your search criteria is complete.

Save a filtered search

After selecting the intended filters, you can save a search, by pressing the “Save” button available in the page.

After that, a window will pop up asking you to name the saved search.

The search will be available in the “Saved Searches” tab.

Check transaction details

In order to view the details of a transaction, you must click in the “Actions” button of the transaction and then click in “Details”.

The table below details all the fields displayed on the transaction details. These fields can differ depending on the transaction type.

Transactions
FieldDescription
Date / Time ProcessingDate and time when the transaction was processed.
Terminal Date / TimeDate and time recorded on the terminal when the transaction was processed.
Note: It may differ from the processing date and time, particularly on physical terminals.
OperationType of transaction (e.g. “Purchase” or “Refund”).
Gross AmountGross amount of the transaction.
Net AmountNet amount of the transaction.
Deferred ValueValue of the transaction processed on a deferred basis.
Note: Deferred payments are payments for goods and services where the debit to the customer’s account does not occur immediately but at a later date, to be agreed with the payment service provider. Consequently, the date of compensation to the Merchant is also affected.
CommissionsCommissions associated with a transaction.
Note: SIBS Backoffice does not show commissions for Service Payment transactions.
Currency codeTransaction currency code. Has the fixed value 978 – Euro.
StatusTransaction status (e.g. “Completed”, “Declined”).
Authorisation TypeIdentifies the type of authorization operation (e.g. incremental authorization).
Error ReasonInforms the error code that occurred in the rejected operations.
Note: successful operations are associated with the code “00.000.0000”.
Error DescriptionGives a description of the error.
Channel Transaction IDIdentification of the transaction channel at SIBS.
Id (Merchant)Identification of the Merchant (assigned by the Merchant).
Authorisation Id / ARNIdentification of the payment system authorization.
Authorisation KeyIdentification of the transaction at SIBS.
Original Authorisation KeyIdentification of the associated transaction in SIBS.
External Original Authorization KeySecondary identification of the transaction in SIBS.
Authentication MethodIdentification of the authentication method used.
AcquirerIdentification of the Acquirer of the transaction.
TSEIdentification of the Terminal Support Entity
Authorised Payment IDIdentification of the Authorized Payment token.
DCC indicatorIdentifies whether the transaction used Dynamic Currency Conversion (DCC). DCC is an option for foreign cardholders that allows payment in the card’s home currency or in Euros.
Amount in Original CurrencyIdentification of the amount in the original currency.
Fall-Back IndicatorIdentifies whether the transaction was decided on a track because the chip data could not be read.
Offline TransactionIdentifies whether the transaction was carried out offline.
Merchant
FieldDescription
MerchantMerchant identification in SIBS systems.
StoreIdentification of the Merchant’s establishment to which the terminal where the transaction was made belongs.
Terminal
FieldDescription
POSIdentification (number) of the terminal used in the operation.
POS brand codeIdentifies the brand and model of the terminal (e.g. ZD).
Terminal TypeIdentifies the type of terminal used (e.g. SmartPOS or WEB).
Accounting PeriodIdentifies the accounting period of the terminal used.
Acceptance
FieldDescription
ChannelIdentifies the type of channel (e.g. digital or physical).
Acceptance network codeIdentifies the network acceptance code.
Acceptance channel Type CodeIdentifies the type of acceptance in the channel.
Payment
FieldDescription
Payment TypeIdentifies the payment mode used, associated with the payment method (e.g. “Contactless” or “QR Code”).
QR Code Express DescriptionName/description defined by the Merchant when creating the QR Code Express. Valid for transactions with the “QR Code Express” payment method.
SchemeIdentifies the brand used in the transaction (e.g. “MB”).
SystemIdentifies the financial system or product used in the transaction.
Payment MethodIdentifies the payment method used (e.g. “MB WAY”, “Card”).
Authentication MethodIdentifies the authentication method used in a physical terminal transaction (e.g. “PIN”, “Signature”).
eCommerce AuthenticationIdentifies the authentication method used in a digital or virtual terminal transaction (e.g. “3DS”).
Merchant Exemption RequestIdentification of the request for a Merchant’s exemption regarding authentication.
Card
FieldDescription
Card Data Entry ModeIdentifies the type of authentication of the operation, from the equipment’s point of view (e.g. “Track”, “Contactless”).
Country CodeIndicates the country of the card.
PresenceIndicates the presence or absence of a card at the time of payment.
MB WAY mobile phoneIdentification of the MB WAY phone number.
NumberNumber of the card used, encrypted.
Card holder
FieldDescription
CodeCustomer identification on the merchant.
PresenceIndicates whether or not the owner of the card is present.
Billing Client NameIdentifies the customer’s name.
E-mailCustomer’s e-mail address.
PhoneIdentifies the customer’s phone number.
Mobile PhoneIdentifies the customer’s mobile phone number.
Billing AddressIdentifies the billing address provided by the customer.
Billing Post CodeIdentifies the postal code associated with the billing address provided by the customer.
Billing CityIdentifies the city associated with the billing address provided by the customer.
Card Country CodeIdentifies the country associated with the billing address provided by the customer.
Shipping AddressIdentifies the shipping address provided by the customer.
Shipping Postal CodeIdentifies the postal code associated with the delivery address provided by the customer.
Shipping CityIdentifies the city associated with the shipping address provided by the customer.
Shipping Country CodeIdentifies the country associated with the delivery address provided by the customer.
Payment reference
FieldDescription
Payment Owner CodeCode of the SIBS merchant that generated the reference for payment of services.
Payment Entity CodeIdentification of the payment of services entity.
Payment Entity Reference CodeNumber corresponding to the payment of services reference.

Download/export transaction list

In order to download the list of transactions, click in the “Complete” or “Basic” download button at the end of the Payment Operations page.

The two types of download differ in:

  • Complete export: allows you to export up to 30.000 transactions, with all the information the platform has on each transaction;
  • Basic export: allows you to export a larger number of rows, up to 100.000 transactions, with a slight reduction in the number of exported columns.
Notification

This export is only available for 24-hour intervals.

In both export options, if the “Transactions Found” list returns a value higher than the defined limit the application will not be able to export all the transactions. In these cases, an informative pop-up is displayed with the time window considered in the export.

Check reconciliation operations

The “Reconciliation Operations” submenu allows the Merchant to search and check details of reconciliations.

The reconciliation procedures depend on the type of terminal:

  • Digital terminal reconciliation: daily automatic reconciliation at 1:00 AM.
  • Physical terminal reconciliation: daily reconciliation (minimum) or every 7 days (maximum), noting that there can exist more than one daily reconciliation which can correspond to different accounting periods.

To check the details of a reconciliation, click on the “Actions” button of a reconciliation and then on “Details”.

Check events and audits

The “Events and Audits” menu serves as a directory in which all actions executed by the users will be recorded. It will provide information about the type of actions executed, the user involved, the date and the description of the action.

In order to see the actions performed by all the users, you must have the Owner role in SIBS Backoffice. Other users will only see the record of actions from users with hierarchically lower profile types.