Modules‎ > ‎Manager‎ > ‎

Sales Report

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.

Daily Sales Report

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 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.


2. 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.


3. 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.


4. 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.


5. 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.


6. 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.


7. 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.


8. 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.


Transaction Aging

9. Transaction Aging 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 aging periods.


10. Transaction Aging 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.


11. Transaction Aging 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 aging summary displayed in different columns according to the accounting module aging periods configurations. This is an excellent report for credit control.


12. Collection With Invoice Aging 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 aging amount based on some complex formulas. This report is extremely useful to reward and performance appraisal of the salesman.



Gross Profit

13. 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.


14. Gross Profit By Salesman By Invoice Report

This report is useful for salesman commission calculations, as well as performance ranking and appraisal for salesmen within a company.


Other Reports

15. Official Receipt Listing

Sometimes, management would like to take a view at the details of the collections,

Home > Modules > Manager Module > Sales ReportsAll collections, from cash sales 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.


16. Monitor Outstanding Documents

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.


17. 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.


18. 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.


19. Multi Branch Daily Sales, Purchases and Collection Report

Users such as higher level management may find this report very useful. At one glance, users will be able to see the sales, gross profit, GRN, trade-in, purchases from suppliers and collection from customers. It is somewhat a brief Bird's-Eye view of the management of the business on a daily basis.


20. 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.
Ċ
Unknown user,
Mar 12, 2009, 8:11 PM
Ċ
Unknown user,
Mar 12, 2009, 3:01 AM
Ċ
Unknown user,
Mar 12, 2009, 3:03 AM
Ċ
Unknown user,
Mar 12, 2009, 3:12 AM
Ċ
Unknown user,
Mar 12, 2009, 8:20 PM
Ċ
Unknown user,
Mar 12, 2009, 7:26 PM
Ċ
Unknown user,
Mar 12, 2009, 2:53 AM
Ċ
Unknown user,
Mar 12, 2009, 7:33 PM
Ċ
Unknown user,
Mar 12, 2009, 7:21 PM
Ċ
Unknown user,
Mar 12, 2009, 9:21 PM
Ċ
Unknown user,
Mar 12, 2009, 3:10 AM
Ċ
Unknown user,
Mar 12, 2009, 8:29 PM
Ċ
Unknown user,
Mar 12, 2009, 8:14 PM
Ċ
Unknown user,
Mar 12, 2009, 8:35 PM
Ċ
Unknown user,
Mar 12, 2009, 3:33 AM
Ċ
Unknown user,
Mar 12, 2009, 7:43 PM
Ċ
Unknown user,
Mar 12, 2009, 2:57 AM
Ċ
Unknown user,
Mar 12, 2009, 7:48 PM
Ċ
Unknown user,
Mar 12, 2009, 8:06 PM
Ċ
Unknown user,
Mar 12, 2009, 8:08 PM
Comments