Skip to main content

Accounting Software for Private Foundations (2026)

Last updated: March 20, 2026

TLDR

Private foundations have accounting needs distinct from public charities. They must track investment portfolios, grants-out to other organizations, mandatory distribution requirements (5% minimum payout), and Form 990-PF reporting. General nonprofit accounting software built for public charities often doesn't handle these requirements well.

How private foundation accounting differs from public charity accounting

Public charities earn program revenue and receive restricted grants. Private foundations hold investment assets and make grants out. The accounting model is nearly the opposite.

Most nonprofit accounting software is designed for the public charity model. The fund structure, reporting templates, and workflow assumptions all point toward tracking incoming restricted funds and spending them on programs. A private foundation accountant using software designed for a community service organization will find the tool misaligned with their actual work.

Investment accounting requirements

The primary asset of most private foundations is an investment portfolio. The accounting system needs to track:

  • Beginning and ending market values by investment type
  • Realized and unrealized gains and losses
  • Investment income (dividends, interest) by period
  • Investment management fees (relevant to excise tax calculations)

Form 990-PF Schedule B requires a list of investment holdings over $5,000 or 5% of total assets. Without a structured investment ledger, assembling this schedule requires pulling data from brokerage statements and reconciling manually — a time-consuming process that introduces transcription errors.

Grants-out tracking

Unlike public charities that receive grants, private foundations make them. Each grant out requires tracking:

  • Grantee organization name and EIN
  • Grant purpose and any attached restrictions
  • Approved amount and payment schedule
  • Payments made and outstanding balance
  • Reports received from grantee (if required)

This is a distinct workflow from accounts payable. Grants span multiple periods, may have multi-installment payment schedules, and require purpose documentation that standard AP systems don’t capture.

Mandatory distribution calculation

Private foundations must distribute at least 5% of the average fair market value of non-charitable-use assets annually. Failing this requirement triggers excise taxes. Calculating the minimum distribution requires accurate asset valuations throughout the year and a clear picture of qualifying distributions already made.

Most accounting software doesn’t perform this calculation automatically. Foundations track it manually or in spreadsheets alongside their accounting system — a workaround that introduces the risk of errors in a calculation with tax consequences.

Form 990-PF complexity

The 990-PF is substantially more detailed than Form 990. It includes investment income schedules, a list of all grants made, officer and director compensation detail, and excise tax calculations. Foundations relying on software that doesn’t produce these schedules natively spend considerable CPA time assembling supporting documentation at year-end.

Software that handles these requirements

Smaller family foundations often start with QuickBooks or Aplos and supplement with spreadsheets for investment tracking and distribution calculations. This works at low grantmaking volume but doesn’t scale well.

Sage Intacct handles investment accounting and 990-PF reporting at the enterprise level but starts at $1,000-$5,000/month — out of reach for most family foundations.

RestrictedBooks ($20-$99/month) offers fund separation and restricted grant tracking at a price point accessible to mid-sized family foundations. For foundations with significant investment complexity, consult with a nonprofit CPA on whether the accounting system needs investment module functionality.

Q&A

What accounting software do private foundations use?

Larger private foundations typically use Sage Intacct or Blackbaud Financial Edge NXT for their investment tracking and reporting depth. Mid-sized foundations often use QuickBooks with significant manual workarounds or purpose-built tools like Aplos. Smaller family foundations sometimes rely on spreadsheets, which creates compliance risk around mandatory distribution tracking. The right choice depends on asset size, grantmaking volume, and whether the foundation has staff accountants or relies on outside CPAs.

Q&A

How is private foundation accounting different from public charity accounting?

Public charities track program revenue, grants-in, and program expenses. Private foundations primarily manage investment assets and make grants out to other organizations. This inverts the typical nonprofit accounting model. Instead of tracking restricted grants received, foundations track restricted grants given. Instead of program revenue, the main income line is investment return. Form 990-PF captures these distinctions and requires significantly more detail than Form 990 — including a list of all grants made, investment holdings, and officer compensation.

Accounting software built for Private Foundations organizations

RestrictedBooks handles fund accounting, restricted donations, and Form 990 prep at $99–$249/month.

What Makes Private Foundations Accounting Different

  • Investment portfolio tracking and return attribution
  • Grants-out management with purpose restrictions
  • Minimum distribution calculation (5% of net investment assets)
  • Form 990-PF reporting (distinct from standard Form 990)
  • Excise tax compliance on investment income
  • Jeopardizing investment tracking for self-dealing rules

Estimated private foundations organizations in the US: 110,000+

Compliance Considerations

Private foundations are subject to excise taxes on investment income (typically 1.39%), mandatory distribution requirements (must pay out at least 5% of net investment assets annually), and strict self-dealing rules. Form 990-PF is required annually and is far more detailed than the public charity Form 990. Foundations with assets over $10M face additional reporting. The IRS Pension Protection Act of 2006 imposed automatic revocation of exemption for organizations that fail to file for 3 consecutive years.

Does a private foundation need fund accounting software?
A private foundation with significant grantmaking activity needs at minimum a system that tracks grants out by purpose, grantee, and payment status. For foundations with multiple program areas or restricted endowments, full fund accounting adds value by maintaining clear separation between investment assets, distributable amounts, and program funds. Foundations that rely on spreadsheets often struggle to calculate mandatory distribution requirements accurately and produce Form 990-PF schedules under audit pressure.
What is Form 990-PF and how does it differ from Form 990?
Form 990-PF is the annual information return filed by private foundations. It requires disclosure of investment holdings, all grants made (with grantee names, amounts, and purposes), officer and director compensation, and excise tax calculations on net investment income. The standard Form 990 filed by public charities covers program activities, revenue, and expenses but doesn't include the investment schedule and distribution calculation that 990-PF requires. The two forms are not interchangeable — a private foundation filing Form 990 instead of 990-PF is non-compliant.
How do private foundations track grant distributions?
Grant distribution tracking requires recording each grant with the grantee organization, grant purpose, approved amount, payment schedule, and any reporting requirements attached. The accounting system needs to maintain outstanding grant liabilities (approved but unpaid), record payments against those liabilities, and report total distributions for mandatory payout calculations. Foundations making dozens of grants per year need this structured — spreadsheet tracking breaks down when payments span multiple fiscal years or grants have multi-year terms.

Ready to simplify accounting for your private foundations?

Keep reading