To improve your experience, we’d love your feedback on how and why you use the Support Site!
TAKE THE SHOPKEEP SUPPORT SITE SURVEY NOW>>
Sales by Customer Report
Use the Sales by Customer report to see who your best customers are, what they’re purchasing, and who hasn’t visited in a while.
Table of Contents
Run the Report
From BackOffice, run the Sales by Customer report for an overview of what each customer has purchased during a specific time period.
- Click 'Analytics' and select 'Customers'.
- Click the Date icon, choose a preset or custom range, and press 'Retrieve'.
Read the Report
Let’s break down the report to maximize the benefits of its data for your business.
The charts at the top show your top 10 customers by number of sales and total sales amount.
The table view below provides even more detailed information such as your customers’ returns, discounts, net sales amount, and more. By default, only the first 4 columns display on Table View. To enable all of the columns seen below, use the Filter control to the right of the date picker.
Default Table View:
Table View with All Columns:
Sort the table by clicking any column header with arrows.
Totals | The total amount of each column.
Last Name | The customer’s last name.
First Name | The customer’s first name.
Email | The customer’s email address.
Sales Count | The number of Sale transactions by the customer.
Returns Count | The number of Return transactions by the customer.
Quantity Sold | The total number of items purchased by the customer.
Sales Amount | The total dollar amount of items purchased by the customer.
Quantity Returned | The total number of items returned by the customer.
Returns Amount | The total dollar amount of items returned by the customer.
Costs | The total costs of items sold and net of returns.
Cost is calculated using the weighted average cost of each item at the time of sale.
Discounts | The net amount discounted on purchased items.
Want to see more detail on discount usage? Check out the Sales by Discount Report.
Net Sales | The revenue generated by sales of an item after accounting for discounts and returns.
Gross Margin | The percentage of your net sales that contributes to your profit. It’s calculated by subtracting Cost from Net Sales, then dividing the result by Net Sales.
Gross Profit | The total business profit after subtracting Cost from Net Sales.
Average Items Per Sale | The average number of items per transaction.
Average Sale Amount | The average net sales amount per transaction.
Last Sale Date | The date of the customer’s last transaction.
Filter the Report
- Click 'Filter'.
- Click the 'Show/Hide Columns' arrow and check/uncheck the boxes.
- On the table, click any row to view the items a customer has purchased.
- Click 'Filter', then the 'Customers' arrow.
- Check/uncheck the boxes.
Search by first name, last name, or email to quickly filter the list.
Export the Report
Download a copy of your Sales by Customers report via the Export Center to analyze and filter the data using any spreadsheet software.
- Click 'Export'.
- Click 'OK' to continue working while the report is prepared.
Click the Export Center link to skip the steps below and be taken to the Export Center instead.
- Choose 'Export Center' from the menu.
- When the status of the report is ‘Ready’, click the icon to download the spreadsheet.
- View the Sales by Customer CSV in any spreadsheet software.
The majority of the columns on the export are the same as the Table columns defined above. Below is the additional column included in the export.
Customer ID | The customer ID is used for linking a customer’s sales with the customer information you can export from the Marketing section in BackOffice.
Print the Report
Use the Print feature to create the report in an easy-to-read and printer-friendly format.
- Click ‘Print’.
- Wait for the report to open in a new browser tab.
- Select 'File' from your browser’s menu and choose 'Print...'.
You can also choose to save the print view as a PDF for easy sharing.