Hello Frappe Community,
We are implementing ERPNext for a public / donor-funded education institution that requires compliance with IPSAS (International Public Sector Accounting Standards).
We understand that IPSAS is a set of accounting standards rather than a software feature, and that compliance is achieved through proper configuration, controls, and reporting. However, we would like guidance on best practices and existing ERPNext capabilities for this use case.
Our key requirements are:
1. Fund Accounting
- Ability to track income, expenses, assets, and liabilities by Fund (e.g. Tuition Fund, Government Grant Fund, Donor Fund)
- Clear segregation of balances per fund
- Fund-level reporting (surplus/deficit per fund)
We are considering using Accounting Dimensions for this, but would like confirmation if this is the recommended approach.
2. IPSAS-aligned Chart of Accounts
- Replacement of the default IFRS/SME-oriented CoA with an IPSAS-style CoA
- Use of Net Assets instead of Equity
- Surplus / Deficit instead of Profit / Loss
- Proper classification of public sector assets and liabilities
Are there any community-maintained IPSAS CoA templates available, or recommended approaches for building one?
3. Budgeting and Budget Control
- Budget approval per Fund and Cost Center
- Enforcement to prevent posting transactions that exceed approved budgets
- Budget vs Actual reporting in an IPSAS context
4. Asset Management
- Capitalization of assets acquired through grants
- Depreciation, revaluation, and disposal tracking
- Linking assets to funding sources (Funds)
5. IPSAS Financial Reports
We aim to generate IPSAS-style reports such as:
- Statement of Financial Position
- Statement of Financial Performance
- Statement of Changes in Net Assets
- Cash Flow Statement
- Budget vs Actual Statement
We assume these will require custom Script Reports and report formatting.
Our questions to the community:
- Has anyone successfully implemented IPSAS-compliant accounting using ERPNext?
- Is Accounting Dimensions the recommended way to implement Fund Accounting?
- Are there known gaps or pitfalls we should be aware of?
- Are there any existing apps, PRs, or community resources related to IPSAS or public sector accounting?
Any guidance, references, or real-world implementation experiences would be highly appreciated.
Thank you.