SmartERP Documentation An Ashewa Technology Solutions Platform

Security Governance & Internal Audit Controls

Core banking security policies, maker-checker authorization gates, four-eyes principles, and tamper-evident audit trails.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Security Governance & Internal Audit Controls within SmartERP.

SACCO membership on-boarding, share capital subscription, savings accumulation, and patronage dividend distribution.
SACCO member capital formation, savings operations, and annual patronage dividend lifecycle.

Core banking security policies, maker-checker authorization gates, four-eyes principles, and tamper-evident audit trails.

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#

  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. 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.

Four-Eyes Principle & Maker-Checker Governance#

To safeguard member funds and prevent internal embezzlement, SmartERP enforces the Four-Eyes Principle (Maker-Checker) across all high-risk transactions:

  • Loan Approvals: The loan appraisal officer (Maker) cannot approve the loan; approval requires independent review by the Branch Manager or Committee (Checker).
  • Vault Cash Transfers: The teller initiating a cash transfer cannot confirm receipt; the Chief Cashier must authenticate via separate credentials.
  • Journal Entries & Write-Offs: Loan write-offs or manual general ledger adjustments mandate dual sign-offs from the Chief Accountant and General Manager.

Role-Based Access Control Matrix#

RoleMember KYCSavings DepositsLoan AppraisalLoan ApprovalVault TransfersAudit Logs
TellerReadRead/WriteNoneNoneRequest OnlyNone
Credit OfficerRead/WriteReadRead/WriteNoneNoneNone
Branch ManagerFullReadReadApprove ($\le 100k$)ApproveRead
Chief CashierReadReadNoneNoneFull ControlNone
Internal AuditorRead (All)Read (All)Read (All)NoneNoneFull Audit (All)

Tamper-Evident Transaction Logging#

All balance-affecting transactions write to an immutable append-only ledger (sacco.transaction.audit):

  • Every record captures SHA-256 hash chaining connecting back to the genesis transaction.
  • Direct database UPDATE or DELETE SQL queries against balance tables are programmatically blocked by PostgreSQL triggers.

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#

Error Symptom / ExceptionProbable Root CauseCorrective Action / Resolution
Loan Blocked: Exceeds 3x savings ceilingRequested 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 detectedSelected 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% ceilingSubscribed shares exceed statutory maximum under Proclamation No. 985/2016.Restrict share allocation to maximum allowable 10% total cooperative equity threshold.
Last updated: 2026-11-15