fbpx

How to Track Restricted Funds Using Classes in Quickbooks Online

One question I get asked a LOT is: How do we track restricted funds so we can easily report to our funders?

The first thing I want to do is give you a HIGH FIVE because this is hugely important to tracking grants internally, reporting to funders, and ensuring that you have the systems in place to honor donor intent (i.e. using the money how the donor wants you to!)

Many organizations come us with a spreadsheet they’ve used for tracking restricted funds (like, a TRNA schedule) but they find it cumbersome, clunky, and error-prone to report to donors this way. I completely agree that this is NOT the best way to track restricted funds.

Enter: Quickbooks classes!

I’m going to walk you through, step-by-step, how to set up classes in Quickbooks Online. Now, before you send me a message saying But we don’t use Quickbooks Online!, have no fear. Do a little investigation into your accounting system to see if there’s a function like classes; they might be called segments. (Want to know which accounting system out there is best? Check out this post.)

Wait! Are you a for-profit business owner? Wondering if this applies to you? Tell me this: Do you have multiple revenue streams? If you answered yes, then you should DEFINITELY be using classes in Quickbooks to be able to analyze the profitability of each revenue stream. Read on!

Let’s do this!

 

Make sure your system is set up for class tracking. Here’s the step-by-step:

  1. Click the gear icon in the top right corner to access settings
  2. Under Your Company, click Account & Settings
  3. Advanced
  4. Under Categories, make sure Track Classes is set to On
  5. Click Done at the bottom
  6. Watch this video to see a quick tutorial!

Add custom classes to Quickbooks

I recommend starting with at least Programs, Fundraising, and Admin. This will make your Statement of Functional Expenses (in your audited financials AND the 990!) a total breeze to pull.

But remember, our end goal is to be able to track restricted funds within the accounting system, so you want to set up subclasses for each restricted funding line. Here’s the step-by-step:

  1. Click the gear icon in the top right corner to access settings
  2. Under Lists, click All Lists
  3. Click Classes
  4. Click New and input the class name
  5. Watch this video to see a quick tutorial!

Here’s an example outline of a class structure:

  1. Programs

    A. Education Program

     i. Restricted Grant from Z Family Foundation

     ii. Restricted Grant from XYZ Corporation

    B. Nutrition Program

     i. Restricted Grant from Jessica Smith

    C. Water Program

  2. Fundraising
  3. Admin

A few things to consider:

You may not want to set up a separate class for smaller donors because your class structure will become unwieldy QUICKLY. For example, if an individual gave your organization $500 for the Education Program, I would not set them up with their own subclass. That donation would simply get classified under the Education Program class. On the other hand, if you have a grant agreement with a larger donor who will be expecting periodic reports on how you spent their funds, then I would set them up with a separate subclass.

If you have a grant/donor whose award spans across several program areas, you may consider using Customers within Quickbooks to track their revenue and expenses, rather than Class. Use class to differentiate the expenses by program, then select Customer (donor) within the transaction.

How to track the restricted funds in your day-to-day accounting

In every function of Quickbooks Online, you will see a dropdown to enter a class. Because you selected the option for Quickbooks to warn you if a transaction does not have a class assigned, you won’t be able to save the transaction without a popup from Quickbooks.

In order to ensure our reports are the most useful, you want to enter a class for every single expense and revenue transaction. Check out another quick video here!

If you’re not sure of the class when entering transactions, you can ask yourself a couple questions. If the transaction is revenue, ask yourself Is this transaction restricted to any particular program? If yes, choose the class associated with that program OR perhaps you set up that donor with its own class. If you’re entering an expense, think of the primary purpose of that expense and class it accordingly. Some expenses may be split between different classes based on their use, and that’s perfectly okay.

How to report on the restricted funds using Quickbooks Online

Now that we’ve got our classes set up and we are using them to track every single transaction, it’s time to report on them! After all, that’s why we set up this system – to be able to provide better reports to our donors, much more easily than doing them in Excel or by hand.

Here’s the step-by-step:

  1. Go to Reports
  2. Under Business Overview, click Statement of Activity by Class (it may also be called Profit & Loss by Class)
  3. Watch this video for more

Setting up classes in Quickbooks is going to make a huge impact on your organization. You will be able to quickly and easily report on restricted funds to your donors, analyze profitability or viability of each program, and gain more insight into your numbers to help you make better strategic decisions.


Do you want a detailed step-by-step process to managing temporarily restricted net assets (i.e. TRNA)? I’ve laid it all out for you here! >>>

More Resources:
Here’s a detailed step-by-step process to managing temporarily restricted net assets >>>
Join our community to receive insightful, actionable tips on managing your nonprofit numbers >>>
Still feeling stuck? Set up a time to chat with us and see how we might be able to help >>> Schedule Here

0 comments to " How to Track Restricted Funds Using Classes in Quickbooks Online "

Leave a Comment