Financial reports

[ { "title":"Testing", "link":"https://docs.solidgate.com/payments/testing/", "text":"Simulate payments to test your integration before launching in production.", "imgSrc":"https://solidgate.com/wp-content/uploads/2022/06/icon-customizable.svg" } , { "title":"Create your payment form", "link":"https://docs.solidgate.com/payments/integrate/payment-form/create-your-payment-form/", "text":"Understand how to integrate the payment form into your product.", "imgSrc":"https://solidgate.com/wp-content/uploads/2022/06/icon-payments.svg" } , { "title":"Subscriptions", "link":"https://docs.solidgate.com/subscriptions/", "text":"Create and maintain a stable and healthy business subscription model.", "imgSrc":"https://solidgate.com/wp-content/uploads/2022/06/icon-global.svg" } ]

Get started
Sign In
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
anchor

To run a report, follow these steps:

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

Step 1
anchor

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
anchor

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
anchor

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
anchor 

 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"
}
Looking for help? Contact us
Stay informed with Changelog