Hi – I’ve searched and couldn’t find anything for this report:Build a custom report that shows only gross profit by product

Answered

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.

Rookie Asked on February 17, 2026 in Reports.
Add Comment
1 Answer(s)
Best answer

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.

Rookie Answered on February 17, 2026.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   SuiteMigration   Become a Sponsor