Bank To Customer Account Report

Bank to customer account report provides a comprehensive, structured intraday data of account activity for reconciliation, cash management, and financial reporting.

📘

By default, the report will be a summary of the account and the current balances. To include transactional data, make sure to set includeTransactions to TRUE. Transactions will be sorted by the newest transaction first. When using the synchronous endpoint with cursor-based pagination, the recordsand recordCount fields refer to the amount of transactions returned. If transactions are not included, the fields will be emptyor return 0, respectively.

The report can be retrieved by Report On Request (asynchronous) or Cursor-based pagination (synchronous):

Supported Formats

The report is available in the following formats:

  • CSV - Flat, tabular format suitable for spreadsheets and simple integrations.
  • JSON - Structured format optimized for system-to-system integrations.
  • CAMT.052.001.08 (ISO 20022) - Standardized XML format for financial messaging and enterprise-grade integrations.

Report Content

The Bank To Customer Account Report includes:

  • Account identification and metadata
  • Interim Available Balance (ITAV) and Interim Booked Balance (ITBD)
  • Booked transactions
  • Transaction details, including:
    • Amount
    • Currency
    • Transaction date and value date
    • Transaction references
    • Counterparty information

Balances

Balance

Description

ITAV - Interim Available Balance (Intraday)

Available balance calculated in the course of Banking Circle's business day, at the time specified, and subject to further changes during the business day. The interim balance is calculated on the basis of booked credit and debit items during the calculation time/period specified.

Entries are included based on whether the Transaction Date falls within the specified time/period. Entries with a Value Date beyond the specified time/period are excluded.

ITBD - Interim Booked Balance (Intraday)

Balance calculated in the course of Banking Circle's business day, at the time specified, and subject to further changes during the business day. The interim balance is calculated on the basis of booked credit and debit items during the calculation time/period specified.

Entries are included based on whether the Transaction Date falls within the specified time/period.

Properties

