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

Reports Modification

Hello. I need to be able to add PROJECT to all reports, but especially on the "Sales by Customer Detail". It doesn't appear I can do this. Is there a work around.

 

I need the following:

Customer

Date

Transaction 

Number

Project

Product/Service

Memo/Description

Amount

Rate

Balance

5 Comments 5
Rea_M
Moderator

Reports Modification

You're unable to add a specific project column in the Sales by Customer Detail report, LdyRhds. But you can customize it to manually include your projects. I'll guide you on how to do this below.

 

When you customize reports in QuickBooks Online (QBO), you can filter particular accounts or customers, or format the layout so the right data shows up. To incorporate projects into your Sales by Customer Detail report, here's how:

 

  1. Go to the Reports menu and find and open the Sales by Customer Detail report.
  2. Select the Customize button.
  3. Choose the Filter dropdown.
  4. In the Customer field, manually select your projects.
  5. Click Run report.

 

After that, you can memorize the report to save its current customization settings.

 

Also, if you wish to utilize your financial reports outside of QuickBooks for future reference, you can export them. You can refer to this article for guidance on how to perform this procedure: Export your reports to Excel from QuickBooks Online.

 

Come back here anytime if you have additional questions about modifying reports in QBO. I'll be willing to assist you further. Keep safe.

LdyRhds
Level 1

Reports Modification

Thank you for replying. However, this did not work. There is no way to manually select your projects in the Customer field under FILTER. 

JuliaMikkaelaQ
QuickBooks Team

Reports Modification

Hi there, LdyRhds. I'm here to guide you so you can successfully add them to the report.

 

Since the option to add a Project column on the report is unavailable, you can customize and filter this to show this detail. Please know this will show under the Customer column it's associated with. You may refer to the image below:

 

If you're in the Modern view, click Filter, then select Customer in the Filter box. Then, in the operation box, select equals, while for the Value, choose the project you want to include in the report. You can select multiple projects at the same time. Also, ensure to enter the reporting period to gather all associated projects. 

 

 

On the other hand, if you're using the Classic view, you can follow the steps provided by Rea_M. Similarly to the latter view, you can select multiple projects in the Customer dropdown list.

 

 

However, if you have already performed any of these steps and can't select your projects in the Customer field, this could be due to a cache-induced browser. It can affect the program's performance and hinder it in collecting your data. To fix this, you can start by accessing your account through an incognito or private browser. I'll write down the shortcut keys for easier access: 

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Microsoft Edge: Ctrl + Shift + P
  • Safari: Command + Shift + N

 

Once you log in, please generate the report and follow the steps above to filter it. 

 

If this works, you can clear your browser's cache to eliminate unnecessary caches that affect the program's performance. You can also use other supported browsers as an alternative option.

 

Furthermore, you can visit these references as your guide in personalizing your reports and managing them for future use:

 

 

Notify us by replying in the thread if you have questions about managing your projects in the Sales by Customer Detail report or any other QuickBooks concerns. We'll get back to help you the best that we can. Stay safe!

LdyRhds
Level 1

Reports Modification

I appreciate your help, but none of these options are populating for me. I cannot choose project anywhere, only customer. 

MelroseV
QuickBooks Team

Reports Modification

Let me chime in to this thread, LdyRhds.

 

To see the project, ensure that it is enabled in the Account and Settings. If still enabled, I recommend contacting our support team. They have the resources to identify what's causing this issue through screen sharing.

 

Here's how:

 

  1. Sign in to your QuickBooks Online company.
  2. Go to Help (?).
  3. Select Contact Us.
  4. Enter your concern, then select Let's talk.
  5. Choose a way to connect with us:
  • Start a chat with a support expert.
  • Get a callback from the next available expert.

 

You can check out their operation hours to determine availability. 

 

Additionally, you may customize your report to ensure you'll get the data you need for your business. I've added this article for more details: Customize Reports in QuickBooks Online.

 

We appreciate your efforts in bringing these concerns to us, LdyRhds. Should you have any report-related queries, comment below. We're available anytime to offer a helping hand. Take care! 

Need to get in touch?

Contact us