Reconciliation report

Banking Circle offers three types of reconciliation reports, each designed for different reconciliation needs:

  1. Standard Reconciliation Report (GET /api/v1/reports/reconciliation-report)

  2. Paginated Reconciliation Report (GET /api/v1/reports/reconciliation-paged-report)

    • Single-day reconciliation for large volumes (>50,000 payments)
    • Customizable page sizes for efficient processing
    • No date range support
  3. Intraday Reconciliation Report (GET /api/v1/reports/reconciliation-intraday-report)

    • Same-day transaction monitoring with time-range filtering
    • Tracks transactions based on creation time
    • Note: Payments after 19:00 CET will appear in the next business day's report

All reports include payments with status processed and pendingProcessing, and are both available in JSON and CSV format. The generated report contains the following fields.

Report Fields

Mandatory Fields

The fields listed below are always included in the report by default.

Note: Field names use camelCase in JSON format (e.g. pIdChannelUser or pTxnDate), while CSV format uses capitals and underscores (e.g. P_ID_CHANNELUSER or P_TXNDATE).

Field Name

Field Type

Example

Description

pIdChannelUser

Varchar

[email protected]

User ID of the requesting client

pTxnDate

Date (YYYY-MM-DD; MM/dd/yyyy HH:mm:ss.fff)

2021-10-27T00:00:00.000+00:00

Internal date that indicates when payment was instructed in BC Connect. It does not match the processing date.

reportDate

Date (DDMMYYYY)

29102021

Date of when the report is generated

customerId

Number

15106

Customer ID of the account

account

Varchar

DKXXXX0000000XXXXX

IBAN of the account

accountCurrency

Text (3)

EUR

ISO currency of your account

debitAmount

Number, 2 decimals

22.26

The amount debited, it is only populated if DBIT. In case of reversal of a debit, the amount will be given as a negative equivalent of the original amount debited

creditAmount

Number, 2 decimals

10.89

The amount credited, it is only populated if CRDT. In case of reversal of a credit, the amount will be given as a negative equivalent of the original amount credited

valueDate

Date (YYYY-MM-DD;DD/MM/YYYY)

27/10/2021

Value date for posting on the account

instructedAmount

Number

22.26

Only for DBIT. Equivalent in original currency to the amount transferred after currency exchange. The instructed amount based on the choice of "payment currency" as provided in the payment instruction

instructedAmountCurrency

Text (3)

EUR

ISO currency of instruction. Contains the currency of the instructed amount as provided in the payment instruction

transactionAmount

Number

18.78

DBIT: actual amount transferred to beneficiary.

CRDT: actual amount received for credit to the beneficiary account

transactionAmountCurrency

Text (3)

GBP

ISO currency of transaction amount

exchangeRate

Number

0.84367

Currency exchange applied in the transaction, between the instructed amount and the transaction amount.

debtorBankCode

Varchar

SXPYDKKKXXX

Bank Code of the debtor, only populated for CRDT

debtorAccount

Varchar

DKXXXX0000000XXXXX

For CRDT: Account of debtor.

For DBIT: Blank

For DBIT using VIBAN: VIBAN used for the transaction (DK representation)

debtorLine1

Varchar

Debtor Name

For CRDT: Line 1 details for debtor

For DBIT: Blank

For DBIT using VIBAN: Name associated with Virtual account

debtorLine2

Varchar

Debtor Address line 1

For CRDT: Line 2 details for debtor

For DBIT: Blank

debtorLine3

Varchar

Debtor Address line 2

For CRDT: Line 3 details for debtor

For DBIT: Blank

debtorLine4

Varchar

Debtor Address line 3

For CRDT: Line 4 details for debtor

For DBIT: Blank

beneficiaryBankCode

Varchar

SXPYDKKKXXX

Bank code of creditor, only populated for DBIT

beneficiaryAccount

Varchar

DKXXXX0000000XXXXX

For DBIT: Account of creditor

For CRDT using VIBAN: DK IBAN representation of VIBAN used in the transaction.

For CRDT: Blank

beneficiaryLine1

Varchar

Creditor Name

For DBIT: Line 1 details for Beneficiary.

For CRDT using VIBAN: Name associated with virtual account.

For CRDT: Blank

beneficiaryLine2

Varchar

Creditor Address Line 1

For DBIT: Line 2 details for Beneficiary

For CRDT: Blank

beneficiaryLine3

Varchar

Creditor Address Line 2

For DBIT: Line 3 details for Beneficiary

For CRDT: Blank

beneficiaryLine4

Varchar

Creditor Address Line 3

For DBIT: Line 4 details for Beneficiary

For CRDT: Blank

paymentReferenceNumber

Varchar

010F10xxxx001007

BC Connect reference number, unique identifier for processed transactions

fileReferenceNumber

36 CHAR a-Za-Z0-9/-?:.+

923578e7-7a58-4982-93f1-5862e687611d

Bulk id of instructed payment file, only populated for bulk payments

userReferenceNumber

a-Za-Z0-9/-?:.+

