How to Track Nonprofit Grants in QuickBooks

Keeping accurate financial records is essential for nonprofit organizations, especially when managing restricted funds. With QuickBooks for Nonprofits, you can easily track grant balances and ensure your Net Assets with Donor Restrictions are properly updated. A well-organized bookkeeping system not only keeps your accountant happy but also helps you stay compliant and transparent with donors.

Here are three effective methods to track restricted grant balances in QuickBooks Online and maintain accurate financial records throughout the year.

Use classes to track grants – Set up a ‘parent’ class for restricted grants and another for unrestricted grants.

• Create unique sub-classes for each grant under the correct parent to record all grant income awarded and expenses related to the grants.
• Select the grant in the Class field in every transaction related to the grant.
• To generate a report that includes income and expenditures over more than one fiscal year for a particular grant, run a Statement of Activity (Profit and Loss), all dates, filtered for that grant sub-class. The total in this report signifies the grant dollars that have not been expended.

Use donors/sub-donors – This technique frees up your classes for tracking programs and allows for more than one grant to fund a particular program.

• Create a donor (change ‘customers’ to ‘donors’ in Account and Settings) for the grantor.
• Create a sub-donor under the grantor name for each unique grant made by that grantor. In the grant name, use a designator, such as “R” for restricted and “U” for unrestricted, so you can easily identify the sub-donors that represent restricted grants.
• In Account and Settings, select ‘track expenses by donor’.
• Select the grant in the donor field in every transaction related to the grant. Run a Statement of Activity, all dates, filtered for that sub-donor. The total in this report signifies the grant dollars that have not been expended.

Use projects – Create a unique project for each grant. This technique is like using donors/sub-donors and has the added benefit of tracking time activity within each project. Also, there is an easy-to-understand dashboard of the status of each project/grant in one place.

Each of these methods has advantages and disadvantages that depend on the unique needs of the nonprofit. Let us help you figure out the best QuickBooks Online structure for your organization!