The Ranked Sales By Customer report can provide a list of customers who have made purchases during the selected date range. These purchases can be separated by the transaction type, supplier or department. It also has the option to display the items from each purchase.
The Ranked Sales By Customer report is the best report to list customers with their Total Sales Amount for a date range. Customers can also be ranked by Quantity Sold or Gross Profit.
The Ranked Sales By Customer report does not list the customer's phone number, email address or company name.
Generating the Report
- To run this report, in the top menu bar of Retailer, click on Reports → Sales Report → Ranked Sales By Customer.
- Report Date Range
- Select the Start Date – This will be the Start Date of the report.
- Select the End Date – This will be the End Date of the report.
- Select Customers - This allows you to choose from All Customers or a Customer Range: From (choose the start of the customer range by customer number), To (choose the end of the customer range by customer number). This is especially useful for checking a particular customer's sales or spending over a period.
- Customer Categories and Customer Interests - these options allow you to filter the report to only customers assigned to certain categories and/or interests to show on the report.
- Customer Tags - This will filter the customers listed on the report to only customers with any of the selected tags.
- To add a Tag, type the Tag Name into the box next to 'Tag', then press Enter or click the plus + button
- To select multiple Tags, click the ellipsis (3 dots • • •) button . You can then select any Tag from the 'All Tags' box
- Transaction Types - Select the types of transactions to include in the report
- Cash Sales: Normal Sales performed in POS, paid in full at time of sale (Can be paid by Cash, Eftpos, Gift Voucher etc)
- Invoice Sales: Sales to be paid later by Account Customer.
- Duty Free/Tax Free Sales
- Layby Sales
- Stock Quantity on Hand - Set the report to include all stock, only include stock that has a positive quantity on hand or only include stock where the quantity on hand is less than or equal to zero
- Suppliers - Filter the report to include stock from all suppliers or selected supplier(s).
- Departments - Filter the report to include stock from all departments, or selected department(s).
- To the left of each Department, click the arrow > to tick or untick individual categories within the department.
- Stock Items in a department without a Category will always be included.
- Summary Details - Choose the style of report to generate:
- Summarize Sales: Show only the Customer and total details (Quantity Sold, Sales Amount, Cost, Discount, Gross Profit)
- Show Details of Sales: Under each Customer Total row, also show each item purchased (Department, Category, Supplier, Barcode, Supplier Stock Code, Description, Serial Number [Optional], Quantity Sold, Sale Amount, Item Cost, Discount, Gross Profit, Date Last Sold)
- Note the items of each sale are listed separately without aggregating. If a customer purchased the same item in 3 sales, it will be listed 3 times.
- Discounted Sales - allows you to choose between Show All Sales, Discounted Sales Only or Non Discounted Sales Only
- Other Options:
- Exclude Outstanding Layby - will exclude any layby transactions that haven’t been completely paid off.
- Show Serial Numbers - will show the serial number with the stock item sold. Note 'Show Details Of Sales' must be selected.
- Rank Order - There are several ways you can order the report (from highest to the lowest)
- Rank on Quantity Sold - Ranks the report from the highest quantity of stock sold for each customer to the lowest
- Rank on Total Sales Amount - Ranks the report from the highest combined sales totals for each customer to the lowest
- Rank on Number of Sales - Ranks the report from the highest number of sales for each customer to the lowest
- Rank on Gross Profit - Ranks the report from the highest gross profit to the lowest
- Rank on Discount - Ranks the report from the highest combined discount of each customer to the lowest
- Click Preview or Print.
Reading the Report
The summarised version of the report it shows the totals for each customer. The detailed version will show per customer totals along with individual stock item information.
- Customer Name
- Customer Number
- Sales Quantity - the total quantity of items sold for each customer
- Sales Amount Inc - the total amount the customer spent
- Stock Cost Inc - the total cost of the items purchased
- Discount Amt Inc - the discount amount given to the customer, either by voucher, catalogue or discount profile
- Gross Profit Amt - the amount of Gross Profit made (Sales Amount Inc – Stock Cost Inc – Discount Amt Inc)
- Gross Profit % - the percentage of Gross Profit made (Gross Profit ÷ Sales Amount Inc × 100)
- Date Last Sold - shows the Date Last Sold for the individual stock item
Exporting the Report
You can export the report to either a PDF document or Excel spreadsheet by using the Preview button and following the below steps:
- PDF - Click on the red PDF button at the top of the report and choose your save destination.
- CSV - From the Report Preview, click 'Export CSV'
- Excel spreadsheet - Click on the Print button at the top left. Tick 'Print to File' and select 'Xlsx Data File'. Click on the three dots button [...] to choose your save destination. Click OK to save the file.