Sales by Customer Report

The Sales by Customer Report in GlassJar gives businesses a detailed breakdown of total sales attributed to each customer over a selected period. This report captures invoices, sales receipts, credit memos, and customer payments, and organizes them by customer name. For each listed customer, it displays the total amount of revenue generated, allowing business owners, bookkeepers, and sales managers to see exactly who their top customers are and how revenue is distributed across the client base.

Unlike broader income summaries or general revenue reports, the Sales by Customer Report is highly targeted. It focuses on relationships, performance trends, and customer value—making it an indispensable tool for evaluating sales strategies, customer retention, and growth opportunities. The report supports custom filters for dates, products or services sold, customer groups, and even sales representatives, allowing for tailored insights based on how the business is structured.

Add Template

Available Data

• Customer Name
• Customer Email
• Customer Address
• Transactions

Available Filters & Sorting

• Transaction Date
• Customer Name
• Customer Address
• Transaction Amount

Available Totals

• Customer Count
• Transaction Count
• Revenue

COMING SOON

Why Businesses Use the Sales by Customer Report

Understanding which customers drive the most revenue is fundamental to strategic planning and customer relationship management. The Sales by Customer Report helps answer critical questions such as:

• Which clients are generating the highest sales volume?
• Are there dormant customers who haven’t purchased recently?
• What percentage of sales is concentrated among a few clients?
• Are there seasonal trends in client activity?

This report allows business owners to measure performance not just by what was sold, but to whom it was sold. It offers the ability to evaluate the impact of marketing campaigns, track the effectiveness of loyalty programs, and detect shifts in purchasing behavior. This level of insight allows companies to prioritize high-value relationships and address underperforming segments before they affect profitability.

How to Access and Use the Report in GlassJar

Within the GlassJar reporting dashboard, users can locate the Sales by Customer Report under the Sales & Revenue category. Once opened, the user is prompted to define the reporting window—monthly, quarterly, year-to-date, or a custom range. The software pulls all relevant sales data and displays the results as a table, with customer names in rows and total sales figures in columns.

Users can drill into each customer’s row to view a list of underlying transactions. This detailed view includes invoice numbers, payment dates, products or services purchased, and the salesperson responsible, if applicable. Totals can be grouped by product type, customer type, or location to gain deeper insights into purchasing patterns.

The report can also be exported in multiple formats, including PDF and Excel, for use in team meetings, sales strategy planning, or client performance reviews. Because GlassJar’s reports are built on real-time transaction data, there is no need for manual updates—every figure reflects the most current activity in your business.

GlassJar also supports tagging and filtering functionality, allowing businesses to segment customer data in the way that works best for them. Tags such as “wholesale,” “retail,” “monthly client,” or “enterprise” can be used to create focused versions of the report that align with internal sales categories.

Key Use Cases for the Sales by Customer Report

Identify Top Revenue Contributors

One of the most common uses of this report is identifying which customers are contributing the most to your bottom line. This allows companies to reward loyalty, provide enhanced service to VIP clients, or plan retention strategies for high-value accounts. Many businesses use this report to rank customers by revenue and use that data to shape future outreach or upgrade campaigns.

Monitor Sales Rep or Account Manager Performance

For businesses that assign customers to specific sales reps or account managers, the Sales by Customer Report can be filtered to display revenue per rep. This helps in setting and evaluating sales goals, distributing leads more effectively, and recognizing high-performing team members. If customer groups are assigned to reps, trends in client activity can also point to training needs or strategy adjustments.

Track Customer Lifetime Value

By running the report over a longer period—such as one, two, or three years—businesses can approximate customer lifetime value. This view helps in marketing investment decisions, especially when evaluating whether customer acquisition costs are justified by the revenue those clients ultimately bring in. If the data shows that some customers grow in value over time while others drop off after an initial sale, sales teams can refine targeting strategies accordingly.

Analyze Seasonal Buying Behavior

Some industries experience heavy fluctuations in sales by season, such as retail, construction, or hospitality. The Sales by Customer Report helps spot these trends at the customer level. For example, you may notice that a key customer places large orders in Q4 every year. With that knowledge, your team can prepare for those surges, plan inventory needs, or offer early order incentives to lock in the sale.

Detect Dormant or Declining Clients

A sudden drop in customer activity can be an early warning sign of dissatisfaction, competitor poaching, or financial issues on the client’s side. By running the Sales by Customer Report over sequential periods, users can flag customers who haven’t purchased in the past quarter or whose order frequency has slowed down. This insight allows the team to intervene, check in, and potentially save the relationship before it’s lost for good.

Prepare for Client Meetings or Sales Reviews

Before meeting with a client, reviewing their data in the Sales by Customer Report gives sales teams a valuable summary of the relationship. It shows total purchase history, sales growth or decline, and patterns in product or service preferences. This prepares account managers to offer personalized recommendations, suggest relevant upgrades, or pitch additional services in a data-backed, informed way.

Similar Accounting Reports in GlassJar

While the Sales by Customer Report focuses on individual customer sales totals, GlassJar offers several complementary reports that provide additional insight into business performance from different angles.

Profit and Loss Report

The Profit and Loss Report gives an overall view of income and expenses across the entire business, helping you determine if you’re operating at a profit. While it doesn’t break revenue down by customer, it helps frame total income in the context of costs and shows net profitability over time.

Sales by Product or Service Report

This report breaks down sales based on what was sold, rather than who bought it. It is often used alongside the Sales by Customer Report to understand which items or services are most popular and which customers are driving demand for specific offerings.

Accounts Receivable Aging Report

If your business offers payment terms, the Accounts Receivable Aging Report helps monitor unpaid invoices grouped by how long they’ve been outstanding. It is especially useful when cross-referenced with the Sales by Customer Report. A client may generate large amounts of revenue but pose a cash flow risk if they’re consistently late in paying.

Customer Statements

For businesses that issue statements to clients showing balances, payments, and outstanding invoices, customer statements are useful as a supplement to the Sales by Customer Report. These statements can be generated for one client at a time, and are often used in follow-ups for overdue payments.

Sales Tax Liability Report

This report shows sales tax collected and owed, grouped by jurisdiction. When paired with the Sales by Customer Report, it helps ensure accurate tax filing and compliance, particularly in businesses that operate across multiple states or countries.

Customization and Filters for Greater Insight

GlassJar gives users powerful tools to tailor the Sales by Customer Report to meet specific business needs. Filters can be applied based on date range, customer tags, products sold, location, payment method, or even custom fields set up in the customer profile. These filters allow teams to create variations of the report for different departments or strategic goals.

Users can choose to display totals only, or include itemized transactions for each customer. The layout can be modified to include columns such as invoice number, date, item sold, or payment status. These customization options turn the Sales by Customer Report into a dynamic, insight-rich resource that adapts to your workflow and objectives.

Whether used for daily monitoring or quarterly reviews, the Sales by Customer Report in GlassJar offers a clear, actionable look into your customer revenue distribution. It supports better client management, strategic growth decisions, and long-term financial planning—all from a simple, centralized dashboard that updates in real time.