Access itemized financial entries with timestamps, amounts, fees, and settlement references for precise transaction-level reconciliation
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 get financial data and enable daily reporting and monitoring, ensuring real-time insights into financial performance.
Create report
Financial entries
API v1 report provides 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, 4 hours after the transaction date. The 4-hour delay ensures that any post-calculation changes are shown in the next period. It is also possible to filter by another date range.
For example, a transaction late on January 31 may have a created_at timestamp early on February 1 because of the 4-hour processing window. To include all transactions that occurred from January 1 through January 31 when querying by created_at, extend the requested range slightly past the calendar month end (for example, through the morning of February 1), then filter the results by transaction date in the extracted file.
To create and download a financial entries report
Send a request to the
financial entries
API v1 endpoint with the following parameters:
date_from
,
date_to
,
filter
.
Receive the report URL report_url in the response.
Send a GET request to the
download
API v1 endpoint using report_url and the same authorization
Guide
Get API credentials and open the API reference for authentication, signing, and endpoint details.
credentials
(
publicKey
+
secretKey
) used in the report creation request.
Report generation is asynchronous, and the time required depends on the volume of requested data. If the report is not ready when you send a download request, the API returns
204
. This is expected, and you can retry the request until the report is ready.
The download request can return the following status codes:
200
- authentication failed, check your Solidgate API access
204
- the report is not ready yet, retry the request later
302
- the report is ready, and the response redirects to a one-time S3 download URL
404
- the report was not found
410
- the report is unavailable or has expired
Reports are available for 30 days
after generation. After this period, they can no longer be downloaded.
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 properties
Expand all
Description
Financial record ID.
Example
ft_1mc2209090000_fKJScPc
Description
Order ID generated by the merchant.
Example
mvbcdj1335d
Description
Order ID generated by Solidgate.
Example
psp_order_1samrzwv8my
Description
Unique identifier associated with a transaction.
Example
5019d00bb70f82cd42f6bc654cbdfcbd63a9b5b1dbd6a
Description
Unique identifier associated with a chargeback.
Example
148812
Description
Order description in your system and for bank processing.
Can be null.
Example
Premium package
Description
String of when the record was created by Solidgate’s financial system.
Typically within 4 hours after the transaction time.
Pattern: ^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$
Example
2025-07-23 17:39:50
Description
Date on which the transaction or fee occurred.
Dates in the timezone of the provider.
Example
2025-07-23 17:39:50
Description
Date on which the transaction or fee occurred.
Dates in UTC.
Example
2025-07-23 17:39:50
Description
Determines which settlement or invoice includes the record.
Only populated for provider “Solidgate”.
Pattern: ^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$
Example
2025-07-23
Description
Original amount of the financial record.
Expressed in minor currency units (as an integer). For instance, 1020 means 10 USD and 20 cents.
Example
1020
Description
Amount automatically converted to major currency units by dividing amount by the currency’s minor units.
For example, if amount = 1020 and currency minor units = 100, this field shows 10.20.
This conversion is done automatically by the system before export to simplify processing.
Example
10.20
Description
Currency in which the financial record is initially defined (3-letter code under
ISO 4217
Wiki).
Example
EUR
Description
Minor units of the currency.
Example
100
Description
Payout amount is expressed in minor currency units (as an integer).
For instance, 1020 represents 10 USD and 20 cents
Example
1020
Description
Payout amount automatically converted to major currency units by dividing payout_amount by the payout currency’s minor units.
For example, if payout_amount = 1020 and payout currency minor units = 100, this field shows 10.20.
This conversion is done automatically by the system before export.