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.
Resolution for 'by vendor names issue: 'Which report would give me a summary of each expense for a particular customer, by vendor names?' available: Yes.
The by vendor names 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 by vendor names issue yourself by looking for a resolution described in the article. If it is a complex by vendor names issue or you are unable to solve the issue, you may contact us by clicking here or by using other by vendor names support options.
For more information about resolving issues related to by vendor names in Quickbooks/QBO or to get support for the issue 'Which report would give me a summary of each expense for a particular customer, by vendor names?', click the link below:
Details