Financial entries

Financial entries report offers crucial data for reconciliations and reporting

These reports include essential data such as the original and payout amounts, the respective currencies, and the types of financial records such as sales or refunds. Additionally, they contain details about the payment method, card brand, and geographical information of both the customer and the issuing bank.

Via API

Financial entries API report provide a detailed and structured insights into financial transactions, encapsulating key information such as financial record IDs, order IDs, creation dates, transaction amounts, and currencies.

The report unloads data based on the created_at + 2 days parameter, which corresponds to the date the operation was executed.

To create a report

Make an API request by the suitable API endpoint and with the necessary parameters:
- Financial entries by date range API
  date_from , date_to
- Financial entries by settlement API
  settlement_id
Receive the report URL in the response.
Download the report in CSV format using the URL and authorization credentials.

It is crucial to use the same ( publicKey + secretKey ) to make the API request for downloading the report API .

Since the report is prepared asynchronously, it may take some time before it is ready for download. If the report is not ready, the API reference returns the corresponding status code:

200 - authentication failure. Double-check your access to the Solidgate API.
204 - report is not yet ready. Wait a little longer for it to be generated.
302 - redirect to a one-time S3 download report link.
404 - report was not found.
410 - report is unavailable, expired.

Please note that the report is only available for 30 days from its generation date. After that period, it is no longer accessible.

Via HUB

To create a financial entries report

Go to Reports&Exports.
In the top-right corner, click on +Create report.
In the pop-up window, add the required information:
- Select the Finance report type
- Select one or several channels
- Specify a date range of up to 36 days
- Optionally, change the auto-created file name
Click on Create.
Once confirmed, the reports are created for each selected channel.
Click on Download to save and view the report.

Please note that a more detailed report is available through our API, including additional fields for expanded analysis and insights.

Financial report example

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24


{
  "id": "ft_1mc2209090000_fKJScPc",
  "order_id": "mvbcdj1335d",
  "external_psp_order_id": "2343253452323412sd12ds",
  "transaction_id": "5019d00bb70f82cd42f6bc654cbdfcbd63a9b5b1dbd6a",
  "chargeback_id": "148812",
  "created_at": "2021-07-23 17:39:50",
  "transaction_datetime_provider": "2021-07-23 17:39:50",
  "transaction_datetime_utc": "2023-07-23 17:39:50",
  "accounting_date": "2021-07-23",
  "amount": 1020,
  "currency": "EUR",
  "currency_minor_units": 100,
  "payout_amount": 1020,
  "payout_currency": "EUR",
  "payout_currency_minor_units": 100,
  "record_type_key": "SALE",
  "provider": "Solidgate",
  "payment_method": "card",
  "card_brand": "VISA",
  "geo_country": "USA",
  "issuing_country": "USA",
  "legal_entity": "Global Ltd."
}

Looking for help? Contact us

Stay informed with Changelog