The Sales Report enables you to view the detailed report on total sales, return, refund, profit and discounts.
To generate the sales report:
1. In the RPM menu, click Reports and then click Sales Report.
The Sales Report screen is displayed.
2. Select the required filters.
3. Select the appropriate Report Type.
4. Select one of the Report Options:
- Last Buy Price: This option displays the price that the stores last paid for the products to the supplier. The comparison of last buy price between the stores indicates the correct amount for the products.
- Average Cost: This option compares the average cost of the products between various stores. It is beneficial for the products whose price fluctuate frequently.
5. Select the other required filters and specify the Date Range.
6. Select View Report to view the report.
The Sales report will be generated.
Sample of Sales Report
The fields displayed in the sample report can vary depending on your selection. The items displayed have been described in the table below.
| Columns | Descriptions |
|---|---|
UPI | The UPI number of the product. |
Barcode | The barcode number of the product. |
Supplier Code | The supplier code of the product. |
Product Name | The name of the product. |
Store | The name of the store. |
Qty | The quantity of the product sold during the defined time period. |
Gross Sales | The gross sales generated by the Departments during the defined time period. |
Govt Rec. | The government recovery received based on the script od the products from Departments or Sub Departments during the defined time period. |
GST | The amount of GST generated from the Department during the defined time period. |
Nett Sales | The nett sales generated by the Department during the defined time period. |
Discounts | The amount of discount in dollar within the defined time period. |
COGS | The cost of sales during the defined time period. |
GP ($) | The gross profit generated by the Department during the defined time period in dollar. |
GP (%) | The gross profit generated by the Department during the defined time period in percentage. |
SOH ($) | The stock on hand, calculated as: Current SOH (for the store for the item)×Last Buy Price (for the store for the item). |
Turn | The stock turn calculated as: Total Cost (sales of the item for specified date range). |
SOH | The stock on hand. |
