Close this window
This is the third blog of my series on configuring QuickBooks for use in a nonprofit organization. In my first blog, I mentioned that the very first step in configuring QuickBooks is to have a QuickBooks implementation meeting, and I recommended using a questionnaire to facilitate the meeting and act as a centerpiece. My second blog dealt with setting up the chart of accounts in a nonprofit environment. This blog will cover steps 3 (using the "Customer/Jobs" utility) and 4 (using the "Classes" utility). QuickBooks is a relational database, and as such it offers a few ways to flag (or relate) transactions such as invoices, cash receipts, bills, cash disbursements, and journal entries to Customer/Jobs (funding sources) and Classes (programs). By flagging a transaction (relating the transaction to a particular grant or program), QuickBooks can then quickly pull the related data into relevant reports by a particular grant or program. QuickBooks offers the user two utilities that can be assigned to each of the transactions mentioned above. The first of these is the "Customer/Jobs" utility.
The "Customer/Jobs" utility should be used to keep track of your nonprofit's funding sources. Let's say that the XYZ Foundation awards your nonprofit a grant for 2011. In QuickBooks, set up a customer called "XYZ Foundation." Next, set up a job underneath the XYZ Foundation called "2011 XYZ Foundation Grant." In database vernacular, the customer is a "parent" record and the job is a "child" or subordinate record. They are related to one another, but they are separate records in the database. By using this hierarchal setup, you will be able to keep track of all the grants that were awarded to your nonprofit by the XYZ Foundation, and you can keep track of each individual grant simultaneously.
A common error that many nonprofits make is to create a customer record for each grant even if it is from the same funding source. Using the setup recommended here will allow you to see the history of all grants from the same funding source. The sample implementation questionnaire (mentioned above and in my second blog) will assist you in making a list of your customers (funding sources) and the individual grants (jobs) awarded by those funding sources to your nonprofit. Evaluate your current funding sources and put them in this hierarchical order. Your list should look something like this:
This setup allows you to go to your "customer" (funding source) record in QuickBooks and see all activity for that funding source at a glance.
The QuickBooks "Class" utility should be used to manage and report on your nonprofit's programs. If you read my first two blogs, you will remember that a nonprofit's programs are defined as "what the nonprofit does" (and not who funds the nonprofit). If you used the sample implementation questionnaire that I developed for my nonprofit clients as your first step in setting up QuickBooks, you and all the stakeholders involved with setting up QuickBooks should have come to a consensus on what your programs are and you should have a list of these programs. Using the list of programs from your implementation meeting, go to the "lists" option in the QuickBooks database and then click on "Class List." Add each program as a QuickBooks class. If you need help doing this, just click on the help button or the F1 key while you are in the Class List screen, and relevant help will pop up on your screen. A sample listing of programs for a nonprofit might look something like this:
For an explanation of the concepts in this blog that shows you how to set up "Customer/Jobs" (your funding sources) and "Classes" (your programs), see this short video.
My next blog post will show you how to tie together the chart of accounts, funding sources, and programs in transactions within QuickBooks. After these relationships are built for each transaction (accounts receivable, cash receipts, accounts payable, cash disbursements, and journal entries), you will be able to use standard reports in QuickBooks (Profit & Loss, Profit & Loss by Job, and Profit & Loss by Class) to run reports by grant (funding source or Customer/Job) and by program (Class). My next blog post in this series will be:
Mark McCallick, CPA, CITP has a practice dedicated to nonprofit organizations and small business ' see http://www.mac-cpa.biz. He has served nonprofit organizations for over 25 years and is a Certified QuickBooks Pro Advisor. He is also the founder of the website www.nonprofit-connect.com, whose mission is to provide nonprofit organizations with a forum to collaborate with one another and share access to resources and best practices in the nonprofit industry. You can contact Mark McCallick at email@example.com or firstname.lastname@example.org. This blog series was updated for our readers in February 2013 by Mr. McCallick.
Can you tell me where can I find all six steps (the blogs)?
If you click on the tag "QuickBooks" at the bottom of this post, you'll be able to see all four posts in the series (that covered the six steps) as well as other QuickBooks related content and webinars.
Here's the link: forums.techsoup.org/.../QuickBooks
Hope that helps!
In addition to this blog series, Mark conducted a webinar with TechSoup. You can view the archived recording here along with a variety of the resources, samples, and sites he recommends for learning more.
If you set up classes based on various programs the nonprofit is involved in, how then do you distinguish admin, development versus program expenses?
I have been using QuickBooks for five years and gone to a few trainings--and bought the book. This is the first true explanation of what the heck customers/jobs are for a nonprofit. Thanks so much.
Npsahm, this would be a great question for the TechSoup Community. forums.techsoup.org/.../20.aspx
Your take on classes here doesn't seem to be fully consistent with the UCOA's approach, which you mention in setting up accounts in the first post. Breaking out programs like this makes sense, but shouldn't you also have classes for fundraising and management and general (and possibly common costs)?
thanks, this is great. My big question is how to see the employers payroll costs divided into classes (projects). Also worker comp payments.
RE: The Labor Distribution in a Nonprofit. If you are using QuickBooks payroll you would create the labor distribution using the Jobs and Classes you setup originally. I have many clients who use an outside payroll service. For those clients using an outside service I create a labor distribution "matrix" using a spreadsheet software. I setup the Jobs and classes along the horizontal axis and the names of each employee along the verticle axis. I insert the perentage distribution for each employee at each coordinate cell. Once I do this, I schedule a meeting withe the Payroll Company and ask if they can setup the payroll based upon the labor distribution I setup. Normally this is easily done by the payroll company. What normally happens is that the Payroll company sets up screens in their software that allow the Nonprofit to process payroll using the jobs an classes setup in implementation, It also allows for the flexibility to add new jobs and classes and more importantly to change the percentages for each employee as the Nonprofit gains and loses old and new jobs and classes. Hope this helps.
Mark McCallick, CPA.CITP