# 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   |                                                                               |
| 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 %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.latam-payments.depay.us/reference/api-reference/reconciliation-files.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.