Solid HUB has a number of reports. This makes it possible to analyze the data from the first day of cooperating with Solid. The report “Finance” gives the opportunity to understand and reconcile the activity in your account. When creating the report, you can select the date range and choose the needed channels.
The following parameters are available in this CVS report:
id - Financial record ID;
order_id - Order ID generated by the merchant;
external_psp_order_id - Order ID generated by Solidgate;
created_at - The timestamp of when the record was created by Solidgate's financial system;
transaction_datetime_provider - The date on which the transaction or fee occurred. Dates in the timezone of the provider;
transaction_datetime_utc - The date on which the transaction or fee occurred. Dates in UTC;
accounting_date - Determines which settlement or invoice the record will be included in Only populated for the provider = 'Solidgate'. Format: YYYY-MM_DD;
amount - The original amount of the financial record. Expressed in minor currency units (as an integer).
For instance, 1020 means 10 USD and 20 cents;
currency - The currency in which the financial record is initially defined (3 letter code under ISO 4217);
currency_minor_units - Minor units of the currency;
payout_amount - The payout amount. Expressed in minor currency units (as an integer).
For instance, 1020 means 10 USD and 20 cents;
payout_currency - The payout currency (3 letter code under ISO 4217);
payout_currency_minor_units - Minor units of the payout currency;
record_type_key - Type of the financial record. Fir example: SALE, REFUND, DISCOUNT FEE, CHARGEBACK FEE;
provider - Name of the Provider that processed the transaction;
payment_method - Payment method;
card_brand - Card Brand;
geo_country - Customer country. The code shall have the format ISO 3166-1 alpha-3;
issuing_country - Сountry of the issuing bank.
In case of any questions, please contact our Support Team directly via http://support.solidgate.com/