Description

A focused course, tailored for you

Regulatory Reporting Accountant Mastery: COREP, FINREP and LCR

Build the reconciliation discipline, data-lineage audit trail and sign-off workflow that lets you close the quarter without last-minute escalations.

One unexplained COREP cell, one blank data-lineage note, one missed sign-off step. That's all it takes to hold up submission at quarter-end. The course gives regulatory reporting accountants the documented architecture to prevent it.

$199 one-time

Tailored to your situation. Access within 24 hours. 30-day money-back.

Includes a hand-built implementation playbook delivered alongside course access, generated for your specific situation.

Why this course

Regulatory reporting sits at the intersection of accounting, data engineering and regulatory interpretation. The numbers flow from dozens of source systems, pass through mapping tables that were built under pressure and documented (if at all) in shared drives that no one owns. When the ECB or PRA reviewer sends a query, the answer often requires reconstructing a decision that was made eighteen months ago by someone who has since moved teams. The quarter-end crunch is the symptom. The underlying problem is that the reconciliation framework was never formalised: no canonical mapping register, no lineage audit trail, no sign-off workflow that is repeatable under time pressure. This course builds that framework from scratch, using COREP, FINREP and LCR/NSFR as the working examples.

What you walk away with

Build a canonical source-to-template mapping register that any auditor or regulator can follow without a walkthrough.
Design a data-lineage audit trail that survives staff turnover and answers ECB or PRA queries within the same business day.
Construct FINREP and COREP reconciliation packs that self-document the bridge between the general ledger and the regulatory cell.
Implement an LCR supporting-schedule architecture where every inflow and outflow line traces back to a signed-off source extract.
Run a quarter-end review-gate workflow that catches mapping gaps before the submission window opens.
Write the internal mapping-decision memos that turn one-off judgement calls into repeatable, documented policy.

The 12 modules

Module 1. The Regulatory Reporting Stack

Map the full production chain from core banking and treasury systems through to XBRL submission: where COREP, FINREP, LCR and NSFR data originates, which transformations are applied at each layer and where undocumented mapping decisions accumulate over time. Participants build a system-inventory diagram specific to their reporting perimeter that becomes the foundation for every subsequent module.

Module 2. Building the Source-to-Template Mapping Register

Design the canonical mapping register that links every regulatory template cell to its source-system field, transformation rule and mapping-decision memo. The module covers register schema, version control, owner assignment and the review cadence that keeps it current. Participants leave with a register template pre-populated with COREP OF 01.01 and FINREP F 01.01 as worked examples, ready to extend across their full returns.

Module 3. COREP Reconciliation Architecture

Build the reconciliation pack for the COREP own-funds templates: the general-ledger bridge, the deduction waterfall and the cross-template consistency checks (OF vs CA vs LR) that the ECB examiner runs on receipt. The module walks through the three most common query categories and the pre-submission checks that catch them before they become observations. Worked examples use published EBA validation rules as the check framework.

Module 4. FINREP Template Discipline

Set up the FINREP reconciliation workflow from balance sheet (F 01.01) through P&L (F 02.00) to the off-balance-sheet schedules. Covers the classification-and-measurement mapping decisions (IFRS 9 stage allocation, fair-value hierarchy), the intra-group elimination adjustments in consolidated returns and the supporting-note structure that lets the regulator trace a FINREP cell to a specific portfolio segment. Includes a reusable FINREP closing pack template.

Module 5. LCR Supporting-Schedule Architecture

Design the LCR calculation architecture so that every inflow, outflow and HQLA line traces back to a signed-off source extract with a documented haircut assumption. The module covers the mapping of current accounts, committed facilities, securities portfolios and retail deposit buckets to the CRR Article 412 stress-scenario rates. Participants build a supporting-schedule workbook where each row carries a lineage reference and a last-reviewed date.

Module 6. NSFR and Stable Funding Schedules

Extend the liquidity architecture to the NSFR templates: map Available Stable Funding and Required Stable Funding components to the same source extracts used for LCR, flag the items where NSFR and LCR treatments diverge and document the divergence in the mapping register. The module includes the internal sign-off memo structure for NSFR assumptions that satisfies both the risk committee and the PRA/ECB reviewer.

Module 7. Data-Lineage Audit Trail

Build the lineage audit trail that answers a regulator query without reconstructing history. Covers lineage metadata standards (source system, extract timestamp, transformation version, approver), the difference between lineage as a living document versus a submission artefact and the tooling options from Excel-based lineage logs to lightweight data-catalogue entries. Participants design the lineage schema for their own reporting environment.

Module 8. Mapping-Decision Memos

Write the internal memos that convert one-off judgement calls into repeatable, documented policy: the scope of the decision, the regulatory reference, the alternative treatments considered, the conclusion and the next review date. The module provides a memo template and works through five common regulatory-reporting judgment areas where undocumented decisions generate recurring queries: off-balance-sheet classification, intragroup netting, scope of consolidation, fair-value levelling and liquidity bucket assignment.

Module 9. Quarter-End Review-Gate Workflow

Design the review-gate workflow that runs inside the submission window: pre-submission validation checklist, escalation path for open items, sign-off sequencing (preparer, reviewer, head of regulatory reporting, CFO attestation) and the handoff package that goes to compliance before XBRL filing. The module maps the workflow against the typical T-3 to T+0 submission timeline and identifies where the most common late-stage holds occur and how to pre-empt them.

Module 10. Regulator Query Response Protocol

Build the response protocol for ECB, PRA, ACPR and Fed examiner queries: triage by query type (data, methodology, restatement), response drafting with lineage evidence attached, escalation criteria and the internal tracker that keeps response commitments visible to the CFO. Covers the difference between a Section 165 Fed data request and an SREP information request in terms of response format, timeline and the evidence package expected.

Module 11. Change Management for Mapping Updates

Manage the lifecycle of a mapping change: trigger (new product, regulatory amendment, system migration), impact assessment across COREP, FINREP and LCR templates, parallel-run period, sign-off and register update. The module uses the EBA COREP phase-2 XBRL taxonomy update as a worked example, walking through the change-impact log, the parallel submission and the mapping-register rollover procedure.

Module 12. Building the Continuous-Improvement Register

Create the continuous-improvement register that captures regulator observations, internal audit findings and near-misses from quarter-end closes: root-cause categorisation, owner assignment, due date and closure evidence. The module ties the register back to the mapping register and the review-gate workflow so that a closed observation translates into a documented process change rather than an email thread that gets forgotten before the next cycle.

How this addresses your situation

Specific modules that map to what you said you are dealing with.

Module 1-2 addresses the foundational gap: no canonical mapping register means every quarter-end starts with archaeology.

Modules 3-6 build the per-template reconciliation architectures for the four returns that generate the most regulator queries.

Modules 7-8 create the audit-trail and decision-memo discipline that makes the reconciliation defensible to any external reviewer.

Modules 9-12 deliver the operational layer: the review-gate workflow, the query-response protocol, the change-management procedure and the improvement register.

What you get with this course

Twelve written modules with downloadable templates for each: mapping register schema, COREP reconciliation pack, FINREP closing pack, LCR supporting-schedule workbook, lineage audit-trail schema, mapping-decision memo template, quarter-end review-gate checklist, regulator query tracker.
Hand-built implementation playbook delivered alongside course access: a 90-day build plan scoped to the regulatory returns the participant owns, with week-by-week milestones from mapping-register draft to first full quarter-end run.
Access in the Art of Service learning environment within 24 hours of purchase.

What you will have in hand by Day 1, Week 1, Month 1

Access provisioned within 24 hours of purchase.

Hand-built implementation playbook delivered alongside course access.

Before and after

Before

Quarter-end closes are reactive: a COREP cell is queried, the team reconstructs the mapping decision from email threads and informal notes, the response takes two days and the fix is not captured anywhere that survives staff turnover.

After

Quarter-end closes run against a pre-submission checklist. Every template cell has a lineage reference. Regulator queries are answered within the business day from the audit trail. Mapping decisions are in a register that any new team member can read and apply.

What happens if you do not address this

Without a documented reconciliation architecture, every regulatory change (new EBA taxonomy, new PRA data item, new Fed reporting requirement) triggers a manual rework cycle. The cumulative time cost across four returns, four regulators and quarterly submissions compounds quickly. More importantly, an undocumented mapping environment is a regulatory risk: a material misstatement that traces back to an undocumented assumption is treated differently from one that traces back to a documented decision that was reviewed and approved.

Who it is for

Regulatory reporting accountants at large banks and broker-dealers who own the production and submission of prudential returns. They understand accounting and have worked with the regulatory templates, but have never had a structured course on building the underlying reconciliation architecture and the data-lineage documentation that makes it auditable.

Who this is NOT for. Consultants building a generic framework product. Finance graduates still learning the templates. Anyone whose firm already has a mature, documented reconciliation architecture with zero open regulator queries.

How it arrives

Text-based course in the Art of Service learning environment, plus downloadable templates and worked examples for every module, plus the hand-built implementation playbook delivered alongside course access.

Time investment. Twelve modules, approximately 30-45 minutes each. Most participants work through one module per working day alongside their regular production cycle, completing the core modules in three weeks and applying the templates to their live quarter-end in week four.

Why $199 is the right number

EBA and BIS publish the regulatory frameworks. Big-four advisory practices offer gap assessments at consulting rates. Internal training programmes cover the accounting standards but rarely the operational reconciliation architecture. This course is the only structured programme that walks a working regulatory reporting accountant through building the complete production-to-submission architecture for COREP, FINREP and LCR in one place, with reusable templates for every component.

FAQ

The course covers COREP and FINREP. Does it apply to a US-headquartered branch reporting under Fed requirements?

Yes. Modules 10 covers the Fed examiner query protocol specifically. The reconciliation architecture in modules 2-9 applies to any prudential return because the underlying challenge (mapping source data to a regulatory template with a documented, auditable lineage) is the same. The worked examples use EBA templates; the implementation playbook is scoped to the specific returns the participant owns.

My firm has a data-management team that owns the lineage tooling. Is this course still relevant?

Yes. The course focuses on the regulatory-reporting accountant's role in defining the lineage metadata requirements, reviewing the mappings and owning the reconciliation pack. The data-management team implements the tooling; this course gives the accountant the specification to hand them and the review protocol to validate what comes back.

How is the implementation playbook tailored?

The playbook is hand-built by Gerard within 24 hours of purchase, scoped to the specific returns and regulators named in the purchase context. It maps the 12-module framework to a 90-day build plan with week-by-week milestones relevant to the participant's reporting cycle.

30-day money-back guarantee. If after a week of working through the materials this is not what you needed, reply to the receipt email and a full refund is processed. No questions, no forms.

Within 24 hours your account in the learning environment is provisioned and the tailored implementation playbook is delivered alongside it.