Customer Profitability Report

Customer Profitability Report

This report module prints a ranking of customers by either total sales, total profit, or total gross margin. It shows this information for the current month and for the year. It is an extremely useful report for the accounting department as well as for the sales department. When you enter this module, an A/R Customer Profitability Report screen will appear as follows: 



The default settings appear in the screenshot above. In the first box, the Customer option will rank all Customers together. The other option is to rank each Territory group together. In the Sort By box, the default Sales option will rank Customers in order of highest sales to lowest sales. If you select Profitthe report will rank Customers in order of highest total profit earned to lowest total profit earned. If you select Margin, the report will rank Customers in order of highest overall gross margin to lowest gross margin. The Skip Customers With No YTD Activity, when checked, will leave off Customers with no activity for the year. Make any applicable changes and then either click the Excel icon in the top left to export the data, or click the Print button for paper output.


    • Related Articles

    • Customer Reference Listing

      This is a much simpler customer listing report. It shows the Customer ID, the Customer name and address information, the telephone number, the Customer’s Credit Status and Credit Limit, and the Territory Code and Salesperson ID assigned to ...
    • Overbill Overhead Job Cost Margin Rpt

      This report module works the same as the Job Cost Margin report module accessible from the Job Cost menu. The only difference is that when the Overhead and Overbill features are utilized in the system, an owner/manager must use this report to view ...
    • Customer Payment Register

      CUSTOMER PAYMENT REGISTER (DAILY REPORT): This report module displays a listing of all customer payments that were posted in the system through the Post Customer Payments module, via the “Receive Money” feature, or through either of ...
    • Customer Mailing Labels 3up

      This module will allow you to print a mailing label for every Customer in the RollMaster System. It can be customized in many ways in order to allow you to perform target mailings. This mailing label report is formatted for 3up laser printer label ...
    • Track Displays For Sales Analysis

      In order to know how a particular display rack is doing sales/profit/margin wise within your store, you will need to perform some setup in your Catalog so you can generate sales analysis on the displays. This starts by creating a User Defined File ...