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

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

It is crucial to use the same authorization credentials ( 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

  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
    • Select the preferred Date field option
    • 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 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.

chevron down chevron up Financial report properties Expand all chevron down chevron up id string

Description

Financial record ID.

Example

ft_1mc2209090000_fKJScPc

chevron down chevron up order_id string

Description

Order ID generated by the merchant.

Example

mvbcdj1335d

chevron down chevron up external_psp_order_id string

Description

Order ID generated by Solidgate.

Example

psp_order_1samrzwv8my

chevron down chevron up transaction_id string

Description

Unique identifier associated with a transaction.

Example

5019d00bb70f82cd42f6bc654cbdfcbd63a9b5b1dbd6a

chevron down chevron up chargeback_id string

Description

Unique identifier associated with a chargeback.

Example

148812

chevron down chevron up created_at string

Description

String of when the record was created by Solidgate’s financial system.

Format: YYYY-MM-DD HH:MM:SS

Example

2024-07-23 17:39:50

chevron down chevron up transaction_datetime_provider string

Description

Date on which the transaction or fee occurred.

Dates in the timezone of the provider.

Example

2024-07-23 17:39:50

chevron down chevron up transaction_datetime_utc string

Description

Date on which the transaction or fee occurred.

Dates in UTC.

Example

2024-07-23 17:39:50

chevron down chevron up accounting_date string

Description

Determines which settlement or invoice includes the record.

Only populated for provider “Solidgate”.

Format: YYYY-MM-DD

Example

2024-07-23

chevron down chevron up amount string

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

chevron down chevron up amount_in_major_units string

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

chevron down chevron up currency string

Description

Currency in which the financial record is initially defined (3-letter code under ISO 4217 Wiki ).

Example

EUR

chevron down chevron up currency_minor_units string

Description

Minor units of the currency.

Example

100

chevron down chevron up payout_amount string

Description

Payout amount is expressed in minor currency units (as an integer).

For instance, 1020 represents 10 USD and 20 cents

Example

1020

chevron down chevron up payout_amount_in_major_units string

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.

Example

10.20

chevron down chevron up payout_currency string

Description

Payout currency (3-letter code under ISO 4217 Wiki ).

Example

EUR

chevron down chevron up payout_currency_minor_units string

Description

Minor units of the payout currency.

Example

100

chevron down chevron up record_type_key string

Description

Type of financial record.

  • SALE
  • REFUND
  • DISCOUNT FEE
  • CHARGEBACK FEE

Example

SALE

chevron down chevron up provider string

Description

Name of the provider that processed the transaction.

Example

Solidgate

chevron down chevron up payment_method string

Description

Payment method used for the transaction.

  • card
  • network-token
  • token
  • apple-pay
  • google-pay

Example

card

chevron down chevron up card_brand string

Description

Brand of the card used for the transaction.

Example

VISA

chevron down chevron up geo_country string

Description

Customer country.

The code shall have the format ISO-3166 Wiki alpha-3.

Example

USA

chevron down chevron up issuing_country string

Description

Country of the issuing bank.

Example

USA

chevron down chevron up legal_entity string

Description

Legal entity associated with the financial record.

Example

Global Ltd.