SP-01 Sales Report by Salesman
This report is useful for calculating Salesman's Commission. By looking at the Net Sales, you can find out how much the Salesman sold and multiply with the Commission %. However, this method can only be used if factors such as, Collection Period and Type of Items Sold are not taken into account.
- Respective Salesman names.
- Net Sales = Sales - Returns + CM
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_1.png?version=1&modificationDate=1487230513869&cacheVersion=1&api=v2&width=800&height=311)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_2.png?version=1&modificationDate=1487230537023&cacheVersion=1&api=v2&width=800&height=290)
SP-02 Sales Report by Item Salesman, Customer, Category
Sales amount for each level will be shown for each salesman. Select salesman 'Nobody' to view for all salesman. Here, the customer names also appear individually.
Sales (Level 1) + Sales (Level 2) - Credit Note = Total Amount
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_3.png?version=1&modificationDate=1487230552102&cacheVersion=1&api=v2&width=800&height=309)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_4.png?version=1&modificationDate=1487230569029&cacheVersion=1&api=v2&width=800&height=416)
SP-03 Sales Report by Item Salesman, Category (Summary)
An exact duplicate of Sales Report by Salesman, Customer, Category, except that the customers' names are not shown in this report.
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_5.png?version=1&modificationDate=1487230587520&cacheVersion=1&api=v2&width=800&height=309)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_6.png?version=1&modificationDate=1487230601058&cacheVersion=1&api=v2&width=800&height=404)
SP-04 Daily Gross Profit by Item Salesman Report
This report list the gross profit of sales that have been done by each salesman on daily basis. Users will be able to know the daily performance of each salesman from this report. The sales amount, sales return amount, cost amount , gross profit amount, Number of Invoice/Sales Return, Average of Invoice and Quantity Sold for each salesman is listed in the report.
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/image2017-11-28_15-17-39.png?version=1&modificationDate=1511853462972&cacheVersion=1&api=v2&width=800&height=337)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/image2017-11-28_15-23-20.png?version=1&modificationDate=1511853805506&cacheVersion=1&api=v2&width=800&height=168)
Notes:
- Calculation of AVG on INV: Eg. 100 invoice = total RM20,000; Average spend for the invoice = RM20,000 / 100 = RM200
- For Sample Above: Salesman "wms1001" with 3 Invoices = total RM104,049.06; Average spend for the invoice = RM104,049.06 / 3 = RM 34683.02
- Total Unit Sold: Eg. each invoice with X number of items; Total unit sold = add up all X number for all invoice on the selected date
SP-05 Gross Profit by Salesman by Invoice
This report lists the gross profit of the invoices categorized according to the salesman. users will find it useful for salesman commission calculations, as well as performance ranking and appraisal for salesmen within a company.
- The date, item code, item quantity, standard price, discount, unit price, unit cost, total amount, total cost and total gross profit for each invoice are stated clearly asInvoice Total.
- The total of item quantity, standard price, discount, unit price, unit cost, total amount, total cost and total gross profit of invoices are calculated for each salesman stated as Salesman Total.
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_9.png?version=1&modificationDate=1487230663222&cacheVersion=1&api=v2&width=800&height=398)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_10.png?version=1&modificationDate=1487230678870&cacheVersion=1&api=v2&width=800&height=410)
SP-06 Gross Profit by Index Salesman by Invoice Report with Inventory Category Grouping
This report lists the gross profit of the invoices categorized according to the salesman. users will find it useful for salesman commission calculations, as well as performance ranking and appraisal for salesmen within a company.
- The date, item code, item quantity, standard price, discount, unit price, unit cost, total amount, total cost and total gross profit for each invoice are stated clearly asInvoice Total.
- The total of item quantity, standard price, discount, unit price, unit cost, total amount, total cost and total gross profit of invoices are calculated for each salesman stated as Salesman Total.
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_11.png?version=1&modificationDate=1487230694030&cacheVersion=1&api=v2&width=800&height=131)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_12.png?version=1&modificationDate=1487230710259&cacheVersion=1&api=v2&width=800&height=397)
SP-07 Gross Profit by Department Details Report
Users will be able to view on the gross profit of each item code categorized according to the department.
- The quantity, unit price, unit cost, sales amount and gross profit amount for each item is listed in the report.
- The total sales amount and gross profit amount for each department is also calculated.
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_13.png?version=1&modificationDate=1487230725929&cacheVersion=1&api=v2&width=800&height=131)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_14.png?version=1&modificationDate=1487230741356&cacheVersion=1&api=v2&width=800&height=407)
SP-08 Gross Profit by Department Summary Report
This report is a summary of the Gross Profit By Department Details Report. This report will only list the department code with its respective sales amount, cost amount and gross profit amount in a lump sum. No details of each individual transaction is available.
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_15.png?version=1&modificationDate=1487230759271&cacheVersion=1&api=v2&width=800&height=118)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_16.png?version=1&modificationDate=1487230776907&cacheVersion=1&api=v2&width=800&height=57)
SP-09 Gross Profit by Supervisor/ Technician Details Report
This report shows the gross profit amount for each item code categorized according to the salesman or technician. The report list the unit price, sale quantity, return quantity,unit cost, total sale, total sale return, total cost, total cost return and gross profit for each item code. The Unit Price, Total Sale and GP will have two columns each, one with tax included and another without tax.
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_17.png?version=1&modificationDate=1487230793685&cacheVersion=1&api=v2&width=800&height=133)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_18.png?version=1&modificationDate=1487230808539&cacheVersion=1&api=v2&width=800&height=394)
SP-10 Gross Profit by Supervisor/ Technician Summary Report
This report is a summary of the Gross Profit By Supervisor / Technician Details Report.
It shows only the total sales, total cost and total gross profit of the respective personnel in a lump sum. It is a very straightforward report that shows the performance of the supervisor or the technician at a glance.
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_19.png?version=1&modificationDate=1487230825933&cacheVersion=1&api=v2&width=800&height=126)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_20.png?version=1&modificationDate=1487230842104&cacheVersion=1&api=v2&width=800&height=339)
SP-11 Sales Report by Salesman by Branch
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_21.png?version=1&modificationDate=1487230862138&cacheVersion=1&api=v2&width=800&height=290)
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/Screenshot_22.png?version=1&modificationDate=1487230877280&cacheVersion=1&api=v2&width=800&height=60)
Previously the date selection only display options of from until to. Now the new enhancement allows to filter the report by the Date Range of either day, month or quarter.
![](https://bigledger.atlassian.net/wiki/download/thumbnails/17367890/image2017-4-5_10-40-21.png?version=1&modificationDate=1491360027759&cacheVersion=1&api=v2&width=800&height=355)
SP-12 Sales Commission Report by Salesman