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, financial record types like sales or refunds, payment methods, and card brands. 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.

Create report

Via API

Financial entries API report provides a detailed and structured insights into financial transactions. It covers 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. It is also possible to filter by other date range.

For example, a transaction from January is 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 the results by transaction date in the extracted file.

To create a report

Make an API request to the Financial entries by date range API endpoint and with the following parameters:
date_from , date_to , filter
Receive the report URL in the response.
Download the report as a CSV file using the URL and authorization credentials.

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

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 failed, check your Solidgate API access
204 - report not ready yet, wait a bit longer for it to generate
302 - redirect to a one-time S3 report download link
404 - report not found
410 - report unavailable or 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
- Select the preferred Date field option
- 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 Solidgate API, including additional fields for expanded analysis and insights.

View report data

Descriptions and examples of financial report properties are provided in the list that follows.

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": "psp_order_1samrzwv8my",
  "transaction_id": "5019d00bb70f82cd42f6bc654cbdfcbd63a9b5b1dbd6a",
  "chargeback_id": "148812",
  "created_at": "2024-07-23 17:39:50",
  "transaction_datetime_provider": "2024-07-23 17:39:50",
  "transaction_datetime_utc": "2024-07-23 17:39:50",
  "accounting_date": "2024-07-23",
  "amount": 1020,
  "amount_in_major_units": 10.20,
  "currency": "EUR",
  "payout_amount": 1020,
  "payout_amount_in_major_units": 10.20,
  "payout_currency": "EUR",
  "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