Sales

Generate detailed insights into your sales performance, helping you track important revenue, returns and tax information.

---

Group Sales Analysis Report

Group and filter your sales data for straightforward analysis and insight.

Configuration

Generating a Group Sales Analysis Report can differ based on your platform configuration, but this typically includes:

Configuration	Summary
Grouping Strategy	Choose how you intend to group your sales data. Sales can be grouped by: Brand, Customer, Customer Type, Sales Channel or Product.
Filters	The grouping can be filtered by: Sales Audience, Sales Channel, Department, Product Category, Tax Rate, Supplier, Payment Type or Payment Date.
Dates	Apply a Start Date and End Date.
Stores	Include or exclude in-store sales.

Metrics

The Group Sales Analysis Report generates the following metrics for each group:

Metric	Summary
Items Sold	The total number of items sold within the selected date range.
Total exc. VAT	Total sales excluding VAT.
Total inc. VAT	Total sales including VAT.
VAT	The amount of VAT calculated on the sales.
% of Grand Total	Each group’s contribution to the overall sales of the segment.
Actual Cost exc. VAT	The actual cost of goods sold, excluding VAT.
Profit	The total profit for each group.
Margin %	The profit margin percentage for each segment.
Available Stock	The current stock levels of the items sold.

About the Group Sales Analysis Report

The Group Sales Analysis Report is a valuable tool for understanding how different segments contribute to your overall sales.

For example, you can view how much revenue was generated by each Brand, or assess the performance of different Customer Types for specific Product Categories.

Due to its wide range of configurable options, this is one of the most commonly used reports in Venditan Commerce.

We can provide additional Grouping Strategies and Filters to help you generate the reports you need.

Note: This report, along with the Payment Receipts by Payment Type report, is commonly used to aid Tax Return reporting.

---

Grouped Sales Analysis: Comparison Report

You can also compare Grouped Sales Data across two date ranges.

While it has more limited grouping and filtering options than the standard Grouped Sales Analysis Report, it provides valuable insights by comparing Grouped Sales Data month-on-month, year-on-year, or across any other configurable date range.

---

Rate of Sale Report

Generate sales projections for an upcoming period using your historical sales data.

Configuration

When generating a Rate of Sale Report, you will:

1

Choose your Analysis Period

Define how far back historical sales data should be analysed, e.g., 1 week, 1 month, or 1 year.

2

Choose your Projection Period

Specify the duration for which you want to generate sales projections.

3

Apply Filters

You can filter the report by Manufacturer, Season, Sales Audience, Department, Category, Product Tag, or Supplier.

4

Choose an Inventory Grouping strategy

Select from Master, Member or Stock to group your inventory for the report.

Metrics

The report generates the following sales projection metrics:

Metric	Summary
Product	Product Title and Product Code to identify the product.
Sales History	Total number of products sold within the specificed Analysis Period.
Projection	Projected sales based for the Projection Period.

The report generates the following additional metrics for a deeper analysis of stock levels:

Metric	Summary
Is End of Line?	Indicates if the product is discontinued.
Max Stock	The Max Stock Level for the product.
Unallocated Stock	The quantity of stock not currently assigned to any orders.
Unallocated Stock + PO	Unallocated stock plus any incoming tock on open Purchase Orders.
Stock Value (Available Stock)	The total value of the available stock for the product.
Current Days Cover	The expected number of days the current stock will last is based on sales velocity.
Current Weeks Cover	The expected number of weeks the current stock will last is based on sales velocity.

About the Rate of Sale Report

The Rate of Sale Report is essential for forecasting future sales based on historical performance.

It provides accurate sales projections for a defined period, helping to inform replenishment and staffing decisions.

---

Returned Orders by Reason Report

Break down your returned products and understand why they were returned.

Configuration

When generating a Returned Orders by Reason Report, you will:

1

Choose your Date Range

Define the period you want to analyse returned orders for.

2

Apply Filters

You can filter the report by Sales Channel, Return Reason, Delivery Country and Product Code.

3

Choose a Grouping Strategy

Select from Sales Channel, Return Reason, Delivery Country/Return Reason and Product/Return Reason to group your inventory for the report.

Metrics

The report generates the following key metrics:

Metric	Summary
Product	Product Title and Product Code to identify the product.
Number of Returns	Total count of returned items for the specified criteria.
Date	The date on which the returns occurred.
Return Reason	The reason provided for the return of the product.
Value of Returns	The monetary value associated with the returned items.
Sales Channel	The Sales Channel where the product was sold.
Delivery Country	The country to which the product was delivered.

About the Returned Orders by Reason Report

The Returned Orders by Reason Report provides a comprehensive analysis of returned items, offering insights into the reasons behind product returns.

This report breaks down returns by Sales Channel, Delivery Country, and Return Reason, enabling you to identify trends and potential issues within your product offerings, and ultimately work towards a reduced return rate.

---

Order Cancellation Reasons Report

Generate a list of cancelled orders and understand why they were cancelled.

Configuration

When generating a Order Cancellation Reasons Report, you will:

1

Choose your Date Range

Define the period you want to analyse returned orders for.

2

Apply Filters

You can filter the report by Sales Channel or Department.

Metrics

The report generates the following key metrics:

Metric	Summary
Order Number	The individual code for each order, e.g. XCUS001.
Customer Name	The name of the Customer.
Date Placed	The data the order was placed.
Sales Channel	The Sales Channel that generated the Order, e.g. Website, Amazon.
Cancellation Date	The date the order was cancelled.
Cancelled By	The member of staff that cancelled the order.
Cancellation Reason	The selected reason for cancellation.

IOSS Report

Venditan Commerce includes an IOSS Report to support your EU VAT compliance obligations.

The report generates a list of all orders where the total value of goods exceeds the €150 IOSS threshold, which are excluded from IOSS coverage and subject to different VAT and customs treatment. This data is required for VAT reporting under EU import regulations.

The report includes key order-level details such as:

• Order ID

• Order Date

• Country of Destination

• Total Order Value

• Currency

• Shipping Method

• VAT Rate (if applicable)

This allows you to identify and account for transactions not covered by the IOSS scheme, helping to ensure accurate VAT declarations and cross-border compliance.

Reports can be exported and used as part of your monthly VAT submission or internal audit process.