Sales Reports

A sales analysis report shows the trends that occur in a company's sales volume over time. A record of calls made and products sold during a particular time frame kept by a sales person , outlet manager or management. For example, a sales volume observed per item or group of items.

In its most basic form, a sales analysis report shows whether sales are increasing or declining. At any time during the fiscal year, sales managers may analyze the trends in the report to determine the best course of action. Managers often use sales analysis reports to identify market opportunities and areas where they could increase volume. For instance, sales trends during periods and revenue reports. This data can help direct the company to establish market trends and demands.

Available Sales Report List:

Report Code	Report Name	Description
SR-01	Daily Sales Report With Cash Flow Analysis	Allow user/Manager to monitor daily/weekly/monthly/yearly Net Sales and Collection generated by Branch
SR-02	Daily Invoice Summary Report	Allow user/Manager to monitor daily/weekly/monthly/yearly invoices generated by Branch, User and Salesman for controlling/auditing purpose.
SR-03	Daily Sales Report with Inventory Category Grouping	To calculate salesman commission manually (if applicable) Allow user to generate/monitor sales report by "Category Grouping" in the inventory features Ease of decision making for marketing strategy, increase sale performance by: re-grouping inventory category by sale performance
SR-04	Sales Report by Invoice with Inventory Category Grouping	Provide Net Sales report by document levels (Invoice and Sales Return) with Inventory Grouping
SR-05	Stock Sales Report	This report displays the In and Out of inventory quantities due to Sales or Sales Return. the balance quantity can be obtained here as at specific dates. The other information provided are : Unit price = How much it is invoiced (sales price) or for Sales Return (how much is refunded or CM to customers). Unit Cost (Average) = Cost / Quantity Amount = Quantity x Unit price Cost = Quantity x Unit Cost (Average) Gross Margin = Amount - Cost Margin (%) = Gross Margin / Amount x 100%
SR-06	Stock Sales by Item Code	This report displays the summary (No documents displayed) of item codes and the QTY sold, including the Price, Cost and GP.
SR-07	Stock Sales Details Report By Item Code (same with SBR-07)	This report allows user to view the item codes which has backlog
SR-08	Sales Report by Daily, Weekly or Monthly	Allows users to do comparison between 2 or more months on Sales for each Item Code. This report will give information on the sales quantity which might help to analyze the stock ordering management.
SR-09	Detailed Sales Item and Finance Charges Report	The cost of sales for each invoice item is not limited to the inventory cost (cost of goods sold). There are several other costs incurred, for example, if the customers pay using Credit Card or Easy Payment Scheme (EPP) where finance charges could be amounting to between 5% to 9%, which is pretty significant. While giving out sales commissions to the salesman, sometimes it makes sense to deduct these direct charges, and only pay out commissions based on gross profit calculated after deducting these finance charges etc.
SR-10	Gross Profit by Invoice Report	From this report, users will be able to know the summarized gross profit (GP) amount of each invoice and the progress of the settlement of the invoice.
SR-11	Stock Sales Report By Item Code with Discount and Tax	This report allows user to view the Item Codes with the List Price as well as the Discount before Tax and the Price amount after Tax.
SR-12	Sales Report For GL Code Item	User will be able to view the Sales for the Item Code which is GL Code type.
SR-13	Daily Sales Report In Receipt Format	Shows the daily sales report by user and transactions in receipt format
SR-14	Daily Sales and Collection with Card Type Summary by Branch	This report merge or combine the Payment Mode from Credit Card Configuration and shows the amount by row in 1 column
SR-15	Daily Sales Report by Manager Hierarchy and Branch	This report shows the sales and sales return amount by user which allows the management generate by hierarchy (3 date ranges).
SR-17	Master Dealers PSI Report	Customized Report
SR-18	Sell-Thru Coverage Summary Report	Customized Report
SR-19	Sell-Thru Distribution Efficiency Report	Customized Report
SR-20	ST Price Volatility	Customized Report
SR-21	Sell Thru Price Overview	Customized Report
SR-22	SI / ST / SO Achievement Report	Customized Report
SR-23	Prescription Record	Customized Report
SR-24	Poison Record	Customized Report
SR-25	CE Dealers PSI Report	Customized Report
SR-26	Sell Out Coverage Report	Customized Report
SR-27	Departmental Sale and Profit Monthly Report	This report shows the sales and profit by customer type and item category. SR-27 can be compared with SR-06 on the Sales Amount Exclude Tax and GP. make sure the filter are the same when generating both report
SR-28	Stock Sales And Purchase By Item Code Report	Stock Balance = Acc Inv Value in SBR-05 for the selected location, as of the selected Date To Stock Turn Ratio = Stock Balance / Cost Last Purchase = last GRN for the selected location
SR-29	Sales Item And Collection With Invoice Aging Report	Enhancement from SR-09 report with additional filter on the invoice aging and also item point calculation
SR-30	General Purchase Sales Inventory Report	Similar with SR-25 with additional item filter
SR-31	Multi Branch Stock Sales Summary By Item Code	This report is similar to SR-06, however this report will show Balance Stock as of date with QTY, Sales Amount before Tax and GP% by selective branches

