cancel
Showing results for 
Search instead for 
Did you mean: 
Sirlexus
Level 1

We run a non-profit that accepts donations/grants that are often restricted by program.

We allocate grant funding to identified clients to help pay a percentage of their invoice for services. For example the money comes from GRANT A but this money is then allocated to pay 20% of client 1, 40% of client 2 and 100% of client 3 invoice for services based on financial need. At the end of the year not all the grant funding has been allocated and then must carry over to the next fiscal year. What is the best way to account for this in QBO? Allowing us to get a clear picture of the amount of money in the grant remaining and to whom it has been allocated.
2 Comments 2
Accracy Accounting
Level 5

We run a non-profit that accepts donations/grants that are often restricted by program.

So here is how I do it (you will need QBO projects module)

 

1) Customer: Create New Customer - "Grant 1"

2) Projects: Create 3 Projects - Client 1, Client 2, Client 3
Make sure you select "Grant 1" customer for these three projects

3) Product/Service: Setup New "Restricted Funds 1"

4) Create New Invoices (Assume total funding of 10,000)
Invoice 1001

Customer: Client 1

Product/Service: Restricted Funds 1

Amount: 2,000 (20% of 10,000)

Invoice 1002

Customer: Client 2

Product/Service: Restricted Funds 1

Amount: 4,000 (40% of 10,000)

Invoice 1003

Customer: Client 3

Product/Service: Restricted Funds 1

Amount: 4,000 (40% of 10,000)


5) Grant Payment Received:

Receive Payment for $10,000

Select invoice 1001, 1002 and 1003

 

At this point you will have all restricted funds allocated to project based on their proportion

Now you want to make sure you allocate all the expense to the respective project when costs are incurred

 

6) Incurred/Paid 500 against Client 2 funds

Create Bill/Expense

Under customer column select "Client 2"

 

You can browse through Project module to understand grant amount vs spent 
Under reports section you can view Profit & Loss by Customer for details as well.

You can also see a consolidated view for "Restricted Funds 1" by running Profit & Loss and filter or display column by Product/Service

sandy98758
Level 1

We run a non-profit that accepts donations/grants that are often restricted by program.

Hi, 

You may consider setting the grant up as a parent customer GRANT and then each grant would be a subcustomer : Grant 1, Grant 2 to track all your grants and be able to  run a report by customer Grant 1, Grant 2.. Profit & Loss by Customer then filter for GRANT or Grant 1, Grant 2 customer... then

 

Code all income and expenses with the GRANT as the customer/job so you are able to run a Profit & Loss by customer and filter as stated above.  

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us