Logical PropertyDescriptionCAMT.052 XPathJSONCSV
Header
Message IdentificationUnique message identifier./Document/BkToCstmrAcctRpt/GrpHdr/MsgIdcontext.header.messageIdentificationMESSAGE_IDENTIFICATION
Group Creation Date TimeMessage creation timestamp./Document/BkToCstmrAcctRpt/GrpHdr/CreDtTmcontext.header.creationDateTimeGROUP_CREATION_DATETIME
Group Additional InformationAdditional header info./Document/BkToCstmrAcctRpt/GrpHdr/AddtlInfcontext.header.additionalInformationGROUP_ADDITIONAL_INFORMATION
Account
Account IBANAccount IBAN./Document/BkToCstmrAcctRpt/Rpt/Acct/Id/IBAN
OR
context.accounts.0.ibanACCOUNT_IBAN
Account NumberAccount number./Document/BkToCstmrAcctRpt/Rpt/Acct/Id/Othr/Idcontext.accounts.0.accountNumberACCOUNT_NUMBER
Account CurrencyAccount currency./Document/BkToCstmrAcctRpt/Rpt/Acct/Ccycontext.accounts.0.currencyACCOUNT_CURRENCY
Account Servicer BICServicing institution BIC./Document/BkToCstmrAcctRpt/Rpt/Acct/Svcr/FinInstnId/BICFIcontext.accounts.0.servicerBicACCOUNT_SERVICER_BIC
Balances
Interim Booked AmountBooked balance amount./Document/BkToCstmrAcctRpt/Rpt/Bal[0]/Amtcontext.accounts.0.balances.0.amount.amountBALANCE_INTERIM_BOOKED_AMOUNT
Interim Booked CurrencyBooked balance currency./Document/BkToCstmrAcctRpt/Rpt/Bal[0]/Amt/@Ccycontext.accounts.0.balances.0.amount.currencyBALANCE_INTERIM_BOOKED_CURRENCY
Interim Booked Credit/DebitBooked balance indicator./Document/BkToCstmrAcctRpt/Rpt/Bal[0]/CdtDbtIndcontext.accounts.0.balances.0.creditDebitIndicatorBALANCE_INTERIM_BOOKED_CREDIT_DEBIT_INDICATOR
Interim Booked DateBooked balance date./Document/BkToCstmrAcctRpt/Rpt/Bal[0]/Dt/Dtcontext.accounts.0.balances.0.dateBALANCE_INTERIM_BOOKED_DATE
Interim Available AmountAvailable balance amount./Document/BkToCstmrAcctRpt/Rpt/Bal[1]/Amtcontext.accounts.0.balances.1.amount.amountBALANCE_INTERIM_AVAILABLE_AMOUNT
Interim Available CurrencyAvailable balance currency./Document/BkToCstmrAcctRpt/Rpt/Bal[1]/Amt/@Ccycontext.accounts.0.balances.1.amount.currencyBALANCE_INTERIM_AVAILABLE_CURRENCY
Interim Available Credit/DebitAvailable balance indicator./Document/BkToCstmrAcctRpt/Rpt/Bal[1]/CdtDbtIndcontext.accounts.0.balances.1.creditDebitIndicatorBALANCE_INTERIM_AVAILABLE_CREDIT_DEBIT_INDICATOR
Interim Available DateAvailable balance date./Document/BkToCstmrAcctRpt/Rpt/Bal[1]/Dt/Dtcontext.accounts.0.balances.1.dateBALANCE_INTERIM_AVAILABLE_DATE
Entry
AmountTransaction amount./Document/BkToCstmrAcctRpt/Rpt/Ntry/Amtrecords.0.amount.amountAMOUNT
Amount CurrencyTransaction currency./Document/BkToCstmrAcctRpt/Rpt/Ntry/Amt/@Ccyrecords.0.amount.currencyAMOUNT_CURRENCY
Credit/Debit IndicatorCredit or debit./Document/BkToCstmrAcctRpt/Rpt/Ntry/CdtDbtIndrecords.0.creditDebitIndicatorCREDIT_DEBIT_INDICATOR
Reversal IndicatorIndicates reversal./Document/BkToCstmrAcctRpt/Rpt/Ntry/RvslIndrecords.0.reversalIndicatorREVERSAL_INDICATOR
StatusEntry status./Document/BkToCstmrAcctRpt/Rpt/Ntry/Sts/Cdrecords.0.statusSTATUS
Booking DateEntry booking date./Document/BkToCstmrAcctRpt/Rpt/Ntry/BookgDt/Dtrecords.0.bookingDateBOOKING_DATE
Value DateEntry value date./Document/BkToCstmrAcctRpt/Rpt/Ntry/ValDt/Dtrecords.0.valueDateVALUE_DATE
Account Servicer ReferenceServicer-assigned reference for the entry./Document/BkToCstmrAcctRpt/Rpt/Ntry/AcctSvcrRefrecords.0.accountServicerReferenceACCOUNT_SERVICER_REFERENCE
Bank Transaction CodeProprietary bank transaction code./Document/BkToCstmrAcctRpt/Rpt/Ntry/BkTxCd/Prtry/Cdrecords.0.bankTransactionCodeBANK_TRANSACTION_CODE
End To End IdEnd-to-end identification./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/Refs/EndToEndIdrecords.0.endToEndIdEND_TO_END_ID
PurposePurpose of the transaction (code or proprietary)./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/Purp/Cd or Prtryrecords.0.purposePURPOSE
Return ReasonReturn reason code./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RtrInf/Rsn/Cdrecords.0.returnInformation.returnReasonRETURN_REASON
Return Additional InformationReturn description./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RtrInf/AddtlInfrecords.0.returnInformation.additionalInformationRETURN_ADDITIONAL_INFORMATION
Remittance Information 1Unstructured remittance line 1./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RmtInf/Ustrd[0]records.0.remittanceInformation.0REMITTANCE_INFORMATION_1
Remittance Information 2Unstructured remittance line 2./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RmtInf/Ustrd[1]records.0.remittanceInformation.1REMITTANCE_INFORMATION_2
Remittance Information 3Unstructured remittance line 3./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RmtInf/Ustrd[2]records.0.remittanceInformation.2REMITTANCE_INFORMATION_3
Remittance Information 4Unstructured remittance line 4./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RmtInf/Ustrd[3]records.0.remittanceInformation.3REMITTANCE_INFORMATION_4
Debtor
Debtor NameDebtor party name./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Dbtr/Pty/Nmrecords.0.debtor.nameDEBTOR_NAME
Debtor Address Line 1Debtor address line 1./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Dbtr/Pty/PstlAdr/AdrLine[0]records.0.debtor.addressLines[0]DEBTOR_ADDRESS_LINE_1
Debtor Address Line 2Debtor address line 2./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Dbtr/Pty/PstlAdr/AdrLine[1]records.0.debtor.addressLines[1]DEBTOR_ADDRESS_LINE_2
Debtor Address Line 3Debtor address line 3./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Dbtr/Pty/PstlAdr/AdrLine[2]records.0.debtor.addressLines[2]DEBTOR_ADDRESS_LINE_3
Debtor Country CodeDebtor postal address country./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Dbtr/Pty/PstlAdr/Ctryrecords.0.debtor.countryCodeDEBTOR_COUNTRY_CODE
Debtor Account
Debtor Account Type[1]Debtor account type./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/DbtrAcct/Type/Cdrecords.0.debtorAccount.typeDEBTOR_ACCOUNT_TYPE
Debtor Account IBANDebtor account IBAN./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/DbtrAcct/Id/IBAN
OR
records.0.debtorAccount.ibanDEBTOR_ACCOUNT_IBAN
Debtor Account NumberDebtor account number./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/DbtrAcct/Id/Othr/Idrecords.0.debtorAccount.accountNumberDEBTOR_ACCOUNT_NUMBER
Debtor Agent
Debtor Agent BICDebtor agent BIC./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdAgts/DbtrAgt/FinInstnId/BICFI
OR
records.0.debtorAgent.bicFiDEBTOR_AGENT_BIC_FI
Debtor Agent NCCDebtor clearing code./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdAgts/DbtrAgt/FinInstnId/ClrSysMmbId/MmbIdrecords.0.debtorAgent.nationalClearingCodeDEBTOR_AGENT_NATIONAL_CLEARING_CODE
Ultimate Debtor
Ultimate Debtor NameUltimate debtor name./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/UltmtDbtr/Pty/Nmrecords.0.ultimateDebtor.nameULTIMATE_DEBTOR_NAME
Ultimate Debtor CountryUltimate debtor country code./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/UltmtDbtr/Pty/PstlAdr/Ctryrecords.0.ultimateDebtor.countryCodeULTIMATE_DEBTOR_COUNTRY_CODE
Creditor
Creditor NameCreditor party name./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Cdtr/Pty/Nmrecords.0.creditor.nameCREDITOR_NAME
Creditor Address Line 1Creditor address line 1./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Cdtr/Pty/PstlAdr/AdrLine[0]records.0.creditor.addressLines[0]CREDITOR_ADDRESS_LINE_1
Creditor Address Line 2Creditor address line 2./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Cdtr/Pty/PstlAdr/AdrLine[1]records.0.creditor.addressLines[1]CREDITOR_ADDRESS_LINE_2
Creditor Address Line 3Creditor address line 3./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Cdtr/Pty/PstlAdr/AdrLine[2]records.0.creditor.addressLines[2]CREDITOR_ADDRESS_LINE_3
Creditor Country CodeCreditor postal address country./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Cdtr/Pty/PstlAdr/Ctryrecords.0.creditor.countryCodeCREDITOR_COUNTRY_CODE
Creditor Contact Details NameCreditor contact details name (proxy alias)./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/Cdtr/Pty/CtctDtls/Nmrecords.0.creditor.contactDetailsNameCREDITOR_CONTACT_DETAILS_NAME
Creditor Account
Creditor Account Type[1]Creditor account type./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/CdtrAcct/Type/Cdrecords.0.creditorAccount.typeCREDITOR_ACCOUNT_TYPE
Creditor Account IBANCreditor account IBAN./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/CdtrAcct/Id/IBAN
OR
records.0.creditorAccount.ibanCREDITOR_ACCOUNT_IBAN
Creditor Account NumberCreditor account number./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/CdtrAcct/Id/Othr/Idrecords.0.creditorAccount.accountNumberCREDITOR_ACCOUNT_NUMBER
Creditor Proxy
Creditor Proxy TypeProxy account type./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/CdtrAcct/Prxy/Tp/Prtryrecords.0.creditorAccount.proxy.typeCREDITOR_PROXY_ACCOUNT_TYPE
Creditor Proxy IdentificationProxy identifier./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdPties/CdtrAcct/Prxy/Idrecords.0.creditorAccount.proxy.identificationCREDITOR_PROXY_ACCOUNT_IDENTIFICATION
Creditor Agent
Creditor Agent BICCreditor agent BIC./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdAgts/CdtrAgt/FinInstnId/BICFI
OR
records.0.creditorAgent.bicFiCREDITOR_AGENT_BIC_FI
Creditor Agent NCCCreditor clearing code./Document/BkToCstmrAcctRpt/Rpt/Ntry/NtryDtls/TxDtls/RltdAgts/CdtrAgt/FinInstnId/ClrSysMmbId/MmbIdrecords.0.creditorAgent.nationalClearingCodeCREDITOR_AGENT_NATIONAL_CLEARING_CODE

References

  1. This field will only be populated if the account is a virtual account. In CSV and JSON formats, the value will be VirtualAccount, whereas in CAMT.052 format it will be VACC.