Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIn 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.
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.
Once done, you can now pull up a report by following these steps:
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.