Job Profitability Report still not right
It has been two years since I first raised the problem of the job profitability report not showing costs accurately. Still having this issue, QuickBooks Customer Service has proven useless on this topic, and I'm hoping someone in the community has a solution.
To summarize:
- I create a fixed price invoice that is sent to a customer for some amount; say, $50,000.
- I create a second invoice that has no price, just inventory and non-inventory items used on the job. I tag each line item with the relevant customer/job. (This does NOT get sent to the customer since they are billed fixed price and don't know/see/care what gets used.) For example, one line item is 36 pieces of steel at a cost of $593.23 each,
So far, so good. I look at the P&L report, various inventory reports, etc. All show the correct costs being allocated for all inventory items. In this example, 36 widgets x $593.23 = $21,356.28 inventory cost of goods sold.
Then, I run the job profit report. It shows just $6318.76 in cost. Yet, when I click on that line it brings up the invoice from which it is taking the numbers, and that invoice is correct at $21k.
I have verified the data file. I have rebuilt the data file. I have deleted and recreated the invoice. I have put the inventory items on the original invoice (instead of a separate invoice) as a test -- I could never send that invoice -- and the job profit report remains incorrect.
This wasn't a huge problem, as we are a small company and I can run it just fine from the P&L view. However, we now have salespeople who are to be paid based on job profitability. This report MUST be correct or I will mispay people, either costing them money, or in the case of this example, costing the company money.
Thoughts?