Cookie Consent by Free Privacy Policy Generator Update cookies preferences

Settlement Reports

How Can I View 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 an Clearpay order.
See also: Settlement Timing

Viewing Settlement Reports

1376

Downloading Settlement Report

You can export your settlement files by using the Settlement Export option from your Settlements tab.
For additional download options, such as API requests, please reach out to your account manager.

539

📘

Email Notifications

If you would like to receive an email summarising each settlement payment amount contact our Merchant Admin team.

Please note, emails are not sent if there are no amounts due to the Merchant.

Settlement Report Fields

DescriptionTypeFormatExample ValueDisplayed in CSV Format
Settlement DateStringSee table belowSee table belowSee table below
Order Date and TimeStringdd/MM/yyyy HH:mm12/01/2018 10:43"24/06/2019 22:56"
Order MonthStringMMMJan"Jun"
Order YearString2019"2019"
Clearpay Order IDNumber7904381012345679"79169085"
Merchant Order IDStringMerchant Supplied2345678"2345678"
Merchant Refund IDStringMerchant Supplied9163251003631241"9163251003631241"
Order AmountString£00.00 or £0.00£85.95"85.95" - with the currency symbol before the number
Settlement AmountString£00.00 or £0.00£85.95"85.95" - with the currency symbol before the number
Merchant Fee excl TaxString£00.00 or £0.00£5.46"5.46" - with the currency symbol before the number
Merchant Fee TaxString£00.00 or £0.00£0.55"0.55" - with the currency symbol before the number
Merchant Fee incl TaxString£00.00 or £0.00£6.00"6.00" - with the currency symbol before the number
Net Settlement AmountString£00.00 or £0.00£79.95"79.95" - with the currency symbol before the number
Type ChannelStringOrder"Order"
Store NameStringOnline"Online"
Store Id19756
Device Name"POS251"
Device Id38301
Clearpay Refund IDNumber4561545
Refund Date and TimeStringdd/MM/yyyy HH:mm"24/06/2019 18:43"
Acquirer Terminal ID
Consumer CountryStringAU / NZ"AU"

Global Date Formats (Settlement Date)

RegionTypeFormatExample ValueDisplayed in CSV Format
UK (Clearpay)Stringdd/MM/yyyy25/06/19"25/06/2019"
AU/NZStringdd/MM/yyyy25/06/19"25-Jun-19"
USStringMM/dd/yyyy06/25/19"06/25/2019"