---
url: >-
  https://acquirer-api-docs-v4-en.pingpongx.com/en/notes/reconciliation/settlementFileSheet/index.md
description: >-
  The settlement file sheet description document introduces the billing template
  of PingPongCheckout and the purpose of each sheet, including key data such as
  settlement reports, transaction records, refunds, chargeback fees, etc., to
  help merchants perform financial verification and management.
---
# Settlement File Sheet Description

## Billing Template

<a :href="$withBase('/v4/sftp/202305290716154339301_202309.xlsx')" download="202305290716154339301_202309.xlsx">Get PingPongCheckout Billing Template</a>

<v4-iImage src="/v4/settlement/settlementExcel.png" name="Settlement Template" ></v4-iImage>

## Settlement File Sheets

| sheet             | Description                              |
|:------------------|:-----------------------------------------|
| Settlement Report | Settlement report, overview of current billing period data |
| Purchase          | Settled transaction records and transaction fee data |
| Refund            | Refund and refund fee transaction data    |
| Chargeback        | Chargeback fee data                       |
| Reserve           | Rolling security deposit                 |
| Deposit           | Fixed security deposit                   |
| Withdrawal        | Withdrawal details                        |
| Other Fee         | Other fees                                | 
| Adjustment        | Adjustment details                        |

## Settlement File Field Details

<v4-SettlementFileFieldsTable />