Blog

The TPTIBS report — Monthly Security-by-Security Reporting of Financial Companies — is a mandatory statistical submission to the Banque centrale du Luxembourg (BCL). Required under Regulation 2014/17, it obliges resident Luxembourg financial companies above the €500 million asset threshold to report every individual security on their balance sheet each month. This guide covers the full technical specification: scope, data model, field constraints, verification rules, and XML submission requirements — and introduces how Fund XP’s Excel-based reporting solution can dramatically simplify your compliance workflow.

---

Table of Contents

1. Scope and Reporting Population
2. Securities Subject to Reporting
3. Data Model and Key Concepts
4. The Five Balance Sheet Items Explained
5. ISIN vs. Non-ISIN Securities
6. Supplementary Information Requirements
7. Verification Rules: Permanent and Temporary
8. XML Submission Format and File Naming
9. Deadlines and Reporting Calendar
10. How Fund XP’s Excel Solution Simplifies Your Reporting
11. Compliance Best Practices

---

1. Scope and Reporting Population

The TPTIBS obligation applies to all resident financial companies whose total assets exceed €500 million. Under BCL Regulation 2014/17, a company qualifies as a financial company if its business purpose includes at least one of the following activities:

• Investment in any entity for any kind of investment purpose
• Acquisition of securities, shares, bonds, certificates of deposit, and other financial instruments
• Direct or indirect investment in real estate, patents, or other intellectual property
• Borrowing in any form
• Lending funds to shareholders, subsidiaries, affiliated companies, or any other entity

A company is considered resident when it is incorporated under Luxembourg law (covering all activities of its head office, subsidiaries, and Luxembourg-based branches) or incorporated under foreign law but operating through a Luxembourg head office or branch.

The BCL exemption threshold is currently set at €500 million in total assets. Companies below this threshold are exempt from monthly and quarterly statistical reporting.

2. Securities Subject to Reporting

The securities to be reported are those recorded in the following lines of the quarterly statistical balance sheet S 2.16 (Layout 2). No other lines are in scope.

Assets

Item Code	Description
1-003000	Debt securities held
1-005000	Equity and investment fund shares/units held

Liabilities

Item Code	Description
2-002050	Short sales of securities
2-003000	Debt securities issued
2-C05000	Capital, share premium, reserves and results

Not in scope: Securities received in repurchase agreements or through securities borrowing are not recorded on the balance sheet of the temporary acquirer and therefore must not be reported in TPTIBS.

3. Data Model and Key Concepts

3.1 Reference Dates

• End-of-month date (endOfMonthDate): The last calendar day of the reporting month — the statistical reference date.
• Closing date (closingDate): The date on which data were established. May be earlier than the end-of-month date. The issue date of any security must be ≤ the closing date.

3.2 Layout Version

The report entering into force in January 2027 is the third version of TPTIBS, corresponding to layout «2». This designator appears in both the XML schema and the file name (TPTIBS_L2_…).

3.3 Balance Sheet Line Identifier

Component	Field	Required Value in TPTIBS
Balance sheet item	item	e.g. 1-003000, 2-C05000
Country	country	XX (no geographic breakdown)
Currency	currency	XXX (no currency breakdown)
Economic sector	sector	90000 (no sector breakdown)

3.4 Reported Amount and Valuation

• Quoted securities: Closing stock-exchange price at end of reporting date.
• Debt securities: Dirty price — market price plus accrued interest since the last coupon payment.
• Sign rules: reportedAmount ≥ 0 for items 1-003000, 2-002050, 2-003000. May be negative for 1-005000 and 2-C05000.

3.5 Quantity of Securities

Quotation Type	Field to Use	Notes
Percentage-quoted (nominal value)	nominalAmount + nominalCurrency	Pool factor must NOT be applied to the nominal
Currency-quoted (unit count)	numberOfUnits	Do NOT report nominalAmount / nominalCurrency

4. The Five Balance Sheet Items Explained

Item 1-003000 — Debt Securities Held

Covers all negotiable debt instruments on the asset side: bonds, notes, commercial paper, treasury bills, subordinated debt in securities form. Certificate-type hybrid instruments (PECs, CPECs, TPECs) are explicitly excluded — they are classified as loans. Accrued interest is included (dirty price).

