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 sys...

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