Get intraday paged reconciliation report

get

https://www.bankingcircleconnect.com/api/v1/reports/intraday-reconciliation-paged-report

This endpoint returns a reconciliation report. This report contains relevant information on all your payments at the given transaction date, within a specific time range indicating the time the transactions were created in our system. The report can contain one or all your accounts.

The report can be used to perform financial reconciliation of bookings during the day. The report is paginated.

Only data from current and previous year is available online. Contact Client Services to access older data.

📘
Last available report for transaction date

The last available report for transaction date = current calendar date will be at 19.00, following our EOD cycle. Please set the ToTransactionDate parameter to next business day, to obtain payments received or executed after 19.00 CET.

Query Params

FromTransactionDate

date-time

required

Minimum transaction date

FromTransactionDate and ToTransactionDate form a date range

Criteria: Reconciliation.ReportDate must be equal or later

Format: ISO 8601 | YYYY-MM-DD

ToTransactionDate

date-time

required

Maximum transaction date

FromTransactionDate and ToTransactionDate form a date range

Criteria: Reconciliation.ReportDate must be equal or earlier

Format: ISO 8601 | YYYY-MM-DD

FromCreatedAt

date-time

required

Minimum created at date and time

FromCreatedAt and ToCreatedAt form a date range

Criteria: Reconciliation.ReportDate must be equal or later

Format: ISO 8601 | YYYY-MM-DDTHH:MM:SS.0000000Z

ToCreatedAt

date-time

required

Maximum created at date and time

FromCreatedAt and ToCreatedAt form a date range

Criteria: Reconciliation.ReportDate must be equal or earlier

Format: ISO 8601 | YYYY-MM-DDTHH:MM:SS.0000000Z

PageNumber

int32

required

Page number

Valid page number (1 to n)

PageSize

int32

required

Page size

Any positive value may be specified however values above an internal maximum value will be reset to the max allowed value (e.g. 5000)

IncludeProperties

array of strings

deprecated

This Parameter has been deprecated. Please use PropertiesIncluded instead.

IncludeProperties

PropertiesIncluded

string

Properties of Reconciliation object to include in result

Please note: the use of IncludeProperties and PropertiesIncluded are mutual exclusive. - When both are used all IncludeProperties are ignored.

If PropertiesIncluded is set, PropertiesExcluded need not be set

If neither PropertiesIncluded nor PropertiesExcluded are specified, default value will be PropertiesIncluded =

	PIdChannelUser

	PTxnDate

	ReportDate

	CustomerId

	Account

	AccountCurrency

	DebitAmount

	CreditAmount

	ValueDate

	InstructedAmount

	InstructedAmountCurrency

	TransactionAmount

	TransactionAmountCurrency

	ExchangeRate

	DebtorBankCode

	DebtorAccount

	DebtorLine1

	DebtorLine2

	DebtorLine3

	DebtorLine4

	BeneficiaryBankCode

	BeneficiaryAccount

	BeneficiaryLine1

	BeneficiaryLine2

	BeneficiaryLine3

	BeneficiaryLine4

	PaymentReferenceNumber

	FileReferenceNumber

	UserReferenceNumber

	PaymentDetails1

	PaymentDetails2

	PaymentDetails3

	PaymentDetails4

	CreditDebitIndicator

	BankTrnsCodeDomain

	BankTrnsCodeFamily

	CreatedAt

Extra parameters that can be added to the array, but are not part of the default array

	PaymentId

	LastChangedTimestamp

	BankTrnsCodeSubFamily

	DebtorAgentBankCode

	UltimateDebtorLine1

	UltimateDebtorLine2

	UltimateDebtorLine3

	UltimateDebtorLine4

	UltimateDebtorAccount

	UltimateBeneficiaryAccount

	StatusReasonCode

	StatusReasonDescription

    AdditionalRemittanceInformation1

    AdditionalRemittanceInformation2

    AdditionalRemittanceInformation3

    AdditionalRemittanceInformation4

    AdditionalRemittanceInformation5

    PaymentRail

    Return

    DirectDebitMandateId

    LatestStatusChangedTimestamp

    ProcessedTimestamp

    ClientOrderId

Format: comma (,) separated string

ExcludeProperties

array of strings

deprecated

This Parameter has been deprecated. Please use PropertiesExcluded instead.

ExcludeProperties

PropertiesExcluded

string

Properties of Reconciliation object to exclude from result

Please note: the use of ExcludeProperties and PropertiesExcluded are mutual exclusive. - When both are used all ExcludeProperties are ignored.

To get all available properties send an empty PropertiesExcluded list

If PropertiesExcluded is set, PropertiesIncluded need not be set

Format: comma (,) separated string

AccountId

string

Id of the account on which activities have been booked

Criteria: Exact match on the Id of the account.

It is possible to send comma separated list of GUIDs

Format: comma (,) separated string

Headers

string

enum

Defaults to application/json

Generated from available response content types

Allowed:

Responses

500

Internal Server Error

200OK

400Bad Request

403Forbidden