Sales by Employee report allows you to view the sales performance of each employee. The report features many columns. However, the report can be adjusted to only include columns you would like to use. Please click the gear icon and select the columns you would like to use.
All metrics in the report are sortable and are defined as follows:
Employee: The name of the employee
Gross Sales: Sum of Sales subtotals, excludes gift cards and layaway deposits
Returns: Sum of Returned subtotals
Discounts: Net discounts from Sales and Returns
Net Sales: Gross sales - Discounts - Returns
Sales Tax: Net Tax from Sales and Returns
Shipping: Total shipping income
Restocking Fees: Total restocking fees
Total Sales: Gross sales - Discounts - Returns + Taxes + Shipping & restocking Fees (excludes gift cards and layaway deposits)
% of Total Sales: Percent of Total sales attribute to employee
COGS: Sum of Unit costs of Items sold and Returned. Unit costs are averages.
Gross Margin: (Net sales - Cost of goods sold) / Net sales
Sales Count: Number of sales
Returns Count: Number of returns
Average Sale Value: Total sales / Number of sales, excludes Returns
Items Sold: Number of Items sold
Items Returned: Number of Items returned
Gift Cards Issued: Gift cards sold - Gift cards returned
New Layaway Reservations: Sum of Layaway order reservations
Net Layaway Deposits: Sum of Layaway deposits received - Sum of Layaway deposits returned
Hours Worked: Number of hours an employee work in a given time
Net Sales Count Per Hour: (Sales count - Returns count) / The number of hours worked
You can find the filters at the top-right corner and filter the data by:
- Date Range
You can also export the report to excel by clicking the "Export" button next to the date filter button.