# Performance by User This report will show a breakdown of company-wide sales within a given period; the value of sales will be split by User (Salesperson). This list is based on the data you have set up in the [Update Users](https://bookstack.iconography.co.uk/books/update-users "Update Users") menu. This report can also be used to calculate commission.

Sales Orders can each be attributed to a single Salesperson. This can be edited within the Sales Order management screen.

Sales Orders without a Salesperson will be omitted from this report.

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/scaled-1680-/IIjimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2026-03/IIjimage.png) ### Data Explanation This report is split into two sections; 'sales data' and 'adjusted sales data' #### Sales Data This section of the report performs exactly like a standard Sales Report (see ['what is a sale'?](https://bookstack.iconography.co.uk/books/sales-reports/page/faqs)). This includes:
FieldPurpose
New Orders*Total number of new sales orders, e.g. sales orders created within the selected date range*
New Sales Value*Total value of those new sales orders, e.g. sales orders created within the selected date range*
Average profit margin*Average [margin](https://bookstack.iconography.co.uk/books/general/page/margin-calculation "Margin Calculation") on those new sales orders, e.g. sales orders created within the selected date range*
#### Adjusted Total These figures to the right of the first dividing line are *adjusted figures*; that means that they have been adjusted to take into account changes on a line by line basis. Rather than reflecting the Sales Order date, these figures reflect the date against the Sales Order line. For example, a £1000 widget is sold on the 1st of May, creating a new Sales Order. On the 1st June, a second widget is added for £1000. The total value of that Sales Order is £2000, but it would only show as a new Sales Order on a report run on May's sales figures. If the report were run for June, the second widget would be included under 'items sold total'.
FieldPurpose
Items sold totalTotal value of items sold within the period, based on 'date added' as stored against each Sales Order line

This is not based on the sales date of the Sales Order

Items cancelledTotal value of items cancelled against Sales Order where 'date cancelled' (stored against the Sales Order line) is within the selected date range
Items returnedTotal value of items returned against Sales Order where 'date returned' (stored against the Sales Order line) is within the selected date range
DiscountsTotal value of discounts on Sales Order lines where 'date added' (stored against the Sales Order line) is within the selected date range
Adjusted RevenueThe sum of the preceding columns
#### Commission This column shows the commission due to each Sales Person.

Please ensure that you have spoken to Iconography to setup your commission rules

Commission is calculated user the commission rate set against each user in the [Update Users](https://bookstack.iconography.co.uk/books/update-users "Update Users") screen: ##### 1. As a percentage of the value of items sold The commission for this period will be calculated as a percentage of the total value of items sold during the specified timeframe. However, deductions will be applied for any items that were either returned or cancelled within the same period. These deductions will be based on the data reflected in the 'Cancelled' and 'Returns' columns of the report. The final commission amount will be adjusted accordingly to ensure it reflects only completed and successful sales. The report will be adjusted appropriately for items returned/cancelled during that time period for all orders, regardless of when they are placed. ##### 2. As a percentage of the value of items delivered The commission for this period will be calculated as a percentage of the total value of items delivered during the specified timeframe, based on the delivery date. Deductions will be made for any items that were returned within the same period, as indicated in the 'Returns' column of the report. The final commission amount will be adjusted to reflect only those sales where the items were successfully delivered and not returned. The report will be adjusted appropriately for items returned during that time period for all orders, regardless of when they are placed. ##### 3. As a percentage of the value of payments The report will be adjusted appropriately for refunds during that time period for all orders, regardless of when they are placed. ##### Returns, Refunds, Cancellations and Clawbacks **Sales Data**:
1. **Orders within the Period** - **Order 1**: Placed on **1st September**, delivered on **5th October**, total value: **£100** - **Order 2**: Placed on **3rd October**, delivered on **7th October**, total value: **£150** - **Order 3**: Placed on **10th October**, delivered on **12th October**, total value: **£200**
1. **Returns within the Period**: - **Return for Order 1**: The customer returned the item on **20th October** (also within the report period). - **Return for Order 2**: The customer returned the item on **15th October** (within the report period). - **Cancellation** **for Order 3:** The customer changed their mind, and cancelled the original line item, and added a new one in a different colour on the **10th** **October**; the original line is counted neither as a sale, nor as a cancellation, as it was cancelled on the same day it was added to the order. The new line is counted as normal. 2. **Commission Calculation**: - Let’s say the commission rate is **10%**. - The total sales amount for the period (1st October - 20th October) is: £100 (Order 1) + £150 (Order 2) + £200 (Order 3) = **£450**. 3. **Deductions for Returns**: - Since both **Order 1** and **Order 2** were returned within the reporting time period, their values will be deducted from the commission total. - Total returns: £100 (Order 1) + £150 (Order 2) = **£250**. 4. **Adjusted Sales for Commission**: - Adjusted sales amount = £450 (total sales) - £250 (returns) = **£200**. 5. **Commission Earned**: - Commission = 10% of £200 = **£20**.
In this example, even though **Order 1** was placed in September and **Order 2** was placed earlier in October, but both of their returns fall within the specified period (1st October - 20th October). As such, they are deducted from the total sales before calculating the commission. The commission earned would be **£20**.
### Filters This report may be filtered by: - Source - Device - Store - Date Range ### Key to icons [![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/s7rimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/s7rimage.png) = view sales from this User in the [Sales by Category](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-category "Sales by Category") report (matching any other filters applied) ![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

For more information on margin calculation, click [here](https://bookstack.iconography.co.uk/books/general/page/margin-calculation)

### FAQs FAQs for Sales Reports may be viewed [here](https://bookstack.iconography.co.uk/books/sales-reports/page/faqs "FAQs").