---
title: Get a report file by ID
description: To get the status and a link to the report file in CSV or XLSX format, send a GET request to {YOUR DWH URL}/api/v2/reports/{report_id}, where {report_id} stands for identifier assigned by the PSP system to the requested report. The report identifier can be obtained in a successful response to the report request.
---

[Skip to content](https://help.ecomcharge.com/en/knowledge-base/api-get-a-report-file-by-id#main-content)

- [English](https://help.ecomcharge.com/en/knowledge-base/api-get-a-report-file-by-id)
- [Русский](https://help.ecomcharge.com/knowledge-base-ru/api-get-a-report-file-by-id)

English

Show submenu for translations

[Customer portal](https://help.ecomcharge.com/tickets?hsLang=en)

- [Subscribe to platform updates](https://share-eu1.hsforms.com/1iuchcnmzT9yq2VKMCRdsLwfnh6h)
- [Support & Requests](https://help.ecomcharge.com/en/knowledge-base/support-requests)

Open main navigation

Close main navigation

- [Subscribe to platform updates](https://share-eu1.hsforms.com/1iuchcnmzT9yq2VKMCRdsLwfnh6h)
- [Support & Requests](https://help.ecomcharge.com/en/knowledge-base/support-requests)
- - [English](https://help.ecomcharge.com/en/knowledge-base/api-get-a-report-file-by-id)
    - [Русский](https://help.ecomcharge.com/knowledge-base-ru/api-get-a-report-file-by-id)

  English
  
  Show submenu for translations
- [Customer portal](https://help.ecomcharge.com/tickets)
- [eComCharge Blog](https://ecomcharge.com/blog/)

[eComCharge Blog](https://ecomcharge.com/blog/)

 This is a search field with an auto-suggest feature attached.

- There are no suggestions because the search field is empty.

1. [eComCharge knowledge base](https://help.ecomcharge.com/en/knowledge-base?hsLang=en)
2. [PSP API documentation](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en)
3. [Reports (DWH v.2)](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#reports-dwh-v-2)

# Get a report file by ID

To get the status and a link to the report file in CSV or XLSX format, send a GET request to `{YOUR DWH URL}/api/v2/reports/{report_id}`, where {report\_id} stands for identifier assigned by the PSP system to the requested report. The report identifier can be obtained in a successful response to the [report request](https://psp-doc.begateway.com/en/psp_reports/reports_async/).

### Response

 Response example

```
{    "data": {        "report": {            "id": "c3050350-358c-4336-9ba2-da187fc443f5",            "status": "successful",            "type": "balance_records",            "format": "xlsx",            "engine": "oban",            "attempt": 1,            "updated_at": "2025-12-15T12:22:38.821314Z",            "language": "en",            "user_id": 1098,            "created_at": "2025-12-15T12:22:38.821314Z",            "psp_id": 1,            "generated_at": "2025-12-15T12:22:55.605715Z",            "expiry_date": "2025-12-18T12:22:55.618136Z",            "file_url": "https://s3.eu-west-1.amazonaws.com/wlsexports-test/app/local_vol/reports/c3050350-358c-4136-9ba2-da187fc443f5/report_balance_records_202412312100_202511302059_c3050350.zip?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAJBYIPDD7GHCZUBWQ%2F20251215%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Date=20251215T122255Z&X-Amz-Expires=259200&X-Amz-SignedHeaders=host&X-Amz-Signature=77e5f4e97f8544e26f90c75877df81167871b09736524f3110eabea1aa270f17",            "notification_email": "test@test.com",            "request_params": {                "currency": "USD",                "shop_id": 1673,                "date_from": "2024-12-31T21:00:00.000000Z",                "date_to": "2025-11-30T20:59:59.999999Z"            }        }    }}
```

#### Report structure

### `balance_records` report structure

**Balances** are the total amount of all pay-in transactions (payments, captures) minus the tptal amount of payouts, refunds, chargebacks, rolling reserve, rates and adjustments.

The report contains two sheets: `balance_records` and `opening_balance`.

#### `balance_records`

 

| **Column name** | **Column description** |
| --- | --- |
| Merchant ID | Merchant identifier in the PSP system. |
| Merchant name | Merchant company name in the PSP system. |
| Shop ID | Shop identifier in the PSP system. |
| Shop name | Shop name in the PSP system. |
| Gateway ID | Identifier of the shop gateway in the PSP system. |
| Transaction UID | Transaction identifier in the PSP system. |
| Transaction type | Transaction type. Balance records are created only for financial transaction types. |
| Transaction status | Transaction status. Balance records are created only for the transactions with final statuses. |
| Balance record ID | Balance record identifier in the PSP system. |
| Creation date | Date and time when the balance record was created in the PSP system. |
| Balance record type | Balance record type in the system. |
| Balance record amount | Balance record amount in minimal currency units. |
| Balance record currency | Balance record currency. |
| Description | Balance record description. |

#### `opening_balance`

 

| **Column name** | **Column description** |
| --- | --- |
| As of date | Date of the beginning of the period for which the balance is calculated. |
| Amount | Balance amount in minimal currency units. |
| Currency | Balance currency. |

- [Admin Panel User Guide](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#main-content)

    - [Introduction](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#introduction)
    - [Before you start](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#before-you-start)
    - [Users](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#users)
    - [System administration](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#system-administration)
    - [Merchant account management](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#merchant-account-management)
    - [Configuration of payment gateways](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#configuration-of-payment-gateways)
    - [Merchant shop management](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#merchant-shop-management)
    - [Dashboard](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#dashboard)
    - [Configuration of fraud protection services](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#configuration-of-fraud-protection-services)
    - [Transaction management](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#transaction-management)
    - [Subscription management](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#subscription-management)
    - [Transaction reports](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#transaction-reports)
    - [Accounting and financial reports](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#accounting-and-financial-reports)
    - [Finances](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#finances)
    - [Merchant's balance](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#merchants-balance)
    - [Mass payouts to customers](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#mass-payouts-to-customers)
    - [Additional services](https://help.ecomcharge.com/en/knowledge-base/admin-panel-user-guide?hsLang=en#additional-services)
- [Smart Risk and Routing Engine](https://help.ecomcharge.com/en/knowledge-base/smart-risk-and-routing-engine?hsLang=en#main-content)

    - [Introduction](https://help.ecomcharge.com/en/knowledge-base/smart-risk-and-routing-engine?hsLang=en#introduction)
    - [Overall service description](https://help.ecomcharge.com/en/knowledge-base/smart-risk-and-routing-engine?hsLang=en#overall-service-description)
    - [Getting started](https://help.ecomcharge.com/en/knowledge-base/smart-risk-and-routing-engine?hsLang=en#getting-started)
    - [Smart routing management](https://help.ecomcharge.com/en/knowledge-base/smart-risk-and-routing-engine?hsLang=en#smart-routing-management)
    - [Settings management](https://help.ecomcharge.com/en/knowledge-base/smart-risk-and-routing-engine?hsLang=en#settings-management)
    - [Appendix 1: Logical operators](https://help.ecomcharge.com/en/knowledge-base/smart-risk-and-routing-engine?hsLang=en#appendix-1-logical-operators)
    - [Appendix 2: List of system fields](https://help.ecomcharge.com/en/knowledge-base/smart-risk-and-routing-engine?hsLang=en#appendix-2-list-of-system-fields)
- [PSP API documentation](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#main-content)

    - [Introduction](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#introduction)
    - [Request requirements](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#request-requirements)
    - [HTTP response codes](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#http-response-codes)
    - [PSP ID and Secret Key](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#psp-id-and-secret-key)
    - [Merchants](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#merchants)
    - [Shops](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#shops)
    - [Transactions (DWH v.2)](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#transactions-dwh-v-2)
    - [Transactions (DWH v.1)](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#transactions-dwh-v-1)
    - [Reference](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#reference)
    - [Reports (DWH v.2)](https://help.ecomcharge.com/en/knowledge-base/psp-api-documentation?hsLang=en#reports-dwh-v-2)
- [Video guides](https://help.ecomcharge.com/en/knowledge-base/video-guides?hsLang=en#main-content)

    - [Creating rules in Smart Routing](https://help.ecomcharge.com/en/knowledge-base/video-guides?hsLang=en#creating-rules-in-smart-routing)
    - [Payment Widget customization](https://help.ecomcharge.com/en/knowledge-base/video-guides?hsLang=en#payment-widget-customization)
- [Integrations](https://help.ecomcharge.com/en/knowledge-base/integrations?hsLang=en#main-content)

    - [Active Connectors with PSPs, banks, APM solution providers](https://help.ecomcharge.com/en/knowledge-base/integrations?hsLang=en#active-connectors-with-psps-banks-apm-solution-providers)
- [Release Notes](https://help.ecomcharge.com/en/knowledge-base/release-notes?hsLang=en#main-content)

    - [2025](https://help.ecomcharge.com/en/knowledge-base/release-notes?hsLang=en#2025)
- [Support and Requests](https://help.ecomcharge.com/en/knowledge-base/support-and-requests?hsLang=en)

[![eComCharge\_main logo uncut@3x 1-2](https://help.ecomcharge.com/hs-fs/hubfs/eComCharge_main%20logo%20uncut@3x%201-2.png?width=150&height=77&name=eComCharge_main%20logo%20uncut@3x%201-2.png "eComCharge_main logo uncut@3x 1-2")](https://help.ecomcharge.com/?hsLang=en)

<https://www.linkedin.com/company/ecomcharge/> [mailto:sales@ecomcharge.com](mailto:sales@ecomcharge.com)

© 2026 eComCharge UAB