Category Sales Report (Employees)

Category Sales Report (Employees)

Overview

The "Category Sales Report" provides an organized view of sales by category across one or multiple locations. You can create, schedule, and print custom reports based on your requirements. 
Products with similar features can be grouped into categories, allowing sales managers and super-admins to track category-specific performance, essential for managing promotions and optimizing sales strategies. 

With FTx Cloud POS, you can analyze sales data by category, including cost, retail price calculations, and profit margins, providing a comprehensive view of category performance. 

In this guide, you'll learn how to:
  1. Check category-wise sales reports
  2. Apply custom filters for refined data analysis
  3. Use grouping options to customize category sales views 

Reaching the "Category Sales Report"

  1. Step 1: Log into Control Center
  2. Step 2: Choose Reports
  3. Step 3: Choose Sales Reports
  4. Step 4: Choose Category Sales
Figure 1.2 below will help you understand the navigation better: 


                                                                Figure 1.2

When you click "Category Sales," the "Category Sales Report" screen will open with relevant filtering and sorting options, as Figure 1.3 shows.


                                                                              Figure 1.3
 The report data will be empty initially. You must choose a date range, select the appropriate filters, and click "Generate Report" to generate a report. 

2. Generating the "Category Sales Report"

Please follow the steps below to generate the "Category Sales Report" that meets your requirements: 
  1. Navigate to the Category Sales Report screen.
  2. Select the date range and click "Generate Report" to view the Category Sales Report for the selected date range.
    1. You can use the filters Filter Items (Custom Filters), Group By Location, Include In Sales Reporting, Group By, and Store and Location Groups as per your requirements. You can use the multiple filters to be more specific about the report.
      Please refer to point       3. Report Filter Options to learn more about these filters.
    2. Click "Generate Report" whenever you change your selection in any field to view the updated report. 
  3. When you click the "Generate Report" button after selecting the date range, the system will show the category sales records, as Figure 2.1 shows. 

                                                                                              Figure 2.1
Report Fields: 
  1. Category: This column shows the category name. 
  2. Sales Count: This column shows transactions that fall under a specific category.
  3. Qty Sold: This column shows how many items were sold in each category. 
  4. Total Retail: This column shows the total retail amount for the sold quantity in the category.
  5. Discounts: This column shows the discounts applied to items in the category during the transaction.
  6. Adj Retail: This column shows the adjusted retail value after deducting the discount from the total retail. [Adj Retail = Total Retail - Discount]
  7. Avg Retail: This column shows the average retail amount for a single item quantity by dividing the total sold qty. [Avg Retail = Total Retail / Qty Sold]
  8. Total Cost: This column shows the total applicable cost to the department's sold quantity.
  9. Buydowns: This column shows the buydown amount applied to the items in each category, if any.
  10. Adj Cost: This column shows the adjusted cost after deducting the buy-down value from the total cost. [Adj Cost = Total Cost - Buy-down]
  11. Avg Cost: This column shows the average cost for a single item quantity by dividing the total sold qty. [Avg Cost = Total Cost / Qty]
  12. $ Margin: This column shows the total margin of the sold quantity after calculating the buydowns and discounts. [$ Margin = Adj Retail- Adj Cost].
  13. % Mgn: This represents the margin that gains or losses in percentage. % Margin will calculate the margin against the total retail in percentage. [% Mgn = ($ Margin*100) / Adj Retail].

3. Report Filter Options

FTx Cloud POS lets you view the Category Sales Report records according to your preferences using various filter options. You can configure the report with any single filter or combination of multiple filters. The filters are highlighted in Figure 3.1.
                                                                                        Figure 3.1

1: Report Filters: 

  1. Filter Items: This lets you select the report data based on six parameters: Department, Category, Manufacturer, Tag, Vendor, and Department Tag. Point 3.1 Filter Items (Custom Filters) explains the further details.  
  2. Date Range & Presets: This filter lets you select the report's time interval. Point 3.2 Date Range & Presets explains further details.  
  3. Group By Location: This filter lets you view the records organized by locations or location groups. Point 3.3 Group By Location explains the further details. 
  4. Include in Sales Reporting: This filter lets you filter the category sales records based on three parameters: All Departments, Only Include in Sales Reporting, and Not Include in Sales Reporting. Point 3.4 Include In Sales Reporting explains the further details.  
  5. Group By: Use the Group By drop-down to view the depth of the category. Point 3.5 Group By Category Depth explains the further details. 

3.1 Filters Items (Custom Filters)

The Filter Items drop-down lets you select the report data using specific parameters. It has two selection options:
  1. Show All: The system selects "Show All" by default. It considers all parameters to generate the Category Sales Report for the selected locations. The "Manage" button is disabled for this option. 
  2. Custom Filter: This option enables you to generate the report by selecting specific parameters such as Department, Category, Manufacturer, Tag, Vendor, and Department Tag. Once you choose Custom Filter, the system will enable the "Manage" button to set up the filters. 
