Fund Accounting in QuickBooks Online: Complete Guide

QuickBooks Online can approximate fund accounting with careful setup, but it has real limits. Nonprofit accountants often ask whether they can do fund accounting in QuickBooks Online, and the answer depends on how many restricted funds you have and how much reporting your funders need.

The sections below cover what QuickBooks Online can and can't do, and how to decide whether it is enough for your needs.

What is fund accounting?

Fund accounting is a way of keeping books that focuses on how money was used, not on profit. Nonprofits need to answer questions like these:

• Did we use restricted money for its intended purpose?
• How much of each grant is left?
• Are we following donor restrictions?
• Can we report accurately to each funder?

Some fund accounting systems keep a separate, self-balancing set of accounts for each fund, but not every nonprofit uses them. Under current U.S. GAAP, nonprofits report net assets with donor restrictions and net assets without donor restrictions. QuickBooks Online tags can support internal reporting, but they don't create self-balancing funds.

Key terms

Term	Meaning
Fund	A separate set of accounts within one organization
Restricted fund	Money that a donor limited to a time or purpose
Unrestricted fund	Money with no donor restriction, which the board can direct
With donor restrictions	The current term for net assets subject to donor-imposed time, purpose, or perpetual restrictions
Temporarily or permanently restricted	Older terms that "with donor restrictions" replaced for presentation
Net assets	The nonprofit term for equity

How QuickBooks Online is built

QuickBooks Online uses standard double-entry accounting with a single general ledger. Intuit built it for businesses that track profit, not for nonprofits that track donor restrictions.

QuickBooks Online has:

• A chart of accounts
• Classes, which can tag transactions in any account, on Plus and Advanced
• Locations, which tag a whole transaction, on Plus and Advanced
• Customers, and Projects on Plus and Advanced
• Standard financial reports

QuickBooks Online lacks:

• Separate fund records
• Restriction tracking
• A balance sheet for each fund
• Automatic entries between funds
• Budgets that follow an award's own periods, categories, and revisions

Setting up fund tracking in QuickBooks Online

Method 1: Classes as activity tags

Use Classes to tag grant or program activity for internal reporting.

To set it up:

1. Turn on class tracking in Settings > Account and settings > Advanced, in the Categories section.
2. Create Classes for the activity you need to report, for example:
   • Unrestricted
   • Program A (Restricted)
   • Program B (Restricted)
   • Building Fund (Restricted)
   • Endowment activity
3. Apply Classes consistently to whole transactions or to rows, as your accounting design requires.
4. Run Profit and Loss by Class to see activity by fund.

Classes are fairly simple to set up, work on all transaction types, and support sub-classes. However, QuickBooks Online doesn't give you a balance sheet by fund or any automatic restriction tracking, and you still compile reports by hand. On Plus, Classes and Locations share a limit of 40 active entries, while Advanced has no limit.

Classes are reporting tags. They aren't self-balancing funds, restriction accounting, donor records, or compliance controls.

Method 2: Separate accounts for each fund

Create separate accounts for each fund:

1. Create separate cash accounts in the general ledger for each fund. The cash accounts can exist only in the ledger, without separate bank accounts.
2. Create separate revenue and expense accounts for each fund.
3. Use a clear naming pattern, for example "5010 Program A Salaries" and "5020 Program B Salaries."

The standard Profit and Loss report then shows activity by fund, and account balances show fund balances. However, the chart of accounts grows quickly, the method doesn't scale to many funds, and consolidated reports are harder to produce. Simple Start, Essentials, and Plus also cap the chart of accounts at 250 accounts.

Method 3: Combined approach

Combine Classes with a planned account structure:

1. Use Classes to track each fund or grant.
2. Use equity accounts for the net asset classes:
   • 3000 Net Assets Without Donor Restrictions
   • 3100 Net Assets With Donor Restrictions (Time and Purpose)
   • 3200 Net Assets With Donor Restrictions (Perpetual)
3. Record restriction releases through a close process that your CPA approves.

Recording restriction releases

Under U.S. GAAP, a restriction is released when the donor's time or purpose restriction is met. Spending cash doesn't release it automatically. The statement of activities shows releases as reclassifications, and they show up in ending net assets with and without donor restrictions.

In QuickBooks Online, a release process usually works as follows:

1. Keep support for each donor restriction and for the events that meet it.
2. At the end of each period, calculate and review release activity.
3. Record releases using the account design and entry policy that your CPA approves.

There is no single standard release journal entry. A manual process takes time and can lead to errors. A grant management tool such as GrantLink can help you prepare and review release activity from QuickBooks Online data, but your finance team should still review the accounting treatment and any entry.

Required statements and what QuickBooks Online provides

Statement of financial position (balance sheet)

