Unlock the dynamics of your pricing strategy with the Price Level Sales report, delivering a concise overview of product group sales categorized by price level. But here's the added depth – opt for the detailed version to explore product-level sales within each price level. This report equips you with insights into how different price tiers impact your overall sales performance. It's not just a summary; it's your key to understanding the nuances of product sales at various price levels.
For companies with multiple sites, this can be split per site or can be consolidated for all sites.
If required, this report can be created as a Saved Report and set up to send out periodically.
Report Filters
Access the Price Level Sales report via: Reports & Analysis > Sales > Price Level Sales.
Select the required report parameter options from:
Select Sites |
Select which sites and/or site groups to include in the report. |
Date Range |
Select which date range to include sales for. |
Product Groups |
Select which product groups to include. If left blank, all groups will be included. |
View Type |
Select whether to view the report as:
|
Grouping |
Select to group the report data:
|
Price Levels |
Select which price level(s) to report on. If left blank, all price levels will be included. |
Show Details |
Select this is you wish to include product sales data in the report. If not selected, only product group sales data is shown. |
Report Output
The output of the Price Level Sales report depends on the Grouping and Sow Details filters selected:
- Grouping: By Price Level (Summary)
- Grouping: By Price Level (Detailed)
- Grouping: By Product Group (Summary)
- Grouping: By Product Group (Detailed)
Grouping: By Price Level (Summary)
When Grouping option By Price Level is selected, and Show Details is not selected, the Price Level Sales report summarises product group sales split by price level type, displaying:
Price Level Type |
Displays the price level type of the price level(s) that sales have been assigned to. |
Product Group |
Displays the product group name. |
Quantity |
Displays the quantity of products sold within the product group shown. |
Gross |
Displays the total gross sale value. (Excludes discount.) |
Net |
Displays the total net sale value. (Excludes discount and tax.) |
Tax |
Displays the total tax value. |
Cost |
For Inventory Management users, the product cost is displayed. |
GP |
For Inventory Management users, the products gross profit value is displayed as a percentage of gross sales. |
Grouping: By Price Level (Detailed)
When Grouping option By Price Level is selected, and Show Details is selected, the Price Level Sales report provides product sales, per product group, split by price level and price level type, displaying:
Price Level Type |
Displays the price level type of the price level(s) that sales have been assigned to. |
Price Level |
Displays the price level that sales have been assigned to. |
Product Group |
Displays the product group name. |
Product |
Displays the name of the product sold on the price level shown. |
Quantity |
Displays the quantity of products sold within the product group shown. |
Gross |
Displays the total gross sale value. (Excludes discount.) |
Net |
Displays the total net sale value. (Excludes discount and tax.) |
Tax |
Displays the total tax value. |
Cost |
For Inventory Management users, the product cost is displayed. |
GP |
For Inventory Management users, the products gross profit value is displayed as a percentage of gross sales. |
Grouping: By Product Group (Summary)
When Grouping option By Product Group is selected, and Show Details is not selected, the Price Level Sales report summarises price level type sales split by product group, displaying:
Product Group |
Displays the product group name. |
Price Level Type |
Displays the price level type of the price level(s) that sales have been assigned to. |
Quantity |
Displays the quantity of products sold within the product group shown. |
Gross |
Displays the total gross sale value. (Excludes discount.) |
Net |
Displays the total net sale value. (Excludes discount and tax.) |
Tax |
Displays the total tax value. |
Cost |
For Inventory Management users, the product cost is displayed. |
GP |
For Inventory Management users, the products gross profit value is displayed as a percentage of gross sales. |
Grouping: By Product Group (Detailed)
When Grouping option By Product Group is selected, and Show Details is selected, the Price Level Sales provides price level sales split per product, displaying:
Product Group |
Displays the product group name. |
Product |
Displays the name of the product sold on the price level shown. |
Price Level Type |
Displays the price level type of the price level(s) that sales have been assigned to. |
Price Level |
Displays the price level that sales have been assigned to. |
Quantity |
Displays the quantity of products sold within the product group shown. |
Gross |
Displays the total gross sale value. (Excludes discount.) |
Net |
Displays the total net sale value. (Excludes discount and tax.) |
Tax |
Displays the total tax value. |
Cost |
For Inventory Management users, the product cost is displayed. |
GP |
For Inventory Management users, the products gross profit value is displayed as a percentage of gross sales. |
Comments
0 comments
Article is closed for comments.