Field	Constraint
holdSecurityType	01 (held outright), 02 (lent), 03 (sold under repo)
securityType	F.3 only
reportedAmount	≥ 0

Item 1-005000 — Equity and Investment Fund Shares/Units Held

Field	Constraint
holdSecurityType	01, 02, or 03
securityType	F.511 (quoted), F.512 (unquoted), F.519 (other equity), F.52 (investment fund units)
reportedAmount	May be negative

Item 2-002050 — Short Sales of Securities

Records the liability arising from short selling. The amount is the sale price of the securities, valued consistently with similar positions on the asset side.

Field	Constraint
holdSecurityType	05 only
securityType	F.3, F.511, F.512, F.519, or F.52
reportedAmount	≥ 0

Item 2-003000 — Debt Securities Issued

Field	Constraint
holdSecurityType	04 only
securityType	F.3 only
Issuer country (non-ISIN)	Must be LU
Issuer sector (non-ISIN)	Must be 44000
reportedAmount	≥ 0

Item 2-C05000 — Capital, Share Premium, Reserves and Results

Records equity capital issued: paid-up capital, share premiums, reserves, and undistributed profits. Requires identification of each shareholder and their country of residence. The country code XX is not permitted here.

Field	Constraint
holdSecurityType	04 only
securityType	F.511, F.512, or F.519
Holder country	Valid ISO 3166 code — XX is prohibited
affiliation	04, 05, V0, or 06
reportedAmount	May be negative

5. ISIN vs. Non-ISIN Securities

5.1 Valid ISIN Codes (codeType = 1)

• First two characters must be a valid ISO 3166 country code at date of issue, or one of: EU, XA, XB, XC, XD, XS.
• Explicitly invalid prefixes: DU, EV, HF, HS, QS, QT, QU, QY, TE, XF, XX, ZZ.
• Must pass the Luhn check-digit verification.
• Provisional/pseudo-ISIN codes are not valid and must be reported as codeType = 2.

5.2 Non-ISIN Securities (codeType = 2)

Additional mandatory fields: name (official company name), currency, issuer identification (LEI, national ID type/code, country, sector). If the reporter has no issuer identifier, declare type XX_NOTAP / code XX — for exceptional use only, monitored by the BCL.

5.3 Luxembourg Investment Fund Identification

• CSSF-authorised funds: CSSF number in format LUOxxxxxxC00000 (traditional) or LUOxxxxxxCxxxxx (sub-fund).
• Non-authorised AIFs (NAF): RCS-based: LURCSB0123456 (traditional) or LURCSB0123456C00001 (compartment 1).
• Securities must be reported at sub-fund level unless the fund has a traditional structure.

6. Supplementary Information Requirements

Supplementary information (supplements) is required only for non-ISIN securities and varies by security type.

6.1 Debt Securities (items 1-003000, 2-002050, 2-003000)

Field	Description	Key Rules
securityType	Security classification	Must be F.3
issueDate	Issue date	Must be ≤ closingDate
finalMaturityDate	Final maturity	Use 01.01.2999 for perpetual bonds
poolFactor	Fraction of principal remaining	> 0; default = 1; may exceed 1 exceptionally
couponType	Nature of coupon	01=fixed, 02=progressive, 03=floating, 04=zero, 05=index-linked, 99=other
couponFrequency	Coupons per year	00=zero, 01=annual, 02=semi-annual, 04=quarterly, 06=bi-monthly, 12=monthly, 24=fortnightly, 99=other
couponLastPaymentDate	Last coupon payment	If no payment yet: equals issueDate. Must be ≥ issueDate and ≤ finalMaturityDate.
couponRate	Annualised rate (%)	E.g., report 5.5 for a 5.5% rate

6.2 Equity and Investment Fund Shares/Units (item 1-005000)

Field	Constraint
securityType	F.511, F.512, F.519, or F.52
affiliation	01=≥10% held, 02=cross-holding <10%, U0=sister company, 03=no affiliation
dividendAmount	Dividend coefficient (last dividend per unit)
dividendLastPaymentDate	Date of last dividend payment

