How the Report Works
The report groups eligible sales transactions by customer rather than presenting only a company-wide total. Users generally select a reporting period and relevant criteria, then review the resulting customer-level figures. The available detail depends on the report version, selection settings, and data recorded in Sage 100.
Customer records provide the basis for grouping transactions. Sales invoices and related transaction details contribute to reported activity, while credit memos, returns, discounts, and other adjustments may affect the figures depending on the report's configuration. Before comparing results, confirm whether the selected report reflects invoiced sales, posted transactions, or another defined sales basis.
A Sales Order records a customer's request to purchase goods or services, while the sales report helps users review sales activity after relevant transactions have been recorded. Reviewing Sales Order Processing alongside the report can help teams trace order activity through fulfillment and billing. Sales Order Verification also supports reliable reporting by checking key order details, such as customer identity, pricing, quantities, and terms, before transactions move forward.
Key Figures and Customer-Level Analysis
The report's value comes from interpreting customer totals in context. Depending on the fields available, users may examine sales amounts, transaction counts, and period comparisons to identify important customer relationships and changes in demand.
- Sales by customer: Shows the sales amount associated with each customer during the selected period.
- Customer contribution: Indicates how much a customer contributes to total reported sales.
- Period comparison: Highlights increases or decreases in customer purchasing activity when comparable periods are available.
- Transaction detail: Helps users investigate a total by reviewing the underlying invoices or related records where supported.
For example, suppose total reported sales for a month are $250,000 and one customer accounts for $50,000. The customer's share is calculated as customer sales divided by total sales, multiplied by 100. In this example, ($50,000 ÷ $250,000) × 100 = 20%. This means the customer contributed 20% of reported sales for that period. The result can help managers assess customer concentration and prioritize account planning.
Using the Report for Financial Decisions
Sales by customer data supports practical decisions across sales, finance, and operations. Managers can identify accounts with rising demand, investigate declining purchases, and compare customer activity with forecasts or account plans. Finance teams can also use customer-level totals as a starting point for reviewing receivables, although sales figures alone do not show whether invoices have been paid.
For receivables management, AR Automation Software can help automate collection follow-ups and match payments with invoices, supporting efforts to reduce days sales outstanding (DSO) and reconciliation effort. The report can help prioritize attention toward customers with substantial sales, while aging reports and payment records provide the additional evidence needed to assess overdue balances. Effective collections processes use due dates, disputes, customer communications, and promises to pay rather than sales volume alone. For more detail on receivables, dunning, and customer follow-ups, the Order-to-Cash Process: Complete Guide to O2C Automation explains how these activities connect across the order-to-cash cycle.
When customers pay several invoices in one transfer or provide incomplete remittance details, cash application helps match incoming payments to open invoices and identify items needing review. This complements sales reporting by helping finance distinguish revenue activity from cash actually received.
Data Quality, Tax, and Cross-System Reporting
Reliable customer reporting depends on consistent customer records, correctly posted transactions, appropriate period selections, and clear treatment of returns and adjustments. If customer accounts are duplicated or transactions are assigned to the wrong account, totals may not reflect the true commercial relationship. Establishing Customer Account Activation procedures helps ensure customer records are created and maintained with the information required for billing, reporting, and compliance workflows.
Sales totals may also need tax-specific review. The treatment of sales tax depends on applicable jurisdiction rules, taxable product categories, exemptions, and transaction locations. The Navigating NY Sales Tax: Rates, Exemptions & Real-Time Compliance guide illustrates why local rates and location-based requirements matter when validating transactions. A Taxable Sales Report focuses on sales relevant to tax reporting, while a general customer sales report may serve a different purpose; the two should not be treated as interchangeable without checking their definitions and included amounts.
Businesses operating across entities or ERP systems may need consolidated reporting rules to align customer identities and sales classifications. The Multi Entity Support For Sales Tax Verification approach supports centralized visibility across connected systems for tax verification and finance workflows. The Hyperbots Platform uses agentic AI for finance and accounting tasks, including document processing and ERP integration, which can help connect reporting-related workflows when configured for the organization's systems.
Best Practices for Accurate Reporting
Use the same date basis and transaction status when comparing reporting periods. Confirm whether the report includes returns, credit memos, discounts, freight, and tax, and reconcile its totals with the appropriate Sage 100 sales or general ledger reports. Investigate material differences before using the figures in management presentations or forecasts.
For a broader view of commercial performance, the Sync Sales to Cash guide discusses how CRM and invoicing systems can connect sales activity with billing and finance workflows. Customer sales totals are most useful when combined with gross margin, outstanding receivables, payment behavior, and sales targets. This gives decision-makers a more complete picture than revenue totals alone.
Summary
The Sage 100 Sales by Customer Report organizes sales activity by customer to support revenue review, account planning, and financial analysis. Its usefulness depends on understanding the report's selection criteria, transaction basis, and adjustment treatment. By validating source data and combining customer sales totals with receivables, margin, and tax information, businesses can make better-informed decisions about customer relationships and financial performance.