Fund Accounting in QuickBooks Online: Complete Guide

"Can we do fund accounting in QuickBooks Online?"

It's one of the most common questions nonprofit accountants ask. The short answer: sort of. QBO can approximate fund accounting with creative setup, but it has significant limitations.

This guide covers what's possible, what's not, and how to decide if QBO is enough for your needs.

What Is Fund Accounting?

Fund accounting is an accounting system that emphasizes accountability over profitability. Instead of asking "did we make money?", nonprofits need to answer:

• Did we use restricted funds for their intended purpose?
• How much of each grant remains?
• Are we compliant with donor restrictions?
• Can we report accurately to each funder?

In fund accounting, the organization is divided into "funds"—each a self-balancing set of accounts with its own assets, liabilities, and net assets.

Key Fund Accounting Concepts

Concept	Description
Funds	Separate accounting entities within one organization
Restricted Funds	Donor-imposed limitations on use
Unrestricted Funds	No donor restrictions, board discretion
Temporarily Restricted	Restrictions satisfied by time or purpose
Permanently Restricted	Principal maintained in perpetuity (endowments)
Net Assets	Fund balances (nonprofit equivalent of equity)

QuickBooks Online's Architecture

QBO uses standard double-entry accounting with a single general ledger. It's designed for businesses tracking profitability, not nonprofits tracking donor restrictions.

What QBO has:

• Chart of accounts
• Classes (categories that span all accounts)
• Departments/Locations
• Customers and Projects
• Standard financial reports

What QBO lacks:

• Native fund entities
• Restriction tracking
• Fund-level balance sheets
• Automatic interfund transactions
• Grant budget tracking

Setting Up Pseudo-Fund Accounting in QBO

Method 1: Classes as Funds (Recommended)

Use Classes to simulate fund accounting:

Setup:

1. Enable Classes in Settings > Advanced

2. Create a Class for each fund:

   • Unrestricted
   • Program A (Restricted)
   • Program B (Restricted)
   • Building Fund (Restricted)
   • Endowment (Permanently Restricted)

3. Apply Classes to ALL transactions

4. Run Class reports to see activity by fund

Pros:

• Simpler setup
• Works across all transaction types
• Class hierarchy for organization

Cons:

• No fund-level balance sheet
• No automatic restriction tracking
• Manual report compilation

Method 2: Tracking by Account

Create separate accounts for each fund:

Setup:

1. Create separate bank accounts (in GL, not literally) for each fund
2. Create separate revenue/expense accounts per fund
3. Use naming conventions: "5000-Program A Salaries", "5000-Program B Salaries"

Pros:

• Native P&L shows activity by fund
• Fund balances visible in account balances

Cons:

• Chart of accounts becomes huge
• Doesn't scale with many funds
• Difficult to get consolidated reports

Method 3: Hybrid Approach

Combine Classes with strategic account structure:

Setup:

1. Classes track the fund/grant

2. Equity accounts track net asset classifications:

   • 3000 - Net Assets Without Donor Restrictions
   • 3100 - Net Assets With Donor Restrictions (Time/Purpose)
   • 3200 - Net Assets With Donor Restrictions (Perpetual)

3. Period-end journal entries move released restrictions

The Net Assets Release Problem

Under GAAP (ASU 2016-14), when restricted funds are spent appropriately, you must "release" the restriction—moving the amount from "With Donor Restrictions" to "Without Donor Restrictions."

In proper fund accounting software: GrantLink can support the release schedule from synced spending, but the accounting entry should be reviewed and recorded by your finance team.

In QuickBooks Online:

1. Track restricted spending manually (usually in Excel)
2. At period-end, calculate the release amount
3. Create a journal entry:

Account	Debit	Credit
Net Assets - With Donor Restrictions	$X
Net Assets - Without Donor Restrictions		$X

4. Repeat for each fund

This manual process is error-prone and time-consuming.

Required Reports and QBO's Capabilities

Statement of Financial Position (Balance Sheet)

GAAP requires: Net assets shown in two categories

• Without Donor Restrictions
• With Donor Restrictions

QBO provides: Standard balance sheet with equity accounts You'll need to: Set up net asset accounts manually, reconcile to fund balances

Statement of Activities (P&L)

GAAP requires: Revenues and expenses by restriction category, with releases shown

QBO provides: Profit & Loss by Class You'll need to: Create custom reports or compile manually

Statement of Functional Expenses

GAAP requires: Expenses by function (Program, Admin, Fundraising) and nature

QBO provides: P&L by Department (if using for functions) You'll need to: Cross-tab Class (fund) × Department (function) manually

When QBO Fund Accounting Breaks Down

QBO's limitations become painful when you have:

• Many restricted funds — Class management becomes unwieldy
• Complex restrictions — Time + purpose restrictions on same gift
• Multi-donor funds — Multiple donors to one restricted purpose
• Grants with budgets — No budget vs. actual in QBO
• Funder reporting requirements — Manual report compilation
• Audit requirements — Need clear restriction tracking

Alternatives to Consider

Option 1: Add a Grant Management Layer

Tools like GrantLink sit on top of QuickBooks, adding:

• Grant/fund budget tracking
• Automatic expense allocation
• Restriction status tracking
• Funder report generation

You keep QBO for general accounting; the add-on handles fund-specific needs.

Best for: Organizations wanting to stay on QuickBooks but needing better fund tracking

Option 2: Switch to Nonprofit-Specific Software

Platforms built for fund accounting:

• Sage Intacct (mid-market)
• Blackbaud Financial Edge (enterprise)
• Aplos (small nonprofit)

Best for: Organizations ready to migrate from QuickBooks entirely

Option 3: Advanced QBO Setup + Discipline

With careful setup and rigorous processes, some organizations make QBO work:

• Detailed policy documentation
• Staff training on Class usage
• Monthly reconciliation procedures
• External tracking for budgets

Best for: Small organizations with simple fund structures

Making the Decision

Stay with QBO native if:

• You have 1-3 simple restricted funds
• Your grants don't have detailed budgets
• Funder reporting is minimal
• You have capacity for manual tracking

Add a grant management layer if:

• You have 5+ active grants
• Grants have budgets you need to track
• You spend significant time on funder reports
• You want to stay on QuickBooks

Consider migration if:

• You have 20+ funds requiring full fund accounting
• You're preparing for complex audits
• You've outgrown any QBO-based solution
• Budget allows for enterprise software

Summary

QuickBooks Online can approximate fund accounting, but it requires:

• Creative setup using Classes, accounts, or both
• Manual period-end journal entries
• External budget tracking
• Significant discipline and reconciliation

For many nonprofits, adding a grant management tool to QuickBooks provides the fund accounting capabilities they need without the disruption of switching accounting systems.