IFRS quantitative finance series
IFRS 9 Data Lineage: From Loan Systems to the General Ledger
A sophisticated credit model cannot rescue an allowance built on incomplete balances, stale collateral, missing origination dates or irreconcilable ledger mappings. Data lineage should make every material reported number traceable to source and transformation.
Control the population
The first reconciliation proves completeness: all in-scope financial assets, commitments and guarantees are identified, classified and mapped to a calculation treatment. Exclusions and manual records require explicit ownership.
Trace transformations
Lineage should record joins, filters, currency conversion, staging overrides, parameter assignment, scenario expansion and aggregation. Technical lineage becomes useful only when paired with business meaning and control evidence.
Close the reporting loop
Instrument-level allowance should reconcile to sub-ledger, general ledger and disclosure tables. Differences need categorisation by timing, scope, rounding or correction, with thresholds and sign-off appropriate to materiality.
Quantitative expression
Implementation controls
- Reconcile counts and balances before calculation.
- Version every material dataset and rule.
- Prevent unapproved manual changes.
- Retain drill-down from disclosure to contract.