Sales Analytics & Performance Reports in ERPNext
Sales Analytics in ERPNext provides a real-time, filter-driven view of your sales performance across Leads, Quotations, Sales Orders, and Customers.
It helps you track trends, conversion rates, and revenue performance using graphical and tabular insights.
In :contentReference[oaicite:0]{index=0}, sales reporting is designed as an interactive analytics layer.
Instead of static reports, most views are dynamically filtered and updated based on user selections.
1. Sales Analytics Report
The Sales Analytics report provides a multi-dimensional view of sales data with three main components:
- Filter Toolbar – Controls what data is included (company, customer, item, date range, etc.)
- Graph Window – Visual representation of sales trends
- Data Window – Drill-down table for detailed analysis
As filters are changed, both the graph and data views update instantly, enabling quick comparison across dimensions such as Item Group, Territory, Customer, and Sales Person.
The data window supports drill-down analysis. You can expand or collapse levels (for example: Territory → Customer → Item) without changing the report structure.
You can also customize charts using the Set Chart option by defining X-axis, Y-axis, chart type, and colors for better visualization.
2. Sales Funnel Report
The Sales Funnel report shows how leads move through the sales pipeline, giving a clear view of conversion efficiency.
Stages in the Funnel
- Active Leads – Total leads in the system
- Opportunities – Leads converted into opportunities
- Quotations – Leads where quotations are created or submitted
- Converted – Leads converted into customers and sales orders
This report helps identify drop-off points in your sales process and measure how efficiently leads are being converted into revenue-generating customers.
3. Customer Acquisition & Loyalty Report
This report separates customers into new vs existing segments to analyze loyalty and retention trends.
It is useful for understanding repeat purchase behavior and revenue concentration.
Key Features
- Dynamic Filtering – Apply company and date filters instantly
- Sortable Columns – Rearrange and sort data for analysis
- Inline Filtering – Filter directly within the table view
This helps businesses identify whether growth is driven by new customer acquisition or repeat business from existing customers.
4. Additional Sales Reports (Key Insights)
- Inactive Customers Report
- Ordered Items To Be Delivered
- Sales Person-wise Transaction Summary
- Item-wise Sales History
- Quotation Trends & Sales Order Trends
- Customer Credit Balance
- Sales Partner Commission Reports
SUMMARY
Sales Analytics in ERPNext provides a complete performance monitoring system using interactive filters, graphs, and drill-down tables.
It includes Sales Analytics, Sales Funnel, and Customer Loyalty reports that help businesses track conversion efficiency, revenue trends, and customer behavior.
Together, these tools give a full picture of how sales are generated, converted, and retained across the organization.
