How to use QuickBooks Online for Grant Management

Learn how to use Quickbooks Online the right way for grant management. Streamline your grant management process with this tutorial.

Discover the power of the Profit and Loss report filtered by customer to effortlessly monitor grant income and expenses using QuickBooks Online for nonprofits. Learn the importance of accurately categorizing transactions by customer, offering a simplified yet effective approach to grant fund tracking. These are essential nonprofit accounting basics that will help you in the grant management process. Explore the versatility of QuickBooks Online's Projects feature in the second method, providing a robust solution for grant management software. By the end of this video, you'll learn practical tips on crafting and managing grant budgets, empowering your organization with optimal financial management and decision-making capabilities. This is crucial for managing grant funds for your nonprofit.

**WATCH MORE**

00:00 Introduction
00:35 Tracking Grants using P&L Report
02:20 Tracking Grants using Projects
09:16 Tracking Grants using Budgets

[LeighKramerCMD]

Great. Very helpful. Going to set up my first non-profit budget.

[DebbyDearinger]

Hi Germeen. Do you have a video on stock donations and posting of the sell of the stocks?

[ChristyStrach]

Can you do a video on tracking subgrants/grant partners? My organization has grant partners where we are the main grantee, and we send some of the $ to the partner, and I just wasn't sure how to account for that correctly and I haven't found a good explanation by googling. Thank you, I love your videos!!

[AcresAccounts]

Love it! THANKS SO MUCH for this video! I have been wanting to start doing something like this but did not know the exact inputs and what it would look like. GREAT PRESENTATION!!!

[Venitap]

I really like your trainings, especially this one. I’m new to doing non-profit bookkeeping. So, I’m trying to setup the chart of accounts to be able to track the way management will need to see it on reports. I just upgraded to Advance.

[kdm]

THIS IS SO HELPFUL! Thank you Germeen, can't wait to watch more! You mentioned using tags to track fiscally hosted projects. I am about to set up a COA for a new nonprofit that will have fiscal hosting as one of it's core programs. Would you recommend, in this case, building the fiscally hosted projects into the categories or classes? Or stick with tags? Would love a vid on this!

[cooldesert]

This is incredible and very helpful for grant management.

[deavillon]

Great info! Thanks for the video! What if you have a project being funded by different 'customers' / grantors. How do you input this project into QBO?

[JackHorlick]

This is great, thanks very much. What would happen if you have multiple funders to one program? For example, you got two companies to contribute £100k to a specific program you wanted to run. Given that the projects feature only allows you to have one customer, how would you handle this?

[sabdurrauf]

Thank you so much, I really appreciated this video. Do you have any information on how to import staff time cards into QuickBooks Online? For example is it compatible with Gusto, ProCare or other time card software? Any help would be appreciated!

[Watchful-Of-MySalvation]

Thank you so much for breaking this down!

[ArlaLong-lj]

Thank you so much! I so appreciate you:)

[ccafKhmer]

Hello, I am running a local NGO, to my understanding location can set title like restricted Fund and non restrict fund, and can be set title as location of office that is a branch office in another location. Is it correct? Thanks

[Riridree]

Hello @germeeng700 can you also do a video on how you enter or categorize expenses in QBO according to its function for the statement of functional expense for 990?.

[kloverend]

Do you use Projects exclusively instead of Sub-Customers?

[kamilawilliams]

It was too difficult to follow you. You're moving too fast. Please start with adding a new grant "name" and move from there. Thank you!