Dear Eric and Mei Mei,
I just wrote the following specially for the 2 of you.
You can use the following for:
1) training the new customers
2) has more things to say when doing Wavelet Demo (so you may need to memorize some bullet points inside).
all these reports are available under MANAGER -> SALES RELATED REPORT.
Thank you very much
Best regards,
Vincent
ps. I have also included the following in the manual... will be made available at
http://help.wavelet.biz when i next publish it online.
Sales Reports
There are many reports in the Manager module, all reports here are specially design to help senior management of a company make informed decisions as well as serving as a dash board to have a high level overview of the performance of the business.
1. Daily Sales Report With Cash Flow Analysis
This report shows all sales transactions being done, and the collection associated with the sales (both credit sales and cashsales). 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.
2. Gross Profit By Invoice Report
Sometimes, certain stocks within an invoice are sold below costs, but overall invoice is profitable. When managers look at the Stock Sales Report, which shows the profitability of each item being sold, it may results in too many false alarm. The Gross Profit by Invoice report solves this problem because it summarize the overall gross profit generated from each invoice, as well as sales return. It also show the sales return beside the invoice this particular invoice was subsequently reversed.
3. Stock Sales Report
Stock Sales Report provides senior management a very detailed transaction listing on all products sold and returned. The exact absolute gross profit and gross profit in percentage are generated for each of the invoice and sales return details.
4. Sales Item, CRV, 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 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.
5. Daily Invoice Summary
This report gives a very high level overview of all the invoices issued, summarized day by day, and also showing if any of these invoices are still outstanding. Management could use this report as a rough gauge of the business trend over a period of time (weeks or even months). A better report that includes Sales Report, and also provide a high level overview would be the Daily Sales Report with Inventory Category Grouping.
6. Official Receipt Listing
Sometimes, management would like to take a view at the details of the collections, all collections, from cashsales to deposit and payment for credit sales are listed here. With separate columns on cash, cheques, post dated cheques, credit cards etc, managers will be able to get a firm grasp of the cash flow for the company. User will be able to drill down to individual Official Receipt, and trace the invoices accordingly through the user friendly interface.
7. Daily Receipt Summary
This report is a condense version of Official Receipt Listing, providing a high level overview of all cash flowing into the company within a range of dates.
8. Periodic Stock Balance and Movement Summary / Periodic Stock Balance and Movement By Category
This computationally intensive report shows the details movement of the stocks, from purchases to purchase return, sales to sales return, trade-in, stock transfer etc. The gross profit and cost of goods sold are also displayed here. It is an excellent report for store managers to have a very complete view of the entire flow of inventory items in the company, profitability of stocks, and giving out stock replenishment instructions optimally.
9. Monitor Outstanding Invoice
Monitoring customer credit is extremely important. This report consolidates outstanding invoices grouped by customer from various branches on a real time basis. All customer accounts that have exceeded credit limits or credit terms will be highlighted. Managers could suspend or black list these accounts to prevent further credit sales to these accounts to better control the credit risk.
10. Detailed Sales Record by Customer
This report allow users to generate the detailed transactions (Sales and Sales Return) for a specific customer. With this report, users will be able to see exactly how much gross profit has been generated from each customer from the transaction history. Useful for Customer Relationship Management.
11. Gross Profit By Salesman By Invoice
This report is useful for salesman commission calculations, as well as performance ranking and appraisal for salesmen within a company.
12. Stock Sales Report By Item Code
This report display the sales, gross profit and also balance quantity for each of the item code. User could also group the reports based on different category levels. Some users find it extremely useful to analyze this report while doing stock replenishment. Sometimes, best selling stock may be low margin stock, and high margin stock may be moving slowly. So, with all these information consolidated in a single report, decision makers will be able to decide what are the stocks to be replenished, what brands are best sellers, what type of products bring in most profit and so on.
13. Transaction Ageing Analysis
This report is similar to Monitor Outstanding Invoice Report, where all outstanding documents are displayed. Instead of showing the exact number of days where a document is outstanding, this report display them into various columns, based on the configurations in the accounting module for various ageing periods.
14. Transaction Ageing Summary By Customer
This report is similar to Monitor Outstanding Invoice Report, but the details of each documents are omitted. Only a list of customers, with their respective ageing summary displayed in different columns according to the accounting module ageing periods configurations. This is an excellent report for credit control.
15. Transaction Ageing Summary By Branch
To effectively manage a chain store, certain customers may buy from multiple branches hence performance of the branch managers in chasing for collections should be monitored accordingly. This report helps senior management to control the people who control the credit risk of the company.
16. Collection With Invoice Ageing Report
Certain companies reward their salesmen according to how fast they manage to collect from their customers. For the same amount of sales, if the salesman collect faster, they get rewarded faster. This report shows all the collections within a period of time, and analyze each of the collection, to compute the corresponding age of the collection based on the invoice dates. As one receipt (settlement) could be done for multiple invoices, and there could also be partial settlements for certain invoices, the report is smart enough to compute the exact ageing amount based on some complex formulas. This report is extremely useful to reward and performance appraisal of the salesman.
17. Sales Report By Invoice With Inventory Category Grouping
This report is extremely useful to get a quick feel of the sales amount, and its breakdown according to various category levels.
18. Daily Sales Report With Inventory Category Grouping
This report is similar to Daily Invoice Summary, or better. Not only it consolidates the sales and sales return, users will also be able to see the summary of net sales for each category level on a daily basis. If one of the categories are used to define departments, this report could essentially transform into a department performance report.
19. Purchase Report By GRN with Inventory Category Grouping
With this report, procurement managers will be able to see the type of products being replenished within the company, at a high level overview.
--
1) Being Second is the First Loser.
2) Our Vision: A linux server for every company and accessible everywhere through internet, running Wavelet Software.
--------------
WAVELET SOLUTIONS SDN BHD 632468W (
www.wavelet.biz)
GC-43, Ground Floor, Block C,
Kelana Square, 17 Jalan SS7/26,
Kelana Jaya, 47301 Selangor, Malaysia.
H/P: +6012-6018838
Tel: +603-78042207
Fax: +603-78042281
-------------
CONFIDENTIAL NOTE:
The information contained in this email is intended only for the use of the individual or entity named above and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete the mail. Thank you.
