Documentation Index
Fetch the complete documentation index at: https://docs.encoreos.io/llms.txt
Use this file to discover all available pages before exploring further.
Version: 1.0.0
Last Updated: 2026-01-11
Module: Finance & Accounting
Prefix:fa_
Tables: 45
Changelog
- 1.0.0 (2026-01-11): Initial ERD documentation
Overview
The Finance & Accounting module provides nonprofit fund accounting capabilities including general ledger, accounts receivable, accounts payable, budgeting, and financial reporting.Chart of Accounts ERD
Journal Entries ERD
Accounts Receivable ERD
Accounts Payable ERD
Budgeting ERD
Banking ERD
RLS Policy Coverage
| Table | SELECT | INSERT | UPDATE | DELETE | WITH CHECK | Status |
|---|---|---|---|---|---|---|
| fa_accounts | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| fa_funds | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| fa_journal_entries | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| fa_journal_entry_lines | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| fa_invoices | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| fa_customers | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| fa_bills | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| fa_vendors | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| fa_budgets | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
| fa_bank_accounts | ✅ | ✅ | ✅ | ✅ | ✅ | Complete |
Key Tables
fa_accounts
Chart of accounts with hierarchical structure and fund accounting support.fa_journal_entries
Double-entry journal entries with multi-dimensional posting (fund, department, program).fa_invoices
Customer invoices for accounts receivable management.fa_bills
Vendor bills for accounts payable management.fa_budgets
Annual/project budgets with version control and approval workflow.Helper Functions
| Function | Purpose |
|---|---|
fa_has_org_access(org_id, user_id) | Check FA module access |
fa_get_account_balance(account_id, as_of_date) | Calculate account balance |
fa_get_budget_variance(budget_id, period_id) | Calculate budget vs actual |
fa_post_journal_entry(entry_id) | Post entry and update balances |
Cross-Module Dependencies
- PF: Organizations, profiles, departments
- HR: Payroll journal entries, expense reports
- RH: Resident billing, charge posting
- FM: Asset depreciation, maintenance costs