QB Issue Resolution:

Have you used Job Profitability Summary? Job Profitability Detail? P&L by Job?

I don’t know which data you are calculating in Excel, but QB has these reports built in. I will attach some for your review.

Job_Profit_Summary.JPG
Job_Comparison.JPG
PL_No_Name.JPG

Resolution for Issue 'Which report would give me a summary of each expense for a particular customer, by vendor names?' available: Yes (Solved).
Source: Intuit Community forum.

Which report would give me a summary of each expense for a particular customer, by vendor names?: this issue or error code is a known issue in Quickbooks Online (QBO) and/or Quickbooks. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Quickbooks issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If it is a complex issue or you are unable to solve the issue, you may contact us by clicking here or by using other support options.

Support for by vendor names
Quickbooks Repair Pro will resolve it efficiently and affordably. Guaranteed resolution of your issue, or you pay nothing!

Error Recovery for by vendor names [Canada]
E-Tech is the #1 Quickbooks data migration and Conversion service provider.

Get 50% off Quickbooks Online

Click Here for 50% off!

Additional Support Options: