Decide · the pilot

BCBS239 assessment: test one board report in two weeks

A BCBS239 assessment is only as good as the evidence under each rating. Start from one page of the board risk report, trace every figure to its source and let the ratings follow; this guide sets out the two-week plan, what to ask of any tool, and where BCBS 239 Compliance fits.

Updated · 15 min read

A BCBS239 assessment is a bank's own evaluation of how far its risk data aggregation and risk reporting meet the eleven bank-facing BCBS 239 principles, rated principle by principle and usually approved by the board before supervisors see it. Most banks still run it as a questionnaire: ratings argued in meetings, evidence attached as folders. That is why supervisors so often rate banks lower than banks rate themselves. A sounder method starts at the other end, with one page of the board risk report, and follows each figure on it back to its source, reconciling and timing it hop by hop; the ratings are then drafted from what the trace found. Botminds' BCBS 239 Compliance does that tracing with agents and leaves every confirmation and rating to named people, and a two-week pilot on one board report is the honest way to judge it, or any alternative.

The worked example is a fictional sample bank, Corvane National Bank, a $92 billion regional lender, and page 7 of its September 2026 Board Risk Report. The two-week plan is our recommendation, not a regulatory timetable.

One board figure, assessed from the report back to the source

  1. Agent

    Lineage agent

    Starts from $14.86B on page 7 and traces seven hops to the loan origination system, using the catalog, scheduler logs, report specifications and file-share access logs.

    Never: confirms a hop

  2. Agent

    Accuracy agent

    Reconciles each hop to the one before and splits the $212.0M difference at the workbook hop into what it can cite and what it cannot.

    Never: adjusts a figure

  3. Agent

    Timeliness agent

    Replays the June stress drill from the logs: 81.6 hours from request to board, 60 of them at the workbook.

    Never: re-runs a production job

  4. Agent

    Spreadsheet agent

    Rates the workbook High: 1,840 formulas, no version control, no reviewer sign-off, no reconciliation.

    Never: edits or locks a workbook

  5. A person decides

    Risk Data Steward

    Confirms the hop, accepts the finding and opens two remediation items for the data owner, each with a reason code.

  6. Agent

    Assessor

    Drafts each principle’s rating from the findings, citing every finding and its hop.

    Never: rates finally

  7. A person decides

    Head of Risk Reporting, CDO, Internal Audit

    Decides and submits the ratings, approves them, and validates them independently: three different people.

Fictional sample data. Agents trace, reconcile, time, rate and draft; people confirm, decide, approve and validate.

What is a BCBS 239 self-assessment, and why do supervisors expect one?

A BCBS 239 self-assessment is the bank's rating of itself against Principles 1 to 11, with the evidence behind each rating. The Committee built it into the timetable from the start: supervisory approaches were "likely to include requiring self-assessments by G-SIBs against these expectations in early 2013, with the goal of closing significant gaps before 2016" (BCBS 239, paragraph 88). Supervisors still use them. The 2023 progress report lists self-assessments among their ongoing tools and adds a condition: "Banks’ self-assessments, while needing to be validated, provide a basis for the supervisory assessment and remediation activities" (BCBS, November 2023).

Banks also run them for their own reasons. The Committee's January 2026 newsletter notes that "some banks find it helpful to conduct periodic assessments of in-scope data to observe alignment with the principles" (BCBS Newsletter 36). In the euro area the ECB's annual Management Report on data governance and data quality adds a signature: at least one member of the management body signs the bank's answers. In the United States, a bank covered by the OCC's heightened standards will want the same evidence for section II.J of 12 CFR Part 30, Appendix D, which the OCC proposed in December 2025 to apply only from $700 billion in assets; the proposal was not final as of October 2026.

What is a BCBS 239 gap analysis, and why do so many fall short?

A gap analysis compares the bank's current practice with the principles and the supervisor's expectations and lists what must change; it is the self-assessment's to-do list. The ECB's 2024 targeted reviews found the analyses missing or weak: "many banks do not provide proper recent or regular gap analyses where they compare against the BCBS 239 and relevant supervisory expectations. Even when such analyses have been conducted, their relevance for effective steering often remains unclear" (ECB Supervision Newsletter, February 2025).

