Skip to content
Last updated

Introduction

Our Reconciliation API helps you reconcile and match the payouts credited in your account and with the transactions and refund operations they relate to.

Three endpoints are available to help you with your reconciliation:

  • GET Payout List: will provide you with a list of all the payments credited into your payout account(s) by date.
  • GET Payment List: will provide you with a list of all the SUCCEEDED transactions by Payout ID or by date range.
  • GET Refund List: will provide you wirh a list of all the SUCCEEDED refunds by Payout ID or by date range.

Please note that all reconciliation data will only be made available on D+1 starting at 09:00CET. Recociliation data is available in both PREPROD and PROD environements.

For the full endpoint documentation, please refer to the Reconciliation API.

For more information on Payouts and Remittance Information, please refer to this guide.

Get Payout List

This endpoint allows you to retrieve a list of all the payments credited into your payout account(s) by date.

Path Parameters

NameTypeRequiredDescription
sizeIntegerNoThe size of the page to be returned (Default is 10000).
pageIntegerNoZero-based page index in list request (Default is 0).
dateStringNoThe date for which the list of payouts should be returned. Format should be yyyy-MM-dd. (Default is current UTC date)

Response

sizeinteger>= 0required

the total number of elements in the current page of this response

totalPagesintegerrequired

the total number of pages in the response

totalElementsintegerrequired

the total number of elements in the response

numberintegerrequired

the current page number

payoutsArray of objects(PayoutListItem)required

a list of payouts. If the list is empty, then there were no payouts made.

payouts[].​payoutIdstring= 24 charactersrequired

The unique identifier associated with the payout if a pay-out was successfully created

payouts[].​merchantIdstring= 24 charactersrequired

The merchant id used during aggregation of the payout run

payouts[].​bulkIdstringnon-emptyrequired

The bulk id used during aggregation of the of the payout run if available, if not NONE would be sent as default

payouts[].​ibanstringnon-empty^[A-Z]{2,2}[0-9]{2,2}[a-zA-Z0-9]{1,30}$required

The IBAN in (ISO 13616) format used during aggregation of the payout run and this will be used to payout to the merchant

payouts[].​payoutStatusstring(PayoutStatus)required
  • SUCCEEDED - Payout was successfully processed
  • FAILED - Payout failed.
Enum"SUCCEEDED""FAILED"
payouts[].​payoutDatestring(date-time)required

timestamp, when payout was created in UTC

payouts[].​payoutCurrencystring(Currency)required

currency code. Only EUR is supported ISO 4217

Default "EUR"
Value"EUR"
payouts[].​totalPaymentsintegerrequired

The total number of payments included in the payout

payouts[].​totalRefundsintegerrequired

The total number of refunds included in the payout

payouts[].​totalPaymentAmountinteger(int64)> 1required

The total payment amount in cents contained in the payout.

payouts[].​totalRefundAmountinteger(int64)> 0required

The total refund amount in cents contained in the payout.

payouts[].​payoutAmountinteger(int64)> 1required

Total amount in cents paid out the to merchant

Error Codes

HTTP StatusCodeMeaning
400BAD_REQUESTSome fields in the requests were not formatted correctly
401UNAUTHORIZEDThe JWS signature is not valid
the caller does not have valid authentication credentials
403ACCESS_DENIEDOperation not allowed,
the caller doesnot have the required authorities
500TECHNICAL_ERRORInternal technical error in the payment service.
503//Service unavailable.

Sample Request – getPayoutList

curl -i -X GET \
  'https://merchant.api.preprod.bancontact.net/reconciliation/payouts?size=10000&page=0&date=2020-06-18' \
  -H 'Signature: YOUR_API_KEY_HERE'

Get Payment List

This endpoint allows you to retrieve a list of all all the SUCCEEDED transactions by Payout ID or by date range.

Path Parameters

NameTypeRequiredDescription
sizeIntegerNoThe size of the page to be returned (Defaul is 10000).
pageIntegerNoZero-based page indew in list request (Default is 0).
start-dateStringNo, unless end-date providedThe inclusive start date for the Payment list. Format should be yyyy-MM-dd. Maximum 30 days between start-date and end-date
end-dateStringNo, unless start-date providedThe inclusive end date for the Payment list. Format should be yyyy-MM-dd. Maximum 30 days between start-date and end-date
payout-idIntegerNoUnique payout identifier for which you wish to retrieve the Payment list.

Response

sizeinteger>= 0required

the total number of elements in the current page of this response

totalPagesintegerrequired

the total number of pages in the response

totalElementsintegerrequired

the total number of elements in the response

numberintegerrequired

the current page number

paymentsArray of objects(PaymentDetails)required

