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.

GET https://stage.api.payments.depay.us/reports/conciliation/payins

Headers

Name	Type	Description
Authorization*	String	Bearer Token.

Query Parameters

Name	Type	Required	Description
start_date	String	No	Start date for the report (format: YYYY-MM-DD).
end_date	String	No	End date for the report (format: YYYY-MM-DD).
status	String	No	Filter by transaction status (e.g., CREATED, COMPLETED, CANCELED).
format	String	Yes	File format: csv (default) or txt.

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).

200: OK

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

401: Unauthorized

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