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 Grouping | 1. 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 Grouping | 1. 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 Code | 1. 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 Monthly | 1. 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 Report | 1. 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.
|
