Expenses By Vendor By Customer Report In Quickbooks Enterprise Desktop Version

Thanks for becoming part of the Community, RasC.

You can customize reports based on their display, filters, header/footer, and fonts/numbers.

Here's how:
 

1. Run a report.
2. On your Report window, click Customize Report.
3. From the Modify Report screen, go to the necessary tabs for the changes you'd like to make and make your updates. You can review our Customize reports article for detailed information on what all you can accomplish with the customization options.
4. Select OK.

Since you're working with QuickBooks Enterprise, you can also look into QuickBooks Advanced Reporting (QBAR). If you need to customize a report further, you can export and customize it outside of QuickBooks:
 

1. In your top menu bar, go to Reports, then Report Center.
2. Find and double-click a report you want to export.
3. Use the Excel ▼ drop-down list, then choose Create New Worksheet or Update Existing Worksheet.
4. If you see a message saying your report has too many columns, press Advanced, then uncheck the Space between columns checkbox and click OK.
5. Select OK.

I've also included a couple detailed resources about working with reports which may come in handy moving forward:
 

• Understand reports
• Export reports as Excel workbooks

Please feel welcome to send a reply if there's any additional questions. Have an awesome Monday!

What you have sent is a general one.

We want to filter by the Customer also which this report is not providing.

What you have sent is a general one.

We want to filter by the Customer also which this report is not providing.

Thank you for getting back to the thread, @RasC.

Let me add more details about your concern.

I can see the importance of having a specific report that allows your customer to show the total sales going toward your vendor or subcontractors. However, there's no option to have them in one report. 

As a workaround, you can pull up two reports that you can export to Excel, and from there, you can compare and manually customize or filter them with the information you need. These are the Purchases by Item Detail and Sales by Item Detail reports.

To pull up Purchases by Item Detail:

1. In the Reports menu report, locate the Purchases by Item Detail.
2. Click Customize Report.
3. Select the Display tab.
4. Under the Columns section, select the Billing status.
5. Under the Filter section, search for the billing status and choose Billed.
6. Click OK.

On the Sales by Item Detail report, filter it to the specific item you need to compare. Once everything is good and you're ready to export the reports, refer to this article for guidance: Export reports as Excel workbooks in QuickBooks Desktop.

Additionally, you can check out this article for more details on handling reports in QuickBooks Desktop: Understand reports.

Tag me in the comment below if you have clarifications or additional queries. I'll be around to help you.