---
url: >-
  https://acquirer-api-docs-v4-en.pingpongx.com/notes/zh/reconciliation/settlementFileSheet/index.md
description: 说明对账单各 sheet 的用途和字段范围，帮助商户核对结算报告、交易流水、退款和拒付费用。
---
# 对账单sheet说明

## 账单模板

<a :href="$withBase('/v4/sftp/202305290716154339301_202309.xlsx')" download="202305290716154339301_202309.xlsx">获取 PingPongCheckout 账单模板</a>

<v4-iImage src="/v4/settlement/settlementExcel.png" name="对账单模板" ></v4-iImage>

## 对账单sheet

| sheet             | 说明               |
|:------------------|:-----------------|
| Settlement Report | 结算报告，总览当前账期数据    |
| Purchase          | 已交易结算流水数据和交易费用数据 |
| Refund            | 退款和退款费用流水数据      |
| Chargeback        | 拒付费用数据           |
| Reserve           | 循环保证金            |
| Deposit           | 固定保证金            |
| Withdrawal        | 提现明细             |
| Other Fee         | 其他费用             | 
| Adjustment        | 调账明细             |

## 对账单字段明细
<br/>
<v4-SettlementFileFieldsTable />