Dashboard and Report Samples for Sales

Home/Dashboard and Report Samples for Sales

Download full list or reports, dashboards and KPIs

The following is a sample from over 1,300 reports, dashboards and KPIs for analyzing invoiced sales, quantity sold cost of sales, gross profit and returns by customer, acct manager, product, customer address, ship to, location/warehouse, and several other dimensions. Please contact us to discuss other templates you might be interested in.

SA Sales – Sample Dashboards

Top Performers 

Shows top sales this year. We also have this for quarter and month.

top-sales-and-gp-this-year

360-degree View of your Business Operations

The example below shows customers with outstanding receivables (brown color indicates clients with AR past due amounts), all CRM opportunities with high probability of closing, orders to be shipped, actual sales and gross profit, all according to selected filters (in this example: this quarter and by an account manager).
Similar dashboards can show information by product, territory, account manager and other dimensions that work across the involved data sources. This dashboard is not available out-of-the-box. However, it’s easy to set it up if your organization has the data to populate it (contact us for details).

Ship To by Customer

The user searches/selects a customer from the drop down list, and query shows their sales in the same month in the last 2 years. Red colors indicate that there’s a sales decline comparing to last year. This can be helpful to address declining sales and see why certain regions are doing better than others. We have similar dashboards by product and salesperson.

customer-shiptos

Customer Trends 

  • Similar to the dashboard above. The rep can select a customer and:
    See sales trends by month
    See which products have declining sales from the same period last year. If the rep is in a call with the client, the rep can investigate reason for sales declines.

We have similar dashboards by product and salesperson.

customer-trends

Top Sales Increase and Decrease by Customer

It shows which clients are growing the most and declining the most since  last YTD  (also for QTD and MTD).
We have similar dashboards by product, customer address, ship to and salesperson.

top-ytd-sales-change-by-customer

Top Sales Increase and Decrease by Product

It shows which products are growing the most and declining the most since  last QTD (also for MTD and YTD).
We have similar dashboards by customer, customer address, ship to and salesperson.

top-qtd-sales-change-by-product

Top Products and their ShipTos

Dashboard shows top products and their sales by ShipTo. User can change number of top products, as well as what period to look at.
This can be helpful addressing logistics and shipping methods for top products.

top-products-by-sales-shipto-sales


Sales of Top Products to Top Customers

Ideally, top customers should be buying lots of top products. If not, why not?
There are similar reports showing sales of top customers and top products by different dimensions such as salespeople, ship to, and cst address.

top-customers-and-top-products-sales


Company wide Monthly Sales Trends

Shows company wide sales trends (sales, accumulated sales, and growth). We also have this by year.

sales-trends-by-month-trends

QTD Sales and Year-over-Year Sales Growth (customer focus)

A detailed report showing quarter-to-date sales this and last year by salesperson and customers (and other dimensions as well). Why some of them (red fonts) are declining? Can you do something about it? We have similar dashboards by product, customer address, ship to and salesperson (also by company in multi-company systems).

sales-same-quarter-across-years-by-salesp-and-cst

QTD Sold, Sales and Year-over-Year Sales Growth (product focus)

A detailed report showing quarter-to-date sales this and last year by product and salesperson. Why some reps are more/less successful than others pushing products out?

sales-same-quarter-across-years-by-prod-and-salesp

Top Sales Decline by Customer (no sales in this vs last period)

This report is usually useful to find out which major customers aren’t buying anymore (we have this for last 30, 90 and 360 days. It’s easy to change the time buckets).
We have similar dashboards by product, customer address, ship to and salesperson.

sales-decline-by-customer-no-sales-this-360-days

Top Sales Decline by Product (no sales in this vs last period)

This report is usually useful to find out which major selling items aren’t selling anymore (we have this for last 30, 90 and 360 days. It’s easy to change the time buckets).

We have similar dashboards by customer, customer address, ship to and salesperson.

sales-decline-by-product-no-sales-this-90-days

Sales Growth from the Same Period in prior Year(s) by Customer

