Grant Management at Small Not for Profits: Simplicity is scalable

For many organizations, the hurdle of grant management isn’t a lack of diligence, but the complexity of the tools involved. It is a common misconception that robust grant tracking requires expensive, specialized software. In reality, you can achieve full-cycle grant management right within QuickBooks Online (QBO).  You don’t need the top license either, much of it can be done with the lower tiers.

By leveraging three core features—Custom Fields, Classes, and Locations—you can transform a standard accounting system into a sophisticated tracking engine that satisfies both internal stakeholders, grantors and external auditors.

The Strategy: Using What You Already Have

The goal is to eliminate “shadow accounting”—those external spreadsheets used to track data that the accounting system seemingly can’t handle. By moving grant data into QBO, you ensure that every report is pulled from a single source of truth, reducing the risk of manual entry errors and streamlining your year-end audits.

1. Custom Fields: Capturing Grant-Specific Data

Standard accounts tell you what was spent, but Custom Fields tell you the context. Whether you need to track a specific Grant ID number, a secondary approval status, or the expiration date of a funding round, Custom Fields allow you to tag transactions with information that is unique to your organization.

  • How it works: You can set these fields to appear on internal forms (like bills and expenses) or external ones (like invoices).

  • Video Demo: [Insert Video Link: Adding Custom Fields]

2. Classes: Segmenting Your Programs

Classes are perhaps the most powerful tool in the nonprofit QBO toolkit. Think of a Class as a “bucket” for a specific grant or program. When you assign a Class to an expense or a deposit, you are effectively telling the system exactly which project that money belongs to.

  • The Benefit: This allows you to track income and expenses for multiple grants simultaneously without cluttering your Chart of Accounts.

  • Video Demo: [Insert Video Link: Using Classes for Grant Tracking]

3. Locations: The Geographic or Departmental Lens

While Classes track the “what,” Locations are often used to track the “where.” If your grant is restricted to a specific office, city, or physical site, the Location feature allows you to filter your data through a geographic lens.

  • The Distinction: Unlike Classes, which can be applied to individual line items, Locations apply to the entire transaction, making them perfect for high-level departmental or regional reporting.

  • Video Demo: [Insert Video Link: Setting Up and Using Locations]

Bringing it to Life: The Profit & Loss Report

The true value of this setup is revealed when you run your reports. Instead of a generic financial statement, you can generate a Profit & Loss by Class or a Profit & Loss by Location.

By filtering these reports, you can see exactly how much funding remains for a specific grant, what has been spent to date, and where those funds were utilized. This level of transparency is exactly what grantors look for during the reporting phase, and it can be generated with just a few clicks.

 

“Managing grants doesn’t have to be a manual, spreadsheet-heavy burden.”

A Note on Payroll

It is important to remember that for most grants, payroll is the largest expense. To have a truly accurate picture, your labor costs must also be split across these same Classes and Locations. Because payroll allocation involves its own set of nuances and compliance requirements, we will be covering the specifics of “Splitting Payroll for Grants” in a dedicated follow-up article.  This part needs to be done quite carefully too.  

Efficiency Without the Price Tag

Managing grants doesn’t have to be a manual, spreadsheet-heavy burden. By mastering the native tools within QuickBooks Online, you can maintain a high level of fiscal responsibility and reporting accuracy within a simple, low-cost system that grows with your organization.

About Author

Matt Fogler, CPA founded Not For Profit CFO with a singular vision: to bridge the gap between complex accounting and the heart-led work of the nonprofit sector. With years of experience as a Certified Public Accountant specializing in tax-exempt organizations, Matt understands that you don’t just need a bookkeeper—you need a strategic partner.

Categories