Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 6, 2024
Question

Projects Report - Need QB Ninja Help!

  • November 6, 2024
  • 2 replies
  • 38 views

I have spent countless hours with QB Online Advanced Help and still spinning my wheels.  We are undergoing a large reporting project where I need to be able to export all of my projects information for a time period into Excel so then I can slice and dice it how I want.  We use the Project Name as the unique identifier so then we can tie everything together in Excel.  I can pull all Invoice and Payment information and the Project Name will tie to it appropriately.  However, the expenses/checks will not.  I've tried multiple support agents and they all end up back at the same conclusion - QB can't export or tie that data together in a report.  This is bananas to me because I know the system ties it together because I can pull a Project Profitability Summary report that ties everything together, the Projects functionality itself is built on the fact you can tie expenses and income together under a project.  I am praying one of you QB ninjas will be able to help me out because I am at a loss on how to make this happen.

2 replies

Level 1
November 6, 2024

Have you considered using a business intelligent app as a workaround to "cook" your data?

November 7, 2024

I would if I understood them.  Any advice would be much appreciated!

Level 1
November 8, 2024

You can explore this BI app to sync with QBO.

https://go.zoho.com/M5c

 

QuickBooks Team
November 7, 2024

Hi there, Ehconstruction0710.

 

I'm here to help you find the best solutions to resolve this issue quickly. Working together, we can pinpoint and implement the most effective approach to address your concern.

 

You may want to consider creating a transaction list that will allow you to view all your interrelated projects. This would be an effective means of monitoring and managing your tasks.

 

Here's how:

  1. Go to Reports.
  2. Click on the Transactions List by Customer.
  3. Tap Customize. To show specific project names.
  4. Set the date to, All Dates. This will show all the transactions tied to projects.

 

However, you can also try to resort using a third-party app for advanced reporting within QBO. To do this, simply navigate to the Apps menu as a workaround.

 

I've added this resource for future reference to learn how to run reports in QBO: Run reports in QuickBooks Online. It provides step-by-step instructions and detailed guidelines to assist you throughout the process.

 

I'm just a message away. If you need any further assistance related to QuickBooks like running reports, handling transactions, etc. Feel free to reply to this post, and I'll be happy to provide additional guidance. 

November 7, 2024

yes, I know how to pull and customize reports.  What I'm saying is QB will not display the project names for expenses or checks on those reports.  It is a flaw in the system.