Tracking Restricted Funds in QuickBooks for Nonprofits
Managing a nonprofit’s books in QuickBooks is common, but it comes with real limitations. Standard QuickBooks Desktop and QuickBooks Online were designed primarily for for-profit businesses, so features like restricted fund tracking, grant-specific reporting, and Form 990 preparation require workarounds or supplemental tools.
Why QuickBooks Falls Short for Nonprofits
The core issue is that QuickBooks has no native concept of restricted versus unrestricted net assets. A for-profit business tracks income and expenses to measure profitability. A nonprofit must track whether donations can be spent freely, are temporarily restricted to a specific program, or are permanently restricted. QuickBooks also does not generate IRS Form 990, 990-EZ, or their associated schedules out of the box.
Tracking Restricted Funds With Classes
The most practical workaround inside QuickBooks is to use the Class Tracking feature combined with equity accounts. Set up classes for each fund or grant — for example, “General Operating,” “Building Campaign,” or a specific grant name. When you record a restricted donation, assign it to the appropriate class. You can then run a Profit and Loss by Class report to see how much money was raised and spent within each restricted category.
Setting Up Net Asset Accounts
To produce accurate nonprofit financial statements, create separate equity accounts in your Chart of Accounts for Unrestricted, Temporarily Restricted, and Permanently Restricted Net Assets. When you close out the year, map your unrestricted income and expenses to the appropriate net asset account so your balance sheet reflects true fund balances rather than standard owner’s equity.
Handling Grant Reporting
Grants often require detailed reports showing exactly how funds were spent. By tagging every related transaction — bills, checks, and journal entries — to the correct class and using Customer:Job fields for the specific grant, you can pull a transaction detail report filtered by that grant. This gives you the spending breakdown most grantors require without needing a separate spreadsheet.
When to Look Beyond QuickBooks
If your organization juggles multiple complex grants, needs draft 990 schedules, or requires automated reconciliation across funding sources, QuickBooks alone may not be enough. Many nonprofits layer a dedicated nonprofit management tool on top of QuickBooks, or migrate to nonprofit-specific accounting platforms like Aplos that handle fund accounting and basic 990-EZ filing directly.
Next Steps
Audit your Chart of Accounts and turn on Class Tracking in your QuickBooks company file settings. Once classes are active, map your existing funds and grants so every future transaction is categorized correctly from this point forward.