SR-01 Daily Sales Report With Cash Flow Analysis

This report allow user/Manager to monitor daily/weekly/monthly/yearly Net Sales and Collection generated by Branch

Select Branch
Select Date Range
Select Customer Type from the drop down list → deselect will generate ALL types
Select Details → Company Name or Contact Person and Company Name
Tick Display Columns → if needed

Tick Options → Show Receipt with 0 amount
Click Generate Report
Click Printable Page → to print current columns or tables
Click Printable Page without Salesman → to print current columns or tables without salesman column
Click Printable Page with Branch Running Number → to print current columns or tables with Branch Running Number

Click Printable Page with Customer Invoice Listing → to print without Payment Method, Terms, Trade In, Disc, Tax and User

Click Printabe Page with Signature → to print current columns or table with signature

Click Printable Page with Vehicle → to print current columns or table with vehicle information

NOTES:

Terms = Invoice Amount - Sum of Receipt (RCT) / Cedit Memo (CM)

This Column will ONLY shown current transaction amount instead of the entire transaction amount.

SR-02 Daily Invoice Summary Report

This report allow user/Manager to monitor daily/weekly/monthly/yearly invoices generated by Branch, User and Salesman for controlling/auditing purpose.

Select Branch → default is all
Select User → default is all
Select Salesman → default is all
Select Customer Category and Customer Type → deselect all will generate ALL
Select From and To Date

SR-03 Daily Sales Report with Inventory Category Grouping

Advantages of SR-03:

To calculate salesman commission manually (if applicable)
Allow user to generate/monitor sales report by "Category Grouping" in the inventory features
Ease of decision making for marketing strategy, increase sale performance by: re-grouping inventory category by sale performance

Select Branch → base on Manager Reports (Permission)
Key in From Date and To Date
Select Salesman → leave blank for all salesman
Select Customer Type → base on Drop Down List
Select Inventory Category → base on Item Categories
Click 'Generate Report'

Click Printable Page → to print current table or column
Click Export to CSV → to export current table or column

Tips:

Description
No	Date	Day	Total Sales Amt (A)	Total Discount (B)	Total Return Amt (C)	Total Net Sales Exclude Tax (D)	Total Tax Amt (E)	Total Net Sales Include Tax (F)
Line No	Date	Day	Sale Amount of the selected date	Discount	Sale Return	D = A - B - C	E = D* 6%	F = D + E
Example:
1	2018-03-01	Friday	1000.00	50.00`	0.00	950.00	57.00	1007.00

SR-04 Sales Report by Invoice with Inventory Category Grouping

Advantages of SR-04:

Provide Net Sales report by document levels (Invoice and Sales Return) with Inventory Grouping

Select Branch → base on Manager Reports (Permission)
Key in Date Range
Select Salesman → leave blank for all salesman
Select Customer Type → base on Drop Down List
Select Inventory Category → base on Item Categories
Click 'Generate Report'

Click Printable Page → to print current table or column
Click Export to CSV → to export current table or column

SR-05 Stock Sales Report

This report displays the In and Out of inventory quantities due to Sales or Sales Return. the balance quantity can be obtained here as at specific dates. The other information provided are :

Unit price = How much it is invoiced (sales price) or for Sales Return (how much is refunded or CM to customers).
Unit Cost (Average) = Cost / Quantity
Amount = Quantity x Unit price
Cost = Quantity x Unit Cost (Average)
Gross Margin = Amount - Cost
Margin (%) = Gross Margin / Amount x 100%

Key in Customer PKID or click Select for search function
Select Custumer Type → base on drop down list under Drop Down List
Select Customer Category →base on drop down list under Drop Down List
Select Location → under Inventory (Permission) for SSR-01 Report
Select Branch → under Inventory (Permission) for SSR-01 Report
Select Date Range
Key in Invoice Remarks
Key In Item Code Fuzzy Search
Key in Item Code Range → if any
Select Item Category→ if any
Select Item Status → default is active

Select Item Type → deselect all will generate ALL
Select or Tick to Separate by Salesman → if any
Select or Tick to Separate by Technician→ if any
Select Choose By → default is item code
Tick Options →for extra information

Key in Gross Margin Range → under Inventory (Permission) for SSR-01 Report

Key in Margin Percentage → under Inventory (Permission) for SSR-01 Report

Key in Item's Unit Price Range → if any

Select Calculate Base On → under Inventory (Permission)
Select Transaction Type → if any
Select Display Item Category → it will shown at printable 5
Select GL Dimension for Filter→ make sure GL Dimension configuration is ENABLED under EMP Configuration - Trading

Click Generate Now or Generate and Export to CSV

Click Printable Page → to print current columns
Click Printable Page 2 → to print current columns without branch, customer category, customer code and salesman

Click Printable Page 3 → to print detailed product sales

Click Printable Page 4 → to print with PO Number

Click Pintable Page 5 → to print Display Item Category with Quantity, Selling Price, Cost Price and Amount
Click Export Excel xls File → to export current columns to excel file
Click Export CSV → to export current colums to csv file

SR-06 Stock Sales by Item Code

Select Date Range
Select Specific Location or Branch
Select Salesman
Select Customer Type from the drop down list → deselect will generate ALL types
Key In Specific Item Code or Item Fuzzy Search for desciption or select the Item Category
Select Item Status and item Type
Select the Calculate Base On
Select Group by → base on item level category
Tick Sort by → Item Name, Gross Profit, Quantity Sold
Tick Options → Show Zero Sold Qty, Batch Expiry(Qty Sold, Show Sale Amount, Show Delta GP, Show Qty Sold

Click on Export Excel or CSV to export current table

Notes:

Cost View and Branch Availability are guided by permissions
If Branch is selected, but no location → system will be filtered by branch
If Location is selected > system will be filtered by location
If Location and Branch are selected > will be filtered by both
If no branch and location selected, error message will be displayed as per the following image:

SR-07 Stock Sales Details Report By Item Code (Same with SBR-07)

SR-08 Sales Report by Daily, Weekly or Monthly

This report allows users to do comparison between 2 or more months on Sales for each Item Code. This report will give information on the sales quantity which might help to analyze the stock ordering management.

Select Branch → controlled by permission
Key In Specific Item Code or Item Fuzzy Search for desciption or select the Item Category
Select Item Status, Item Category and item Type → for additional filter
Select Salesman
Select the Calculate Base On → controlled by permission to view replacement cost or MA cost by company
Select Customer Type from the drop down list → deselect will generate ALL types
Select Date Range → by month, week or day
Tick Group by → Item level, branch or do not group; refer below as sample.

Item Level → categorized by item level

Branch → categorized by branch

Do not Group → indicate the whole company performance

Click on Printable Page → to print current columns or tables
Click Printable Page 2 → to print by group
Click Export Excel or CSV → to export current tables or columns

NOTES:

GP column will shown regardless the user only allowed to see specific cost (replacement cost or MA cost) → calculation is based on the "calculate base on' column

SR-09 Detailed Sales Item and Finance Charges Report

The cost of sales for each invoice item is not limited to the inventory cost (cost of goods sold). There are several other costs incurred, for example, if the customers pay using Credit Card or Easy Payment Scheme (EPP) where finance charges could be amounting to between 5% to 9%, which is pretty significant. While giving out sales commissions to the salesman, sometimes it makes sense to deduct these direct charges, and only pay out commissions based on gross profit calculated after deducting these finance charges etc.

Select Branch → controlled by permission
Select Date Range
Key In Specific Item Code or Item Fuzzy Search for desciption or select the Item Category
Select Item Status, Item Category and item Type → for additional filter
Select the Calculate Base On → controlled by permission to view replacement cost or MA cost by company
Select Salesman (compulsory) and sort by
Select display item category → for printable 6 only
Tick to hide child items

Click Printable page 1 → to print current columns
Click Printable Page 2 → to print without finance charges

Click Printable Page 3 → for format another printable arrangement

Click Printable with Serial Number
Click Printable Page 5 → to print include invoice outstanding

Click Printable Page 6 → to show the item category

Click Export to Excel or CSV → to export current columns
Click Google Sheet → to link with google sheet or google drive

SR-10 Gross Profit by Invoice Report

From this report, users will be able to know the summarized gross profit (GP) amount of each invoice and the progress of the settlement of the invoice.

Select Branch → controlled by permission
Select Date Range
Key In Specific Customer ID or click Select for search function
Select Bill To and customer type
Tick and Key in Gross Margin, Margin % Range → if any
Tick to show Negative Gross Profit only→ if any
Select the Calculate Base On → controlled by permission to view replacement cost or MA cost by company
Click Generate Report

SR-11 Stock Sales Report by Item Code with Discount and Tax

'

Select Location → controlled by permission
Select Date Range
Key In Specific Item Code or Item Fuzzy Search for description or select the Item Category
Select Item Status, Item Category and item Type → for additional filter
Tick to show zero discount and tax → if any
Click Generate Report Now

SR-12 Sales Report for GL Code Item

Key in Specific Customer ID or click Select for search function
Select Customer Type → if any
Select Branch → controlled by permission
Select Date Range
Key In Specific Item Code or Item Fuzzy Search for desciption or select the Item Category
Select Item Status, Item Category and item Type → for additional filter
Key in Reference No → if any
Select Salesman (compulsory) and sort by
Click Generate Report Now

SR-13 Daily Sales Report in Receipt Format

Select Branch
Key in Date and click Generate Report

SR-14 Daily Sales and Collection with Card Type Summary by Branch

Select Branch and click Submit
Select Date Range
Select Customer Type → deselect will generate All Type and user may refer when Create Customer Account
Select Any Credit Card Type → Compulsory and user may refer to Credit Card Maintenance (Merchant / Card Payment Config)

SR-15 Daily Sales Report with Manager Hierarchy and Branch

SR-17 Master Dealers PSI Report

SR-18 Sell Thru-Coverage Summary Report

SR-19 Sell-Thru Distribution Efficiency Report

SR-20 ST Price Volatility

SR-21 Sell Thru Price Overview

SR-22 SI/ ST/ SO Achievement Report

SR-23 Prescription Record

SR-24 Poison Record

SR-25 CE Dealers PSI Report

SR-26 Sell Out Coverage Report

SR-27 Departmental Sale and Profit Monthly Report

SR-28 Stock Sales and Purchase by Item Code Report

This Report is the combination of SBR-05, stock movement and SPR-01 which list all items, regardless if there's sales during the selected duration.

Stock Balance : Acc Inv Value in SBR-05 for the selected location, as of the selected Date To
Stock Turn Ratio : Stock Balance / Cost
Last Purchase : last GRN for that location

Select Company and click 'Change'
Select Location
Select Date Range
Key in specific Item Code or click 'Item Code Fuzzy Search' for search function
Key in Item Code Range → if any
Select Item Status → default is active
Select Item Type → deselect all will generate ALL types
Select Group By → item category under Item Categories
Tick Options → default will tick all options
Click "Generate Report"

Click Printable Page → to print current columns or tables
Click Export Excel xls File → to export current tables or columns to excel file
Click Export CSV → to export current tables or columns to CSV file

Tips

Stock Balance = Acc Inv Value in SBR-05 for the selected location, as of the selected Date To

Stock Turn Ratio = Stock Balance / Cost
Last Purchase = last GRN for the selected location

SR-29 SalesItem and Collection with Invoice Aging Report

Select Specific Location or Branch → controlled by permission
Select Date Range
Key In Item Code Range or Item Fuzzy Search for desciption or select the Item Category
Select Item Status and item Type
Select the Calculate Base On → controlled by permission to view replacement cost or MA cost by company
Select Salesman → compulsory
Select Sort by → Invoice date or Invoice number
Select Display Item Category → for printable 2
Tick for Aging Filer → optional
Tick to hide child item → optional
Click Generate Report

Click Printable page 1 → to print current columns or tables
Click Printable Page 2 → to print current columns or table with Display Item Category

Click Expot Excel or CSV → to export current columns or tables

NOTES:

Aging Columns shows the Outstanding Invoice aging range
Click on the Transaction Number for Pop Up Document

SR-30 General Purchase Sales Inventory Report

SR-31 Multi Branch Stock Sales Summary By Item Code

This report is similar to SR-06, however this report will show Balance Stock as of date with QTY, Sales Amount before Tax and GP% by selective branches

Select Date Range
Select Location and Branches → need to choose EITHER Location or branch
Select Salesman
Select Customer Type → deselect all will generate ALL
Key in Item Code → if any
Select Item Category → if any
Select Item Status → by default is active
Select Item Type → deselect all will generate ALL
Select Calculate Base On → under Inventory (Permission)
Select Group By → refer to Item Category Level
Select Sort By → Item Name, Gross Profit or QTY Sold
Tick Options
Click Generate Report Now

NOTES:

Cost View and Branch Availability are guided by Inventory (Permission)
If Branch is selected, but no location → system will be filtered by branch
If Location is selected > system will be filtered by location
If Location and Branch are selected > will be filtered by both
If no branch and location selected, error message will be displayed as per the following image: