Finance AI Skill

Fund Accounting Nonprofit

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

Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.