# Sales Reports

# FAQs

## Sales and Revenue

### What is a 'Sale'?

The Sales Reports report on revenue generated on a specific date. Revenue is defined as the total value of an order, including all Products, Addons, Discounts and Delivery.

Revenue is separate to payments, which are reported on separately under Payment Reports.

### Which Orders and Order Lines will form part of revenue reporting?

Orders with the following statuses are excluded from revenue reporting:

- Draft
- Quote
- Abandoned

In addition, Order Lines with the following statuses are ignored (as they value will have been set to £0.00)

- Cancelled
- Returned

## Real Time Data

### Are the reports up to date?

All reports show a snapshot of data at the instant that they were generated. As such, they are always up to date.

### The value of a Sales Order has changed; how will this be reflected in the reporting?

With the exception of Sales by User, all revenue reporting is done based on the Sales Order date. That means that a Sales Order that has a date of the 1st of October will always report its revenue as the 1st of October, even if new lines are added on the 1st November.

### The Salesperson on a Sales Order has changed; how will this be reflected in the reporting?

This will immediately update and change all reports. This will adjust how reports are filtered, and will also have a direct impact on the Sales by User report.

### The Store on a Sales Order has changed; how will this be reflected in the reporting?

This will immediately update and change all reports. This will adjust how reports are filtered, and will also have a direct impact on the Sales by Channel report.

### What happens if a Product is deleted?

Some information is stored against the Sales Order, and IXO Commerce will report on that; other data is stored only against the product. This is done via a lookup of the product, and if that product has been deleted then it will not be possible to report on that data.

Stored against the Sales Order

- Sales Date
- Store
- User
- Source
- Payments
- Selling Price
- Cost Price
- Product Name
- Product SKU

Stored against the Product

- Brand Associations
- Category Associations
- Collection Associations
- Supplier Associations

#### Example

A product is sold in May for £10 at a cost price of £5. That product was a Lego Boat, associated with the Lego Brand.

If that product is deleted, then the association with the Lego Brand will also be deleted. This means that while the selling price and cost price are still reportable (as data that is held against the sales order), that order line will no longer be associated with the Lego Brand.

This will mean that this order line will not be included if the user filters a report by Brand, and if they view the Sales by Brand report, it would add to the 'n/a' row.

## Average Cost Prices and Profit Margins

### What is an 'Average Cost Price' and how is it calculated?

An Average Cost Price represents the mean cost of all items sold within a specific period. It’s calculated by dividing the total cost of all products sold by the total number of units sold. This metric helps businesses understand the average expense of acquiring or producing the goods they’ve sold, allowing for better profitability analysis.