6.3 Capital, Share Premium, Reserves (item 2-C05000)

Field	Constraint
securityType	F.511, F.512, or F.519 only (F.52 not permitted)
holderID / country	ISO 3166 code; XX is prohibited
affiliation	04=≥10% by shareholder, 05=cross-holding, V0=sister company, 06=no affiliation

7. Verification Rules in Detail

The BCL applies two categories of rules. Permanent rules must be implemented in reporting software. Temporary rules are addressed primarily to reporting agents when preparing data.

7.1 Permanent Internal Verification Rules (23 rules)

#	Rule Description
1	Only the five authorised item codes are permitted.
2	Only the five authorised line identifiers are permitted (XX, XXX, 90000 components).
3	reportedAmount ≥ 0 for items 1-003000, 2-002050, 2-003000; may be < 0 for 1-005000, 2-C05000.
4	Percentage-quoted: if reportedAmount > 0, then nominalAmount > 0.
5	Currency-quoted: if reportedAmount > 0, then numberOfUnits > 0.
6	ISIN codes must satisfy ISO 6166 (valid country prefix + Luhn check-digit).
7	Non-ISIN: issuer country must be valid ISO 3166 (no XX); sector must be a valid Level 1 code.
8	Authorised sector codes: 11000, 12100, 12200, 12300, 21000, 22110, 22120, 22200, 31000, 32100, 32200, 33000, 41000, 42100, 42200, 42900, 43000, 44000, 45000, 46000.
9	holdSecurityType must match the item (01/02/03 for assets; 05 for 2-002050; 04 for 2-003000 and 2-C05000).
10	Nominal currency must be a valid ISO 4217 code; XXX is prohibited.
11	securityType must match the item (F.3 for debt; F.511/F.512/F.519/F.52 for equity).
12	Non-ISIN issued by LU reporters: country=LU, sector=44000, holdSecurityType=04, affiliation=04/05/06/V0.
13	Non-ISIN held by LU reporters: holdSecurityType=01/02/03, securityType=F.511/F.512/F.519/F.52, affiliation=01/02/03/U1/U0.
14	issueDate ≤ closingDate.
15	poolFactor > 0; default = 1 when not applicable; may exceed 1 exceptionally.
16	couponType ∈ {01, 02, 03, 04, 05, 99}.
17	couponFrequency ∈ {00, 01, 02, 04, 06, 12, 24, 99}.
18	Zero-coupon type (04) may only be combined with zero-coupon frequency (00), and vice versa.
19	couponLastPaymentDate ≥ issueDate and ≤ finalMaturityDate; equals issueDate if no payment yet.
20	couponRate is the annualised rate in percentage at the reporting date.
21	closingDate – couponLastPaymentDate must be consistent with coupon frequency (limits doubled to allow first-coupon exceptions).
22	If couponLastPaymentDate > issueDate and < finalMaturityDate, then couponRate > 0.
23	If couponFrequency ≠ 00 and couponType = 01 (fixed), then couponRate > 0.

7.2 Cross-Report Consistency (TPTIBS ↔ S 2.16)

The totalReportedAmount for each of the five balance sheet lines in TPTIBS must exactly equal the corresponding amount in S 2.16. This cross-check is enforced permanently for all five items.

7.3 Temporary Rule — Federal State Sector (12100)

Sector code 12100 (State government) may only be used with countries having a federal structure, including: AE, AR, AT, AU, BA, BE, BR, CA, CH, DE, ES, ET, FM, IN, IQ, KM, MX, MY, NG, NL, PK, RS, RU, SD, SS, US, VE.

8. XML Submission Format and File Naming

8.1 File Name Structure

TPTIBS_L2_yyyymm_Rrrrrrrrrr_Dddddddddd_yyyymmdd.nnn

Component	Description	Example
TPTIBS	Report code	TPTIBS
L2	Layout version 2	L2
yyyymm	Reporting period	202701 = January 2027
R + 9 digits	Reporter type + ID (left-padded zeros)	DSE000000999
D + 9 digits	Declarant type + RCS numerical part	DSE0003524
yyyymmdd	File creation date	20270220
nnn	Sequential number (starts at 001 daily)	001

