Financial entries

[ { "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 in touch
Sign in
Financial entries
Financial entries report offers crucial data for reconciliations and reporting

Financial entries report provides a detailed transaction-level breakdown of financial records, delivering insights into operational performance. It includes key details, such as original and payout amounts, respective currencies, types of financial records such as sales or refunds, payment methods, card brands, and more. You can use this report for:

  • Transaction review
    Examine transactions that influenced the balance, including sales, refunds, chargebacks, and RDRs.
  • Fee evaluation
    Assess each fee associated with individual transactions for detailed cost assessment.
  • Currency conversion
    Compare amounts in original and payout currencies while calculating applicable exchange rates.
  • In-depth financial analytics
    Perform detailed analyses using various criteria, such as payment method, card brand, geo country, issuing country, legal entity, and other relevant factors.
  • Automated data retrieval
    Configure automated processes to obtain financial data and enable daily reporting and monitoring, ensuring real-time insights into financial performance.
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.

Data is retrieved based on the created_at field, which reflects when the record was entered into the Solidgate financial system, two days after the transaction date. The two-day delay ensures that any post-calculation changes are shown in the next period.

For example, a transaction from January 1st will be included in the data for January 3rd, reflecting any post-calculation changes. To get transactions from January 1st to January 31st, request data from January 1st through February 2nd, then filter by transaction date in the extracted file.

To create a report

  1. Make an API request by the suitable API endpoint and with the necessary parameters:
  2. Receive the report URL in the response.
  3. Download the report in CSV format using the URL and authorization credentials.
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 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.
To create a financial entries report

  1. Go to Reports&Exports.
  2. In the top-right corner, click on +Create report.
  3. 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
  4. Click on Create.
    Once confirmed, the reports are created for each selected channel.
  5. 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.

 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