A detailed report showing monthly sales and growth from the same period prior year(s). Amounts in red means decline from the same period in the prior year.
We have similar dashboards by product, customer address, ship to, and salesperson (also by company in multi-company systems).

customer-sales-yoy

Sales Growth from the Same Period in prior Year(s) by Product

A detailed report showing monthly sales and growth from the same period prior year. Amounts in red means decline from the same period in the prior year.
We have similar dashboards by customer, customer address, ship to, and salesperson (also by company in multi-company systems).

product-sales-yoy

Invoice Trends

Is it important for your organization to monitor average amount per invoice, invoice count, average items per invoice, and average days between invoices? Our dashboards and reports will provide you with a great starting point.
The example below shows average invoice amount and invoice counts over time. As shown, there’s a clear pattern of average invoice amounts to decrease from Jan to Dec.

sales-trends-by-invoice

What-If Forecast

This is an example of what-if scenarios where the forecast is calculated by applying user-defined growth and churn rate to actuals from period periods. Forecast can be calculated in a variety of ways or imported from other data sources (such as Excel or dedicated forecast systems).

what-if-forecast

Actual versus Budget

This is an example of actual versus budget where the budget is calculated by applying a user-defined growth to actuals from period periods. Budget can be calculated in a variety of ways or imported from other data sources (such as Excel or budgeting systems).

actual-versus-budget

Sales Ranking by Customer 

How are your most important customers ranking on a year basis? Are they going up or down on sales ranking? See example below where customer #9 from Total dropped to rank 44 in 2016.

sales-ranking-by-customer

Sales Ranking by Product

How are your most important products ranking on a year basis? Are they going up or down on sales ranking? See example for customer ranking above for ideas of how this insight can be valuable.

sales-ranking-by-product

Sales Projections by Customer

DataSelf Analytics has different ways to project your sales (expenses, etc) based on different parameters (such as past performance, outstanding orders, and other inputs – example CRM opportunities).

sales-projections-by-customer


Sales Projections by Product

DataSelf Analytics has different ways to project your sales (expenses, etc) based on different parameters (such as past performance, outstanding orders, and other inputs – example CRM opportunities).

sales-projections-by-product


Comparison of YTD vs PYTD Sales by Customer

A report showing customer sales this YTD, prior YTD, YTD variances and full last year. The cart quickly shows box sizes based on YTD variance, and color based on growth/decline.

sales-ytd-vs-pyd-by-customer


Comparison of YTD vs PYTD Sales by Product

A report showing product sales this YTD, prior YTD, YTD variances and full last year. The cart quickly shows box sizes based on YTD variance, and color based on growth/decline.

sales-ytd-vs-pyd-by-product


Sales Decline this 90 days by ShipTo

If ShipTo is critical, this dashboard shows sales variances this 90 days (it’s easy to change the time buckets). You can see the data across all sales or filter it by customer and/or product.

sales-change-this-90-days-by-shipto


Moving Averages

Is it important to monitor moving averages? Dashboards like the one below will help you monitor moving averages in different parts of your business. It’s easy to change the period included in the report as well as the period to calculate the moving average (such as avg among 3, 6 and 12 months).

product-3-mo-moving-avg

Top Sales Last QTD vs This QTD

This allows the monitoring of how top performers in the last QTD are doing in this QTD. Ideally, they are doing better now. These dashboards cover dimensions such as Salesperson, Customer, Product and ShipTo.

top-sales-last-vs-this-qtd

Sales and Gross Profit Scatter Plots

These dashboards can show outliers or trends that might not be so obvious. In the example shown here, Salesperson=Ingrid has a profitability way below than everyone else.

sales-and-gp-scattered-plots

Download full list or reports, dashboards and KPIs

DataSelf provides plug-and-play templates for the following ERP systems:
Acumatica
Everest
MS Dynamics 365
MS Dynamics AX
MS Dynamics GP
MS Dynamics NAV
MS Dynamics SL
NetSuite
Sage 100
Sage 300
Sage 500
Sage Pro
Sage X3
Contact us to discuss other ERP systems.