NGO Grant Data Model & Fund Ledger Architecture
Technical specifications of database models, grant agreements, budget line tables, and restricted fund accounting relationships.
1. Overview & Business Value#
This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for NGO Grant Data Model & Fund Ledger Architecture within SmartERP.

Technical specifications of database models, grant agreements, budget line tables, and restricted fund accounting relationships.
2. Prerequisites & Security Access Groups#
- Required Modules:
smarterp_ngo_grants, smarterp_humanitarian, smarterp_fund_accounting - Security Groups:
Grant Officer(Technical ID:smarterp_ngo.group_grant_user)Finance Director (NGO)(Technical ID:smarterp_ngo.group_grant_manager)Field Relief Distribution Officer(Technical ID:smarterp_ngo.group_field_officer)
- Master Data Dependencies: Donor profiles (USAID, EU, UN, FCDO), multi-currency grant agreements, restricted fund accounts, ACSO 80/20 cost allocation categories, and beneficiary rosters.
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 Grants → Active Grants.
Step 2: Operational Data Parameters & Controls#
Ensure all mandatory parameters comply with enterprise operational standards:
- Authorized Operator: Action executed under assigned RBAC permissions (Country Director, Grant Manager, Compliance Officer, M&E Specialist).
- 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.
Relational Entity Architecture#
SmartERP NGO Grants connects donor profiles, grant agreements, WBS activities, budget burn ledgers, and beneficiary registries into an ACID-compliant schema:

Core Model Specifications#
1. Donor Grant: ngo.grant#
Maintains the institutional grant contract:
name(Char): Contract title.donor_id(Many2one->res.partner): Institutional donor.grant_code(Char, unique, index): Contract number.currency_id(Many2one->res.currency): Base donor currency (USD, EUR).total_grant_amount(Monetary),local_currency_amount(Monetary).start_date(Date),end_date(Date).state(Selection):draft,active,suspended,closed.
2. ACSO Budget Line: ngo.budget.line#
Governs budget burn and statutory tagging:
grant_id(Many2one->ngo.grant, ondelete="cascade").project_id(Many2one->project.project).acso_category(Selection):program_80,admin_20.budget_amount(Monetary),committed_amount(Monetary),spent_amount(Monetary).available_balance(Monetary, computed).
3. Beneficiary Master: ngo.beneficiary#
Maintains household relief profiles:
name(Char),national_id(Char, index).woreda_id(Many2one->res.country.state).vulnerability_score(Float).aid_type(Selection):in_kind_food,cva_cash,livelihood_grant.
4. Aid Distribution: ngo.distribution#
Tracks physical and cash aid deliveries:
beneficiary_id(Many2one->ngo.beneficiary).siv_voucher_id(Many2one->stock.picking): Model 20 SIV.cash_transfer_ref(Char): Telebirr transaction ID.distribution_date(Datetime).
4. Advanced Configuration Points#
- Automated Actions & Scheduled Tasks (Crons):
NGO: Calculate ACSO 80/20 cost ratio compliance(smarterp_ngo.ir_cron_acso_ratio): Runs weekly to flag any operational overhead drift above 20% limitGrants: Reconcile foreign currency funding variance(smarterp_ngo.ir_cron_fx_reconcile): Runs monthly to revalue restricted foreign currency bank accounts
- Custom Print Templates & Reports:
- ACSO Statutory Annual Financial Statement (80/20 Rule)
- Donor Financial Expenditure Report (Multi-Currency)
- Beneficiary Relief Distribution Voucher (Model 20 SIV)
- Time-and-Effort Personnel Timesheet Allocation Summary
- 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 |
|---|---|---|
ACSO 80/20 Violation Block: Administrative overhead exceeds 20% | Cumulative overhead costs exceed statutory ceiling established under Proclamation No. 1113/2019. | Reclassify direct project support expenses to program operational accounts or restrict general administrative spending. |
Budget Burn Halt: Grant line item allocation exhausted | Committed purchase or payroll expense exceeds approved donor line envelope. | Submit a formal grant budget reallocation or amendment request to the donor. |
Duplicate Beneficiary Error: ID already claimed in cycle | National ID or biometric record already logged for current distribution cycle. | Audit beneficiary registration records and confirm identity against Kebele verification list. |