NBE 5-Tier Asset Classification & Loan Loss Provisioning
Implement National Bank of Ethiopia prudential loan classification, calculate Days Past Due (DPD), and automate statutory impairment reserves.
1. Overview & Business Value#
This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for NBE 5-Tier Asset Classification & Loan Loss Provisioning within SmartERP.

Implement National Bank of Ethiopia prudential loan classification, calculate Days Past Due (DPD), and automate statutory impairment reserves.
2. Prerequisites & Security Access Groups#
- Required Modules:
smarterp_sacco_core, smarterp_equb, smarterp_loan_management - Security Groups:
SACCO Loan Officer(Technical ID:smarterp_sacco.group_sacco_officer)SACCO Credit Committee Member(Technical ID:smarterp_sacco.group_sacco_committee)SACCO General Manager(Technical ID:smarterp_sacco.group_sacco_manager)
- Master Data Dependencies: Member KYC profiles, share capital registers, savings product tiers, loan products with reducing-balance schedules, and Equb rotational pool configurations.
3. Step-by-Step Configuration & Execution#
Step 1: Navigating to the Interface#
- Log into your SmartERP instance at
https://smarterp.et/odoo. - Open the main App Switcher (grid icon in the top-left corner).
- Navigate to SACCO Core → Member Accounts; Loans → Active Loans.
Step 2: Operational Data Parameters & Controls#
Ensure all mandatory parameters comply with enterprise operational standards:
- Authorized Operator: Action executed under assigned RBAC permissions (SACCO General Manager, Loan Appraisal Officer, Cashier).
- Relational Integrity: Linked to upstream master records, approval requests, or transactional ledgers.
- Statutory & Quality Controls: Verified against Ethiopian statutory regulations and corporate governance standards.
Step 3: Operational Execution & State Progression#
- State Progression Gate: Advance record from Draft through Audited to Confirmed / Certified.
- Integrated System Impact: Automatically updates real-time operational states and posts financial/inventory journal moves.
- Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.
NBE 5-Tier Asset Classification Matrix#
Under National Bank of Ethiopia microfinance prudential directives, financial cooperatives must classify their entire loan portfolio into five risk tiers based on Days Past Due (DPD):
| Classification Tier | Days Past Due (DPD) | Provision Rate (%) | Impairment Category |
|---|---|---|---|
| Tier 1: Pass (Current) | 0 to 30 Days Overdue | 1.0% | General Provision |
| Tier 2: Special Mention | 31 to 60 Days Overdue | 3.0% | General Provision |
| Tier 3: Substandard | 61 to 90 Days Overdue | 20.0% | Specific Provision |
| Tier 4: Doubtful | 91 to 180 Days Overdue | 50.0% | Specific Provision |
| Tier 5: Loss | 181+ Days Overdue | 100.0% | Full Impairment (Write-Off) |
Automated DPD Calculation & Migration Engine#
SmartERP calculates DPD daily using the formula:
$$\text{DPD} = \max_{i} \left( \text{Today} - \text{Due Date}_i \right) \quad \forall \quad \text{Unpaid Installments}_i$$
At midnight, active loans migrate dynamically across risk tiers based on their oldest unpaid installment:
- If an installment due on Jan 30 remains unpaid on March 15 (44 DPD), the loan migrates from Pass to Special Mention.
- When the member settles the overdue installment, the loan cures back to Pass.
Monthly Provisioning Journal Posting#
At month-end, the system aggregates net required impairment reserves:
$$\text{Required Reserve} = \sum_{k=1}^{5} \left( \text{Outstanding Balance}_k \times \text{Provision Rate}_k \right)$$
$$\Delta \text{Provision} = \text{Required Reserve} - \text{Existing Balance in Allowance Account}$$
The system automatically generates the general ledger journal entry:
- Debit: Loan Impairment Expense (
510300) - Credit: Allowance for Loan Losses (
110900, Contra-Asset) This ensures financial statements comply fully with NBE and IFRS 9 expected credit loss standards.
4. Advanced Configuration Points#
- Automated Actions & Scheduled Tasks (Crons):
SACCO: Accrue monthly member savings interest(smarterp_sacco.ir_cron_savings_interest): Runs on the final day of each calendar month to credit interestLoan: Evaluate 5-tier NBE delinquency classification(smarterp_sacco.ir_cron_loan_delinquency): Runs nightly to compute loan loss provisions per NBE directivesEqub: Execute scheduled lottery draw(smarterp_sacco.ir_cron_equb_draw): Runs on defined pool cycle dates using provably fair random selection
- Custom Print Templates & Reports:
- Member Savings Passbook & Transaction Ledger
- Loan Amortization Schedule (Reducing Balance)
- NBE 5-Tier Delinquency & Loan Loss Provisioning Statement
- Annual Patronage Dividend Distribution Schedule
- Multi-Company Rules: Record-level security isolation under Company 1 (
Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.
5. Comprehensive Troubleshooting Matrix#
| Error Symptom / Exception | Probable Root Cause | Corrective Action / Resolution |
|---|---|---|
Loan Blocked: Exceeds 3x savings ceiling | Requested loan principal exceeds 300% of member unencumbered savings balance. | Increase compulsory savings deposit or provide authorized co-signers with sufficient collateral. |
Equb Draw Blocked: Participant arrears detected | Selected Equb member has unpaid rotational dues in current or prior cycles. | Collect outstanding contribution payment before executing lottery draw. |
Share Capital Limit Error: Member exceeds 10% ceiling | Subscribed shares exceed statutory maximum under Proclamation No. 985/2016. | Restrict share allocation to maximum allowable 10% total cooperative equity threshold. |