Debtor reference

Provides the reference number of each payment record as stated in payment instruction by the debtor (DebtorReference). In case of internal transfers between BC Connect accounts, this field would be blank.

paymentDetails1

Varchar

End to end id for beneficiary

Line 1 of payment details ( Remitter information line 1).Reference is propagated to beneficiary.

paymentDetails2

Varchar

Info for beneficiary 2

Line 2 of payment details

paymentDetails3

Varchar

Info for beneficiary 3

Line 3 of payment details

paymentDetails4

Varchar

Info for beneficiary 4

Line 4 of payment details

creditDebitIndicator

DBIT/CRDT

DBIT

CRDT for credit, DBIT for debit

bankTrnsCodeDomain

Varchar

PMNT

Bank transaction code for payment type identification. PMNT= Payment transfer FORX= foreign exchange ACMT=Account management: fees, interest, teller bookings

bankTrnsCodeFamily

Varchar

ICDT

Bank transaction sub-code for payment type identification.

IDCT: Issued payment, sold leg FX or fee

RCDT: Incoming payment, bought FX leg, reversal of payment fee

Additional Optional Fields

These fields are only included when specifically requested via the PropertiesIncluded parameter, or excluded via the PropertiesExcluded parameter:

Field Name

Field Type

Example

Description

bankTrnsCodeSubFamily

Varchar

DMCT

DMCT: Domestic Credit Transfer

XBCT: Cross Border Credit Transfer

RRTN: Reversal due to Payment Return

paymentId

36 CHAR, Varchar

4a1e5714-7ac3-9383-08a7-ffbadaa2f4bb

Unique payment reference within BC Connect that can be used to match the transaction instructed via API with the booking in the reconciliation report

lastChangedTimestamp

YYYY-MM-DDTHH:MM:SS.00000000+00:00

2019-11-08T11:40:25.00000000+00:00

Indicates the time stamp of when a transaction was last changed in the processing system.

createdAt

YYYY-MM-DDTHH:MM:SS.00000000+00:00

2019-11-08T11:40:25.00000000+00:00

Indicates the time stamp of when a transaction is created in the processing system.

additionalRemittanceInformation1

Varchar

/RETN/

Additional remittance information. In case of incoming return, it may contain a return indicator.

additionalRemittanceInformation2

Varchar

/AC04/Closed Account Number

Additional remittance information. In case of incoming return, it may contain a return reason code.

additionalRemittanceInformation3

Varchar

/MREF/010F10xxxx012345

Additional remittance information. In case of incoming return, it may contain the original payment reference.

additionalRemittanceInformation4

Varchar

//information

Additional remittance information

additionalRemittanceInformation5

Varchar

//information

Additional remittance information

debtorAgentBankCode

Varchar

BICCIEXX

Bank Identifier Code (BIC) of the financial institution, where the debtor account resides

ultimateDebtorLine1

Varchar

Name

For debits: Name of your customer

For credits: Blank

ultimateDebtorLine2

Varchar

Address line 1

For debits: Your customer's address line 1

For credits: Blank

ultimateDebtorLine3

Varchar

Address line 2

For debits: Your customer's address line 2

For credits: Blank

ultimateDebtorLine4

Varchar

Address line 3

For debits: Your customer's address line 3

For credits: Blank

ultimateDebtorAccount

Varchar

IE29AIBK93115212345678

For debits: The debtor account number (i.e., an account number issued by you).

For credits: Blank

ultimateBeneficiaryAccount

Varchar

IE29AIBK93115212345678

For debits: Blank

For credits: The creditor account number (i.e., an account number issued by you)

statusReasonCode

Varchar

RR01

Reason code in case of payment getting reversed

statusReasonDescription

Varchar

Insufficient sender account or unique identification

Reason description for payment reversal

instructedChargeBearer

Varchar

OUR

Charge bearer instructed by client

chargeBearer

Varchar

SHA

The actual charge bearer used for payment processing

paymentRail

Varchar

SEPA (SCT)

The payment rail used for executing the payment. You can read more about it here.

return

Text (4)

True

Possible values: true or null. The value will be true if the payment is an incoming return payment, otherwise the value will be null. This does not apply to incoming SEPA Direct Debits, where the value will always be null.

directDebitMandateId

Varchar

41b9a62baa5a2320247841ef865c1001

directDebitMandateId is a unique identifier assigned to a mandate issued by creditors under the SEPA Direct Debit scheme, such as a customer number

processedTimestamp

YYYY-MM-DDTHH:MM:SS.00000000+00:00

2024-05-08T11:40:25.00000000+00:00

Indicates the timestamp of when the payment is processed.

latestStatusChangedTimestamp

YYYY-MM-DDTHH:MM:SS.00000000+00:00

2024-05-08T11:40:25.00000000+00:00

Indicates the timestamp of latest status change on the payment.

clientOrderId

35 CHAR, Varchar

YourUniqueId

Your reference for your FX Trade executed via FX API.

Note: Only displayed for FX trades.