Sales by Customer

The Sales By Customer Report allows you to get a breakdown of your monthly sales activity by individual customer entities.  This report is ideal for

• Identifying your largest customers from a Net/Gross sales perspective
• Tracking trends in your customer sales behavior
• Assessing your risk level from a customer demographic perspective
• Identifying customers who are experiencing declining sales activity

Selecting Your Data Range

You can run the Sales by customer report for specific monthly periods.  You can start the report from a specific month and can display data for x months.

 Gross Sales vs Net Sales

You can consider Gross Sales or Net Sales (after discount) This allows you to identify which clients are receiving a large discount to their sales.

Specify Currency

You must run the sales by customer report separately for each active currency under your account.

Include Reversals

You can choose whether or not to include charge reversals in your Sales By Customer data.

Summary for Specified Period

When run the report will provide you a summary of all sales activity for the period you specified in order to give you a sense of the scale of data being looked at.

Heat Map of Top Customers

The Sales By Customer report will provide a visual representation of your top 10/25/50 or 100 customers in the form of a heat map graph.  The graph allows you to see the relative contribution of your top customers to your total sales for the period requested.  Any additional customers are grouped together in a category called “All Others”  This allows for a quick visual representation of how much of a portion of total sales are coming from your top customers.

Drill Down into Specific Customer Sales

You can drill down into any specific customer from the Heat Graph in order to see a bar graph view of the customers monthly sales activity.

Specifying Display Label

You can select to display Company name, your reference id or customer name in the heat map.  This gives you the control of how your customers should be represented depending on the data you are storing on the customer entities within Fusebill.

The Data Grid at the bottom of the Sales By Customer report provides a month by month view of the contribution your top customers made to total sales.  The data in the grid is sorted by largest contributor to the full sales period descending.  Only the top 10/25/50 or 100 customers are displayed on the screen dependent on the filter selected.

Exporting Data with Full Customer Details

You can export the Sales By Customer data.  When you do so you can select to Include Full customer details with the data in order to do your own segmentation using alternate customer level fields.  When you select to export Sales By Customer data all customers with sales activity in the period specified are included in the data as separate entries.