ECC & NBE Statutory Financial Reporting

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for ECC & NBE Statutory Financial Reporting within SmartERP.

Generate mandatory quarterly balance sheets, capital adequacy ratios, liquidity reserve monitoring, and statutory audit schedules.

{screenshot:ecc-and-nbe-statutory-financial-reports-overview-dashboard}

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 Module Interface#

1. Log into your SmartERP instance at https://smarterp.et/odoo.
2. Open the main App Switcher (grid icon in the top-left corner).
3. Select the SACCO & Equb app icon.
4. From the top navigation bar, open SACCO & Equb → Members → KYC Registry / Savings Accounts / Loan Applications / Equb Pools.

{screenshot:ecc-and-nbe-statutory-financial-reports-app-switcher-navigation}

Step 2: Creating and Parameterizing Records#

1. Click the New button in the top-left control panel.
2. Complete the mandatory fields in the record form:
   • Member Identification Number (Mandatory): Unique membership number complying with Ethiopian Cooperative Commission rules
   • Full Name & Kebele ID (Mandatory): Verified member identity with physical residence verification
   • Share Capital Subscriptions (Mandatory): Subscribed shares not exceeding statutory 10% member ceiling (Proclamation 985/2016)
   • Primary Savings Product (Mandatory): Compulsory regular monthly savings account configuration
3. Configure optional operational parameters and localized tags as required:
   • Guarantor & Collateral (Optional): Approved co-signers with locked savings accounts or registered vehicle/property lien
   • Equb Rotational Group (Optional): Linked digital Equb pool with lottery draw eligibility
   • Beneficiary Nominee (Optional): Designated next of kin for death or disability benefit transfer
4. Click the Save icon in the control bar to commit the record.

{screenshot:ecc-and-nbe-statutory-financial-reports-record-creation-form}

Step 3: Validating and Processing Transactions#

• State Transitions: Execute operational state progression (Application → KYC Verified → Approved → Active / Disbursed → Delinquency Monitored → Settled).
• Ledger & System Impact: Loan disbursement debits loans receivable and credits cash/bank; loan repayments credit interest income and loan principal, updating 5-tier NBE provisioning registers.
• Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.

{screenshot:ecc-and-nbe-statutory-financial-reports-transaction-processing-state}

Regulatory Reporting Framework#

Savings and Credit Cooperatives must submit quarterly and annual compliance returns to the Ethiopian Cooperative Commission (ECC) and the National Bank of Ethiopia (NBE). SmartERP generates these statutory reports directly from verified general ledger transactions:

1. ECC Quarterly Financial Statement Returns#

• Comparative Balance Sheet: Member shares, statutory reserves, savings liabilities, and loan portfolio assets.
• Statement of Comprehensive Income: Loan interest revenues, operational expenses, loan loss provisions, and net surplus.
• Portfolio-at-Risk (PAR) Summary: PAR-30, PAR-60, and PAR-90 ratios tracking delinquent portfolio percentages.

2. NBE Prudential Ratios Monitoring#

SmartERP continuously monitors key prudential ratios:

• Capital Adequacy Ratio (CAR): $$\text{CAR} = \frac{\text{Institutional Capital (Reserves + Retained Earnings)}}{\text{Total Risk-Weighted Assets}} \ge 12.0\%$$
• Liquidity Ratio: $$\text{Liquidity} = \frac{\text{Cash on Hand + Bank Balances + Treasury T-Bills}}{\text{Total Short-Term Savings Liabilities}} \ge 15.0\%$$

If liquidity drops below 15%, the system triggers an urgent executive alert to restrict new loan disbursements until liquidity buffers are replenished.

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 interest
  • Loan: Evaluate 5-tier NBE delinquency classification (smarterp_sacco.ir_cron_loan_delinquency): Runs nightly to compute loan loss provisions per NBE directives
  • Equb: 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#