Skip to main content
DD-ECL-001-Q029 Hard Time series

The impairment expense of 2026 so far

The ECL allowance at a month end: a customer whose CreditImpairedDate is on or before that date is provided at 100% of its balance (the specific allowance); every other balance is multiplied by the LossRatePct for its customer's Segment and its Bucket, taken from the MatrixVersion in force on that date (the version with the latest EffectiveFrom on or before it) - the collective allowance. The impairment expense in the income statement = closing allowance - opening allowance + write-offs - recoveries. Taking the opening as 31 December 2025 and the closing as the latest month end in the data (30 September 2026), with the write-offs and recoveries dated in 2026, what is the impairment expense of 2026 so far, in AED?
Expected
One amount in AED, 2 decimals · Waterfall: opening allowance, write-offs, recoveries, charge, closing
Tables
FactAgeingSnapshot, FactWriteOffs, DimCustomer, DimProvisionMatrix · columns
  • FactAgeingSnapshot
  • FactWriteOffs
  • DimCustomer
  • DimProvisionMatrix
  • Balance
  • Bucket
  • Segment
  • LossRatePct
  • CreditImpairedDate
  • Amount
  • EventType
  • EventDate

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us