Financial reports

Financial entries report offers crucial data for reconciliations and reporting

This report enables reconciliation of transactions, fees charged by acquirers and Solidgate, and the exchange rates of acquirers.

Moreover, the report allows for flexible analysis of financial data based on various parameters, including the issuing country, payment method, card brand, and more. This feature is instrumental in providing insights into the financial performance of your payments

Run a report

To run a report, follow these steps:

Make an API request.
Receive the report URL in the response.
Download the report using this URL and the correct authorization credentials.

Step 1

Make a request to generate the report by providing the necessary parameters, such as using the appropriate API endpoint in two ways: Financial entries by date range API
date_from , date_to

Financial entries by settlement API
settlement_id

Step 2

Upon successful submission, the API responds with a report_url where the generated report can be downloaded in CSV format.

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

Step 3

Download the report API using the report_url , it is crucial to use the same Guide
Learn to authenticate API requests and fix validation errors effectively. authorization credentials ( publicKey + secretKey ) to make the API request for downloading the report.

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

201 this indicates an authentication failure; double-check your access to the Solidgate API.
204 this status means the report is not yet ready; wait a little longer for it to be generated.
302 this code signifies a redirect to a one-time S3 download report link.
404 this indicates the report was not found.
410 this means the 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.

Report structure

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


{
  "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"
}

Access to API

Learn to authenticate API requests and fix validation errors effectively.

Integrate

Seamlessly integrate Solidgate into your product using various integration options.

Testing

Simulate payments to test your integration before launching in production.