How to Track Restricted Funds in QuickBooks Online
QuickBooks Online wasn't designed for fund accounting. Learn the workarounds nonprofits use to track restricted funds, their limitations, and better alternatives.
On this page
- The Challenge: Why QuickBooks Online Struggles with Restricted Funds
- Common Workarounds (And Their Problems)
- Workaround 1: Use Classes
- Workaround 2: Use Customers/Projects
- Workaround 3: Use Locations
- Workaround 4: Separate Bank Accounts
- What's Actually Needed for Restricted Fund Tracking
- The GAAP Requirement: Net Assets Released
- When to Consider a Grant Management Add-On
- A Better Approach: Grant Management Layer
- Getting Started
- How GrantLink supports this today
- Sources
If you're a nonprofit trying to track restricted funds in QuickBooks Online, you've probably discovered it's not straightforward. QuickBooks Online is general-purpose accounting software—it wasn't built for the fund accounting that nonprofits need.
This guide covers the common workarounds, their limitations, and what to do when you outgrow them.
The Challenge: Why QuickBooks Online Struggles with Restricted Funds
When a donor gives your nonprofit $50,000 "for youth programs," the organization must evaluate and honor the documented donor restriction and account for it under its applicable reporting framework:
- Track the restriction — Know that these funds can only be used for youth programs
- Spend appropriately — Only charge eligible expenses to these funds
- Report accurately — Show the donor (and your auditors) exactly how funds were used
- Release restrictions — Record when restrictions are satisfied under GAAP
QuickBooks Online has no built-in concept of "restricted funds." It tracks money in and money out, but it doesn't understand donor intent.
Common Workarounds (And Their Problems)
Workaround 1: Use Classes
The approach: Create a Class for each restricted fund/grant. Apply the Class to revenue when received and expenses when spent.
Setup:
- Go to Settings > Account and Settings > Advanced
- Enable "Track classes"
- Create a Class for each restricted fund
The problems:
- Classes don't enforce anything — staff can easily miscategorize
- QuickBooks Online budgets are fiscal-year and account based, so award-specific periods, categories, or revisions may need an external bridge
- Reports require manual compilation
- Class hierarchies get unwieldy with many grants
- No visibility into remaining restricted balances
Classes are activity and reporting tags. They are not self-balancing funds, restriction accounting, donor attribution, or compliance enforcement.
Workaround 2: Use Customers/Projects
The approach: Create a Customer for each funder, with Projects for each grant. Track income and expenses to Projects.
Setup:
- Create Customers for funders
- Add Projects under each Customer
- Use Project tracking on transactions
The problems:
- Projects can only have ONE customer — doesn't work for multi-donor restricted funds
- Requires workarounds like Sales Receipts + Journal Entries for multiple donors
- Time-consuming manual processes
- Project tracking does not by itself provide an award-specific budget model
Workaround 3: Use Locations
The approach: Use the flat, transaction-level Location field as an internal reporting dimension.
The problems:
- Limited hierarchy options
- Typically needed for actual locations or departments
- Same reporting limitations as Classes
Workaround 4: Separate Bank Accounts
The approach: Open a separate bank account for each restricted fund.
The problems:
- Operationally complex with many grants
- Bank fees add up
- Cash management becomes difficult
- Still need GL tracking for proper reporting
What's Actually Needed for Restricted Fund Tracking
Proper restricted fund management requires:
| Requirement | QuickBooks Online Native? | Notes |
|---|---|---|
| Tag income as restricted | Partial | Classes work, but no enforcement |
| Track spending against restriction | No | Manual only |
| Budget vs. actual by fund | Partial | Supported plans provide multiple fiscal-year, account-based budgets, Class/Location subdivisions, and Budget vs Actual; award-specific periods, categories, and revisions may require an external bridge |
| Remaining balance visibility | No | Manual calculation |
| Multi-donor restricted funds | No | Major limitation |
| Release of restriction tracking | No | Requires a supporting schedule and the organization's CPA-approved accounting process |
| Funder reporting | No | Manual report building |
The GAAP Requirement: Net Assets Released
Under ASU 2016-14, a donor restriction is released when the applicable time or purpose restriction is satisfied—not mechanically whenever cash is spent. Releases are reclassification activity in the statement of activities and are reflected in ending net assets with and without donor restrictions.
In QuickBooks, this means:
- Maintaining support for restriction terms and the events that satisfy them
- Preparing and reviewing period-end release activity
- Following the organization's CPA-approved account design and entry policy
There is no universal release journal entry. Many nonprofits maintain a supporting schedule outside QuickBooks.
Revenue timing is separate: receipt, spending, and award dates do not automatically establish recognition. An unconditional contribution, a conditional contribution whose barrier has not yet been substantially overcome, and an exchange transaction are accounted for differently. Follow the organization's CPA-approved classification and revenue-recognition policy.
When to Consider a Grant Management Add-On
If you're experiencing any of these, you've outgrown the workarounds:
- Spending hours on funder reports — Manually compiling data from QuickBooks Online
- Worried about compliance — Not confident funds are spent correctly
- Managing in spreadsheets — Parallel tracking outside QuickBooks
- Multi-donor grants — Fighting QuickBooks Online's one-customer-per-project limit
- Audit prep is painful — Scrambling to document restricted fund activity
- Growing grant portfolio — The mapping, review, and reconciliation workload no longer operates reliably
A Better Approach: Grant Management Layer
Purpose-built grant management tools sit on top of QuickBooks Online, adding the fund accounting capabilities QuickBooks Online lacks:
What to look for:
- Native QuickBooks Online integration (not a replacement)
- Automatic expense allocation to grants
- Budget vs. actual tracking
- Multi-donor grant support
- Funder report generation
- Audit trail and compliance features
How it works:
- Transactions sync from QuickBooks on the automatic schedule or when you run a manual sync
- Configure each grant's Expenses links; those links identify records eligible for automatic allocation, with exceptions reviewed manually
- Track budgets and spending against the latest synced QuickBooks data
- Start a grant report in Chats > New Chat; it then appears on the grant's Reports tab
- Your accountant still uses QuickBooks Online for the general ledger
This approach keeps your accounting in QuickBooks while adding the grant intelligence layer nonprofits actually need.
Getting Started
If you're currently using Classes or Projects to track grants:
- Audit your current setup — Document how you're tracking each grant
- Identify pain points — Where are you spending the most manual effort?
- Evaluate your scale — How many grants? How complex?
- Consider your growth — Will this get harder as you grow?
For organizations whose grant complexity makes the manual controls unreliable, evaluate a dedicated grant-management layer using documented implementation cost, close effort, reporting effort, and control requirements. There is no universal grant-count or payback threshold.
How GrantLink supports this today
After adding a grant, use its QuickBooks links to select the Customers, sub-customers/jobs, Projects, Locations, or Classes used for Expenses and Money received. The Expenses links drive eligible automatic allocation. Money received is a UI label identifying relevant income or revenue records; it does not necessarily mean cash receipts. GrantLink does not require one organization-wide grant-tracking type.
GrantLink Releases can prepare and review release activity, but GrantLink does not rewrite QuickBooks Online automatically. Settings > QuickBooks Mapping is limited to restricted-account mappings; ordinary expense and money-received links remain per grant.
Sources
- FASB: ASU 2016-14 — donor-restriction presentation, releases, and disclosures.
- FASB: ASU 2018-08 — contribution, condition, and exchange analysis.
- Intuit: class tracking, location tracking, and budgets — current QuickBooks Online behavior and plan-dependent limits.
Explore related areas
Related help
QuickBooks for Nonprofits: The Complete Setup Guide
Setting up QuickBooks Online for a nonprofit? This comprehensive guide covers everything from chart of accounts to grant tracking setup.
Fund Accounting in QuickBooks Online: Complete Guide
QuickBooks Online can approximate fund accounting with the right setup. Learn the workarounds, limitations, and when you need more.
Chart of Accounts Best Practices for Nonprofits
Set up your QuickBooks Online chart of accounts to work seamlessly with GrantLink and funder requirements.
See how this workflow fits your QuickBooks data
Review how GrantLink adds grant budgets, transaction allocation, and funder reporting without replacing QuickBooks Online.