Skip to content

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.

Written by GrantLinkLast reviewed August 19, 2026
On this page

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:

  1. Track the restriction — Know that these funds can only be used for youth programs
  2. Spend appropriately — Only charge eligible expenses to these funds
  3. Report accurately — Show the donor (and your auditors) exactly how funds were used
  4. 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:

  1. Go to Settings > Account and Settings > Advanced
  2. Enable "Track classes"
  3. 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:

  1. Create Customers for funders
  2. Add Projects under each Customer
  3. 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:

RequirementQuickBooks Online Native?Notes
Tag income as restrictedPartialClasses work, but no enforcement
Track spending against restrictionNoManual only
Budget vs. actual by fundPartialSupported 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 visibilityNoManual calculation
Multi-donor restricted fundsNoMajor limitation
Release of restriction trackingNoRequires a supporting schedule and the organization's CPA-approved accounting process
Funder reportingNoManual 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:

  1. Maintaining support for restriction terms and the events that satisfy them
  2. Preparing and reviewing period-end release activity
  3. 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:

  1. Transactions sync from QuickBooks on the automatic schedule or when you run a manual sync
  2. Configure each grant's Expenses links; those links identify records eligible for automatic allocation, with exceptions reviewed manually
  3. Track budgets and spending against the latest synced QuickBooks data
  4. Start a grant report in Chats > New Chat; it then appears on the grant's Reports tab
  5. 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:

  1. Audit your current setup — Document how you're tracking each grant
  2. Identify pain points — Where are you spending the most manual effort?
  3. Evaluate your scale — How many grants? How complex?
  4. 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.


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

Back to top
Was this article helpful?
QuickBooks + grants

See how this workflow fits your QuickBooks data

Review how GrantLink adds grant budgets, transaction allocation, and funder reporting without replacing QuickBooks Online.

Explore the GrantLink workflow