Reporting data lineage

From ledger to monthly pack: who owns which number

Purpose. Layer 3 exists so that finance, first line, and risk see one coherent story. This page maps which system should drive which fields and where DCA-reported data plays a supporting role. It complements the conceptual frame in Source of Record.

Hard link: Layer 3 reporting should be built from CP-controlled data and reconciled views. DCA-reported data supports operations, vendor challenge, and dual-state checks. It does not replace CP truth for authoritative balance, placement state, or financial outcomes.

Controls: Lineage is part of the controls framework. If you cannot explain which system produced a number, you cannot control it.

Layer 3 pack: Pack section definitions and metrics align with STD-DCA-REPORT-001 in docs/DCA-Governance; each Layer 3 field should trace to CP or DCA source per Reporting. A filled example sits in Sample monthly pack dashboard under DCA Governance (canonical).

Principle: CP-controlled backbone

Authoritative balances, payments posted to customer accounts, recall execution, and end-state codes should originate from CP systems (core plus recoveries book as designed). DCA feeds explain what the vendor did; CP feeds explain what the bank recognises.

Recovery rate (example lineage)

Definitions vary; pick one and publish it. A defensible pattern:

Both should be computable from CP-controlled tables. If the DCA’s “recovery rate” differs, treat the gap as a reconciliation insight, not as an alternate truth.

Typical field ownership

Reporting conceptPrimary sourceSecondary or challenge source
Open placement balanceCP recoveries bookDCA-reported balance
Cash collectedCP cash allocation / GL attribution rulesDCA payment file
Fees payableCP accrual from contract rulesDCA remittance advice
Accounts placed / recalledCP placement and recall logsDCA confirmation files
Contact attempts and outcomesDCA activity file (defined taxonomy)QA sampling by CP
Complaints countCP complaints register (system of record)DCA internal log for triage
Hardship holdsCP flags driving suppressionDCA identification referrals

Governance pack construction

Build the monthly pack by joining:

  1. CP cohort snapshot at period boundaries.
  2. CP-recognised cash and adjustments in period.
  3. Trace fields for R1 and R2 from R1 / R2 traceability.
  4. Vendor sections where DCA attests to operational metrics under contract.

Attestation should confirm that vendor sections were produced from agreed sources and any known breaks are listed.

Anti-pattern: parallel spreadsheets

If risk uses a spreadsheet built only from DCA PDFs while finance uses GL, you will get “successful” vendor meetings and failed audits. Lineage discipline is boring and essential.

Related: Reporting · Reconciliation · Back to pack home