> For the complete documentation index, see [llms.txt](https://docs.latam-payments.depay.us/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.latam-payments.depay.us/reference/api-reference/reconciliation-files.md).

# Reconciliation Files

This endpoint allows you to download a reconciliation file containing all transactions for a specific period and status. The file can be exported in CSV or TXT format, and includes detailed information for backend validation, accounting, or audits.

## Retrieve files

Returns a reconciliation file with a list of all transactions filtered by date range and status. The file includes key data fields such as UUID, amounts, currencies, statuses, and timestamps.

<mark style="color:blue;">`GET`</mark> `https://stage.api.payments.depay.us/reports/conciliation/payins`

#### Headers

<table><thead><tr><th width="251.4375">Name</th><th width="170.609375">Type</th><th>Description</th></tr></thead><tbody><tr><td>Authorization<mark style="color:red;">*</mark></td><td>String</td><td>Bearer Token.</td></tr></tbody></table>

#### Query Parameters

<table><thead><tr><th width="252.9765625">Name</th><th width="82.125">Type</th><th width="85.8203125">Required</th><th>Description</th></tr></thead><tbody><tr><td>start_date</td><td>String</td><td>No</td><td>Start date for the report (format: YYYY-MM-DD).</td></tr><tr><td>end_date</td><td>String</td><td>No</td><td>End date for the report (format: YYYY-MM-DD).</td></tr><tr><td>status</td><td>String</td><td>No</td><td>Filter by transaction status (e.g., CREATED, COMPLETED, CANCELED).</td></tr><tr><td>format</td><td>String</td><td>Yes</td><td>File format: <code>csv</code> (default) or <code>txt</code>.</td></tr></tbody></table>

#### **Fields in the reconciliation file:**

| Field                           | Type     | Description                                                                   |
| ------------------------------- | -------- | ----------------------------------------------------------------------------- |
| Status                          | String   | Status of the transaction (e.g., COMPLETED, FAILED, CANCELED).                |
| External Reference              | String   | Custom reference provided by the merchant for internal tracking.              |
| POS External Reference          | String   | Reference used by the merchant’s POS system to link the payment.              |
| Order Id                        | String   | Unique identifier assigned by Depay to the order.                             |
| Customer                        | String   | Unique identifier assigned by Depay to the customer.                          |
| Collector Name                  | String   | Registered name of the collector receiving the payment.                       |
| Collector Identification Number | String   | Tax ID or legal identifier of the collector or business.                      |
| User Amount                     | Decimal  | Amount paid by the user in their original currency.                           |
| User Currency                   | String   | Currency code representing the user’s payment currency (e.g., ARS, BRL).      |
| User Country                    | String   | ISO 3166-1 alpha-2 country code of the user's country (e.g., AR, BR, US).     |
| User Name                       | String   | Full name of the user making the payment.                                     |
| User Account Number             | String   | Bank or virtual account number used by the user.                              |
| User Tax ID                     | String   | Tax identifier or document number of the user (e.g., CPF, CUIT, SSN).         |
| Amount USD                      | Decimal  | Payment amount expressed in USD for reference.                                |
| Local Amount                    | Decimal  | Amount to be received by the merchant in the local currency.                  |
| Local Currency                  | String   | Currency code representing the local currency (e.g., ARS, BRL).               |
| Local Country                   | String   | ISO 3166-1 alpha-2 country code of the merchant’s country (e.g., AR, BR, US). |
| Payment Date                    | Datetime | Date and time the payment was processed (ISO 8601 format).                    |

{% tabs %}
{% tab title="200: OK " %}

```json
File: 2025-04-07-conciliation.csv
Content-Type: text/csv
```

{% endtab %}

{% tab title="401: Unauthorized" %}

```json
{
    "message": "Unauthorized",
    "statusCode": 401
}
```

{% endtab %}
{% endtabs %}