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

QuickBooks Online equivalent to QuickBooks Desktop Job Profitability Report - for tracking projects and grant funds for a nonprofit

In QuickBooks Desktop, I had a memorized Job Profitability Report that showed the specific restricted grants we received for a certain project (multiple grants from various sources which were each jobs in QB Desktop) and expenses for the project attributed to each grant (from dozens of vendors), so we could easily see how much we had remaining of each specific grant and how much we had spent on the project as a whole all in one report.

We've migrated all our data to QuickBooks Online.

How do I replicate that report in QuickBooks Online? (or create something similar)

I have tried setting up a new project, but it only lets me choose one customer. I have four sub-customers I need to include in this report. It seems like there has to be an easier way than pulling four separate reports then manually combining them so I can show the total to our executive director and board.

 

Thanks in advance.

2 Comments 2
LollyNino_C
QuickBooks Team

QuickBooks Online equivalent to QuickBooks Desktop Job Profitability Report - for tracking projects and grant funds for a nonprofit

Welcome to the Community, @JBookkeeper.


I can guide you on how to access reports in QuickBooks Online and get the data you require. To create a project and get the profitability report, you must first activate the Project option.

 

  1. Go to the Gear icon at the top.
  2. Under Your Company, select Account and Settings.
  3. Select Advanced.
  4. Find the Projects section and select Edit ✎ to expand it.
  5. Turn on the Use project financial tracking toggle.
  6. Select Save and Done.

 

Once done, you can now pull up a report by following these  steps:

 

  1. Go to Projects on the left pane.
  2. Double-click the project name.
  3. Under Project reports, Select Project Profitability.
  4. Filter your desired date.
  5. Then click run the report.

 

Check out this article for more detailed steps: Set up and create projects in QuickBooks Online

 

I've also included some articles that help you streamline the reporting process in QuickBooks:

 

 

Drop me a comment below if you have further questions about the reports. I'll always have your back.

JBookkeeper
Level 1

QuickBooks Online equivalent to QuickBooks Desktop Job Profitability Report - for tracking projects and grant funds for a nonprofit

Thank you LollyNino_C for your response.

 

I already had projects turned on in QuickBooks Online.

 

When I try to create a project in QuickBooks Online, it only lets me choose one Customer. We have multiple grants (sub-customers) that go toward one project, so this doesn't solve my problem.

 

I have watched the video about a half-dozen times over the last few days looking for answers, and it only shows how to have a project for one customer. I need a project for multiple customers (sub customers).

 

Let me try to explain this differently: We have ABC program. We receive grants from LMNOP Foundation, XYZ foundation and PDQ Foundation for ABC program (three restricted grants designated for the same program to cover the total cost of the program). I need a report that shows the total program expenses and which expenses were allocated to which grant so we know overall how much we've spent and how much is remaining to spend for each restricted grant and the total amount spent on the program.

 

In QuickBooks Desktop, This was a job profitability report customized to filter just the three grants (jobs in QB Desktop).

 

Is there something similar in QuickBooks Online? If a project can't show more than one grant, is there another report type or some other way to set something up so we can see all three restricted grants for the same program all together? Or am I going to have to pull all three reports, export them, and combine them every time I need to report to the Executive Director or Board? 

 

(Side note: we use classes to determine if expenses are for program, administration or development, so tracking restricted grants by class won't work.)

 

Thank you.

Need to get in touch?

Contact us