BCL Reporting SolutionExcel to XML for S and TPT reports
Four Excel workbooks, one per type of entity, covering the statistical and security-by-security reports of the Banque centrale du Luxembourg. Every entry is checked as you type, and each report is exported as an XML file validated against the BCL schemas.
| Report | Content | Checks |
|---|---|---|
| S 1.3 | Statistical balance sheet | No errors |
| S 1.6 | Valuation effects | No errors |
| S 2.20 | Quarterly financial information | 2 errors |
| S 4.4 | Marketing countries | No errors |
| TPTOBS | Security by security | No errors |
4
Workbooks, one per type of entity
16
BCL reports covered
2026
Layouts, including S 2.20 and S 4.4
XML
Validated against the BCL schemas
One workbook per type of entity
The Banque centrale du Luxembourg collects monetary and financial statistics directly from investment funds, financial companies, securitisation vehicles and insurance corporations. Each workbook contains every report its type of entity may have to file.
Investment funds
UCIs, SIFs, SICARs and non-regulated AIFs, including the reports introduced in 2026.
- S 1.3
- S 2.13
- S 1.6
- S 2.20
- S 4.4
- TPTOBS
Financial companies
Holding, financing and investment companies, on the 2026 layout of the S 2.16 and S 2.17.
- S 2.16
- S 2.17
- TPTIBS
Securitisation vehicles
Balance sheet, transactions and write-offs on securitised loans, and the securities held.
- S 2.14
- S 2.15
- TPTTBS
Insurance corporations
Balance sheet, valuation effects, annual premiums, claims and commissions of the Luxembourg entity.
- S 2.18-L
- S 2.19-L
- S 4.3-L
- TPTASS
What the workbooks do for you
Checks as you type
Mandatory fields, code lists, ISIN and LEI check digits, duplicates and breakdowns are checked on each row. Errors appear next to the line, with the reason.
XML validated against the BCL schemas
The BCL XSD schemas are built into each workbook. The XML file is validated before export and named according to the BCL convention.
Reconciliation between reports
At quarter end, the monthly security-by-security report is reconciled with the quarterly balance sheet, so inconsistencies are caught before the BCL sees them.
Comparison with the previous period
Load last month's XML and see the variation of each line. Unusual movements stand out before you submit.
Import and reuse
Import an existing BCL XML file into the workbook to start from your last submission instead of an empty sheet.
Valuation update in one step
Load a price file from your accounting or custodian system, by ISIN or internal code, and the amounts of the TPT are updated automatically.
Auto-complete and status at a glance
Dependent fields fill in as you type. A dedicated Excel ribbon shows the number of entries, errors and reports ready to export.
Optional filing and free support
We can file your reports with the BCL and follow up on the feedback, with no SOFiE e-file or LuxTrust needed on your side. Support and helpdesk are included.
See the workbooks in action
Short demonstrations for three types of entity. The player loads only when you click.
Investment funds
Financial companies
Securitisation vehicles
From your data to the BCL
-
Fill in or import
Paste your positions, import last period's XML or load a price file to update the valuations.
-
Fix what's flagged
Each error is shown on its row with the reason, from a missing code to an invalid ISIN.
-
Compare and reconcile
Check the variations against the previous period and the consistency between reports.
-
Export and file
Export the validated XML with the BCL file name, then file it yourself or let us do it.
BCL reports and frequencies
The reference date is the last day of the month for monthly reports and the last day of the quarter for quarterly reports.
| Report | Content | Frequency |
|---|---|---|
| Investment funds | ||
| S 1.3 | Statistical balance sheet | Monthly |
| S 2.13 | Statistical balance sheet | Quarterly |
| S 1.6 | Valuation effects on the balance sheet (non-MMF funds) | Monthly |
| S 2.20 New 2026 | Quarterly financial information | Quarterly, on ECB working-day deadlines: 30 Jan, 4 May, 28 Jul, 28 Oct 2026 and 1 Feb 2027 |
| S 4.4 New 2026 | Marketing countries | Yearly: 8 Apr 2026, 8 Apr 2027 |
| TPTOBS New layout | Security-by-security reporting | Monthly |
| Financial companies | ||
| S 2.16 | Quarterly statistical balance sheet | Quarterly |
| S 2.17 | Quarterly information on all transactions | Quarterly |
| TPTIBS | Security-by-security reporting | Monthly |
| Securitisation vehicles | ||
| S 2.14 | Quarterly statistical balance sheet | Quarterly |
| S 2.15 | Transactions and write-offs/write-downs on securitised loans | Quarterly |
| TPTTBS | Security-by-security reporting | Monthly |
| Insurance corporations | ||
| S 2.18-L | Quarterly statistical balance sheet, Luxembourg entity | Quarterly |
| S 2.19-L | Valuation effects on the balance sheet, Luxembourg entity | Quarterly |
| S 4.3-L | Annual premiums, claims and commissions, Luxembourg entity | Yearly |
| TPTASS | Security-by-security reporting | Monthly |
Which reports a fund must file depends on its type and size. The decision tree below summarises the 2026 requirements for non-MMF investment funds.
Frequently asked questions
What is BCL reporting?
The Banque centrale du Luxembourg collects statistical data from investment funds, financial companies, securitisation vehicles and insurance corporations to compile monetary and financial statistics for Luxembourg and the euro area. The reports combine aggregated balance sheet data (the S reports) with security-by-security data on each instrument held (the TPT reports).
Is there a reporting threshold?
The BCL provides for an exemption threshold based on total balance sheet, currently set at EUR 500 million or the equivalent in foreign currency. Check the BCL circular or regulation that applies to your type of entity for the exact conditions.
Which financial companies must report?
A financial company is reportable when its corporate object includes at least one of the following: investing in other companies, acquiring securities or other financial instruments, investing in real estate, patents or other intellectual property, borrowing in any form, or lending to shareholders, subsidiaries, affiliated companies or other entities.
Which investment funds must report?
Undertakings for collective investment under the law of 17 December 2010, specialised investment funds under the law of 13 February 2007, SICARs under the law of 15 June 2004, and Luxembourg non-regulated alternative investment funds meeting the criteria of article 1(39) of the law of 12 July 2013, unless they are exempted from BCL reporting.
Do I need SOFiE or LuxTrust to file?
Not if you use our filing option. We submit the XML files to the BCL on your behalf and follow up on the feedback. You can also export the files and file them yourself through your usual channel.
Can I start from last period's report?
Yes. Each workbook imports an existing BCL XML file, so you only update what has changed. You can also compare the current report with the previous one line by line.
Official BCL documents
Circulars, manuals and FAQs published by the Banque centrale du Luxembourg, by type of entity.
Investment funds
Financial companies
Securitisation vehicles
Other reporting solutions
Your next BCL submission, checked before it leaves
Tell us your type of entity and the reports you file. We'll show you the workbook on your own data.