• Stephanie Skryzowski

How to Track Restricted Funds in 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!

Are you still confused as to how to determine your class structure? Here’s an example outline of a class structure:

  1. Programs

  2. Education Program

  3. Restricted Grant from Z Family Foundation

  4. Restricted Grant from XYZ Corporation

  5. Nutrition Program

  6. Restricted Grant from Jessica Smith

  7. Water Program

  8. Fundraising

  9. Admin

One more pointer! I would not set up a separate class for smaller donors. 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.

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

  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! >>>

#monthlyclose #financialmanagement #accounting #financialstatements #financialanalysis #CFO #accountant #bookkeeping

Global consultancy with HQ in NY and consultants around the US.

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Instagram Social Icon

© 2020 100 Degrees Consulting. Website by JM Design Studio. Privacy policy

Join our community!