QuickBooks for Manufacturers and Distributors: Profitability by Product Report

Tucked away inside the QuickBooks Manufacturing and Wholesale software is a great "Profitability by Product" report.

To access the report, click Reports > Manufacturing and Wholesale Reports, then choose Profitability by Product report.

Here is a screen shot of how the report looks:

Within the report, you see the following information:

• Actual cost column - for inventory parts and assemblies, this cost is determined when the inventory is sold and comes from the average cost of the item in the item master file at the time of invoicing.
• Actual revenue column - the revenue as indicated on the invoice when the item is sold.
• $ Difference/% Difference - calculates the profit on each item in both dollars and as a percentage.

As with any report in QuickBooks, if further analysis of the report data is needed, you can click the Export button at the top of the report to dump the contents into Excel.

This report will NOT be found in the Pro version of QuickBooks. It is only available in the Premier: Manufacturing and Wholesale Edition and the Enterprise: Manufacturing and Wholesale Editions of QuickBooks.

______________________________________________________________________________________________

Comments

[Scott Gregory, QuickBooks Expert]

Kathy:

The actual costs only appear on this report for inventory parts.

Otherwise, you have to use some special job costing tricks to get the costs to appear.

Just having a value in the "cost" box will not be enough for it to flow through to this report.

Scott Gregory

[Kathi Grandillo]

A lot of my "Actual Cost" items are blank, though I have filled in costs, but did that after original set up. How can I get the costs to be recognized?

[ray ban]

if further analysis of the report data is needed, you can click the Export button at the top of the report to dump the contents into Excel.

[dme medical billing software]

Many manufacturing companies review profitability of product lines each month and may discontinue production of some items. Good software is the key enabler to achieve this task.