8.2 Reporter / Declarant Type Codes

Type Code	Description	Filename Prefix
01	Number allocated by CSSF to other entities	1
05	Identification number allocated by the BCL	5
23	CSSF number allocated to banks	B
30	CSSF number allocated to management companies	S
32	CSSF number allocated to PFS professionals	P
35	BCL number allocated to financial companies	DSE
40	CSSF number for alternative investment fund managers	A

8.3 Transmission Channels

• Sofie (SIX Payment Services Europe S.A. / CETREL Securities)
• e-file (Bourse de Luxembourg / Fundsquare)
• Any other secure channel mutually agreed with the BCL

9. Deadlines and Reporting Calendar

TPTIBS must be submitted to the BCL monthly, at the latest 20 working days after the end of the reference month. The exact submission calendar is published on the BCL website. Reporting agents must retain all reports and supporting documents for a minimum of 24 months.

10. How Fund XP’s Excel Solution Simplifies Your BCL Reporting

Preparing a fully compliant TPTIBS submission by hand — managing five balance sheet items, ISIN validation, 23 permanent verification rules, proper XML structure, and cross-checks against S 2.16 — is a substantial operational burden for any compliance or finance team. Fund XP, a Luxembourg-based IT & Consulting firm specialising in regulatory reporting, has developed a dedicated Excel-based (XLSM) reporting solution that automates this process end-to-end.

Key Features of the Fund XP XLSM Template

Who Is It For?

The Fund XP BCL reporting solution is designed for Luxembourg financial companies — holding companies, SPVs, treasury vehicles, securitisation entities — that are subject to BCL statistical reporting obligations but do not have a large, dedicated regulatory reporting infrastructure. It is equally useful for external accountants, domiciliation agents, and fund administrators who prepare BCL reports on behalf of multiple entities.

11. Compliance Best Practices

1. Implement all 23 permanent verification rules in your production system before submitting. Do not rely solely on BCL server-side rejection.
2. Validate ISIN codes rigorously — check the country prefix and run the Luhn check-digit algorithm. Treat provisional/pseudo codes as codeType = 2.
3. Reconcile TPTIBS totals with S 2.16 quarterly. The five totalReportedAmount values must match exactly.
4. Use dirty price for all debt securities — forgetting accrued interest is one of the most common valuation errors.
5. Apply the economic-holder principle consistently: securities lent or sold under repo remain on the original owner’s balance sheet.
6. Maintain stable non-ISIN codes — once assigned in the first report, codes must never change.
7. Monitor XX_NOTAP usage — the BCL actively tracks this identifier; it should be used only in genuinely exceptional cases.
8. Retain all reports and documentation for 24 months — this is a regulatory minimum, not a guideline.
9. Subscribe to BCL communications for updates to verification rules, sector code lists, and layout versions.

---

Conclusion

The BCL TPTIBS report is one of the most technically demanding statistical obligations facing Luxembourg financial companies. Its granular security-by-security approach — covering five distinct balance sheet items, two security identification regimes, extensive supplementary data for non-ISIN instruments, and 23 hard verification rules — requires robust data management processes and well-engineered reporting software.

Whether you build your own tooling or leverage a ready-made solution like the Fund XP Excel-to-BCL reporting tool, the key to sustainable compliance is rigorous pre-submission validation, strong reconciliation between TPTIBS and S 2.16, and thorough staff training.

For the full XML schema, the official sector code list, and the reporting calendar, visit the Banque centrale du Luxembourg website. For questions about our solution or Luxembourg regulatory reporting in general, contact the Fund XP team.

---

Related Resources

• BCL Regulation 2026/050 — Legal Basis for Financial Company Statistical Reporting
• BCL Compendium of Verification Rules for TPTIBS (February 2026)
• BCL Definitions and Concepts for the Statistical Reporting of Financial Companies (February 2026)
• BCL Manual of Electronic Transmission for Statistical Reports (February 2026)
• GLEIF — Global LEI Index (Legal Entity Identifier Search)