Questionnaire assessments age for three reasons. The evidence is indirect: a policy shows that a control is required, not that it runs. The scope is chosen by the people being assessed, so the spreadsheet in the middle of a lineage is often outside it. And the result is frozen on the day it is signed, while source systems keep changing. The Basel Committee's picture of banks that rated themselves fully compliant years earlier while still running multi-year data quality remediation is what that produces. The BCBS 239 progress report sets the divergence out in detail.

Two ways to run a BCBS239 assessment

A questionnaire assessmentAn assessment from one board figure
Starting point

A questionnaire assessment: The fourteen principles, as questions to each function.

An assessment from one board figure: A figure on a page the board has read.

Lineage

A questionnaire assessment: Drawn from interviews; stops where the catalog stops.

An assessment from one board figure: Rebuilt hop by hop from logs and specifications, including file shares.

Accuracy

A questionnaire assessment: A sample tied to the general ledger at the end of the chain.

An assessment from one board figure: A reconciliation at every hop, with the unexplained part shown.

Timeliness

A questionnaire assessment: An attestation that ad hoc requests can be met.

An assessment from one board figure: The last drill replayed and measured hop by hop.

Rating

A questionnaire assessment: Argued in a meeting.

An assessment from one board figure: Drafted from findings, each finding cited to its hop, decided by a named person.

Shelf life

A questionnaire assessment: Until the next annual cycle.

An assessment from one board figure: Re-traced when a system or report the figure passes through changes.

Both methods end in a rating per principle. Only the second leaves a supervisor something to re-perform.

How do you do a BCBS 239 assessment on one board report?

Choose one page and treat every figure on it as a critical data element. Page 7 of the sample bank's Board Risk Report holds commercial real estate exposure, concentration and top-obligor figures: material, used in limits, and seen by the board each month. Tracing those figures exercises every aggregation principle, because each passes through source systems, staging, a mart, sometimes a spreadsheet, a reporting platform and a portal.