Depending on the report, this might be done per SKU ([Sell Through](https://bookstack.iconography.co.uk/books/sales-reports/page/sell-through "Sell Through") report), or it might provide an Average Cost Price by Brand ([Sales by Brand](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-brand "Sales by Brand")), or Department ([Sales by Department](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-department "Sales by Department")), etc.

#### Example

Suppose you have a **Sales by Brand report** for the brand **"Brand A"** covering the period **from January 1 to January 31**.

Within this time frame, the following sales occurred:

<table border="1" id="bkmrk-product-quantity-sol" style="border-collapse: collapse; width: 100%; border-width: 1px;"><colgroup><col style="width: 33.3775%;"></col><col style="width: 33.3775%;"></col><col style="width: 33.3775%;"></col></colgroup><thead><tr><td>**Product**</td><td>**Quantity Sold**</td><td>**Cost Price per Unit**</td></tr></thead><tbody><tr><td>Product 1</td><td>10</td><td>£5.00</td></tr><tr><td>Product 2</td><td>20</td><td>£7.00</td></tr><tr><td>Product 3</td><td>15</td><td>£6.50</td></tr></tbody></table>

To calculate the **Average Cost Price** for **Brand A** during January:

1. **Sum up the Cost Prices**:
    
    
    - Product 1: 10 units × £5.00 = £50.00
    - Product 2: 20 units × £7.00 = £140.00
    - Product 3: 15 units × £6.50 = £97.50
2. **Total Cost Price**: £50.00 + £140.00 + £97.50 = **£287.50**
3. **Total Quantity Sold**: 10 + 20 + 15 = **45 units**
4. **Calculate the Average Cost Price**:
    
    
    - £287.50 ÷ 45 units = **£6.39** (rounded to 2 decimal places)

### What is an 'Average Profit Margin' and how is it calculated?

An Average Profit Margin measures the percentage of profit a business earns on its sales after accounting for costs. Depending on the report, this might be done per SKU ([Sell Through](https://bookstack.iconography.co.uk/books/sales-reports/page/sell-through "Sell Through") report), or it might provide an Average Cost Price by Brand ([Sales by Brand](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-brand "Sales by Brand")), or Department ([Sales by Department](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-department "Sales by Department")), etc.

#### Example

An Average Profit Margin on the Sales by Brand report will look for all sales of Products assigned to that Brand that took place within the specified period. It will then total the cost price of those items and compare it to the total sales revenue to produce an Average Profit Margin using the below formula (please note that all margins are calculated net of VAT):

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/q6Jimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/q6Jimage.png)

**Period:** February 1 - February 28

<table border="1" id="bkmrk-product-quantity-sol-1" style="border-collapse: collapse; width: 100%; border-width: 1px;"><colgroup><col style="width: 25.0331%;"></col><col style="width: 25.0331%;"></col><col style="width: 25.0331%;"></col><col style="width: 25.0331%;"></col></colgroup><thead><tr><td>**Product**</td><td>**Quantity Sold**</td><td>**Cost Price per Unit**</td><td>**Selling Price per Unit**</td></tr></thead><tbody><tr><td>Product 4</td><td>30</td><td>£4.00</td><td>£6.00</td></tr><tr><td>Product 5</td><td>25</td><td>£10.00</td><td>£15.00</td></tr><tr><td>Product 6</td><td>10</td><td>£20.00</td><td>£30.00</td></tr></tbody></table>

1. **Calculate the Total Sales Revenue**:
    
    
    - Product 4: 30 × £6.00 = £180.00 = £150.00 ex VAT
    - Product 5: 25 × £15.00 = £375.00 = £312.50 ex VAT
    - Product 6: 10 × £30.00 = £300.00 = £250.00 ex VAT  
        **Total Sales Revenue** = £180.00 + £375.00 + £300.00 = £855.00 = **£712.50 ex VAT**
2. **Calculate the Total Cost**:
    
    
    - Product 4: 30 × £4.00 = £120.00
    - Product 5: 25 × £10.00 = £250.00
    - Product 6: 10 × £20.00 = £200.00  
        **Total Cost** = £120.00 + £250.00 + £200.00 = **£570.00**
3. **Calculate the Profit**:
    
    
    - Profit = £712.50 - £570.00 = **£142.50**
4. **Calculate the Average Profit Margin**:

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/nRBimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/nRBimage.png)

### Why do some reports say 'Unknown' (e.g. Average Cost Price and Profit Margin)?

This will be because IXO Commerce is missing data - nothing is recorded against Sales Orders for cost price. Without a cost price, it is not possible to calculate Average Cost Price or Profit Margin.

## General

### Are Reports sortable?

All reports are sortable - simply click on the headers.

### Can a report be exported?

All reports are exportable as a CSV.

### Why are some results 'N/A' or simply blank?

This will be due to missing information, e.g. products that are sold which have not been assigned to a Department, or to a Brand with a blank entry in the name.

# Sales by Date

This report will show a breakdown of company-wide sales within a given period.

Data may be viewed by:

- Day
- Week
- Month

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/pFiimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/pFiimage.png)

#### Filters

This report may be filtered by:

- Date Range
- Store
- Store User
- Source
- Device
- Category
- Brand
- Collection
- Supplier

#### Key to icons

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/Qq3image.png) = view day/week/month broken down to [Sales by Channel](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-channel "Sales by Channel") (and matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/VJNimage.png) = view matching products (products sold within this date range and matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/gg8image.png) = view matching customers (customers who completed a purchase within this date range and matching any other filters applied)

### FAQs

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

# Sales by Channel

This report will show a breakdown of company-wide sales within a given period.

The data will be broken down by Channel, wither separate rows for:

