Accounting Software for Private Foundations (2026)

How foundation accounting differs

Private foundations operate under a different regulatory framework than public charities. A public charity’s main compliance obligation is filing Form 990. Foundations face excise taxes, distribution requirements, and prohibited transaction rules that their accounting system must track.

The 5% distribution requirement

Every year, a private foundation must distribute at least 5% of its average net investment assets for charitable purposes. This calculation requires accurate investment accounting throughout the year, not just at year-end.

The 5% includes grants made, direct charitable activities, reasonable administrative expenses (with limitations), and certain set-asides for future charitable projects. It does not include investment management fees or non-charitable operating expenses.

Foundations that fall short of the 5% threshold face a 30% excise tax on the undistributed amount. A second-tier penalty of 100% applies if the deficiency isn’t corrected within a specified period.

Accounting software must track the rolling average of net investment assets, calculate the distribution requirement, and monitor progress throughout the year.

Investment accounting

Most private foundations maintain endowed investment portfolios. The accounting system must track cost basis, unrealized gains and losses, dividend and interest income, and fair market value. For foundations with diversified portfolios across multiple asset classes, the tracking is complex.

Investment income is subject to a 1.39% excise tax (reduced from the previous 2% rate). The accounting system should calculate and track this tax liability.

Grant-making workflows

Foundations make grants. The accounting system must track each grant from approval through payment, including:

• Board authorization and due diligence documentation
• Grant agreement terms and conditions
• Payment schedules (many grants are paid in installments)
• Grantee reporting requirements and compliance
• Expenditure responsibility for grants to non-501(c)(3) organizations

For foundations making dozens of grants per year, manual tracking in spreadsheets becomes error-prone.

Form 990-PF

Form 990-PF differs from the standard Form 990. Key sections include:

Part I: Revenue and expenses, with separate columns for investment income, adjusted net income, and disbursements for charitable purposes.

Part II: Balance sheet with fair market value requirements for investments.

Part XI: Minimum investment return calculation.

Part XII: Qualifying distributions and distribution requirement compliance.

Part XV: Grant listing with recipient name, address, purpose, and amount for every grant made during the year.

Self-dealing rules

IRC Section 4941 prohibits most transactions between a private foundation and its substantial contributors, managers, and their family members. The accounting system should flag transactions involving disqualified persons. Violations trigger a 10% excise tax (25% for foundation managers), with second-tier penalties of 200%.

Software considerations

Most nonprofit accounting tools are designed for public charities, not private foundations. Key features to look for: investment accounting with fair market value tracking, distribution requirement calculation, grant-making workflow management, and Form 990-PF support.

RestrictedBooks includes foundation-specific fund tracking and Form 990-PF mapping at $20-$99/month. For foundations managing the interplay between investment accounting, distribution requirements, and grant-making, purpose-built software eliminates the spreadsheet gymnastics that QuickBooks requires.