For each figure, collect four things: the path (every hop, with its system or file, owner and control), the amounts (the figure as held at each hop, reconciled to the hop before), the clock (each hop's elapsed time in the last stress drill) and the exceptions (manual steps, overrides and spreadsheets). Then draft each principle's rating from what those four show. On the sample bank this produced one finding big enough to move a rating: $212.0 million added at a workbook hop, of which $187.4 million is cited to 48 participations sold to other banks but counted as held, and $24.6 million is six manual overrides nobody has explained.

The board figure traced to source, hop by hop

A lineage screen for commercial real estate exposure (committed), CRE-EXP-001, one of 312 critical data elements. The number as the board saw it is $14.86B, with chips reading 7 hops, 81.6 hours end to end, 1 spreadsheet, $212.0M not reconciled and 2 hops with a gap. A thread lists hop 1 Board Risk Report, hop 2 risk reporting platform, hop 3 risk mart RM.CRE_CONC with a P2 chip, hop 4 CRE_concentration_v12.xlsx highlighted with P3, P5 and P6 chips and +2.5 days, hop 5 staging STG.CRE_LOANS and hop 6 core banking, each with owner, control, time added and amount. A side panel names the next step: hop 4 needs a steward.
Fictional sample data. Hops 1 to 4 hold $14,860.0M; hops 5 to 7 hold $14,648.0M. The workbook at hop 4 is where the difference and most of the time sit.

How long does a BCBS 239 assessment take? A two-week pilot plan

A full annual assessment by hand takes months: Botminds' estimate for the sample bank is about 46 weeks of effort across the data office, from inventory to approval. A pilot on one board report should take two weeks, and it should be judged on whether it produces evidence a supervisor could re-perform. The plan below assumes read access to the systems listed later, a named steward and an hour a day from the report owner.

A two-week BCBS239 assessment on one board page, working day by working day

Pilot plan10 working days
Scope the page, name owners, connect read-onlyDays 1–2
Trace every figure to sourceDays 3–4
Reconcile every hop, explain differencesDays 5–6
Replay the last drill; rate the spreadsheetsDay 7
Steward confirms hops and findingsDay 8
Draft ratings; decide, approve, validateDays 9–10
  • Scope the page, name owners, connect read-onlyDays 1–2
  • Trace every figure to sourceDays 3–4
  • Reconcile every hop, explain differencesDays 5–6
  • Replay the last drill; rate the spreadsheetsDay 7
  • Steward confirms hops and findingsDay 8
  • Draft ratings; decide, approve, validateDays 9–10
Our recommended plan, not a measured result. Green phases are people deciding. In the solution's sample story the agents traced the first figure at 07:40, and the steward confirmed its workbook hop at 09:34 the same morning.

What evidence does a BCBS 239 assessment need?

It needs evidence a reviewer can re-perform, tied to a principle. One board figure, traced properly, yields evidence for most of the eleven bank principles. The table shows what the sample bank's commercial real estate figure provided, and what it could not.

What one traced board figure gives each principle

PrincipleEvidence from one figureOn the sample bank
1 GovernanceNamed owner and steward per hop; who confirmed and who countersignedSeven hops, each with an owner; one waiting for a steward
2 ArchitectureControls at each system hop; hops the catalog does not listRisk mart runs a schema check only; the workbook appears in the catalog only as a manual upload
3 Accuracy and integrityReconciliation at every hop; explained and unexplained parts$212.0M at hop 4: $187.4M cited, $24.6M unexplained
4 CompletenessRows and entities lost or added between hopsA later re-trace found 112 office loans unmapped
5 TimelinessElapsed time per hop in the last drill, against target81.6 hours against 24; 60 at the workbook
6 AdaptabilityWhether the stress cut depends on a manual stepBy property type and state, built by one analyst in one workbook
7 to 11 ReportingReport-to-mart tie-out, sign-off, distribution logAutomated tie-out at hop 2; four-eyes sign-off at hop 1
12 to 14Not rated by the bank; evidence prepared for the supervisorPrepared, unrated
Fictional sample data. One page is a sample, not the whole inventory: the pilot shows whether the method holds, and the full assessment extends it to every critical data element.

Who performs a BCBS 239 assessment, and who should sign it off?

The first line prepares it, a second-line function validates it, and the board approves it; no one should approve what they prepared. The Basel text asks for validation that is "independent" and notes that "Common practices suggest that the independent validation of risk data aggregation and risk reporting practices should be conducted using staff with specific IT, data and reporting expertise", kept separate from audit work (BCBS 239, paragraph 29 and footnote 14). The ECB expects "A validation function within the second line of defence that is independent from the units involved in data governance", and an internal audit function that "periodically provides independent reviews" (ECB Guide, section 3.3).

In the sample bank the chain has four links. The Assessor agent drafts. Graham Ashdown, Head of Risk Reporting, decides each of the eleven ratings and submits. Celeste Marchetti, Chief Data Officer, approves for the Board Risk Committee. Owen Pritchard of Internal Audit validates independently, with the agent's draft and every human change side by side. The screen enforces the separation: the Head of Risk Reporting cannot approve what he submitted.

Drafted, submitted, approved, validated: four different signatures

The BCBS 239 self-assessment 2026 screen seen as the Internal Audit Director. A sign-off strip shows four completed stages: drafted by the Assessor, decided and submitted by Graham Ashdown with all 11 ratings decided, approved by Celeste Marchetti, CDO, for the Board Risk Committee, and validated by Owen Pritchard of Internal Audit. Tiles show 11 of 11 bank principles rated, 3 moved since 2025, 44 findings, 19 remediation items open and 1,284 evidence items, and each principle shows Accepted with a reason code.
Fictional sample data. Maker, checker, then an independent validation, each with a reason code.

What to ask of any tool or partner for a BCBS 239 assessment

Ask to see each of these on your own board page during the pilot, not on a vendor's sample. A product that cannot show them on your data in two weeks will not show them to a supervisor either.

Nine questions to put to BCBS 239 assessment software before you buy

  1. Does it start from the figure the board saw?

    Lineage that starts at the catalog misses what was added after it.

  2. Does it find hops the catalog does not list?

    Manual uploads and file shares are where the sample bank’s difference sat.

  3. Does it reconcile every hop, not just the ends?

    An end-of-chain tie-out cannot see a mid-chain difference.

  4. Does it show the unexplained remainder?

    A tool that forces every difference to an explanation is guessing.

  5. Is timeliness measured from logs?

    Principle 5 asks for timely data; an attestation is not a timing.

  6. Does every rating cite its findings, and every finding its hop?

    That is what lets a reviewer re-perform it.

  7. Who decides?

    An agent should never confirm a hop or set a final rating.

  8. What happens when a system changes or stops answering?

    Re-trace only what changed; pause, and say so, when a source is silent.

  9. What does it read, and can it write?

    Read-only access, masking of loan-level rows, and an audit trail of every action.

Where BCBS 239 Compliance fits, and where it does not

BCBS 239 Compliance fits a bank that already reports to its board from systems that leave logs: a data catalog, an ETL scheduler, a risk reporting platform and file shares with access logs. From those, its agents rebuild lineage, reconcile, time and rate, and the Assessor drafts the self-assessment with each rating citing its findings, mapped to the OCC heightened-standards paragraph each one also answers. Thresholds, targets and approvers are the bank's own settings, each change versioned and approved by a second person.

It fits less well where a hop leaves no trace. If a figure is re-keyed from an email or produced by a provider that shares no logs, the Lineage agent marks the hop "needs evidence" below its 0.90 confidence threshold, and a steward must supply it. It does not certify compliance, replace the independent validation the principles require, or fix what it finds: retiring a workbook remains the data owner's remediation item. And a pilot on one page is a sample; the full assessment extends the same method to every critical data element, which in the sample bank means 312 elements across 41 reports.

What to bring to a two-week pilot

  1. One board page

    The latest board, regulatory or supervisory risk report page, with its report specification.

  2. Catalog and scheduler logs

    The data catalog and the ETL scheduler’s job logs for the reporting period.

  3. Source extracts

    Loan origination, core banking and general ledger extracts for the same date.

  4. File-share logs

    Access logs for the shares the reporting workbooks live on, read-only.

  5. The last stress drill

    The request, and the scheduler and report-platform logs for the days it ran.

  6. Your rules

    Risk data policy, materiality, the stress timing target and who approves what.

From the inputs the solution reads. Nothing is written back to any system.

The pilot's output should be an examiner-ready pack for one page: lineage with confirmations, reconciliations, the drill replay, spreadsheet ratings, draft ratings with their citations, and remediation items with owners. If the method holds, naming an owner and steward for every hop and comparing data lineage tools on the same element are the natural next steps. The BCBS 239 principles in plain words covers what each rating means.

Questions people ask

How do you do a BCBS 239 assessment?

Rate each of the eleven bank principles from evidence: lineage to source for each critical figure, a reconciliation at every hop, timings from the last stress drill and an inventory of manual steps and spreadsheets. Starting from one board page and tracing its figures is the fastest way to build that evidence and test the method.

What is a BCBS 239 self-assessment?

The bank's own rating of its compliance with Principles 1 to 11, often on the same four-point scale the Basel Committee's assessments use, from fully compliant to not adopted. The Committee expected G-SIBs to self-assess from early 2013, and supervisors use self-assessments as a basis for their own review once validated.

Who should sign off a BCBS 239 self-assessment?

The person who prepares the ratings should not approve them. A common chain is the head of risk reporting deciding and submitting, the chief data officer approving for the board risk committee, and an independent validation by a second-line function or internal audit.

How long does a BCBS 239 assessment take?

A full annual cycle done by hand runs for months; Botminds' estimate for its sample bank is about 46 weeks of effort across the data office. A pilot on one board page can be done in two weeks if read access to logs and a named steward are in place.

What evidence does a BCBS 239 assessment need?

Evidence a reviewer can re-perform: lineage with owners and controls at each hop, reconciliations with differences explained or marked unexplained, measured timings in stress, the spreadsheets in each lineage with their controls, and findings cited behind each rating.

Is a BCBS 239 assessment the same as an audit?

No. The self-assessment is management's view; internal audit's job is to review it independently, and the Basel text keeps validation separate from audit work. Supervisors then form their own view, often by fire drills, deep dives or on-site inspections.

BCBS 239 Compliance.
See it on your own files.

An agentic solution from Botminds. One board figure followed back to its source, reconciled at every hop, every rating cited. Book a demo, or explore how it works.