Skip to main content

Sales by Customer Report

Overview​

The Sales by Customer Report provides detailed analysis of sales performance by customer account, helping businesses identify their top revenue-generating customers, analyze sales trends, and understand customer purchasing patterns over selected time periods. This report is essential for account management, sales strategy, and customer relationship prioritization.

When to Use This Report​

Use this report when you need to:

  • Identify top customers by revenue contribution
  • Analyze sales trends by customer account over time
  • Evaluate customer purchasing patterns and frequency
  • Prioritize account management efforts based on revenue
  • Compare customer performance across different periods
  • Prepare customer-specific sales presentations
  • Segment customers for targeted marketing or sales campaigns
  • Track customer growth or decline in purchasing volume
  • Support customer credit limit review decisions

How to Run the Report​

Step 1: Navigate to Sales Reports​

Access through main navigation: Reports → Sales Reports

The Sales Reports page displays available report types.

Step 2: Select Report Type​

Reports Dropdown

Click the Reports dropdown and select Sales by Customer Report from the list.

The filter panel updates to show relevant filters for this report.

Step 3: Configure Time Period​

Apply time period filter to define the analysis window:

Time Period Selector

Select from predefined periods or custom range:

  • Click Time Period dropdown
  • Options available:
    • Today - Sales for current day only
    • This Week - Current week's sales (Monday to Sunday)
    • This Month - Current month's sales (1st to last day)
    • This Quarter - Current quarter (Q1: Jan-Mar, Q2: Apr-Jun, etc.)
    • This Year - Current fiscal year sales
    • Custom Range - Select specific start and end dates

The report aggregates all sales transactions (orders and invoices) within the selected period.

Step 4: Run Report​

Click Run Report button to generate the report.

The system calculates total sales by customer for the selected period and displays results grouped by customer account.

Understanding the Report​

Report Structure​

The report displays as a customer-wise summary table. Based on the screenshot showing the report title, the typical structure includes:

ColumnDescriptionExample
Customer NameCustomer business nameAMAR ENTERPRISES, Connaught Place INvent, TechCorp Industries
Total Sales AmountSum of all sales to this customer in period₹15,45,000.00, ₹8,32,500.00
Number of OrdersCount of sales orders placed12, 8, 5
Average Order ValueTotal Sales ÷ Number of Orders₹1,28,750.00, ₹1,04,062.50
Last Order DateMost recent order date15-09-2025, 02-10-2025

Note: Actual columns may vary based on system configuration. Report shows customer-wise aggregated sales data.

Understanding Key Metrics​

Total Sales Amount

Aggregate revenue generated from all sales to this customer during the selected period. Includes:

  • All sales orders (invoiced and unbilled)
  • Multiple transactions summed together
  • GST-inclusive amounts
  • Net of any returns or credit notes

This metric identifies your highest-revenue customers and their contribution to overall sales.

Number of Orders

Count of distinct sales orders placed by the customer in the period. This metric reveals:

  • High frequency buyers - Many orders indicate regular purchasing
  • One-time buyers - Single order may need nurturing for repeat business
  • Purchasing patterns - Regular intervals vs sporadic orders

Compare with total sales to understand if customer places few large orders or many small orders.

Average Order Value (AOV)

Calculated as Total Sales Amount ÷ Number of Orders. This metric helps:

  • Identify high-value customers (high AOV)
  • Segment customers by transaction size
  • Set account management priorities
  • Design pricing strategies for different customer tiers

Example: Customer A with ₹10L sales from 2 orders (AOV ₹5L) requires different service than Customer B with ₹10L sales from 50 orders (AOV ₹20K).

Last Order Date

Most recent order date shows customer recency:

  • Recent dates - Active customers with current engagement
  • Old dates - Inactive customers at risk of churn
  • Gap analysis - Long gaps since last order indicate potential issues

Combine recency with frequency and monetary value for RFM (Recency, Frequency, Monetary) customer segmentation.

Working with Report Data​

Example Scenarios​

Scenario 1: Top Customer Identification

Run report for "This Year" to see annual performance. Sort by Total Sales Amount descending to rank customers by revenue contribution.

Example results:

  1. Connaught Place INvent: ₹48,85,000 (32% of total sales)
  2. AMAR ENTERPRISES: ₹18,45,000 (12% of total sales)
  3. TechCorp Industries: ₹12,30,000 (8% of total sales)

