Hi – I’ve searched and couldn’t find anything for this report:Build a custom report that shows only gross profit by product
Need help in building a custom report that shows only Gross Profit by product (per month and total), instead of a full income statement with all accounts.
You’re looking for the standard inventory report called Inventory Profitability. Rows show products; columns show the profitability. To see totals by month change “Column” to “Month” on the report results page.
Since you only want to see Gross Profit, I’ll suggest some customizations.
Clear the “show zeros” option to avoid reporting items having no activity in the reporting window.
Under Edit Columns, drop the Quantity column and the percentages.
You can’t drop the Total Cost and Total Revenue columns because those are used to calculate Gross Profit. But you can uncheck the “Add %” options, and you can export to Excel and hide the Cost and Revenue columns by resizing to 0 width.



