Nonprofit Accounting Software: What Fund Accounting Actually Requires

The IRS Form 990 Schedule D requires nonprofits to reconcile endowment fund balances line by line. FASB ASC 958-205 requires that restricted net assets be reported separately from unrestricted net assets on every Statement of Financial Position. The Federal single audit under 2 CFR Part 200 requires grant expenditures to be traceable by award. None of these requirements can be met by tagging QuickBooks transactions with a class label.

The gap between “we track grants in QuickBooks” and “we have fund accounting” is visible on the day of your first federal audit finding — and the remediation costs average $15,000–$50,000 per cycle. The purpose of this guide is to make that gap visible before the audit.

What Makes Accounting Software “Nonprofit” (vs. General-Purpose)

The word “nonprofit” in software marketing often means the vendor has added a donation intake screen or configured default chart of accounts with program expense categories. QuickBooks, for instance, offers a “nonprofit” chart of accounts template that still uses a single-entity general ledger — no fund architecture, no FASB ASC 958-compliant net asset classes. That is not fund accounting.

True nonprofit accounting software is built around a fund-based ledger architecture. Each restricted fund — a federal grant, a capital campaign, an endowment tranche — is maintained as a self-balancing set of accounts with its own assets, liabilities, revenues, and expenses. The software enforces balance integrity at the fund level, meaning you cannot inadvertently overspend a restricted fund without an explicit journal entry that flags the exception.

FASB ASC 958, the primary accounting standard for nonprofits, requires that financial statements present net assets in two categories: with donor restrictions and without donor restrictions. This is not a labeling convention — it changes how revenue is recognized, how releases from restriction are recorded, and how financial statements are read. Software that cannot enforce this distinction natively forces your accountant to maintain a parallel reconciliation outside the system, which is exactly the kind of informal workaround that creates audit findings.

The four financial statements required under FASB ASC 958 — Statement of Financial Position, Statement of Activities, Statement of Functional Expenses, and Statement of Cash Flows — each present information in ways that have no direct for-profit equivalent. A software product built to produce a balance sheet and P&L for a business is not the same tool as one built to produce these four statements. The underlying data model is different.

Why QuickBooks Class Tracking Is Not Fund Accounting

QuickBooks Online supports up to 40 class tracking categories. That limit matters less than the fundamental architecture issue: class tracking assigns metadata to transactions, it does not create self-balancing funds.

When you tag a QuickBooks transaction with a grant-named class, the underlying ledger is still a single set of accounts. If you overspend a restricted grant, QuickBooks will not prevent it, flag it, or produce a meaningful report that isolates the overrun. You will discover the problem when you manually reconcile grant spending in Excel before the reporting deadline — if you discover it at all.

For organizations subject to the Federal single audit threshold ($1,000,000 in federal expenditures in a fiscal year (raised from $750,000 for fiscal years ending September 30, 2025 or later)), auditors test whether expenditures are traceable to specific awards under 2 CFR Part 200 Subpart F. Class tags are not the same as a fund-level audit trail. An auditor who asks for a Schedule of Expenditures of Federal Awards (SEFA) and receives a QuickBooks class report will probe further. Organizations that have received an audit finding for inadequate documentation of federal expenditures typically spend $15,000–$50,000 on remediation, corrective action plans, and repeat audits — multiples of what purpose-built software would have cost.

The indirect cost de minimis rate — 10% of Modified Total Direct Costs, available to any organization that has never had a negotiated indirect cost rate agreement — requires accurate MTDC calculation. MTDC excludes equipment over $5,000, capital expenditures, patient care charges, tuition remission, and the portion of each subaward over $25,000. QuickBooks cannot automate this calculation; fund accounting software built for federal grantees can.

The Five Capabilities That Matter for Grant-Heavy Organizations

1. Restricted fund-level financial statements. Your software must produce a Statement of Activities and Statement of Financial Position at the individual fund level, not just at the organization level. You need to show a funder, an auditor, or a board member exactly what was received and spent within a single grant — not a filtered class report that pulls transactions tagged with a label.

2. Net asset classification enforcement. The software must track net assets with donor restrictions and without donor restrictions as distinct ledger categories and correctly handle releases from restriction — the entry that moves dollars from restricted to unrestricted when a programmatic condition is met. Incorrect release-from-restriction entries are among the most common single audit findings.

3. Functional expense allocation. FASB ASC 958-720 requires nonprofits to present expenses by function — program services, management and general, and fundraising — and to disclose the basis of allocation. For staff whose time spans multiple functions, the allocation must be documented and consistently applied. Software that cannot allocate personnel costs by function forces manual spreadsheet work every reporting period.

