Sales By Item Summary

The Sales By Item Summary report provides a comprehensive overview of how many items have been sold and returned within a designated timeframe. This report includes essential details such as item name, description, UPC (Universal Product Code), brand, quantity sold, sales amount, average cost, sales percentage, gross margin percentage, and more. This report is essential for analyzing which products are performing well, inventory management, and strategic planning for future sales.

Key Features of the Sales By Item Summary Report

1. Gross Margin Percentage: The report calculates the gross margin for each item. This provides businesses with a clear understanding of their profitability.

2. Performance Evaluation: Businesses can use this report to evaluate the performance of individual items and identify top-selling products.

3. Performance Trend Over Period: This report allows you to check the number of items sold and returned over different periods of time, such as "This Month", "This Week", "This Calendar Year", etc. to analyze which items are being sold the most.

4. Inventory Management: By understanding which items are selling well, businesses can optimize their inventory levels, ensuring they have sufficient stock of high-demand items while minimizing excess inventory of slow-moving products.

5. Pricing Strategy: The report helps businesses analyze the effectiveness of their pricing strategies and make adjustments to maximize profitability.

6. Profitability Analysis: By calculating the average cost and gross margin percentage for each item, businesses can assess their overall profitability and identify areas for improvement.

The Sales By Item Summary report is a tool for businesses to analyze their sales performance over a specific period.

To access this report, go to Menu > Reports > Sales > Sales By Item Summary

Upon selecting this option, you will be prompted to select a template. Select the "Sales By Item Summar" template and click "Print Preview" to view the report.

Filtering the Sales By Item Summary Report

XoroERP provides the option to view the "Sales By Item Summary" report for different periods, making it easier for businesses to see how many items were sold in a certain timeframe. This overview will guide you through customizing the report view to better suit your analytical needs.

Time Period Selection

To begin filtering the report:

1. Navigate to the "Range" section located on the right-hand side of the interface.

2. Select the appropriate time period for your analysis and click "Preview" to refresh the report data.

   • The initial default setting is "This Fiscal Year-To-Date". Additional timeframes are available, including:

     • Today

     • This Month-To-Date

     • This Calendar Year

     • Last Week

     • And others.

3. For a more tailored analysis, select the "Custom" option, set the "DateFrom" and "DateTo" fields at the top of this section, and click "Preview" to generate a report for the customized period.

Selecting the Store

After setting the time frame, you can select the store for which you want to check the sales data. This feature comes in handy when you want to see how many items are sold from a particular store. Select the store from the available options and click on "Preview" to check the report tailored to the selected store.