Modules‎ > ‎Manager‎ > ‎

Sales Reports

 Report Name
 Step By Step Guide
 Description / Usage / Benefits
Daily Sales Report With Cash Flow Analysis
1. Select 'All Branches' or a Branch.
2. Set the date range for the report.
3. Choose whether you want to view:
  • Company name
  • Contact person and company name

This report shows all sales transactions being done, and the collection associated with the sales (both credit sales and cash sales). Other collections like deposits and collection for previous sales are also included in this report. Users will find this report extremely informative to capture the entire performance of the business for a period of time. With detailed payment modes summarized in different columns, one will be able to know exactly the cash flow in relation to sales.
  • A very detailed report to display cash, credit card, cheque, post dated cheque, voucher and other collection based on a date range specified.
  • Cash collection for current sales, deposits collected and collection for previous invoices are clearly separated
  • Sales Return with hyperlinks showing corresponding invoices enable easy cross referencing
  • An excellent report to look at the cash flow, sales, sales return and various daily transaction in a bird's eye view.

Daily Invoice Summary
1. Select 'All Branches' or a Branch.
2. Choose a user who issued the invoices.
3. Enter date range From and To Date.
From this report, managers will be able to check on users who invoice on a daily basis. This report enable managers to keep track of amount invoices issued and how much has been paid. For example:
  • Number of invoices for the day.
  • Minimum amount invoiced.
  • Maximum amount invoiced.
  • Average amount is automatically calculated.
  • Total invoice amount.
  • How much from the total amount invoiced for the day is still outstanding (not paid).
 Daily Sales Report By Invoice With Inventory Category Grouping1. Select 'All Branches' or a Branch.
2. Enter date range From and To Date.
3. Tick on Salesman and select a Salesman name (if you want to view report based on his / her Sales).
4. Select Inventory Category Grouping - Level 1 to 5 (all items under this category will appear).
Sales Report of Quantity and Amount based on each product type in the chosen Category Grouping. This report can also be filtered by Salesman and at the same time, calculate Salesman Commission ,manually (if applicable). Example given:
  • Sales Amount - Sales Discount = Sales Standard Price
  • Sales Amount - Return Amount = Net Sales
  • Quantity and Amount for each Brand (Category Grouping) sold on that day.
  Sales Report By Invoice With Inventory Category Grouping1. Set Branch or All Branches.
2. Enter Date Range - To and From.
3. Salesman - Select a name and tick the check box.
4. Inventory Category Grouping.
A more detailed report is incorporated here for further analysis. When it comes to calculate salesman's commision, this report is quite useful. For each Category Grouping, the sales amount, quantity and discounts given for every invoice is displayed here. To view the Invoices, just click on the Invoice PKID to see the items sold separately.
 Stock Sales Report
1. 'Select  All' branches or 1 Branch(es).
2. Enter date range.
3. Tick the checkbox and select a salesman name (only if you want the report based on his stock sales).
4. If you have the item code, enter a specific one or a range or leave it blank to view all the items codes.
5. Select Item Category and tick the checkbox.
6. Sort by : Time or Item Code - means in the report, how the items comes in sequence.
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%
 Stock Sales Report By Item Code
1. Set Date range.
2. Location - All or 1 stock location.
3. Select Item Category Filters and tick the box.
4. Group by - Will appear in Blue and Black fonts (2 Groups).
5. Order by - Item Name (Check box).
Stock Sales by Item Code is quite similar to Stock Sales Report, except that it's less detailed and is grouped by Group 1-5. It shows :
  • Balance = Stock quantity left in inventory.
  • Quantity sold = Deduction from inventory. (Negative amount) is actually a Sales Return.
  • Amount = Quantity sold x Unit price.
  • COGS = Cost of the stock sold x Quantity
  • GP = Amount - COGS
  Stock Sales Details Report By Item Code1. Select a date range, applies to invoice and sales return dates.
2. Select Location.
3. Select category filters, if any.
4. Select Group by criteria, if any.
5. Select Order by criteria, if required.
 This report displays a summarized sales report within the specified date range, optionally limited by locations and item categories, broken down by item codes. You can track how much an item has been sold within the time period as well as total sales value, cost and gross profit.
 Sales Report By Daily, Weekly or Monthly1. Set Branch or All Branches.
2. Fuzzy Search (Optional)
3. Item Code (O)
4. Item Category (Level 1-5) (O)
5. Status (Default - Active).
6. Salesman.
7. Customer Name (O)
8. By - Select how you want to view the report - Day / Month.
9. Date.
One Advantage of this report is that, it allows users to do comparison between 2 or more months. You can check the Sales for each Item Code and compare with other days / months. According to this report, you can also see which item sells better, and take in more stock on that item code. Whichever sells poorly as compared to previous months, you can either keep less stock (stock order level) or instruct the salesman to push for that item code.
 Sales Item, CRV and Finance Charges Report1. Select a Branch or All Branches.
2. Invoice Date - To and From.
3. Select by Item Code or Inventory Category.
4. Sort By - Item Code / Invoice Date.
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 Cash Rebate Vouchers were given to customers based on each item, or if the customers pay using Easy Payment Scheme (IPP) 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.


1. Select Branch
2. Set a Date Range
3. Tick on the check box to select
customer account (only if users want to view report of a specific customer)

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. This report contains the following details:
  • Date
  • Invoice number or the Sales Return number
  • User usually refers to the salesman
  • Customer
  • Sales Amount
  • Cost Amount
  • Outstanding Amount
  • GP Amount = Sales Amount - Cost Amount
If the Sales Amount is lower than the Cost Amount, then the text for the entry will be in red.

Unknown user,
Oct 23, 2009, 2:52 AM