How to Track Restricted Funds in QuickBooks Online

If you're a nonprofit trying to track restricted funds in QuickBooks Online, you've probably discovered it's not straightforward. QBO 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 QBO Struggles with Restricted Funds

When a donor gives your nonprofit $50,000 "for youth programs," you have a legal obligation to:

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
• No budget tracking against the restriction
• Reports require manual compilation
• Class hierarchies get unwieldy with many grants
• No visibility into remaining restricted balances

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
• Still no budget vs. actual tracking

Workaround 3: Use Location/Department

The approach: Use the Location field to track restricted funds.

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	QBO Native?	Notes
Tag income as restricted	Partial	Classes work, but no enforcement
Track spending against restriction	No	Manual only
Budget vs. actual by fund	No	Requires external tracking
Remaining balance visibility	No	Manual calculation
Multi-donor restricted funds	No	Major limitation
Release of restriction tracking	No	Journal entries required
Funder reporting	No	Manual report building

The GAAP Requirement: Net Assets Released

Under ASU 2016-14, when you spend restricted funds appropriately, you must record a "release" of the restriction. This journal entry moves amounts from "With Donor Restrictions" to "Without Donor Restrictions" on your Statement of Financial Position.

In QuickBooks, this means:

1. Tracking total restricted spending (manual)
2. Creating period-end journal entries (manual)
3. Maintaining a schedule of restricted balances (usually in Excel)

Most nonprofits end up with a parallel tracking system outside QuickBooks.

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 QBO
• Worried about compliance — Not confident funds are spent correctly
• Managing in spreadsheets — Parallel tracking outside QuickBooks
• Multi-donor grants — Fighting QBO's one-customer-per-project limit
• Audit prep is painful — Scrambling to document restricted fund activity
• Growing grant portfolio — More than 5-10 active grants

A Better Approach: Grant Management Layer

Purpose-built grant management tools sit on top of QuickBooks Online, adding the fund accounting capabilities QBO lacks:

What to look for:

• Native QBO 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 automatically
2. Allocate expenses to grants (manually or via rules)
3. Track budgets and spending in real-time
4. Generate funder reports from actual data
5. Your accountant still uses QBO 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 with more than a handful of grants, or complex multi-funder situations, a dedicated grant management solution typically pays for itself in time savings on the first funder report.

---

GrantLink is a grant management platform that integrates natively with QuickBooks Online, adding restricted fund tracking, budget management, and AI-powered funder reports. Learn more about how it works.