Produce the Pillar 3
Who, when. At every disclosure, quarterly, half-yearly or yearly, you produce the EBA Pillar 3 workbook from the filings already submitted. This guide chains the steps of one production, from checking the source filings to the last reading before publication. It needs the Pillar 3 module; peer comparisons also need the Public data module (see Pillar 3).
1. Check the source filings
The workbook reads the filings of a single perimeter: COREP, FINREP, LCR, NSFR, leverage, asset encumbrance, MREL/TLAC, remuneration, at date T and at the earlier dates T-1 to T-4 according to the frequency. Before starting:
- The filings at date T must be in release 4.2 or in a release read as 4.2. At earlier dates, 4.0 and 4.1 are accepted; 3.2 is always refused.
- A file uploaded before the application kept the filing information, entity, consolidation, version, module, currency, must be reprocessed (see Perimeters and reporting files).
- Mark the submitted filing of each family as official: when several filings carry the same tables at the same date, you will have to choose, and the official one is the natural choice.
Consolidated (LEI.CON) and individual (LEI.IND) are two entities: a workbook does not mix them. A file not yet processed, or whose extraction is incomplete, feeds no cell. The rights required are export on each source filing and modification of the perimeter to enter values.
2. Open the generation and the institution’s choices
In Analysis › Reportings › Pillar 3 workbooks, click Generate Pillar 3, choose the perimeter, the Reference date (T), an end of month, and the Disclosure frequency (see How to generate a Pillar 3 workbook).
Fill in the three Disclosure choices of the institution: fully loaded or transitional Tier 1 for the leverage ratio, type of institution for EU CCR7, trading book boundary for EU OR2. The cells that depend on a choice stay empty until it is filled (see Disclosure choices of the institution).
3. Complete the filings grid
The Reportings tab crosses the families and the dates. It fills itself when a single filing fits (see The Reportings tab):
- Add: a filing exists, add it;
- Choose (n): several filings carry the same tables, keep one; generation is blocked until this is done;
- Missing: the filing is not uploaded. The number of pending cells says what its absence costs.
Templates with history, EU KM1 over five dates, EU LIQ1 over twelve month ends, EU AE1 to AE3 over four quarters, are never half filled: a missing date leaves the cell empty, with the cause Missing history. Upload the earlier filings before generating, rather than entering averages by hand.
Save the draft as soon as the grid is in place: it keeps the selection, the frequency, the templates and the choices, and a colleague can resume it (see The draft).
4. Choose the templates and read the coverage
The Templates to fill tab shows, template by template, the cells filled automatically and the empty cells, grouped by cause (see The Templates to fill tab):
| Cause | What you do |
|---|---|
| Missing data | Upload the filing that carries it, or enter the value by hand. |
| Missing history | Upload the missing earlier dates. |
| Ambiguous | Remove one of the filings that carry the same value. The application never chooses. |
| Not supported yet | The rule is not automated or awaits validation: manual entry, see the treatments. |
| Calculation error | Fix the source filing: a manual value would hide the problem. |
Tick the templates to publish; without a selection, all are generated.
5. Enter what the filings do not give
Qualitative information, remuneration and cells without a mapping are entered by hand, cell by cell with Enter values, or in the sheet with Fill in the sheet, where a block copied from Excel is pasted from the first cell (see Manual values).
- Every value requires a justification: it appears with your name in the workbook’s journal.
- Values are kept from one generation to the next, for this perimeter, this date and this mapping tool version.
- To replace a computed value, double-click the cell and confirm Force the value. The journal keeps the replaced value, and the P3 Issues sheet lists every override.
The decimal separator is the dot: 12,5 is refused. A single invalid value cancels the whole batch entered in the sheet. An ambiguous cell or a cell in error cannot be edited.
6. Generate and read back
Click Generate workbook (n templates) with Include the review sheets checked (see Generate and download). The message says whether the workbook is complete or partial. Read it back in this order:
- P3 Issues: the BLOCKING messages, a family of filings is missing, then WARNING, selection diagnostics, rules awaiting validation, ignored manual values (see The content of the workbook).
- P3 Journal: for every empty cell, its cause; for every filled cell, its rule, the resolved formula and the source facts.
- The workbook detail, Templates tab: How it was computed on a cell shows the rule, the values used and the source facts, and opens the filed template on the datapoint (see The detail of a workbook).
For a cell whose reading looks questionable, the Treatments behind the workbook page explains the interpretations retained, the mapping tool corrections and the readings still awaiting validation, inactive until validated (see Treatments).
Fix, then Regenerate from the history: a new workbook is added, with today’s data and rules.
7. Compare yourself
With the Public data module, the workbook’s Benchmark tab places your 21 risk indicators against the EU distribution of the EBA Risk Dashboard, and the Compare EU KM1 with peers page sets your figures against the institutions of your choice (see The EBA risk indicators and Peer comparisons).
Being above or below the band is neither good nor bad in itself. On KM1 row 17, the LCR, peers publish the twelve-month average while your workbook takes the quarter-end ratio: compare with care.
8. Before publishing
- The published workbook is the Templates only download: the filled templates, without the review sheets. The version with the sheets stays in the history for the audit (see Generated workbooks).
- A partial workbook publishes empty cells, never an invented zero: check that every empty cell is intended.
- Manual and forced values are traced with their author and justification: read them one last time in P3 Issues.
- Keep the draft: it prepares the next disclosure, and the filings grid already shows what the next date T will need.