Please follow the steps below to create and apply a custom filter: 
  1. Select the Custom Filter option in the Filter Items drop-down and click the "Manage" button.

                                                                Figure 3.1.1
  1. The Manage Filters screen will appear, as Figure 3.1.2 shows. 

                                                                 Figure 3.1.2
1: Manage Filters drop-down: Select the saved custom filters from the Manage Filters drop-down (if any) and click "Apply" to apply the saved custom filter. The system will redirect you to the Category Sales Report home screen. Click "Generate Report" to generate the report for the selected filter. Clicking the "Manage Filters" button will also open the list of saved custom filters. 
2: Parameter Tabs: You will see six tabs: Department, Category, Manufacturer, Tag, Vendor, and Department Tag. Select the required tab, i.e., "Department," to create or apply a custom filter specific to the selected departments.
3: Search: Use this Search box for a specific result.
4: Match All Filters drop-down: Use the Match All Filters filter to decide whether or not the Manage Filters screen data matches all applied filters. 
5: Results: Here, you see the relevant list of data on the Manage Filters screen for the selected tab. For example, if you have chosen the "Department" tab, it will show the list of all departments. You can search for a specific department in the "Search" bar.
6: Select the required departments by checking the appropriate checkboxes.
7: Click the green Arrow button to move the selected records to "Selected List." 
The Manage Filters screen will look like the one in Figure 3.1.3.


                                                                                 Figure 3.1.3
1: When the Category Sales Report is generated, you can decide whether to include or exclude the selected parameters.
  1. Include: If you select Include, the system will include all the specified parameters to generate the Category Sales Report.
  2. Exclude: If you select Exclude, the system will exclude all the specified parameters to generate the Category Sales Report.
2: Click the "Clear Selection" button to remove the whole selection. To remove any record from the list, click the Remove (x) icon. 
3: Apply or save the custom filter:
  1. Click the "Apply" button to apply the selected parameters. The system will navigate you to the Category Sales Report home screen. Click "Generate Report." The system will generate reports based on your selection. 
  2. Click the "Save Filters" button to save the custom filter for future use. Point 3.1.1 Save and Manage Custom Filter explains the details.

3.1.1 Save & Manage Custom Filter

You can also save the configured custom filters for future use.
By clicking the "Save Filters" button, a pop-up will appear to allow you to enter the name of the custom filter.
You can also save the configured custom filters for future use.
  1. Click the "Save Filters" button shown in Figure 3.1.3.
  2. The Name pop-up will appear, as shown in Figure 3.1.1.1.
  3. Enter the name of the custom filter and click "OK." 

                                                                                 Figure 3.1.1.1
  1. You can use the saved custom filter whenever you need it and delete it when you don't need it anymore. Open the Manage Filters screen again and use the steps shown in Figure 3.1.1.2 according to your requirements. 
                                                                                      Figure 3.1.1.2
1: Saved Filters drop-down: The saved custom filters will appear in the drop-down selection. You can select the required custom filter from the list for the Category Sales Report.
2: Manage Filters: You can check and manage the filters by clicking the "Manage Filters" button. You will see the listing of the saved custom filters in a pop-up by clicking on it.
3: The Filter Name list shows the list of all saved custom filters. Click on the filter's name to select it.   
4: You can click "Select Filter" or "Delete."
  1. Select Filter: Use the "Select Filter" button to select any filter from the list. Click on the filter's name, and then click on the "Select Filter" button. The system will close the "Manage Saved Filters" pop-up screen. Click the "Apply" button on the Manage Filters screen. The system will navigate you to the Category Sales Report home screen. Click "Generate Report" to generate the report for the selected filter.
  2. Delete: Use the "Delete" button to remove the no longer required filter from the list. Click on the filter's name and then the "Delete" button. A warning message will appear. Click "OK" to delete the filter. 
  1. Similarly, you can filter and set up the records for other tabs (parameters).
To generate the category sales report with the specific data you've selected, apply a selection or choose a saved filter, then click the "Generate Report" button. 
The selected filter details are available under the "Selected Filters (All)" label, as Figure 3.1.1.3 shows.

                                                                                   Figure 3.1.1.3

3.2 Date Range & Presets

Please follow the steps below to select the report's required date range and time interval:
  1. Click inside the Start Date field. The drop-down calendar will appear as shown in Figure 3.2.1.
  2. Select the specific date and time. You can also manually enter the date in MM/DD/YYYY format.
  3. Click inside the End Date field and follow the same process. 
  4. After making the appropriate selections for other filters, click on "Generate Report."

                                                                         Figure 3.2.1
Presets

Use the Presets drop-down to select the specific duration/interval, i.e., Today, Yesterday, This Week, Last Week, etc., to generate the report as shown in Figure 3.2.2.
  1. Please click on the required timeframe and click "Generate Report." 
  2. The system will generate and show the report based on your selection. 

                                                                                          Figure 3.2.2

3.3 Group By Location

The Group By Location filter lets you view records segregated by locations or location groups.  By default, the system selects "None." Click the Group by Location drop-down highlighted in Figure 3.3.1 to change it.

                                                                            Figure 3.3.1

