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.

Details