BCL CDDP – V reportsPayment statistics, from Excel to BCL XML
A simple, efficient and cost-effective Excel tool for the payment statistics collected by the Banque centrale du Luxembourg. Fill in the template, run the automatic checks and generate the XML on your premises, checked against the XSD and named for the BCL.
| Table | Content | Checks |
|---|---|---|
| V0120 | Credit transfers sent | No errors |
| V0130 | Direct debits | No errors |
| V0140 | SEPA R-transactions | 1 error |
| V0150 | Card transactions | No errors |
| V0180 | Book entries | No errors |
Excel
One template for your data
XSD
Technical format checked before export
Local
XML generated on your premises
2013/43
ECB regulation on payment statistics
What the tool does
Data mapping
Your data is mapped to the BCL tables and attributes, so each figure lands in the right V-report and breakdown.
XSD check
Every file is checked against the BCL schema before export, so the technical format is compliant.
BCL file naming
Files are named with the specific convention expected by the BCL.
On your premises
Fill in the template, run the automatic checks and generate the XML locally. Your payment data does not leave your systems.
Purpose and legal basis
The CDDP reporting compiles statistics on the payment activities of financial actors in Luxembourg. It measures the stocks of payment instruments and accounts, and the flows of payment transactions by volume and value.
A payment transaction is “an act, initiated by the payer or by the payee, of placing, transferring or withdrawing funds, irrespective of any underlying obligations between the payer and the payee”, as defined by the Payment Services Directive 2007/64/EC.
Legal framework
- BCL Regulation 2011/N°9 of 4 July 2011 on the collection of data on payment instruments and operations
- BCL Regulation 2015/N°20 of 24 August 2015, amending the 2011 regulation
- ECB Regulation ECB/2013/43 on payment statistics, implemented through BCL circulars and regulations
What the reporting covers
The framework is exhaustive and covers a wide range of payment instruments and transaction types.
PSD instruments
Credit transfers, direct debits, card payments and e-money.
- Credit transfers
- Direct debits
- Cards
- E-money
Other instruments
Cheques and money orders.
- Cheques
- Money orders
Transaction types
Interbank payments, on-us transactions, OTC cash deposits and withdrawals, transactions through telecom, digital or IT devices, and simple book entries such as interest or fees.
- Interbank
- On-us
- OTC cash
- Book entries
Related operations
Payments linked to securities transactions (coupons, purchases and sales) and to customer lending (granting and refunds of loans), mainly classified as book entries.
- Securities
- Lending
Core principles
Residence of the account
All payment accounts opened with a reporting agent legally established in Luxembourg are in scope, whatever the residence of the account holder.
Netting
For netted transactions, only the net flow corresponding to the effective payment is reported.
Rejected and returned
Rejected transactions are excluded. Returned legacy credit transfers are included in gross figures; SEPA R-transactions have their own tables.
Granularity
Transactions are broken down by customer category (MFI or non-MFI), settlement channel, initiation mode and geographical indicators.
The V-report tables
The CDDP reporting is organised in V-report tables, many with sub-tables for specific breakdowns, each targeting a payment instrument or activity.
| Code | Description |
|---|---|
| V01100 | Payment services provided by e-money institutions and payment institutions without the provision of payment accounts |
| V01110 | Payment initiation services (payments) |
| V0120 | Customer credit transfers sent (payments) |
| V01200 | Stock of issued payment cards |
| V01201 | Stock of distributed payment cards |
| V0121 | Customer credit transfers received |
| V01210 | Customer credit transfers received |
| V01220 | Stock of accounts (except e-money accounts) |
| V01221 | Stock of e-money accounts |
| V01222 | Stock of accessed accounts – account information services (AIS) |
| V01230 | Number of customers |
| V0130 | Direct debits – reporting as creditor’s PSP (payments) |
| V0131 | Direct debits – reporting as debtor’s PSP |
| V0140 | SEPA R-transactions |
| V0141 | Interbank payment transactions |
| V0142 | Intermediated payment transactions |
| V0150 | Card transactions with cards issued by resident PSPs (payments) |
| V0151 | Electronic card transactions with cards issued by resident PSPs, split by Merchant Category Codes (MCC) |
| V0152 | Card transactions acquired by resident PSPs (payments) |
| V0153 | Fundings and withdrawals related to prepaid cards |
| V0160 | Cheques and money remittances (payments) |
| V0170 | Over-the-counter (OTC) cash transactions |
| V0180 | Book entries |
| V0190 | Fundings and withdrawals in e-money (except prepaid cards) |
| V0191 | E-money transfers (payments) |
Key reporting concepts
Credit transfers along the payment chain
- Ordering party
- Bank OP
- Intermediary PSP
- Bank BEN
- Beneficiary
Transfers sent (V1.1.1, V1.2.1)
Reported by the bank of the ordering party.
Transfers received (V1.1.2, V1.2.2)
Reported by the beneficiary bank.
Intermediated transfers (V1.1.3, V1.2.3)
Reported by any payment service provider acting as an intermediary.
Settlement channel
The system or method used to settle the payment, chosen with a decision tree based on the currency and on a direct connection to a payment system.
Settlement channels
- TARGET
- EURO1
- STEP1
- STEP2
- EQUENS
- ON-US
- RELATION NOSTRO-LORO
- PSP LU
- PSP NON-LU
Customer categories
MFI: credit institutions, money market funds and other MFIs. Non-MFI: non-MFI funds and other non-MFIs, including government, other financial intermediaries, insurance corporations, non-financial corporations and households.
Card issuing
Transactions made with cards issued by the reporting institution, for its own customers or for customers of third-party distributors.
Card acquiring
Transactions processed by the reporting institution on behalf of merchants.
Card distribution
Cards provided to customers by an institution that is not the issuer, reported separately in the stock table (V1.4.1).
SEPA R-transactions
Exception handling in the SEPA schemes is reported in dedicated tables, based on the interbank XML messages, separately for SEPA Credit Transfers (SCT) and SEPA Direct Debits (SDD).
| Scheme | R-transaction | Meaning |
|---|---|---|
| SCT (V1.1.4, V1.1.5) | Return | After settlement, when the beneficiary bank cannot execute the transfer for a valid reason, such as a wrong account number. |
| SCT | Recall | Request by the originator bank to cancel a transfer: duplicate sending, technical problem or fraud. |
| SDD (V1.3.4, V1.3.6) | Reject | Collection diverted before settlement, for technical reasons or because the debtor refused it. |
| SDD | Return | Collection diverted after settlement, initiated by the debtor bank. |
| SDD | Reversal | Reimbursement initiated by the creditor after settlement, for an erroneous collection. |
| SDD | Refund | Claim by the debtor for reimbursement after settlement. |
| SDD | Request for cancellation | Request by the creditor bank to recall a collection before settlement. |
From your data to the BCL
Fill in
Enter or paste your payment data in the Excel template.
Check
Run the automatic checks, including the XSD validation.
Generate
Create the XML locally, named with the BCL convention.
Send
Transmit the file to the BCL through your usual channel.
Frequently asked questions
What is the BCL CDDP reporting?
The collection of data on payment instruments and operations by the Banque centrale du Luxembourg. It measures the stocks of payment instruments and accounts, and the flows of payment transactions by volume and value, through the V-report tables.
What is its legal basis?
BCL Regulation 2011/N°9 of 4 July 2011 on the collection of data on payment instruments and operations, amended by BCL Regulation 2015/N°20 of 24 August 2015, and ECB Regulation ECB/2013/43 on payment statistics.
Which accounts are in scope?
The collection follows the residence of the account: every payment account opened with a reporting agent legally established in Luxembourg is in scope, whatever the country of residence of the account holder.
Are rejected and returned transactions reported?
Rejected transactions, which are not processed, are excluded. Returned legacy credit transfers are included in the gross figures, while SEPA R-transactions are reported in dedicated tables.
How are netted transactions reported?
Only the net flow corresponding to the effective payment is reported.
Where is the data processed?
On your premises. You fill in the Excel template, run the automatic checks and generate the XML locally, ready to be sent to the BCL.
Official BCL documents
Reporting instructions, tables and technical documentation published by the BCL.
Other reporting solutions
Your next CDDP report, checked before it leaves
Tell us which V-report tables you file. We will show you the template on your own data.