Metrics to Monitor Business Health – Part 2: Gross Profit Margin

How is Gross Profit Margin Calculated?

Profit margins can also be affected by:

  • Special offers from vendors
  • Free items from vendors
  • Discounts or markdowns on items

How Should You use Gross Profit Margin?

You can use profit reporting to:

  • Monitor margins by category
  • Look for categories where price increases might be needed
  • Allocate space to higher profit items

Reporting on Gross Profit Margin

Profit Margin by Store

To run the Flash Sales Report:
  1. Select Sales History → Reports → Flash Sales Report
  2. (Optional) Check box to Show pie chart
  1. Enter a Date Range in Report periods for Report period A
  1. (Optional) Check the box for Report period B and enter a date range to compare two time periods
  2. Enter a store or click the button for All stores
    1. Click the Select columns tab
    2. Pick and choose what data points to print on the report by moving the columns into the visible columns area by either:
      • Double-clicking a column header you want to add or remove
      • Clicking once and using the right or left arrow button

NOTE: Recommended data points include:

    • Sales
    • Cost (this is Cost of Goods Sold)
    • Profit $
    • Profit %
  1. If you have chosen more than five Visible columns/data points, use the Report drop-down at the top of the window to select one of the Wide column layouts
  1. Uncheck the Rounding checkboxes
  1. (Optional) Check or uncheck the Show percentage of total check box

NOTE: If checked the checkbox will show the percentage of the total sales and other data points. This can clutter the report. You can preview the report to determine if you want to keep the percentages of totals or not.

11. (Optional) Use the Ticket History, Ticket History Line, and Store tabs to filter the report

12. Click Preview

Profit Margin by Category

The Sales Analysis by Group Report can be run to show you a breakdown of sales by category. This report also allows you to pick which data points print on the report.
To run the Sales Analysis by Group Report for categories:
  1. Select Sales History → Reports → Sales Analysis by Group Report
  2. In the Group by drop-down, select (Ticket History Line) Item Category
  1. Choose a number of records to print by either choosing:
    • Top + a number of records – This will show the top number of categories based on the Print in Order by field
    • Bottom + a number of records – This will show the bottom number of categories based on the Print in Order by field
    • All – This will show all categories
  1. Choose a Print in order by from the drop-down menu
    NOTE: Most options in the print in order by drop-down are numeric and will print from most to least. If you need this report to print in an alphabetical order, choose either By item category (in alphabetical order by Category Code) or by group description (in alphabetical order by Category Description).
  1. Enter a Date Range in Report periods for Report period A
  1. (Optional) Check the box for Report period B and/or Report Period C and enter a date range to compare up to three time periods
  2. Enter a store or click the button for All stores
  1. (Optional) Check the box for Show pie chart
    1. Click the Select columns tab
    2. Pick and choose what data points to print on the report by moving the columns into the visible columns area by either:
      • Double-clicking a column header you want to add or remove
      • Clicking once and using the right or left arrow button

NOTE: Recommended data points include:

    • Sales
    • Cost (this is Cost of Goods Sold)
    • Profit $
    • Profit %
  1. If you have chosen more than five Visible columns/data points, use the Report drop-down at the top of the window to select one of the Wide column layouts
  1. Uncheck the Rounding checkboxes
  1. (Optional) Check or uncheck the Show percentage of total check box

NOTE: If checked the checkbox will show the percentage of the total sales and other data points. This can clutter the report. You can preview the report to determine if you want to keep the percentages of totals or not.

  1. (Optional) Use the Ticket History, Ticket History Line, and Item Category tabs to filter the report
  2. Click Preview

Profit Margin by Item

The Sales Analysis by Group Report can be run to show you a breakdown of profits by item number. This report also allows you to pick which data points print on the report. You could run the report to show your top 100 most profitable items for example.

To run the Sales Analysis by Group Report for items:
  1. Select Sales History → Reports → Sales Analysis by Group Report
  2. In the Group by drop-down, select (Ticket History Line) Item Number
  1. Choose a number of records to print by either choosing:
    • Top + a number of records – This will show the top number of categories based on the Print in Order by field
    • Bottom + a number of records – This will show the bottom number of categories based on the Print in Order by field
    • All – This will show all categories
  1. In the Print in order by, choose either Profit $ or Profit % – This will show most profitable items at the top of the report.
    NOTE: Most options in the print in order by drop-down are numeric and will print from most to least. If you need this report to print in an alphabetical order, choose either By item category (in alphabetical order by Category Code) or by group description (in alphabetical order by Category Description).
  1. Enter a Date Range in Report periods for Report period A
  1. (Optional) Check the box for Report period B and/or Report Period C and enter a date range to compare up to three time periods
  2. Enter a store or click the button for All stores
  1. (Optional) Check box for Show pie chart
    1. Click the Select columns tab
    2. Pick and choose what data points to print on the report by moving the columns into the visible columns area by either:
      • Double-clicking a column header you want to add or remove
      • Clicking once and using the right or left arrow button

NOTE: Recommended data points include:

    • Sales
    • Cost
    • Profit $
    • Profit %
  1. If you have chosen more than five Visible columns/data points, use the Report drop-down at the top of the window to select one of the Wide column layouts
  1. Uncheck the Rounding checkboxes
  1. (Optional) Check or uncheck the Show percentage of total check box

NOTE: If checked the checkbox will show the percentage of the total sales and other data points. This can clutter the report. You can preview the report to determine if you want to keep the percentages of totals or not.

  1. (Optional) Use the Ticket History, Ticket History Line, and Item tabs to filter the report
  2. Click Preview

Recent Posts

Follow these instructions to learn how to report and learn about your gross profit margins. 
Employ Counterpoint's tool to communicate messages to one user, a group of users, or all users.
There are specific tasks that need to be completed at the end of each fiscal year. If your fiscal year ends on March 31, you need to read this article to learn more about this procedure. 
Walk through how to verify this functionality on your POS workstations in case you lose connection to your server.

i3 Verticals, LLC is a registered ISO of Wells Fargo Bank, N.A., Concord, CA | i3 Verticals, LLC is a registered ISO of RBS Worldpay | i3 Verticals, LLC is a registered ISO of Deutsche Bank, USA, New York, NY i3 Verticals, LLC is a registered ISO/MSP of Merrick Bank, South Jordan, UT | i3 Verticals, LLC is a registered ISO of Harris NA, Chicago, IL | i3 Verticals, LLC is a registered ISO of Fifth Third Bank, Cincinnati, OH Copyright i3 Verticals, LLC © 2019. All Rights Reserved.