Reconciliation Files
Learn about the content, delivery methods, and field reference of the Adopay merchant daily report.
Capabilities Overview
- Details and summaries: Daily details for cashin, cashout, withdrawals, fund flows, MED complaints, cashin refunds, and cashout refunds, plus a merchant daily statistics summary.
- Delivery: SFTP download is supported; delivery can also be made as email attachments per configuration (with content identical to the SFTP files).
- File format: UTF-8 (with BOM) encoded CSV, openable with Excel / Numbers / text tools.
Available Reports
| Report | File Name Suffix | Description |
|---|---|---|
| Cashin orders | payin_orders | cashin (Payin) order details for the specified calendar day |
| Cashout orders | payout_orders | cashout order details for the specified calendar day |
| Withdrawal orders | withdrawal_orders | Withdrawal order details for the specified calendar day |
| Fund flows | bills | Merchant balance change records for the specified calendar day |
| Merchant daily statistics | mch_static | Merchant summary statistics for the specified calendar day (with day-over-day comparison) |
| MED complaints | meds | PIX MED complaint details for the specified calendar day |
| Cashin refunds | ordeRefund | cashin refund details for the specified calendar day |
| Cashout refunds | payoutRefund | cashout refund details for the specified calendar day |
See "File Naming Rules" below for the actual file names written to disk. Which reports are generated depends on your provisioning configuration.
Generation Time
Reports are generated daily, covering all orders, flows, and statistics of the previous full calendar day in the Brazil timezone (America/Sao_Paulo).
- Generation time:
01:00Brazil time every day (corresponding to12:00noon Beijing time). - After generation completes, files are written to your company's SFTP home directory and can be downloaded immediately.
- If a business type has no data on a given day, the corresponding CSV may contain only the header row and no data rows.
Access Method: SFTP
Merchants connect to the SFTP server provided by Adopay to download the daily reports.
Required Before Provisioning
| Information | Description |
|---|---|
| IP allowlist | Your company's outbound public IPs (CIDR supported, e.g. 1.2.3.4 or 1.2.3.0/24) |
| SSH public key | OpenSSH format (can be generated with ssh-keygen, PuTTYgen, etc.) |
Provided After Provisioning
| Information | Description |
|---|---|
| Host | e.g. sftp.domain.com (per the provisioning notice) |
| Port | e.g. 2222 (per the provisioning notice) |
| Username | The SFTP username assigned to your company |
| Password | A complex system-generated password sent to the merchant profile email; you can also log in with the registered public key |
Connection Example
bash
sftp -P 2222 <username>@sftp.domain.comAfter a successful login, the current directory is your company's report root directory (chroot); use ls / get to download files directly.
Permissions
- Directory permissions are read-only download (list / download); uploading, deleting, or modifying files on the server is not allowed.
- Keep the account and password safe. To reset the password, contact your integration contact; the new password will be sent again to the merchant profile email.
File Naming Rules
Format:
text
{merchantNumber}_{date}_{reportType}.csv| Segment | Meaning | Example |
|---|---|---|
| Merchant number | Platform merchant ID (mid) | 1003 |
| Date | Business day the report belongs to, YYYY-MM-DD | 2026-08-09 |
| Report type | See the table below | payin_orders |
| Report Type | Full File Name Example |
|---|---|
| Cashin orders | 1003_2026-08-09_payin_orders.csv |
| Cashout orders | 1003_2026-08-09_payout_orders.csv |
| Withdrawal orders | 1003_2026-08-09_withdrawal_orders.csv |
| Fund flows | 1003_2026-08-09_bills.csv |
| Merchant daily statistics | 1003_2026-08-09_mch_static.csv |
| MED complaints | 1003_2026-08-09_meds.csv |
| Cashin refunds | 1003_2026-08-09_ordeRefund.csv |
| Cashout refunds | 1003_2026-08-09_payoutRefund.csv |
Example listing (after login, ls):
text
1003_2026-08-06_bills.csv
1003_2026-08-06_mch_static.csv
1003_2026-08-06_meds.csv
1003_2026-08-06_ordeRefund.csv
1003_2026-08-06_payin_orders.csv
1003_2026-08-06_payoutRefund.csv
1003_2026-08-06_payout_orders.csv
1003_2026-08-06_withdrawal_orders.csv
1003_2026-08-07_bills.csv
...Order Status Reference
Values of the "status" field in the cashin / cashout / withdrawal details:
| Value | Description |
|---|---|
PENDING | Processing |
SUCCESS | Successful |
FAILED | Failed |
REFUND | Refunded (where applicable) |
Values of the "status" field in the cashin refund / cashout refund details:
| Value | Description |
|---|---|
PENDING | Processing / pending action |
SUCCESS | Successful / processed |
FAILED | Failed (cashin refunds only) |
Report Field Reference
1. Cashin Orders (payin_orders)
Cashin details whose order creation time falls within the report day. The CSV headers are in Chinese.
| CSV Header | Field Meaning |
|---|---|
| Platform order number (平台订单号) | Adopay platform cashin order number |
| Merchant order number (商户订单号) | Merchant-side order number, corresponding to the API field merchantOrderNo. |
| Bank transaction reference (银行流水) | Bank/channel-side transaction number (if any) |
| PIX transaction identifier (PIX交易标识) | Pix end-to-end transaction ID (end-to-end), used to align with the Brazilian central bank clearing system |
| Amount (金额) | Order amount |
| Currency (币种) | Order currency, e.g. BRL |
| Fee (手续费) | Merchant fee |
| Actual paid amount (实际支付金额) | Amount actually paid by the user |
| Estimated settlement amount (预计结算金额) | Amount estimated to be settled to the merchant |
| Order creation time (下单时间) | Order creation time (Y-m-d H:i:s) |
| Processing time (处理时间) | Final-state time; may be empty if not completed |
| Clearing time (清算时间) | Clearing completion time, used to determine the order's reconciliation date |
| Payment method code (支付方式编码) | Payment method code |
| Payment method name (支付方式名称) | Payment method name |
| Customer name (客户姓名) | Payer name |
| Status (状态) | See "Order Status Reference" |
| Callback (回调) | Whether the merchant has been notified via callback (display value per the export) |
| cashin note (收款备注) | cashin note / product information |
| Pass-through data (透传数据) | Pass-through field (attach) provided when the merchant placed the order, returned as-is |
| Error (错误) | Error message on failure (if any) |
2. Cashout Orders (payout_orders)
Cashout details whose order creation time falls within the report day.
| CSV Header | Field Meaning |
|---|---|
| Platform order number (平台订单号) | Adopay platform cashout order number |
| Merchant order number (商户订单号) | Merchant-side order number, corresponding to the API field merchantOrderNo. |
| Bank transaction reference (银行流水) | Bank/channel-side transaction number (if any) |
| Amount (金额) | cashout amount |
| Currency (币种) | Order currency, e.g. BRL |
| Fee (手续费) | Merchant fee |
| Settlement amount (结算金额) | Actual settlement/deduction-related amount |
| Order creation time (下单时间) | Order creation time |
| Payment time (付款时间) | Payment completion time; may be empty if not completed |
| Clearing time (清算时间) | Clearing completion time, used to determine the order's reconciliation date |
| Transfer note (转账备注) | Transfer note / product information |
| Pass-through data (透传数据) | Pass-through field (attach) provided when the merchant placed the order, returned as-is |
| Payment method code (支付方式编码) | Payment method code |
| Payment method name (支付方式名称) | Payment method name |
| Account (账户) | Payee account (possibly masked) |
| Customer name (客户姓名) | Payee name |
| Status (状态) | See "Order Status Reference" |
| Callback (回调) | Whether the merchant has been notified via callback |
| Error (错误) | Error message on failure (if any) |
3. Withdrawal Orders (withdrawal_orders)
Withdrawal details whose order creation time falls within the report day.
| CSV Header | Field Meaning |
|---|---|
| Platform order number (平台订单号) | Adopay platform withdrawal order number |
| Bank transaction reference (银行流水) | Bank/channel-side transaction number (if any) |
| Exchange rate (汇率) | Withdrawal exchange rate (where applicable) |
| Amount (金额) | Withdrawal amount |
| Fee (手续费) | Fee |
| Settlement amount (结算金额) | Settlement amount |
| Order creation time (下单时间) | Order creation time |
| Payment time (付款时间) | Completion time; may be empty if not completed |
| Method (方式) | Withdrawal method code |
| Account (账户) | Payee account |
| Customer name (客户姓名) | Payee name |
| Status (状态) | See "Order Status Reference" |
4. Fund Flows (bills)
Balance change records whose occurrence time falls within the report day.
| CSV Header | Field Meaning |
|---|---|
| Transaction record number (交易流水号) | Fund change transaction number |
| Platform order number (平台订单号) | Associated platform order number (if any) |
| Merchant order number (商户订单号) | Associated merchant order number (if any) |
| Original amount (原金额) | Balance before the change |
| Amount (金额) | Amount of this change |
| Fee (手续费) | Associated fee amount (if any; shown merged in some scenarios) |
| Balance after change (变动后金额) | Balance after the change |
| Time (时间) | Time the flow occurred (Y-m-d H:i:s) |
| Type (类型) | Change type; common values in the table below |
Common values of the fund flow "type" (the actual file text is in Chinese):
| Type Text | Description |
|---|---|
| Cashin credit (代收入账) | cashin credited on success |
| Cashin fee (代收手续费) | cashin fee deduction |
| Cashin settlement release (代收结算) | cashin pending-settlement amount unfrozen into the usable balance |
| Cashout settlement fee deduction (扣除代付结算手续费) | cashout fee |
| Cashout rejection (代付驳回) | cashout failure/rejection return |
| Withdrawal / transfer / settlement (提现/转账/结算) | Withdrawal, transfer, and settlement outflows |
| Withdrawal rejection (提款驳回) | Withdrawal rejection return |
| Cashin refund / cashout refund / withdrawal refund (代收退款 / 代付退款 / 提款退款) | Various refunds |
| Manual balance increase / manual balance decrease (余额增加(手动) / 余额减少(手动)) | Manual balance adjustments |
| Freeze / unfreeze (冻结 / 解冻) | Balance freeze and unfreeze |
| Others (其他) | Refer to the actual text in the file |
5. Merchant Daily Statistics (mch_static)
Summary snapshot of the report day (including day-over-day fields compared with the previous day).
| CSV Header | Field Meaning |
|---|---|
| Date (日期) | Statistics date YYYY-MM-DD |
| Merchant ID (商户编号) | Merchant ID |
| Merchant name (商户名) | Merchant name |
| Balance (余额) | Balance snapshot for the day |
| Pending settlement balance (待结算余额) | Pending settlement balance |
| Frozen balance (冻结余额) | Frozen balance |
| Cashin order count (代收订单数) | cashin orders placed |
| Successful cashin count (代收成功数) | cashin successful count |
| Total cashin amount (代收总金额) | Total cashin order amount |
| Successful cashin amount (代收成功金额) | cashin successful amount |
| Failed cashin count (代收失败数) | cashin failed count |
| Failed cashin amount (代收失败金额) | cashin failed amount |
| Cashout order count (代付订单数) | cashout orders placed |
| Successful cashout count (代付成功数) | cashout successful count |
| Total cashout amount (代付总金额) | Total cashout order amount |
| Successful cashout amount (代付成功金额) | cashout successful amount |
| Failed cashout count (代付失败数) | cashout failed count |
| Failed cashout amount (代付失败金额) | cashout failed amount |
| Withdrawal order count (提现订单数) | Withdrawal orders placed |
| Successful withdrawal count (提现成功数) | Withdrawal successful count |
| Total withdrawal amount (提现总金额) | Total withdrawal order amount |
| Successful withdrawal amount (提现成功金额) | Withdrawal successful amount |
| Failed withdrawal count (提现失败数) | Withdrawal failed count |
| Failed withdrawal amount (提现失败金额) | Withdrawal failed amount |
| Cashin fee (代收手续费) | Total cashin fees |
| Cashout fee (代付手续费) | Total cashout fees |
| Withdrawal fee (提现手续费) | Total withdrawal fees |
| Previous-day cashin order count (前日代收订单数) | cashin order count of the previous day |
| Previous-day cashout order count (前日代付订单数) | cashout order count of the previous day |
| Cashin day-over-day change (代收环比) | cashin count growth rate versus the previous day; may be - when not computable |
| Cashout day-over-day change (代付环比) | cashout count growth rate versus the previous day; may be - when not computable |
6. MED Complaints (meds)
PIX MED details whose complaint record creation time falls within the report day. The CSV headers are in Chinese.
| CSV Header | Field Meaning |
|---|---|
| Platform order number (平台订单号) | Adopay platform cashin order number |
| Merchant order number (商户订单号) | Merchant-side order number, corresponding to the API field merchantOrderNo. |
| Complaint type (投诉类型) | Original MED complaint type text; common values in the table below |
| Status (状态) | Original MED status text; common values in the table below |
| Amount (金额) | Complaint amount |
| User CPF (用户CPF) | Complainant's document number |
| Analysis result (分析结果) | Original analysis result: ACCEPTED / REJECTED / PENDING |
| User name (用户姓名) | Complainant name |
| PIX transaction identifier (PIX交易标识) | PIX end-to-end ID |
| Violation report ID (违规报告ID) | Infraction report ID |
| Deadline (截止时间) | Processing deadline (Y-m-d H:i:s); may be empty if none |
| Order creation time (订单创建时间) | Creation time of the original cashin order |
| Creation time (创建时间) | Creation time of the MED record |
Common values of the MED "complaint type":
| Value | Description |
|---|---|
SCAM_FRAUD | Scam / fraud |
UNAUTHORIZED_TRANSACTION | Unauthorized transaction |
COERCIVE_CRIME | Coercive crime |
FRAUDULENT_ACCESS_AND_AUTHORIZATION | Fraudulent access and authorization |
OTHER | Other |
UNKNOWN | Unknown |
Common values of the MED "status":
| Value | Description |
|---|---|
WAITING | Pending |
EVIDENCE_REQUIRED | Additional evidence required |
UNDER_REVIEW | Under platform review |
ACCEPTED_BY_USER / ACCEPTED_BY_PSP | Merchant has agreed to the refund (reserved, normally not produced) / review result upheld |
REJECTED_BY_USER / REJECTED_BY_PSP | Merchant has disputed (reserved, normally not produced) / review result not upheld |
CANCELLED_BY_USER / CANCELLED_BY_PSP | Cancelled by the user / by the platform |
CLOSED | Closed (terminal state) |
7. Cashin Refunds (ordeRefund)
Cashin refund details whose refund record creation time falls within the report day.
| CSV Header | Field Meaning |
|---|---|
| Platform order number (平台订单号) | Adopay platform cashin order number |
| Merchant refund order number (商户退款单号) | Refund order number submitted by the merchant |
| Refund E2E (退款E2E) | Refund PIX E2E |
| Original payment E2E (原支付E2E) | Original payment PIX E2E |
| Original payment amount (原支付金额) | Original cashin amount |
| Current refund amount (本次退款金额) | Amount of this refund |
| Cumulative refund amount (累计退款金额) | Cumulative refunded amount for the order |
| Fee (手续费) | Refund fee |
| Refund reason (退款原因) | Refund reason |
| Status (状态) | See the refund status notes above |
| Completion time (完成时间) | Refund completion time; may be empty if not completed |
| Creation time (创建时间) | Creation time of the refund record |
8. Cashout Refunds (payoutRefund)
Cashout refund details whose refund record creation time falls within the report day.
| CSV Header | Field Meaning |
|---|---|
| Platform order number (平台订单号) | Adopay platform cashout order number |
| Merchant order number (商户订单号) | Merchant-side order number, corresponding to the API field merchantOrderNo. |
| Bank transaction reference (银行流水) | Bank/channel-side transaction number (if any) |
| Original amount (原金额) | Original cashout amount |
| Refund amount (退款金额) | Amount of this refund |
| Operation time (操作时间) | Refund operation time; may be empty if not operated |
| Status (状态) | See the refund status notes above |
| Creation time (创建时间) | Creation time of the refund record |
Reconciliation Recommendations
- Align orders with your company's system using the merchant order number (cashin / cashout).
- Cross-check successful amounts with status =
SUCCESSagainst the credits/debits in the fund flows. - At the end of the day, cross-validate using the
mch_staticsuccessful amounts and fees against the detail totals. - The timezone follows the Brazil calendar day; for orders spanning the day boundary, the report day is determined by the report day in which the exported "order time / flow time" falls.
Contact Us
For SFTP provisioning, IP allowlist changes, public key updates, password resets, and similar issues, contact your customer success / technical integration contact.