- Each Store
- eCommerce website(s)
- Phone
- Alternative Channels (e.g. [Amazon](https://bookstack.iconography.co.uk/books/integrations/page/amazon "Amazon"), [eBay](https://bookstack.iconography.co.uk/books/integrations/page/ebay "eBay"), etc.)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/Kshimage.png)

#### Filters

This report may be filtered by:

- Date Range

#### Key to icons

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/Qq3image.png) = view [Sales by Category](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-category "Sales by Category") for this date range, filtered to this Channel

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

<p class="callout info">For more information on margin calculation, click [here](https://bookstack.iconography.co.uk/books/general/page/margin-calculation)</p>

### FAQs

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

# Sales by Category

This report will show a breakdown of company-wide sales within a given period; the value of sales will be split by Category. This list is based on the categories you have set up in the [Catalogue](https://bookstack.iconography.co.uk/books/categories/page/summary-UWK "Summary").

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/HLiimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/HLiimage.png)

#### Filters

This report may be filtered by:

- Source
- Device
- Store
- Store User
- Brand
- Collection
- Supplier
- Date Range

#### Key to icons

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/0Ksimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/0Ksimage.png) = view sales from this Category in the [Sales by Brand](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-brand "Sales by Channel") report (matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/VJNimage.png) = view matching products (products sold within this date range and matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/gg8image.png) = view matching customers (customers who completed a purchase within this date range and matching any other filters applied)

<p class="callout info">For more information on margin calculation, click [here](https://bookstack.iconography.co.uk/books/general/page/margin-calculation)</p>

### FAQs

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

# Sales by Brand

This report will show a breakdown of company-wide sales within a given period; the value of sales will be split by Brand. This list is based on the data you have set up in the [Brands](https://bookstack.iconography.co.uk/books/brands "Brands") menu.

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/RNNimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/RNNimage.png)

#### Filters

This report may be filtered by:

- Source
- Device
- Store
- Store User
- Category
- Collection
- Supplier
- Date Range

#### Key to icons

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/tYOimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/tYOimage.png) = view sales from this Brand in the [Sales by Collection](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-collection "Sales by Channel") report (matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/VJNimage.png) = view matching products (products sold within this date range and matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/gg8image.png) = view matching customers (customers who completed a purchase within this date range and matching any other filters applied)

<p class="callout info">For more information on margin calculation, click [here](https://bookstack.iconography.co.uk/books/general/page/margin-calculation)</p>

### FAQs

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

# Sales by Collection

This report will show a breakdown of company-wide sales within a given period; the value of sales will be split by Collection. This list is based on the data you have set up in the [Collections](https://bookstack.iconography.co.uk/books/collections "Collections") menu.

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/Nw9image.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/Nw9image.png)

#### Filters

This report may be filtered by:

- Source
- Device
- Store
- Store User
- Category
- Brand
- Supplier
- Date Range

#### Key to icons

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/KEOimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/KEOimage.png) = view sales from this Collection in the [Sell Through](https://bookstack.iconography.co.uk/books/sales-reports/page/sell-through "Sell Through") report (matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/VJNimage.png) = view matching products (products sold within this date range and matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/gg8image.png) = view matching customers (customers who completed a purchase within this date range and matching any other filters applied)

<p class="callout info">For more information on margin calculation, click [here](https://bookstack.iconography.co.uk/books/general/page/margin-calculation)</p>

### FAQs

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

# Sales by Supplier

This report will show a breakdown of company-wide sales within a given period; the value of sales will be split by Supplier. This list is based on the data you have set up in the [Supplier](https://bookstack.iconography.co.uk/books/suppliers "Suppliers") menu.

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/nVNimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/nVNimage.png)

#### Filters

This report may be filtered by:

- Source
- Device
- Store
- Store User
- Category
- Collection
- Brand
- Date Range

#### Key to icons

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/GJeimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/GJeimage.png) = view sales from this Supplier in the [Sales by Brand](https://bookstack.iconography.co.uk/books/sales-reports/page/sales-by-brand "Sales by Brand") report (matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/VJNimage.png) = view matching products (products sold within this date range and matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/gg8image.png) = view matching customers (customers who completed a purchase within this date range and matching any other filters applied)

<p class="callout info">For more information on margin calculation, click [here](https://bookstack.iconography.co.uk/books/general/page/margin-calculation)</p>

### FAQs

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

# Sales by Campaign



# Sales 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.

This report is calculated differently to other Sales Reports, as it does not use the date of the Sales Order, but the date of amendments to that Sales Order.

> 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/2024-11/scaled-1680-/0eoimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/0eoimage.png)

#### Commission

> Please ensure that you have spoken to Iconography to setup your commission rules; there are three options, defaulted to items sold

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**:

<article class="w-full scroll-mb-[var(--thread-trailing-height,150px)] text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]" data-scroll-anchor="false" data-testid="conversation-turn-6" dir="auto" id="bkmrk-order-1%3A-placed-on-1"><div class="m-auto text-base py-[18px] px-3 md:px-4 w-full md:px-5 lg:px-4 xl:px-5"><div class="mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]"><div class="group/conversation-turn relative flex w-full min-w-0 flex-col"><div class="flex-col gap-1 md:gap-3"><div class="flex max-w-full flex-col flex-grow"><div class="min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words [.text-message+&]:mt-5" data-message-author-role="user" data-message-id="aaa2802c-8930-4381-b11d-365677b73270" dir="auto"><div class="flex w-full flex-col gap-1 empty:hidden items-end rtl:items-start"><div class="relative max-w-[70%] rounded-3xl bg-token-message-surface px-5 py-2.5"><div class="whitespace-pre-wrap"><article class="w-full scroll-mb-[var(--thread-trailing-height,150px)] text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]" data-scroll-anchor="false" data-testid="conversation-turn-7" dir="auto"><div class="m-auto text-base py-[18px] px-3 md:px-4 w-full md:px-5 lg:px-4 xl:px-5"><div class="mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]"><div class="group/conversation-turn relative flex w-full min-w-0 flex-col agent-turn"><div class="flex-col gap-1 md:gap-3"><div class="flex max-w-full flex-col flex-grow"><div class="min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words [.text-message+&]:mt-5" data-message-author-role="assistant" data-message-id="fcb0d8ab-450c-4eb9-8c51-f65f1f0bc0bf" data-message-model-slug="gpt-4o-mini" dir="auto"><div class="flex w-full flex-col gap-1 empty:hidden first:pt-[3px]"><div class="markdown prose w-full break-words dark:prose-invert light">1. **Order 1**: Placed on **1st September**, delivered on **5th October**, total value: **£100**

</div></div></div></div></div></div></div></div></article><article class="w-full scroll-mb-[var(--thread-trailing-height,150px)] text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]" data-scroll-anchor="true" data-testid="conversation-turn-9" dir="auto"><div class="m-auto text-base py-[18px] px-3 md:px-4 w-full md:px-5 lg:px-4 xl:px-5"><div class="mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]"><div class="group/conversation-turn relative flex w-full min-w-0 flex-col agent-turn"><div class="flex-col gap-1 md:gap-3"><div class="flex max-w-full flex-col flex-grow"><div class="min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words [.text-message+&]:mt-5" data-message-author-role="assistant" data-message-id="2e51f9c9-84bd-48df-bb1b-f411fc3557f8" data-message-model-slug="gpt-4o-mini" dir="auto"><div class="flex w-full flex-col gap-1 empty:hidden first:pt-[3px]"><div class="markdown prose w-full break-words dark:prose-invert light">1. - **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**
2. **Returns within the Period**:
    
    
    - **Return for Order 2**: The customer returned the item on **15th October** (within the report period).
    - **Return for Order 1**: The customer returned the item on **20th October** (also within the report period).
3. **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**.
4. **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**.
5. **Adjusted Sales for Commission**:
    
    
    - Adjusted sales amount = £450 (total sales) - £250 (returns) = **£200**.
6. **Commission Earned**:
    
    
    - Commission = 10% of £200 = **£20**.

</div></div></div></div></div></div></div></div>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**.

</article></div><div class="absolute bottom-0 right-full top-0 -mr-3.5 hidden pr-5 pt-1 [.group\/conversation-turn:hover_&]:block"><span class="" data-state="closed"><button aria-label="Edit message" class="flex h-9 w-9 items-center justify-center rounded-full text-token-text-secondary transition hover:bg-token-main-surface-tertiary"><svg class="icon-md" fill="none" height="24" viewbox="0 0 24 24" width="24" xmlns="http://www.w3.org/2000/svg"><path clip-rule="evenodd" d="M13.2929 4.29291C15.0641 2.52167 17.9359 2.52167 19.7071 4.2929C21.4784 6.06414 21.4784 8.93588 19.7071 10.7071L18.7073 11.7069L11.6135 18.8007C10.8766 19.5376 9.92793 20.0258 8.89999 20.1971L4.16441 20.9864C3.84585 21.0395 3.52127 20.9355 3.29291 20.7071C3.06454 20.4788 2.96053 20.1542 3.01362 19.8356L3.80288 15.1C3.9742 14.0721 4.46243 13.1234 5.19932 12.3865L13.2929 4.29291ZM13 7.41422L6.61353 13.8007C6.1714 14.2428 5.87846 14.8121 5.77567 15.4288L5.21656 18.7835L8.57119 18.2244C9.18795 18.1216 9.75719 17.8286 10.1993 17.3865L16.5858 11L13 7.41422ZM18 9.5858L14.4142 6.00001L14.7071 5.70712C15.6973 4.71693 17.3027 4.71693 18.2929 5.70712C19.2831 6.69731 19.2831 8.30272 18.2929 9.29291L18 9.5858Z" fill="currentColor" fill-rule="evenodd"></path></svg></button></span></div></div></div></div></div></div></div></div></div></article><article class="w-full scroll-mb-[var(--thread-trailing-height,150px)] text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]" data-scroll-anchor="false" data-testid="conversation-turn-7" dir="auto" id="bkmrk--1"></article>#### 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

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/VJNimage.png) = view matching products (products sold within this date range and matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/gg8image.png) = view matching customers (customers who completed a purchase within this date range and matching any other filters applied)

<p class="callout info">For more information on margin calculation, click [here](https://bookstack.iconography.co.uk/books/general/page/margin-calculation)</p>

### FAQs

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

# Sales by Department

This report will show a breakdown of company-wide sales within a given period; the value of sales will be split by Department. This list is based on the departments you have set up against [Products](https://bookstack.iconography.co.uk/books/categories/page/product "Product").

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/PBBimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/PBBimage.png)

#### Filters

This report may be filtered by:

- Source
- Device
- Store
- Store User
- Date Range

#### Key to icons

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

<p class="callout info">For more information on margin calculation, click [here](https://bookstack.iconography.co.uk/books/general/page/margin-calculation)</p>

### FAQs

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

# Sell Through

This report will show a breakdown of company-wide sales within a given period; the value of sales will be split by Variant.

If you prefer, use the Combine Variants checkbox to view this report by Product instead of by Variant.

By default, this report will exclude unsold items, but it is possible to include unsold items by using the checkbox.

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/RkHimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/RkHimage.png)

#### Filters

This report may be filtered by:

- Source
- Device
- Store
- Store User
- Category
- Brand
- Collection
- Supplier
- Date Range

#### Key to icons

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/wwAimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/wwAimage.png) = view customers who bought this product in this time period

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/gg8image.png) = view matching customers (customers who completed a purchase within this date range and matching any other filters applied)

<p class="callout info">For more information on margin calculation, click [here](https://bookstack.iconography.co.uk/books/general/page/margin-calculation)</p>

### FAQs

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

# Made to Order

This report will show a breakdown of company-wide sales of Made to Order products within a given period; this data is broken down by product and by options. This list is based on the data you have set up in the [Collections](https://bookstack.iconography.co.uk/books/collections "Collections") menu.

A single SKU may be listed here multiple times, as there will be a separate listing for each combination of Customisations, e.g. 'Blue' with 'Oak Feet' will be separate to 'Blue' with 'Black Feet'.

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/FWMimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/FWMimage.png)

#### Filters

This report may be filtered by:

- Source
- Device
- Store
- Store User
- Category
- Brand
- Collection
- Supplier
- Date Range

#### Key to icons

[![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/KEOimage.png)](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/KEOimage.png) = view sales from this Collection in the [Sell Through](https://bookstack.iconography.co.uk/books/sales-reports/page/sell-through "Sell Through") report (matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/f0Bimage.png) = download report

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/VJNimage.png) = view matching products (products sold within this date range and matching any other filters applied)

![image.png](https://bookstack.iconography.co.uk/uploads/images/gallery/2024-11/scaled-1680-/gg8image.png) = view matching customers (customers who completed a purchase within this date range and matching any other filters applied)

### FAQs

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