--- name: fund-accounting-nonprofit description: Manage fund accounting for nonprofits and foundations including restricted/unrestricted net assets, grant management, program vs administrative expense allocation, donor restrictions tracking, and FASB compliance. Use when setting up nonprofit financial systems, managing restricted funds, allocating expenses across programs, tracking grant compliance, preparing nonprofit financial statements, or handling donor-restricted contributions. Triggers on phrases like "fund accounting", "nonprofit accounting", "restricted funds", "grant management", "donor restrictions", "program allocation", "functional expense allocation", "unrestricted net assets", "board-designated reserves", "FASB nonprofit". --- # Fund Accounting & Nonprofit Financial Management Manage multi-fund accounting structures to track restricted and unrestricted resources, ensure grant compliance, and report transparently on mission-driven financial activities. ## Workflow ### 1. Fund Structure Design ``` NONPROFIT FUND ACCOUNTING STRUCTURE ═══════════════════════════════════════ CLASSIFICATION (per FASB ASC 958): 1. WITHOUT DONOR RESTRICTIONS (Unrestricted) ├─ General Operating Fund │ ├─ Unrestricted contributions │ ├─ Investment income (unrestricted) │ └─ Board-designated reserves │ ├─ Reserve for contingencies │ ├─ Reserve for capital projects │ └─ Reserve for endowment spending │ └─ Temporarily Restricted (released upon fulfillment) ├→ Programs: Education (restriction: program purpose) ├→ Programs: Community Outreach └→ Programs: Research (release to unrestricted when restriction met) 2. WITH DONOR RESTRICTIONS ├─ Temporarily Restricted │ ├─ Grant #2024-001: Youth Education (expires 12/2025) │ ├─ Gift from Smith Foundation: Capital Project (use restriction) │ └→ Releases to unrestricted when time/purpose satisfied │ └─ Permanently Restricted (Endowment) ├─ Board-established endowment ├─ Donor-permanent endowment └→ Investment principal maintained; spending = return only (spending rate typically 4-5% per UPMIFA guidelines) SUB-FUNDS BY GRANT/RESTRICITION: Each restricted grant gets its own sub-fund for tracking: → Sub-fund ID: GRANT-2024-001 → Donor: Dept of Education → Purpose: STEM education in underserved communities → Allowable expenses: program activities, personnel (60%), admin (max 10%) → Period: 1/1/2024 – 12/31/2025 → Total award: $500,000 → Drawn to date: $187,500 → Balance: $312,500 ``` ### 2. Contribution Recording & Classification ``` CONTRIBUTION RECORDING PROCESS ═══════════════════════════════════════ Upon receiving contribution: STEP 1: Classify the contribution □ Unrestricted — donor placed no restrictions □ Temporarily restricted by purpose (must be used for specific program) □ Temporarily restricted by time (cannot be used until future date) □ Permanently restricted (endowment — principal preserved forever) STEP 2: Record the contribution Dr Cash / Receivable $X Cr Contribution Revenue — [Class] $X STEP 3: Track restriction details → Donor name and contact → Restriction type and terms → Reporting requirements → Deadline for use → Allowable vs non-allowable expenses → Matching requirements (if any) STEP 4: Set up monitoring → Budget tracking for restricted funds → Expense allocation rules → Deadline alerts for time restrictions → Reporting schedule for donor ``` ### 3. Functional Expense Allocation ``` FUNCTIONAL EXPENSE ALLOCATION MATRIX ═══════════════════════════════════════ Required by FASB ASC 958 for nonprofit financial statement presentation: Expenses must be classified by function (not just natural expense type). FUNCTIONS: 1. Program Services (mission activities) ├─ Education Programs ├─ Community Services └─ Research 2. Supporting Services ├─ Management & General (administration) ├─ Fundraising └─ Development ALLOCATION METHODOLOGY: Method 1: Direct Allocation (preferred when possible) → Expenses directly traceable to a function → Example: Program director salary → Education Programs → Example: Event costs for gala → Fundraising Method 2: Activity-Based Allocation (time-and-effort) → Shared expenses allocated based on time spent → Require time studies or activity logs → Example: Executive Director spends 60% program, 25% admin, 15% fundraising → Salary allocated 60/25/15 across functions Method 3: Revenue-Based Allocation → Allocate based on proportion of revenue generated → Example: IT costs allocated based on program revenue share → Less preferred; use only when time study impractical Method 4: Headcount-Based Allocation → Allocate based on number of employees per function → Example: HR costs allocated by FTE count ALLOCATION WORKSHEET (Monthly): ═══════════════════════════════════════ Natural Expense Total Education Community Research Admin Fundraising ───────────────────────────────────────────────────────────────────────────────── Salaries $500,000 $200,000 $150,000 $75,000 $50,000 $25,000 Benefits $150,000 $60,000 $45,000 $22,500 $15,000 $7,500 Office Rent $60,000 $24,000 $18,000 $9,000 $6,000 $3,000 Professional Fees $40,000 $10,000 $10,000 $5,000 $10,000 $5,000 Fundraising Events $30,000 $0 $0 $0 $0 $30,000 ───────────────────────────────────────────────────────────────────────────────── TOTAL $780,000 $294,000 $223,000 $111,500 $81,000 $70,500 (37.7%) (28.6%) (14.3%) (10.4%) (9.0%) RATIO ANALYSIS: Program Services %: ($294K + $223K + $111.5K) / $780K = 80.6% Admin %: 10.4% Fundraising %: 9.0% INDUSTRY BENCHMARKS (Independent Sector / BBB Wise Giving Alliance): → Program services: Target >65% (organization at 80.6% ✓) → Administrative: Target <15% (organization at 10.4% ✓) → Fundraising: Target <25% (organization at 9.0% ✓) → Overall efficiency ratio: 80.6% program spend ✓ ``` ### 4. Grant Management & Compliance ``` GRANT COMPLIANCE TRACKING ═══════════════════════════════════════ GRANT DASHBOARD: ═══════════════════════════════════════ Grant ID: GRANT-2024-001 Donor: Department of Education Award Amount: $500,000 Period: January 2024 – December 2025 BUDGET vs ACTUAL (by category): Category Budget Actual Remaining % Used Alert? ────────────────────────────────────────────────────────────────────── Personnel $300,000 $112,500 $187,500 37.5% — Supplies/Equipment $50,000 $18,200 $31,800 36.4% — Travel $25,000 $8,800 $16,200 35.2% — Subcontracts $75,000 $28,000 $47,000 37.3% — Program Materials $30,000 $12,000 $18,000 40.0% — Administrative (max 10%) $25,000 $5,000 $20,000 20.0% — Contingency $25,000 $0 $25,000 0.0% — ────────────────────────────────────────────────────────────────────── TOTAL $500,000 $184,500 $315,500 36.9% COMPLIANCE CHECKLIST: □ Spending within budget categories? YES (all categories within budget) □ Administrative < 10%? YES (2.7% of grant total) □ On track for full expenditure by end date? YES (36.9% used in 36.9% of time) □ Quarterly reports submitted on time? YES (Q1, Q2 submitted) □ Allowed activities only? YES (verified against grant terms) □ Matching funds documented? YES ($50K match from foundation) □ Audit trail complete? YES (all expenses documented) REPORTING SCHEDULE: → Quarterly narrative report: Due Jan 31, Apr 30, Jul 31, Oct 31 → Annual financial report: Due 60 days after grant year end → Final report: Due 90 days after grant end date → Financial audit: Required (independent auditor per grant terms) ``` ### 5. Endowment Management ``` ENDOWMENT ACCOUNTING (per FASB ASC 958) ═══════════════════════════════════════ ENDOWMENT ROLLFORWARD: ═══════════════════════════════════════ Permanently Temporarily Total Restricted Restricted Balance, Jan 1 $2,000,000 $500,000 $2,500,000 Investment returns: Realized gains $80,000 $20,000 $100,000 Unrealized gains $120,000 $30,000 $150,000 Investment expenses ($8,000) ($2,000) ($10,000) Net investment return $192,000 $48,000 $240,000 Contributions: New permanent gifts $250,000 $0 $250,000 New temporary gifts $0 $100,000 $100,000 Spending: Board-approved spending rate: 4.5% of 12-month average market value Amount spent: ($90,000) $0 ($90,000) (from temporarily restricted portion of permanent endowment) Reclassifications: Released from restrictions: $0 ($90,000) $0 (permanently restricted return → temporarily restricted → spent) Balance, Dec 31 $2,432,000 $558,000 $2,990,000 SPENDING POLICY REVIEW: → Market value (12-month avg): $2,000,000 → Approved spending rate: 4.5% → Amount available to spend: $90,000 → UPMIFA safe harbor: 5% or state statute rate (whichever lower) → Organization within safe harbor? YES (4.5% < 5%) → Purpose aligned with donor intent? YES (education programs) → Principal maintained at or above original? YES ($2.43M > $2.0M) PRUDENT INVESTMENT REVIEW: → Diversification: YES (multi-asset class portfolio) → Risk-adjusted returns: 9.6% return (vs S&P 500 12.1%) → Investment fees: 0.43% (target <0.50%) ✓ → Rebalance frequency: Annual (within policy guidelines) → ESG alignment: YES (aligned with nonprofit mission) ``` ### 6. Financial Reporting for Nonprofits ``` NONPROFIT FINANCIAL STATEMENT REQUIREMENTS ═══════════════════════════════════════ Required statements (FASB ASC 958): 1. STATEMENT OF FINANCIAL POSITION (Balance Sheet) → Assets (current and non-current) → Liabilities (current and non-current) → Net Assets (without donor restrictions, with donor restrictions) → Endowment breakdown (board-established vs donor-restricted) 2. STATEMENT OF ACTIVITY (Income Statement) → Revenues by class (contributions, grants, program revenue, investment) → Expenses by function (program services, management/general, fundraising) → Net assets without donor restrictions → Net assets with donor restrictions → Changes in restrictions (added, released) 3. STATEMENT OF CASH FLOWS → Operating, investing, financing activities → Non-cash investing and financing activities disclosure 4. STATEMENT OF FUNCTIONAL EXPENSES → Matrix showing natural expenses cross-tabulated with functions 5. NOTES TO FINANCIAL STATEMENTS → Summary of significant accounting policies → Detail of restricted net assets by restriction type → Endowment composition and spending policy → Contingencies and commitments → Related-party transactions → Liquidity and availability of financial resources ``` ## Edge Cases - **Related-party transactions**: Board members, major donors, affiliated entities; require full disclosure and arm's-length assessment - **In-kind contributions**: Valuate at fair value using FASB ASC 958 guidance; document valuation methodology - **Promised contributions (pledges)**: Record at present value if collection is probable and measurable; track collection status - **Multi-year grants**: Track spending against annual budgets; monitor for under-spend risks (may need to return unused funds) - **Board-designated vs donor-restricted**: Board can designate unrestricted funds internally but cannot create donor restrictions - **Dissolution clauses**: What happens to restricted assets if nonprofit dissolves? Track and disclose ## Integration Points - **Nonprofit ERP**: Blackbaud, QuickBooks Nonprofit, Sage Intacct, NetSuite - **Grant management**: GrantmakeR, Catalant, Submittable - **Donor management**: Raiser's Edge, NeonCRM, Kindful - **Accounting platforms**: Adaptive Financials, FinanceTrack - **Audit platforms**: Workiva, AuditBoard - **Reporting**: Candid (GuideStar), BBB Wise Giving Alliance ## Output ### Nonprofit Financial Summary ``` NONPROFIT FINANCIAL SUMMARY — Q3 2024 ═══════════════════════════════════════ NET ASSETS: Without donor restrictions: $3,200,000 With donor restrictions: $850,000 Total: $4,050,000 REVENUE (YTD): Unrestricted contributions: $680,000 Restricted grants: $420,000 Program revenue: $150,000 Investment income: $72,000 Total: $1,322,000 EXPENSES BY FUNCTION (YTD): Program services: $1,020,000 (77.5%) ✓ Management & General: $180,000 (13.6%) ✓ Fundraising: $120,000 (9.1%) ✓ Total: $1,320,000 EFFICIENCY METRICS: Program ratio: 77.5% (benchmark: >65%) Admin ratio: 13.6% (benchmark: <15%) Fundraising ratio: 9.1% (benchmark: <25%) Cost to raise $1: $0.13 (industry avg: $0.25) GRANT COMPLIANCE: Active grants: 8 On-budget: 7/8 Reports submitted on time: 9/10 (90%) Flags: GRANT-2024-003 underspent by 15% ENDOWMENT: Market value: $2,990,000 YTD return: +9.6% Spending rate: 4.5% Principal maintained: YES ```