Focus account management resources on top 20% customers generating 80% of revenue (Pareto principle).

Scenario 2: Customer Churn Risk Analysis

Run report for "This Quarter" and review Last Order Date column. Identify customers with:

  • No orders this quarter but had orders last quarter
  • Last order date more than 90 days ago
  • Declining order frequency compared to previous periods

Action: Proactive outreach to at-risk customers with special offers or check-in calls to understand any issues.

Scenario 3: Account Growth Opportunities

Compare "This Year" vs previous year using two separate report runs:

  • Export both reports
  • Match customers across periods
  • Calculate growth percentage per customer

Identify customers with declining sales for win-back campaigns and customers with growing sales for upselling opportunities.

Scenario 4: Customer Segmentation

Export the report and segment customers into tiers:

Platinum Tier (Top 10% by revenue):

  • Total sales > ₹20L annually
  • Dedicated account manager
  • Priority support and custom pricing

Gold Tier (Next 20%):

  • Total sales ₹5L - ₹20L
  • Regular quarterly reviews
  • Volume discounts

Silver Tier (Next 30%):

  • Total sales ₹1L - ₹5L
  • Standard service
  • Seasonal promotions

Bronze Tier (Remaining 40%):

  • Total sales < ₹1L
  • Self-service model
  • Nurture campaigns for growth

Comparative Analysis​

Month-over-Month Comparison

Run report for "This Month" and save/export results. Next month, run again and compare:

  • Which customers increased purchases?
  • Which customers decreased or stopped?
  • Are new customers appearing?
  • What's the growth rate in customer base?

Quarter-over-Quarter Trends

Export quarterly reports to build trend analysis:

  • Q1 2025 total: ₹2.5Cr across 45 customers
  • Q2 2025 total: ₹3.1Cr across 52 customers
  • Growth: 24% revenue, 15.6% customer count

Track these metrics to measure business health and sales team performance.

Customer Insights​

High-Value Customer Profile​

Customers appearing at the top of this report (highest Total Sales Amount) deserve special attention:

Relationship Management:

  • Assign dedicated account managers
  • Schedule regular business review meetings
  • Offer preferential payment terms
  • Provide exclusive product previews
  • Faster support response times

Risk Management:

  • Over-dependence on few customers is risky
  • If top 3 customers represent >50% of sales, diversify
  • Build deeper relationships to reduce churn risk

Dormant Customer Activation​

Customers with old Last Order Date but historical high sales are valuable reactivation targets:

Win-Back Strategy:

  • Personal outreach from sales manager
  • Understand reason for decreased purchases
  • Offer "we miss you" discount or incentive
  • Update them on new products/services
  • Request feedback on areas for improvement

Small Customer Growth​

Customers with low Total Sales but high order frequency show potential:

  • They trust your business (repeat orders)
  • Currently buying small quantities
  • May have growth potential as their business grows
  • Nurture relationship for future expansion

Export and Strategic Use​

Exporting Data​

Click Export icon to download the report in Excel or CSV format.

Strategic applications:

Sales Team Performance:

  • Assign sales reps based on customer revenue tiers
  • Set targets based on historical customer performance
  • Identify which sales rep manages top customers

Financial Planning:

  • Forecast revenue based on customer trends
  • Estimate accounts receivable by customer
  • Plan credit limits based on purchasing patterns

Marketing Campaigns:

  • Target high-frequency buyers with loyalty programs
  • Create win-back campaigns for dormant customers
  • Develop upsell campaigns for mid-tier customers

Inventory Planning:

  • Understand which customers drive demand for which products
  • Plan stock based on major customer purchasing cycles
  • Anticipate seasonal demand from key customers

Quick Tips​

Best Practices

Run this report monthly and create a "Customer of the Month" recognition program for the top revenue contributor to strengthen relationships.

Compare quarterly reports to identify declining customers early, enabling proactive retention efforts before they completely stop purchasing.

Use the Last Order Date to set up automated email campaigns for customers who haven't ordered in 60+ days with personalized product recommendations.

Calculate what percentage of total sales your top 10 customers represent - if over 70%, implement customer diversification strategy to reduce business risk.

Need help? Contact support at support@bizconnekt.com