4. Grant drawdown tracking. Federal grants paid through the Payment Management System (PMS) or HHS Payment Management System require organizations to draw down funds against an approved budget. Your software should show, for each award, the total awarded amount, cumulative drawdowns, cumulative expenditures, and remaining balance — in real time, not after a monthly close. Organizations that overdraw grants — spending more than they can justify — face repayment demands and suspension of future draws.

5. Auditor documentation output. When your auditor provides a Prepared by Client (PBC) list, your software should be able to produce each requested schedule without manual reconstruction. This means fund-level trial balances, detailed transaction listings by award, expenditure reports matching the grant budget line items, and support for the SEFA. If producing any of these requires manual Excel work, your accounting software has a compliance gap.

How to Evaluate Software: The Four Questions to Ask Before a Demo

Software demos are designed to show the product at its best. Most nonprofit accounting software evaluations run 60–90 minutes — not enough time to surface fundamental architectural gaps. These four questions surface the gaps vendors prefer not to demonstrate.

1. “Show me a restricted fund release from restriction, including the journal entry.” A vendor who cannot demo this in under five minutes either does not support the capability or has implemented it as a manual journal entry workaround rather than a native workflow. The release from restriction — the reclassification entry that moves dollars from “with donor restrictions” to “without donor restrictions” — is a core FASB ASC 958 workflow that should be native, not a workaround.

2. “How does the system calculate MTDC for indirect cost allocation, and can you show me a federal grant with MTDC-excluded line items?” If the vendor pivots to a general indirect cost discussion without engaging the MTDC calculation specifically, the system does not automate it.

3. “Export a Schedule of Expenditures of Federal Awards for a prior fiscal year.” If this requires custom report configuration, ask how long it takes and who configures it. If the answer is “your accountant or implementation consultant,” budget for that cost.

4. “What happens when I attempt to record an expenditure that would exceed a restricted fund’s balance?” A proper fund accounting system will warn you, require override authorization, or block the transaction. A system that silently allows the overage is not enforcing fund integrity — and a silent overage discovered during a single audit under 2 CFR Part 200 becomes a questioned cost.

When to Upgrade from QuickBooks or Similar

The trigger is not revenue size — it is grant complexity. A $400,000 organization managing three simultaneous federal awards has more fund accounting complexity than a $2,000,000 organization funded entirely by individual donations.

Five signals that your current system has become the risk:

Your auditor’s management letter has cited restricted fund tracking deficiencies in consecutive years. A management letter comment is a warning; a repeat comment is evidence of systemic weakness.

Your finance staff spends more than eight hours per month reconciling grant balances outside the accounting system. If the source of truth for grant balances is an Excel file, not the accounting system, the accounting system is not the system of record.

You cannot produce a fund-level income statement — revenue less expenses for a single grant — in under ten minutes without manual work. This is the baseline capability of any fund accounting platform.

You have a negotiated indirect cost rate agreement or are approaching the $1,000,000 federal expenditure threshold (raised from $750,000 for fiscal years ending September 30, 2025 or later) that triggers single audit requirements. Both situations require accounting documentation that general-purpose software cannot reliably produce.

You have received a corrective action plan from a cognizant federal agency or state awarding agency following an audit finding. At this point, the cost of the inadequate system has already been paid — the question is whether you will pay it again.

The transition cost for mid-market fund accounting software ranges from $8,000 to $30,000 in implementation and training, depending on organizational complexity and data migration volume. That is a one-time cost. The cost of an inadequate system compounds across every audit cycle, every federal reporting period, and every grant renewal conversation where your financial documentation is questioned.

For more on building a chart of accounts that supports restricted fund reporting, see Nonprofit Chart of Accounts for Restricted Funds. For a detailed comparison of QuickBooks class tracking against fund accounting principles, see Why QuickBooks Classes Are Not Fund Accounting. For a foundational overview of fund accounting concepts, see Fund Accounting for Nonprofits.

DEFINITION

Fund accounting

An accounting system in which resources are classified into funds — self-balancing sets of accounts — based on the restrictions placed on them by donors, grantors, or governing bodies. Each fund tracks its own assets, liabilities, and net assets independently, enabling nonprofits to demonstrate that restricted resources were used only for their designated purposes.

DEFINITION

Modified Total Direct Costs (MTDC)

The base used to calculate indirect cost rates under the de minimis provision of 2 CFR Part 200. MTDC includes direct salaries, wages, fringe benefits, materials, supplies, services, travel, and subawards up to $25,000 per subaward. It excludes equipment, capital expenditures, patient care, tuition remission, and subcontract amounts over $25,000.

DEFINITION

Net assets with donor restrictions

Resources whose use has been limited by donor stipulations — either for a specific purpose (purpose-restricted) or for use in a future period (time-restricted). Formerly called "temporarily restricted net assets" before FASB ASU 2016-14 took effect for fiscal years beginning after December 15, 2017.