Reconciliation Files
Learn about the contents, delivery method, and fields of Adopay merchant daily reports.
Capability Overview
- Details and summary: Daily details of cashin, cashout, withdrawal, balance transaction records, MED complaints, cashin refunds, and cashout refunds, as well as a merchant daily statistics summary.
- Delivery method: Supports SFTP download; files can also be delivered as email attachments depending on configuration (identical in content to the SFTP files).
- File format: CSV encoded in UTF-8 (with BOM), which can be opened with Excel / Numbers / text tools.
Available Reports
| Report | File Name Suffix | Description |
|---|---|---|
| Cashin orders | payin_orders | cashin (Payin) order details within the specified calendar day |
| Cashout orders | payout_orders | cashout order details within the specified calendar day |
| Withdrawal orders | withdrawal_orders | Withdrawal order details within the specified calendar day |
| Balance transaction records | bills | Merchant balance change transaction records within the specified calendar day |
| Merchant daily statistics | mch_static | Merchant summary statistics for the specified calendar day (including day-over-day comparison) |
| MED complaints | meds | PIX MED complaint details within the specified calendar day |
| Cashin refunds | ordeRefund | cashin refund details within the specified calendar day |
| Cashout refunds | payoutRefund | cashout refund details within the specified calendar day |
For the actual file names written to disk, see "File Naming Rules" below. Which reports are actually generated depends on your activation configuration.
Generation Schedule
Reports are generated daily, covering all orders / transaction records / statistics for the full day before the calendar day in the Brazil time zone (America/Sao_Paulo).
- Generation time:
01:00Brazil time every day (corresponding to12:00noon Beijing time). - After generation completes, the files are written to your 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, with no data rows.
Access Method: SFTP
Partners connect to the SFTP server provided by Adopay to download the daily reports.
Information Required Before Activation
| Information | Description |
|---|---|
| IP allowlist | Your outbound public IPs (CIDR supported, e.g. 1.2.3.4 or 1.2.3.0/24) |
| SSH public key | In OpenSSH format (can be generated with ssh-keygen, PuTTYgen, etc.) |
Information We Provide After Activation
| Information | Description |
|---|---|
| Host | e.g. sftp.domain.com (subject to the activation notice) |
| Port | e.g. 2222 (subject to the activation notice) |
| Username | The SFTP username assigned to your company |
| Password | A system-generated complex password sent to the partner's registered email address; 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 report root directory (chroot); you can run ls / get directly to download files.
Permissions
- The directory is read-only for downloads (list / download); uploading, deleting, or modifying files on the server is not allowed.
- Keep your account and password safe; if you need to reset your password, contact your account representative, and the new password will be sent again to the partner's registered email address.
File Naming Rules
Format:
text
{merchantNumber}_{date}_{reportType}.csv| Segment | Meaning | Example |
|---|---|---|
| Merchant number | Platform merchant number (mid) | 1003 |
| Date | Business day the report belongs to, in 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 |
| Balance transaction records | 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 (ls after logging in):
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 cashin / cashout / withdrawal details:
| Value | Description |
|---|---|
PENDING | Processing |
SUCCESS | Successful |
FAILED | Failed |
REFUND | Refunded (if applicable) |
Values of the "status" field in cashin refund / cashout refund details:
| Value | Description |
|---|---|
PENDING | Processing / awaiting operation |
SUCCESS | Successful / processed |
FAILED | Failed (cashin refunds only) |
Report Field Reference
1. Cashin Orders (payin_orders)
Cashin details for orders whose 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 (预计结算金额) | Estimated amount 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 reconciliation date the order belongs to |
| Payment method code (支付方式编码) | Payment method code |
| Payment method name (支付方式名称) | Payment method name |
| Customer name (客户姓名) | Payer name |
| Status (状态) | See "Order Status Reference" |
| Callback (回调) | Whether a callback has been sent to the partner (displayed value subject to the export) |
| cashin note (收款备注) | cashin note / product information |
| Pass-through data (透传数据) | Pass-through field provided by the partner when placing the order (attach), returned as is |
| Error (错误) | Error message in case of failure (if any) |
2. Cashout Orders (payout_orders)
Cashout details for orders whose 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 reconciliation date the order belongs to |
| Transfer note (转账备注) | Transfer note / product information |
| Pass-through data (透传数据) | Pass-through field provided by the partner when placing the order (attach), returned as is |
| Payment method code (支付方式编码) | Payment method code |
| Payment method name (支付方式名称) | Payment method name |
| Account (账户) | Receiving account (may be masked) |
| Customer name (客户姓名) | Payee name |
| Status (状态) | See "Order Status Reference" |
| Callback (回调) | Whether a callback has been sent to the partner |
| Error (错误) | Error message in case of failure (if any) |
3. Withdrawal Orders (withdrawal_orders)
Withdrawal details for orders whose 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 (if 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 (账户) | Receiving account |
| Customer name (客户姓名) | Payee name |
| Status (状态) | See "Order Status Reference" |
4. Balance Transaction Records (bills)
Balance change records whose transaction time falls within the report day.
| CSV Header | Field Meaning |
|---|---|
| Transaction record number (交易流水号) | Transaction record number of the balance change |
| 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; displayed merged in some scenarios) |
| Balance after change (变动后金额) | Balance after the change |
| Time (时间) | Time the transaction record occurred (Y-m-d H:i:s) |
| Type (类型) | Change type; common values are shown in the table below |
Common values of the balance transaction record "type":
| Type Text | Description |
|---|---|
| Cashin credit (代收入账) | cashin credited |
| Cashin fee (代收手续费) | cashin fee deduction |
| Cashin settlement release (代收结算) | cashin pending settlement released into the available balance |
| Cashout settlement fee deduction (扣除代付结算手续费) | cashout fee |
| Cashout rejection (代付驳回) | cashout failed / rejected and returned |
| Withdrawal / transfer / settlement (提现/转账/结算) | Withdrawal, transfer, and settlement outflow |
| Withdrawal rejection (提款驳回) | Withdrawal rejected and returned |
| Cashin refund / cashout refund / withdrawal refund (代收退款 / 代付退款 / 提款退款) | Refunds of various types |
| Manual balance increase / manual balance decrease (余额增加(手动) / 余额减少(手动)) | Manual balance adjustments |
| Freeze / unfreeze (冻结 / 解冻) | Balance freeze and unfreeze |
| Others (其他) | Subject to the actual text in the file |
5. Merchant Daily Statistics (mch_static)
A summary snapshot for 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 (代收订单数) | Number of cashin orders placed |
| Successful cashin count (代收成功数) | Number of successful cashin orders |
| Total cashin amount (代收总金额) | Total amount of cashin orders placed |
| Successful cashin amount (代收成功金额) | Successful cashin amount |
| Failed cashin count (代收失败数) | Number of failed cashin orders |
| Failed cashin amount (代收失败金额) | Failed cashin amount |
| Cashout order count (代付订单数) | Number of cashout orders placed |
| Successful cashout count (代付成功数) | Number of successful cashout orders |
| Total cashout amount (代付总金额) | Total amount of cashout orders placed |
| Successful cashout amount (代付成功金额) | Successful cashout amount |
| Failed cashout count (代付失败数) | Number of failed cashout orders |
| Failed cashout amount (代付失败金额) | Failed cashout amount |
| Withdrawal order count (提现订单数) | Number of withdrawal orders placed |
| Successful withdrawal count (提现成功数) | Number of successful withdrawal orders |
| Total withdrawal amount (提现总金额) | Total amount of withdrawal orders placed |
| Successful withdrawal amount (提现成功金额) | Successful withdrawal amount |
| Failed withdrawal count (提现失败数) | Number of failed withdrawal orders |
| Failed withdrawal amount (提现失败金额) | Failed withdrawal amount |
| Cashin fee (代收手续费) | Total cashin fees |
| Cashout fee (代付手续费) | Total cashout fees |
| Withdrawal fee (提现手续费) | Total withdrawal fees |
| Previous-day cashin order count (前日代收订单数) | Number of cashin orders on the previous day |
| Previous-day cashout order count (前日代付订单数) | Number of cashout orders on the previous day |
| Cashin day-over-day change (代收环比) | Growth rate of the cashin order count compared with the previous day; may be - when it cannot be calculated |
| Cashout day-over-day change (代付环比) | Growth rate of the cashout order count compared with the previous day; may be - when it cannot be calculated |
6. MED Complaints (meds)
PIX MED details for complaint records whose 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 are shown in the table below |
| Status (状态) | Original MED status text; common values are shown 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's name |
| PIX transaction identifier (PIX交易标识) | PIX end-to-end ID |
| Violation report ID (违规报告ID) | Violation report ID |
| Deadline (截止时间) | Handling deadline (Y-m-d H:i:s); may be empty if none |
| Order creation time (订单创建时间) | Creation time of the original cashin order |
| Creation time (创建时间) | MED record creation time |
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 | Partner has agreed to the refund (reserved, normally not produced) / review result upheld |
REJECTED_BY_USER / REJECTED_BY_PSP | Partner 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 for refund records whose 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 partner |
| 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 refund amount of the order |
| Fee (手续费) | Refund fee |
| Refund reason (退款原因) | Refund reason |
| Status (状态) | See the refund status reference above |
| Completion time (完成时间) | Refund completion time; may be empty if not completed |
| Creation time (创建时间) | Refund record creation time |
8. Cashout Refunds (payoutRefund)
Cashout refund details for refund records whose 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 yet operated |
| Status (状态) | See the refund status reference above |
| Creation time (创建时间) | Refund record creation time |
Reconciliation Recommendations
- Use the merchant order number (cashin / cashout) to align orders with your own system.
- Cross-check the successful amounts where the status is
SUCCESSagainst the credits / debits in the balance transaction records. - At end of day, you can cross-validate the successful amounts and fees in
mch_staticagainst the detail totals. - The time zone follows the Brazilian calendar day; for orders that cross the day boundary, the report day is determined by where the exported "order placement time / transaction time" falls.
Contact Us
For SFTP activation, IP allowlist changes, public key updates, password resets, and similar issues, please contact your Customer Success / technical contact.