1. By Location: If you select "Location," the system will display records grouped according to locations, as Figure 3.3.2 shows.

                                                                         Figure 3.3.2
2. By Location Group: If you select "Location Group," the system will display records grouped according to location groups.
  1. The Include Location Group(s) drop-down will appear when you select "Location Group," as Figure 3.3.3 shows. Please select the required locations from it. 


                                                                                  Figure 3.3.3
  1. The system will sort the report based on location groups, and the Include Location Group(s) drop-down will show the selected location groups, as Figure 3.3.4 shows.

                                                                           Figure 3.3.4
  1. The report concludes with the totals for each category and the overall total.
InfoThe Location Groups are a collection of locations, and they can be managed from the Manage Location Groups option in POS -> Maintenance -> Locations.

3.4 Include In Sales Reporting

The Include In Sales Reporting drop-down lets you filter the category sales records based on three parameters: All Departments, Only Include in Sales Reporting, and Not Include in Sales Reporting. 
Info
What is "Include In Sales Reporting?"

"Include In Sales Reporting" is a preference available at the department level, managed by the "Include In Sales Reporting" button. 
  1. If you activate it, the system will include the department in sales reporting.
  1. If you deactivate it, the system will not include the department in sales reporting. 
You can activate or deactivate this preference from the respective "Options" tab in "Departments." ("Departments" >> Add/edit a department>> the "Options" tab >> the "Include In Sales Reporting" button). Please refer to "Departments" to learn more about this preference. 
  1. Click the Include In Sales Reporting drop-down. As Figure 3.4.1 shows, the drop-down has three options: All Departments, Only Include in Sales Reporting, and Not Include in Sales Reporting.       
                Figure 3.4.1
  1. All Departments: The "All Departments" option is preselected by default.
                                                                                         Figure 3.4.2
  1. Include in Sales Reporting: Choose this option to display the category sales records in the report where the "Include in Sales Reporting" option is enabled at the department level. 
                                 
                                                                                                                               Figure 3.4.3
  1. Not Include in Sales Reporting: Choose this option to view the category sales records in the report where the "Include in Sales Reporting" option is disabled at the department level.

                                                                                Figure 3.4.4

3.5 Group By Category Depth 

Category depth in retail refers to the number of levels or layers within a product category hierarchy. Use the Group By drop-down to view the category's depth. By default, the system selects "None." Please follow the steps below to select the category's depth. 
  1. Click the Group By drop-down. Select "Group By Category."

                                                                                    Figure 3.5.1
  1. The Category Depth drop-down will appear, as Figure 3.5.2 shows.
NotesCategory depth is the number of hierarchical levels used to organize products (e.g., Category → Subcategory → Sub-subcategory). It determines how detailed product classification, search, and reporting can be.
  1. Make appropriate selections in the other filters and click "Generate Report." 

                                                                                     Figure 3.5.2
  1. Below is a sample report indicating how the system shows the depth of the category:  

                                                                                    Figure 3.5.3

4. Scheduling a Report

FTx Cloud POS supports report automation. You can configure a report and schedule it. The system will send the scheduled report to the indicated email IDs as per defined frequencies (Daily, Weekly, Bi-weekly, Monthly, Quarterly, etc.) 

Please refer to Scheduling a Report to learn how to schedule a report.

5. Printing/Exporting a Report 

You can print or export any report according to your requirements. When you use the Print function, the system creates and opens the report's PDF file in a new tab. You can download the soft copy or print the paper copy according to your requirements. 

Please refer to Printing a Report to learn how to print or export a report. 

6. Manage Favorites 

FTx Cloud POS allows quick access to the reports you need to view frequently through "Favorite Reports." You can save a report as a favorite and manage all your favorite reports from any of the report screens using the "Manage Favorites" button. 

Please refer to Managing the Favorite Reports to learn how to manage or export a report. 
 

    • Related Articles

    • Category Sales Report

      Category Sales Report Overview The "Category Sales Report" lets you view sales by category for one or multiple locations. You can create, schedule, and print custom reports according to your requirements. Products with similar features can be grouped ...

    • Commission Sales Report (Employees)

      Commission Sales Report Overview Sales commissions, also known as spiffs, are additional compensation provided to employees alongside their regular salary for meeting specific sales criteria. As a store owner or retailer using FTx Cloud POS, you have ...

    • Buydown Sales Report - Employees

      Overview The "Buydown Sales Report" allows employees to generate, schedule, and print customized reports that track buydown data using two key parameters: store sales and invoices received by the store. Tobacco manufacturers and distributors have ...

    • Employee Sales Report

      Employee Sales Report Overview The "Employee Sales Report" helps identify the employees who made maximum/minimum sales in the selected date range. These reports work with different types of filters that can be configured depending on the ...

    • Employees

      Overview When you sign up with FTx Cloud POS for the first time, the system creates your API account. You receive an email with information about the API email, username, and password. The system also creates an API user, an employee user, and a ...