Sales by Customer & Margin Report
Customer profitability reporting analyzing net sales revenue, cost of goods sold, gross margin percentages, order volume, and average order value per account.
Reviewed on 2026-10-07
Choose customers and dates#
You need access to advanced reports and the customer you want to review.
Compare customer sales#
- 1Open Reports and select Sales by Customer.
- 2Use Filter by date, Select customer, and All Currencies as needed; then click Search.
- 3Check order count, revenue, and whether canceled orders are included.
- 4Open a customer's underlying orders or invoices when a total seems unexpected.
- 5Check credits and canceled orders in the same period before reporting the result.
Customer totals are only comparable when the report scope and document treatment are the same.
Open contributing orders#
The report groups activity by customer and currency; distinguish ordered value from posted invoice revenue when interpreting totals.
WARNING: Do not combine currencies without an explicit conversion basis.
Before using totals#
Open the contributing orders and invoices before treating the total as collected revenue.
Trace the source documents before changing a customer record or posting an adjustment.
Have a question about this workflow?
Subscribed customers can ask questions about this guide inside the authenticated dashboard.
Ask about Sales by Customer & Margin Report in Dashboard