a list of payments included in the payout.

payments[].​paymentIdstring= 24 charactersrequired

The id of the payment

payments[].​payoutIdstring= 24 characters

The id of the payout

payments[].​paymentProfileIdstring= 24 charactersrequired

The profile id of the merchant used in the transaction

payments[].​merchantNamestringnon-emptyrequired

The name of the merchant

payments[].​paymentChannelstring(PaymentChannel)required

"The channel of the payment"

Enum"ONLINE""INSTORE""INVOICE"
payments[].​currencystring(Currency)required

currency code. Only EUR is supported ISO 4217

Default "EUR"
Value"EUR"
payments[].​amountinteger(int64)>= 1required

Total amount in cents of the transaction

payments[].​referencestringnon-empty

The reference provided by the merchant/partner during a payment/refund

payments[].​descriptionstringnon-empty

The description provided by the merchant/partner during a payment/refund

payments[].​transactionDatestring(date-time)required

timestamp, when transaction was created in UTC

Error Codes

HTTP StatusCodeMeaning
400BAD_REQUESTSome fields in the requests were not formatted correctly
401UNAUTHORIZEDThe JWS signature is not valid
the caller does not have valid authentication credentials
403ACCESS_DENIEDOperation not allowed,
the caller doesnot have the required authorities
404PAYOUT_NOT_FOUNDCould not find a Payout with the prodivded ID
500TECHNICAL_ERRORInternal technical error in the payment service.
503//Service unavailable.

Sample Request – getPayments

curl -i -X GET \
  'https://merchant.api.preprod.bancontact.net/reconciliation/payments?payout-id=stringstringstringstring&size=10000&page=0&start-date=2020-06-18&end-date=2020-06-18' \
  -H 'Signature: YOUR_API_KEY_HERE'

Get Refund List

This endpoint allows you to retrieve a list of all all the SUCCEEDED refunds by Payout ID or by date range.

Path Parameters

NameTypeRequiredDescription
sizeIntegerNoThe size of the page to be returned (Defaul is 10000).
pageIntegerNoZero-based page indew in list request (Default is 0).
start-dateStringNo, unless end-date providedThe inclusive start date for the Payment list. Format should be yyyy-MM-dd. Maximum 30 days between start-date and end-date
end-dateStringNo, unless start-date providedThe inclusive end date for the Payment list. Format should be yyyy-MM-dd. Maximum 30 days between start-date and end-date
payout-idIntegerNoUnique payout identifier for which you wish to retrieve the Payment list.

Response

sizeinteger>= 0required

the total number of elements in the current page of this response

totalPagesintegerrequired

the total number of pages in the response

totalElementsintegerrequired

the total number of elements in the response

numberintegerrequired

the current page number

refundsArray of objects(RefundDetails)required

a list of refunds included in the payout.

refunds[].​paymentIdstring= 24 charactersrequired

The id of the payment

refunds[].​payoutIdstring= 24 characters

The id of the payout

refunds[].​paymentProfileIdstring= 24 charactersrequired

The profile id of the merchant used in the transaction

refunds[].​merchantNamestringnon-emptyrequired

The name of the merchant

refunds[].​paymentChannelstring(PaymentChannel)required

"The channel of the payment"

Enum"ONLINE""INSTORE""INVOICE"
refunds[].​currencystring(Currency)required

currency code. Only EUR is supported ISO 4217

Default "EUR"
Value"EUR"
refunds[].​amountinteger(int64)>= 1required

Total amount in cents of the transaction

refunds[].​referencestringnon-empty

The reference provided by the merchant/partner during a payment/refund

refunds[].​descriptionstringnon-empty

The description provided by the merchant/partner during a payment/refund

refunds[].​transactionDatestring(date-time)required

timestamp, when transaction was created in UTC

refunds[].​refundIdstring= 24 charactersrequired

The id of the refund

Error Codes

HTTP StatusCodeMeaning
400BAD_REQUESTSome fields in the requests were not formatted correctly
401UNAUTHORIZEDThe JWS signature is not valid
the caller does not have valid authentication credentials
403ACCESS_DENIEDOperation not allowed,
the caller doesnot have the required authorities
404PAYOUT_NOT_FOUNDCould not find a Payout with the prodivded ID
500TECHNICAL_ERRORInternal technical error in the payment service.
503//Service unavailable.

Sample Request – getRefunds

curl -i -X GET \
  'https://merchant.api.preprod.bancontact.net/reconciliation/refunds?payout-id=stringstringstringstring&size=10000&page=0&start-date=2020-06-18&end-date=2020-06-18' \
  -H 'Signature: YOUR_API_KEY_HERE'