> This page is for version v2 (default).
> For other versions, use one of these documentation indexes:
> - v2 (default): https://developers-beta.clearpay.co.uk/v-2/llms.txt
> - v1: https://developers-beta.clearpay.co.uk/v-1/llms.txt

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://developers-beta.clearpay.co.uk/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://developers-beta.clearpay.co.uk/_mcp/server.

# Settlement Reports

Settlement Reports explain in detail all payments made by Clearpay to you, and help you to reconcile your accounts. There is one settlement report for each settlement to your bank account, and typically, there's one settlement every day that you capture Clearpay order.

See also: [Getting Paid](/getting-paid)

## Viewing Settlement Reports

You can view and export your settlement files in the [Reconciliation tab](https://hub.clearpay.co.uk/reconciliations) of the Business Hub.

![Business Hub - Viewing Settlement Reports.png](/_fern-files/_img/31ea3703a56ab8c495bcc71c0b795a1be23fbc314731b8cdbf7b5f98b2aeeec9.webp)

## Downloading Settlement Report

You can export your settlement files by using the Settlement Export option from your Reconciliation tab. For additional download options, such as API requests, contact your account manager.

![Business Hub - Downloading Settlement Report.png](/_fern-files/_img/3c0d2dae8830689a4938c3112a28e67588a6ae642ed3608035bf4ae4ce0c3107.webp)

> **Email notifications**
>
> If you would like to receive an email summarising each settlement payment amount contact us through our [merchant support area](https://help.business.clearpay.co.uk/hc/en-gb/requests/new). Please note, emails are not sent if there are no amounts due to the merchant.

## Settlement Report Fields

| Description           | Type   | Format            | Example Value    | Displayed in CSV Format                               |
| --------------------- | ------ | ----------------- | ---------------- | ----------------------------------------------------- |
| Settlement Date       | String | See table below   | See table below  | See table below                                       |
| Order Date and Time   | String | dd/MM/yyyy HH:mm  | 12/01/2018 10:43 | "24/06/2019 22:56"                                    |
| Order Month           | String | MMM               | Jan              | "Jan"                                                 |
| Order Year            | String | nnnn              | 2024             | "2024"                                                |
| Clearpay Order ID     | Number | 79043810          | 12345679         | "79169085"                                            |
| Merchant Order ID     | String | Merchant Supplied | 2345678          | "2345678"                                             |
| Merchant Refund ID    | String | Merchant Supplied | 9163251003631241 | "9163251003631241"                                    |
| Order Amount          | String | £00.00 or £0.00   | £85.95           | "85.95" - with the currency symbol before the number. |
| Settlement Amount     | String | £00.00 or £0.00   | £85.95           | "85.95" - with the currency symbol before the number. |
| Merchant Fee excl Tax | String | £00.00 or £0.00   | £5.95            | "5.95" - with the currency symbol before the number.  |
| Merchant Fee Tax      | String | £00.00 or £0.00   | £0.95            | "0.95" - with the currency symbol before the number.  |
| Merchant Fee incl Tax | String | £00.00 or £0.00   | £6.00            | "6.00" - with the currency symbol before the number.  |
| Net Settlement Amount | String | £00.00 or £0.00   | £79.95           | "79.95" - with the currency symbol before the number. |
| Type                  | String |                   | Order            | "Order"                                               |
| Channel               | String |                   | Online           | "Online"                                              |
| Store Name            | String |                   |                  |                                                       |
| Store ID              |        |                   |                  | 9756                                                  |
| Device name           |        |                   |                  | "POS251"                                              |
| Device ID             |        |                   |                  | 38301                                                 |
| Clearpay Refund ID    | Number |                   |                  | 4561545                                               |
| Refund date and time  | String | dd/MM/yyyy HH:mm  |                  | "24/06/2024 18:43"                                    |
| Acquirer Terminal ID  |        |                   |                  |                                                       |
| Consumer Country      | String |                   |                  | "GB"                                                  |

## Global Date Formats (Settlement Date)

| Region        | Type   | Format     | Example Value | Displayed in CSV Format |
| ------------- | ------ | ---------- | ------------- | ----------------------- |
| AU/NZ         | String | dd/MM/yyyy | 25/06/19      | "25-Jun-19"             |
| US            | String | MM/dd/yyyy | 06/25/19      | "06/25/2019"            |
| UK (Clearpay) | String | dd/MM/yyyy | 25/06/19      | "25/06/2019"            |