GAAP requires net assets in two classes, without donor restrictions and with donor restrictions. QuickBooks Online provides a standard balance sheet with equity accounts. You need to set up net asset accounts yourself and reconcile them to your fund balances.

Statement of activities

GAAP requires changes in net assets with and without donor restrictions, including release reclassifications. Expenses are reported as decreases in net assets without donor restrictions. QuickBooks Online provides Profit and Loss by Class. You need to build custom reports or compile the statement by hand.

Analysis of expenses by nature and function

GAAP requires an analysis of expenses by function, such as program, management and general, and fundraising, and by nature. QuickBooks Online provides reports by account and, on Plus and Advanced, by Location. You need to give every expense a nature and a function, allocate shared costs where needed, and present the analysis on the statement of activities, in a separate statement, or in the notes. A Profit and Loss by Location report isn't automatically a GAAP analysis of expenses.

When fund tracking in QuickBooks Online breaks down

The limits of QuickBooks Online start to cause problems when you have:

• Many restricted funds, which makes the Class list hard to manage and may reach the Plus limit
• Gifts with both time and purpose restrictions
• Restricted funds with several donors
• Grants with their own budgets. Plus and Advanced offer fiscal-year budgets by account that you can subdivide by Class or Location, with a Budgets vs. Actuals report. Award-specific periods, categories, and revisions may still need a separate schedule
• Detailed funder reporting, which you compile by hand
• Audits that need clear restriction tracking

Alternatives to consider

Option 1: Add a grant management tool

Grant management tools such as GrantLink connect to QuickBooks Online and add:

• Grant and fund budget tracking
• Automatic expense allocation
• Restricted fund balances and release review
• Funder report preparation

You keep QuickBooks Online for general accounting, and the added tool handles grant-specific needs. The approach fits organizations that want to stay on QuickBooks but need better grant and fund tracking.

Option 2: Switch to nonprofit accounting software

Several accounting systems market fund accounting for nonprofits, for example Sage Intacct, Blackbaud Financial Edge NXT, and Aplos. Compare current features and pricing on each vendor's site. The approach fits organizations that are ready to move off QuickBooks entirely.

Option 3: Careful QuickBooks Online setup with strong processes

Some organizations make QuickBooks Online work with careful setup and strict processes:

• Written policies
• Staff training on Class use
• Monthly reconciliation
• Separate tracking for grant budgets

The approach fits small organizations with simple fund structures.

Making the decision

Stay with QuickBooks Online alone if:

• Your restricted fund structure is simple enough to reconcile reliably.
• Your grants don't have detailed budgets.
• Funder reporting is light.
• You have staff time for manual tracking.

Add a grant management tool if:

• The number or complexity of active grants makes your manual schedules unreliable.
• Your grants have budgets you need to track.
• Funder reports take a lot of staff time.
• You want to stay on QuickBooks.

Consider moving to another system if:

• You need self-balancing funds or multiple entities that QuickBooks Online and an added tool can't provide.
• You are preparing for complex audits.
• You have outgrown any setup based on QuickBooks Online.
• Your budget allows for a larger accounting system.

Summary

QuickBooks Online can approximate fund accounting, but it requires:

• A setup that uses Classes, accounts, or both
• A period-end release process that your CPA approves
• Separate budget schedules when award requirements don't fit fiscal-year budgets by account
• Steady discipline and reconciliation

Many nonprofits add a grant management tool to QuickBooks Online to get the fund tracking they need without changing accounting systems.

The date you receive, spend, or are awarded money doesn't decide revenue recognition by itself. Unconditional contributions, conditional contributions, and exchange transactions follow different guidance. A conditional contribution is recognized after its barrier is overcome. Use a classification and recognition policy that your CPA approves.

How GrantLink supports this today

In GrantLink, each grant's Expenses links in the QuickBooks panel decide which records GrantLink allocates automatically. Money received links match income or revenue records, so a matched line isn't always a cash receipt. The Releases tab on Grants > Restricted funds lets you prepare and review release activity.

To create a report, select Draft report with Assistant on the grant's Reporting > Reports page, or open Chats > New chat. Finished reports appear on the grant's Reports page.

GrantLink doesn't change QuickBooks Online unless your organization allows that change in Settings > QuickBooks > Permissions. Grant links are set on each grant, and the shared settings in Settings > QuickBooks > Mapping don't relink existing grants.

Sources

• Intuit: QuickBooks for nonprofits: Intuit's description of QuickBooks Online for nonprofits.
• Intuit: Learn about usage limits: account, Class, and Location limits on each plan.
• Intuit: Create budgets: fiscal-year budgets and subdivision by Class or Location.
• FASB: ASU 2016-14: net assets with and without donor restrictions and nonprofit presentation rules.
• FASB: ASU 2018-08: contributions, conditions, and exchange transactions.