How to View Product Wise Profits Report in RetailGraph (RG) Software

View Product Wise Reports

How to View the Product Wise Profits Report in SwilERP

Every business wants to know which products are making good profit and which are not, in terms of profitability for a specific duration. It is tough to find profitable products from large product stock. By product-wise profits report, users can identify the product profitability.
In the SwilERP software, there is an option to view the Product wise profits report. In this report, an analysis option is also given to analyze the data to get to know profitability. This Analysis and Profits Report provides detailed information about Product name, Sales value, Cost value, Margin, and Margin in percentage. Read this article carefully, and you will know how this report can be viewed.


Strat with Login in the SwilERP dashboard to initiate the process:
  1. Go to the Reports menu.
  2. Select the Profit Reports > Product Wise Profits.
Reference window:
SwilERP Dashboard Window

  1. How to view the report:

  1. Firstly select the Home tab.
  2. Enter the Date Range 'From to To.'
  3. If required, tick the mark in the Deduct Return/Deduct Cash Discount boxes.
  4. Select any option in Summary / Detail / Month Wise / Day Wise in which you want to view details in your report.
  5. If you want to apply a filter, you can use it in the Product tab.
  6. Click on the View tab.
Reference window:
Report Window

  1. How to convert the report in the Chart format:

  1. From the Home section.
  2. Click on the Chart tab and select the Chart to which you want to convert the report.
Reference window:
Chart Tab Window

  1. To view the additional details in the report:

           If the user wants to view some other additional details in the analysis report, then they can select the below steps:-

  1. Select the Area-Product section:- 
  2. According to the user's requirement, if users want to view details Area-wise, then they can select the below-mentioned options- 
  1. Region
  2. Area
  3. Sales Person
  4.  Locality
  5. Customer
  6. Refer By (zone), etc.
  1. If the user wants to view the analysis report Group-wise, they can select the options below according to the requirements.
  2. Category /Brand /Product/Strength/Generic/Schedule, etc.
  3. After following the above steps click on the View tab.
Reference window:
Report Window

  1. Select the Station-Product:

  1. If the user wants to view details as the Station-Product wise, then they can select the below steps:
  2. Country
  3. State
  4. District
  5. Station 
  6. Customer
  7.  First ReferBy, etc.
  8. Sales Person
  9. Customer account
  10. After following the above steps click on the View tab.
Reference window:

  1. How to analyze the details:

  1. Go to the Analysis tab.
  2. Select the Date Range from which you want to view data.
  3. Click on the View tab.
  4. Use the field list to arrange fields in a Pivot Table.
  5. After choosing fields, you will see the data in Analysis Grid.
  6. Enter the name and click on the Save tab to save this report.
  7. If you want to open the previous report, enter that report name and click on the Open tab.
  8. Users can Remove/Export, and Import the report as their requirement.
  9. You can set Grid as per the requirement.

  1. How to use the Areas Section:

  1. Use the areas section (at the bottom) of the field list to rearrange fields the way you want by dragging them between the four areas. 
  2.  Fields that you place in different areas are shown in the PivotTable as follows:
1. Filters  
2. Columns
3. Rows
4. Values 
Reference window:
Analysis Tab Window

  1. How to view the Analysis data in chart form:

  1. After analyzing the data, if you want to view the details in the chart form, click on the given chart option.
Reference window:
Window of Analyze Data in Chart For

  1. How to view the Raw data details in the same window:

  1. Click on the given 'Raw Data' option to view the raw data of stock.
Reference window:
Raw Data Tab Window

  1. How to Print/Preview and Export report:

          If the user wants to take a Print and Preview of this report and convert it into Excel format, follow these steps:
  1. Go to the Display tab.
  2. Click on the Print and Preview tab to print your report.
  3. The user can convert this report into Excel, Text, PDF, or HTML format from the 'T' point.
Reference window:
Print-Preview & Export Tab Window