A number of reports is realized in Solid’s HUB. This makes it possible to analyze the data from the first day of cooperating with Solid. The report "Card" reconciliation allows downloading the table with detailed order descriptions for the defined time period.




Card Orders Reconciliation

On the Card page, under the Reconciliation section, you can create the report by tapping on the plus bottom in the upper right corner.


Graphical user interface, text, application

Description automatically generated


After that, you will be able to concretize the report by filters:


- Date


-Channel


Kindly ask you to note, that both fields need to be chosen as they are required to create the report




The Date filter can be concretized by choosing the needed period using the calendar or applying prepared time periods such as today, yesterday, last 7 days, last 30 days, this or last month.

Please note, that the maximum date range for this report is 36 days. 


The created report will be located on the list of Card reconciliation:


Graphical user interface, application

Description automatically generated

It is possible to download the report in CSV format by clicking on the File tab. The following parameters are available in this CVS report:


order_id - ID of the order generated by the merchant;

order_status - status of processed payment, for example, settle_ok, approved, refunded;

order_type - the type of operation. Types of order status are described in the respective directory;

order_amount - the amount of currency in the order. Expressed in minor currency units (as an integer). For instance, 1020 means 10 USD and 20 cents;

order_currency - order currency (3 letter code under ISO 4217);

order_description - order description in UTF-8;

order_customer_account_id - customer account ID on merchant site;

order_customer_email - customer email;

order_customer_first_name - customer's first name;

order_customer_last_name - customer last name;

order_geo_country - customer country. The code shall have the format ISO 3166-1 alpha-3;

order_ip_address - customer IP (only the public one);

order_error_code - error code (error codes list);

order_platform - customer platform at the moment of payment. Available values: WEB - desktop, MOB - mobile version, APP - application;

order_fraudulent - the customer was detected on the merchant end to be the suspicious one;

order_is_secured - the attribute shows that the payment goes through 3DS-verification;

order_created_at - date and time of order creation;

order_updated_at - date and time of order update;

transaction_id - transaction ID;

transaction_operation - type of operation;

transaction_status - transaction status;

transaction_descriptor - descriptor of order transaction (how it looks in the Bank statement);

transaction_amount - the amount of currency in the transaction. Expressed in minor currency units (as an integer). For instance, 1020 means 10 USD and 20 cents;

transaction_currency - transaction currency (3 letter code under ISO 4217);

transaction_refund_reason - refund reason for the transaction;

transaction_refund_reason_code - code of refund reason;

transaction_billing_details.address - address of the billing;

transaction_billing_details.zip - ZIP for the billing;

transaction_billing_details.country - country of the billing;

transaction_billing_details.city - city of the billing;

transaction_billing_details.state - state of the billing;

transaction_created_at - date and time of transaction creation;

transaction_updated_at - date and time of transaction update;

transaction_finance_fee_amount - finance fee amount. Expressed in minor currency units (as an integer). For instance, 1020 means 10 USD and 20 cents;

transaction_finance_fee_currency - finance fee currency (3 letter code under ISO 4217);

transaction_marketing_fee_amount - marketing fee amount. Expressed in minor currency units (as an integer). For instance, 1020 means 10 USD and 20 cents;

transaction_marketing_fee_currency - marketing fee currency (3 letter code under ISO 4217);

transaction_card.card_holder - cardholder name.