Sales Reports

Created by Migration Bot, Modified on Fri, 23 Oct at 2:30 PM by Migration Bot

Originally written by John Hardwick, last updated Aug 25, 2023, on the Swan Retail knowledge base (FRS).


Sales reports provide statistical analysis of the order pipeline.

SwanFRS does not consider the order as a sale until it has been accepted.  I.e., initially, the sale shows the ON HOLD indicator. This indicates the order is being constructed, and such orders do not appear in the statistics until they have been accepted.  Accepting a sales order changes the icon to the ACCEPTED indicator.   (when an accepted order is amended, it reverts to the ON HOLD status, however it has been accepted once therefore it is a sales order and therefore may appear in an audit – these orders are effectively being amended and are effectively deemed to be ‘on hold’ until re-accepted. Reports offering the ability to include / exclude hold orders refer to this state, i.e., include/exclude orders that are in the amend state)

Orders saved as quotations show the ENQUIRY indicator.  Converting the quotation to a sale may change the original quotation date to the date of accepting the order, therefore converting a quote to a sale will cause the ‘booking’ to appear on the date of conversion not the date of the original quote

If a sales order is created on one day and accepted on another, SwanFRS will use the original order date as the date of the booking and not the date the order was finally accepted.

All amendments to orders log against the transaction date of the action.

Sales Reports

Amended Payments Audit

This report is design to provide an audit of payments amended after they were ‘accepted’ - ie. they have been amended after the transaction was completed.

image-20240627-140505.png

Associated Showroom Sales

The report lists sales derived from goods on display.  The output is grouped by supplier / product range within location, listing items from each supplier flagged as ‘on display’ in the location.  Below this is a list showing all SKU’s sold on sales orders from the same range.  Per SKU code, the quantity, average and total selling price is displayed.

Average Sales Value

This report lists bookings made within the specified date range by product group per sales location.  The last section of the report shows by product group booking across the company.  The sales averages are calculated using the number of sales orders booked.

Booked Sales Movement

This report is designed to show differences between the original booking value for sales order generated within a specified week to its current order values.  I.e., pipeline movement.

Bookings By Salesperson

This report produces a list of orders created by the specified login code, effectively it is only possible to view your own orders.

Branch Daily Payment Summary

The report enables the operator to view payment statistics for a selected date range, grouped by tender within date.

Branch Deliveries Summary

This report produces a list of goods acknowledged or confirmed by the supplier but not yet received into stock within a user specified date & time range.

Cancelled Sales (1214 onwards)

This report allows the viewer to establish why orders / order lines are being cancelled.

image-20250407-132414.png

Carpet Detail

This report details measured goods in the system, allowing analysis against a wide array of selection criteria.

Carpet Detail by Date

This report details measured goods in the system, allowing analysis against a wide array of selection criteria with a date range.

Carpet Summary

This report is specifically designed to show measured goods stock.

Chase

This report lists all sales orders which require some form of action to enable the order to become fully delivered.

Cost of Despatched Goods

This report lists all goods delivered from a user defined selling location and date range, showing the cost of each item per delivery location and date.

Cost of Sales

This report lists all goods delivered (confirmed / finalized) from a user defined selling location and date range, showing the cost of each item per delivery location and date.

Cost of Sales Nominal

The report lists the cost of deliveries confirmed / finalized within the specified date range, grouped by location for each calendar month, and uses the accounting date to ensure the report does not produce varying results should a transaction be retrospectively transacted.

Cost of Sales Summary

The report lists the cost of deliveries confirmed / finalised within the specified date range, grouped by calendar month, and uses the accounting date to ensure the report does not produce varying results should a transaction be retrospectively transacted.

Customer Delivery Mail Shot

The report lists the cost of deliveries confirmed / finalized within the specified date range, grouped by calendar month, and uses the accounting date to ensure the report does not produce varying results should a transaction be retrospectively transacted.

Customer Interactions Export

This report produces a customer export data file (similar to Customer Export) with the addition of saved customer interactions.

Customer Name Change Audit

This report lists changes made to customer's name (initials / first name and last / surname) providing an audit of who changed what when.

image-20240408-075859.png

Customer Order Balance

The report produces a statement per customer of outstanding debt by location, with the option to show each individual transaction.

Customer Purchases

The report produces a listing of all goods sold for the selected supplier(s)/range(s) for a given date range, showing the items sold and where selected associated goods on the sales order.  It was designed to inform a ‘fitter’ of other goods and services sold on the sale in addition to the item being fitted, but may be used for other purposes.

Customer Purchases Mail Shot (1214 onwards)

The report is designed to produce a listing of customer’s names and addresses in a format able to be loaded into a mail merge type routine. Filters on the report allow the list to be limited to purchases from specific suppliers / ranges within a date range, and to filter by mail preference.

Customer Type Export

This report is designed to allow the retailer to produce a data export of their customer file.

Daily Sales Summary

The report lists transactions by location for the specified transaction date.  The report shows booked sales alongside payments received / refunded.

image-20240424-155428.png

Debtors

This report produces a statement as to the level of debt grouped by location by customer for user specified location(s) / date and time combination in respect of delivered goods for the company.

Deliverable Special Order Stock

This report is designed to show all stock on-hand which was specifically purchased to fulfil customer requirements but has not been delivered.

Delivered Warranty Orders (1214 onwards)

The report is designed to produce an output file in a format Stainguard can load into their warranty systems. The data file produced may be used for other providers where appropriate

image-20260409-140026.png

Deliveries by Salesperson

This report produces a list of orders confirmed as delivered within the date range for the operator.  

Delivery Address Finder

This report acts as an enquiry, offering the ability to enter part of a customer’s delivery address as search criteria.  The report then shows the customer’s account and order history.

Delivery Performance (1214 onwards)

This report produces statistics re the number of deliveries attempted and those successfully accepted by the customer.

image-20250808-093806.png

Delivery Run Item Removals

This report details items removed from the delivery run, showing removal date and operator.  Item removals occur when an item on a delivery run has not been loaded when the operator chooses the next option (i.e., print dispatch notes).

Delivery Schedule

This report produces a list of deliveries pending confirmation (scheduled but not despatched) and may be used as a driver’s manifest. 

Delivery Scheduled Report

This report is designed to provide a listing of deliveries planned (and confirmed) but not completed within the system, showing the financial value of the delivery.

image-20240628-074046.png

Delivery Schedule Locked

The report produces a listing of all delivery runs which are ‘locked’ but not ‘despatched’ for the user specified process date.

Delivery Statistics

This report produces statistics re how successful delivery run are.

Delivery Timings

This report shows the average time it takes to complete a sales order. i.e. the average number of days from point of the customer raising the sales order with the retailer to the date the order is first fully delivered and paid for.

Delivery Timings - Order Line Detail

Department Sales

This report is designed to group sales by department. 

Department Sales Enhanced

This report is designed to group sales by department. 

Despatch Confirmation

The report produces an audit of goods delivered to customers grouped by sales order within delivery run reference grouped by delivery location within date.

Despatched Orders

The report shows by selling location all orders confirmed as delivered within the specified date range.  Each order is broken out into the VAT rate applied (possibly several lines per order) and provides a VAT analysis of delivered goods.

En Route Collection Pick List

The report details goods which will require to be picked up on route from a specified destination location / date combination.

Free To Sell Special Order Stock

This report is designed to show all stock on-hand which was specifically purchased to fulfil customer requirements, which have subsequently been cancelled and are now free to sell.

Furniture New Business

The report allows the value of sales to be reported by product group, or part of, within a user specified date range.

Furniture New Business Enhanced

The report allows the value of sales to be reported by product group, or part of, within a user specified date range.

Furniture New Business Summary

The report allows the value of sales to be reported by product group, or part of, within a user specified date range.

Goods Despatched Summary

The report allows the value of sales to be reported by product group, or part of, within a user specified date range.

image-20240429-112106.png

Gross Profit by Branch

The report allows the value of sales to be reported by product group, or part of, within a user specified date range.

Hierarchical Sales and Cancellations

Based on the sales and cancellation report, this version allows the collation by reporting hierarchy.

Highest Sales Values

The report details the highest booked sales value with the ability to sort by product group, ascending or descending sales value.

Historic Order Reference Enquiry

This report is designed to act as an order lookup for orders processed on a legacy ERP system, should that system be no-longer available.

Home Delivery Orders

The report lists all home delivery orders waiting for delivery confirmation. 

Incomplete Sales

A report listing orders which require some form of outstanding action to complete or finish the order.  An incomplete order is defined as an order which is unfulfilled, unpaid, flagged for return or there are outstanding undelivered elements on the order.

Incomplete Sales Export

A report listing orders which require some form of outstanding action to complete or finish the order, designed specifically for export.

Item Attribute Usage

Primarily designed to show which items are linked to which ticket style, this report presents a listing of SKUs that share a common Attribute and value.

image-20241021-145655.png

Low Deposits

A report listing all sales orders where the payments made against them fall below the user specified minimum deposit percentage.

Monthly Sales by Branch Graph

This report produces generates a three-format output - a chart showing sales by location / month, a table showing sales and a breakdown list.

New Business Comparison

The report details new business booked for a selected week, showing bookings for this year and last year.

New Business Salesperson

This report details sales by salesperson by location, broken down into product groups.

New Business Source

The report uses the product grouping of items sold per location to analyse the source of business.  The report offers a user specified date range.

New Customer Statistics

This report shows the number of new customers created which have email addresses and / or mobile numbers.  The customer is assigned to the salesperson using the first sales order linked to that account or assigned as an enquirer if no sales order. 

Open Actions

This report lists all open orders and actions relating to those orders.

Open Events

The report lists open events assigned to an operator due within a specified date range.

image-20240627-131942.png

Open Orders (1214 onwards)

A report listing open sales orders grouped by salesperson or location, detailing the financial status of each sale.  This report is designed to allow you to assess the status of sales progressing through the company at a glance.

image-20250616-152828.png

Open Orders Export

This audit is designed to be used as a data feed for a spreadsheet / third party data manipulation and presents a list of sales orders where actions are required to complete the sale.

Orders Booked Analysis

This report is designed to present a list of bookings / cancellations by location showing cost, selling and margin obtained.

Orders Booked Dashboard

This report produces a trading analysis for the 7 days preceding the specified date breaking down the sales activating by value, comparison to promotion, sales by salesperson, supplier, and product group.

Orders Placed following an Interaction

This report provides an analysis of orders placed because of inviting customers to an event (interaction) with the option of filtering orders placed within several days of the event occurring.

Orders Taken

This report lists all sales order bookings processed within the select process date range, group by SKU, supplier and then product group where the customer is due to collect or has taken goods.

Order Value by Region Analysis

This report lists all sales order bookings processed within the select process date range, group by SKU, supplier and then product group. 

Out of Area Delivery

This report is designed for retailers where goods are delivered from a location outside their local delivery area.

Outstanding Customer Collections

This report is designed to list all stock identified as to be collected by the customer.

Picking Plan

The report identifies what is due for picking and where to find the goods.

Pipeline

This report details the order / delivery pipeline showing values in thousands, using the sales calendar for week numbers.

Postcode Area Customer Analysis

The report details orders raised within the specified date range, collating by postcode and whether the customer is a first-time purchaser or a returning customer.

Pre-FRS Customer Orders

This audit is provided, on request, for customers who have a list of ‘legacy’ orders they wish to retain for enquiry purposes.

Price Change Audit

The report identifies what is due for picking and where to find the goods.

Price List

This audit generates a list of prices for a specified promotion.

Product Portfolio

This audit is designed to allow the operator to generate a product list with the option to include prices as at a date.

Product Sales Analysis

This report shows the top ranked products within product groups by location for a user specified date range and enables the viewer to establish which the most popular products per store are.

Product Sales Performance

The report lists by location within the specified date range sales (booked) ranked initially by product group (bestselling group first) then within the product group a second ranking of best to worst selling products (SKU) using the selling value as the ranking mechanism.

Promotion Prices

This report is designed to produce a shop floor catalogue of prices set within a specified promotion.

Purchasing Analysis by Customer

This report is designed to produce a shop floor catalogue of prices set within a specified promotion.

Quotation Analysis

This report is designed to produce a shop floor catalogue of prices set within a specified promotion.

image-20241104-114355.png

Range Sales Performance

This report details the bestselling (booked sales) supplier / range combinations by location within the specified date range. 

Returns Report

This report details the bestselling (booked sales) supplier / range combinations by location within the specified date range. 

Saleable Stock

This report details stock held for a selected location, supplier and product group combination which is deemed saleable. 

Sales Analysis Report

This report details stock held for a selected location, supplier and product group combination which is deemed saleable. 

Sales and Cancellations

An audit detailing bookings and cancellations of sales orders within the specified date range showing product, customer, selling value, margin, and salesperson(s)

Sales and Stock Turn

This report ages sales in 30-day intervals and stocking levels, allowing decisions to be made whether to purchase additional stock.

Sales By Branch Graph

A bar chart detailing booked sales within the specified process dates.  The actual booked value is shown below the graph as values.

Sales By Colour

This report is designed to show sales of measured goods broken out by colour.

Sales By Group

This report is designed to show sales of measured goods broken out by product group or sales department.

Sales By Price Band

This report is designed to sow sales of measured goods broken out by price band (controlled via Set Up Price Bands)

Sales By Product Group (1214 onwards)

This report is designed to show sales of measured goods broken out by product group.

image-20250808-095757.png

Sales Closed Promotions

The report details items sold against closed promotions within a given date range.

Sales Comparison

The report enables comparisons between trading user specified trading weeks this year with those of last year.  To make use of this report, you need to have built your sales calendar and have sufficient trading history for the comparison to be meaningful.

Sales Comparison by Date

The report details sales by location broken out by supplier within product group detailing sales for the financial year.

This report offers a drill-down feature.

Sales Graph

This report produces a sales graph by date with salesperson to location groupings.

Sales Invoice Audit

This report can operate as a stand-a-lone report or plugged in to the RPT_SO_HISTORY report which is produced when the Print Audit is selected from the side panel when viewing the sales order detail.

image-20240627-133750.png

Sales Invoice Cost Margin

This audit shows invoices raised per month for a selected location range indicating margin obtained against each order.

Sales Invoice Detail (1214 onwards)

This report lists all items confirmed as delivered where the ‘final payment method’ is set to ‘invoice’ and were delivered within the specified date range.

This audit optionally includes the stock thumbnail image.

image-20240408-135438.png

Sales Invoice Print (1214 onwards)

This audit is designed to be plugged in to the Sales Order side panel or run from the menu and produces a list of delivery confirmation invoices related to the specified sales order where delivery took place within a specified timeframe.

There are two versions of the print

image-20250203-151812.png

Sales Nominal

The report lists the deliveries confirmed within the specified date range, grouped by location for each calendar month, and uses the accountancy date to ensure retrospective transactions cannot affect the report.

Sales Nominal Summary

The report lists the deliveries confirmed within the specified date range for each calendar month and uses the accountancy date to ensure retrospective transactions cannot affect the report.

Sales Order Audit (1214 onwards)

This report can operate as a stand-a-lone report or plugged in to the RPT_SO_HISTORY report which is produced when the Print Audit is selected from the side panel when viewing the sales order detail.

image-20251028-101510.png

Sales Order Discounts

The report lists the discounts processed against sales orders within the user specified date range.

The report shows the reason for discount below the discount percentage.

Sales Order E-Mail Acknowledgement Audit

This report produces a listing of sales orders where an email has been issued as a result of the sales order being ‘Accepted’.

image-20240627-135030.png

Sales Order Header Change History

The report provides details of changes made to the sales order header.

Salesperson by Department

This report lists orders with either new bookings or amendments to, within the report’s date range, grouped by department.

Salesperson by Group

Similar to the salesperson performance report, this option shows margin contribution compared to the report total collated by product group or sales department.

Salesperson by Product Group

Similar to the salesperson performance report, this option shows margin contribution compared to the report total collated by product group.

Salesperson by Week

This report enables the production of booking statistic by salesperson within location (controlled via the sales calendar). 

Salesperson Deliveries

The report lists deliveries attributed to the primary salesperson of the sales order.  Within the salesperson, the information is grouped by sales order within product group.

Salesperson Delivery Performance

This shows confirmed sales (deliveries and returns) processed within the report’s date range, broken out by salesperson and expressed as percentage contributions to the report's total.

Salesperson Graph

A bar chart detailing booked sales within the specified process dates.  The actual booked value is shown below the graph as values.

Salesperson Orders

A report enabling the user to list all orders attributed to a chosen location, primary and / or secondary salesperson within a specified date range. 

Salesperson Payments

All payments received into the system within the specified date range and optionally grouped by location.  The report sequences the salespersons by the amount of tender received within the selected date range.  The percentages shown indicate the salesperson’s contribution to the branch and company takings during the audit period.

Salesperson Performance (1214 onwards)

This report details the value of sales booked by each salesperson, broken out by sales location.  Each location lists salespeople ranked by value and then the percentage that this person’s sales represent against the report total.

The report offers the ability to analyse sales broken out by salesperson at line level.

image-20250616-150859.png

Salesperson Performance Plus

Similar to the salesperson performance report, this option shows margin contribution compared to the report total.

Salesperson Summary

The audit produces a list of bookings (sales) within the specified week (taken from the sales calendar) showing the bookings cumulatively for the year.

The report allows selection of locations and the ability to group by location.

Salesperson Summary by Date

The audit produces a list of bookings (sales) within the specified date range, showing the bookings per salesperson.

This report uses the sales order's selling location to establish if the selling price should be tax inclusive or exclusive.

Salesperson Tender

A listing showing the tenders processed per salesperson within location, grouped by sales order, date, and tender type.  The report also produces a summary showing by tender type the values transacted.

Salesperson Weekly Sales

The report produces, in a grid format, weekly performance statistics by salesperson within location showing bookings and cancellations with a grand total. 

Sales Pro-forma Invoice Print (1214 onwards)

This audit is designed to be plugged in to the Sales Order side panel or run from the menu and produces a pro forma invoice style document and can be used prior to confirming delivery of goods to the customer.

image-20250616-143621.png

Sales Summary by Region

This report enables the production of booking statistic by region driven by the customer’s postcode for a specific week (controlled via the sales calendar). 

Schedule Deliveries

The report detailing deliveries scheduled by selling location / salesperson, optionally highlighting orders on hold / with contact messages.

SKU Sales

The report is designed to show sales grouped by product group.

Sold Goods

This report creates a two-part output.  The first section details stock which is sold to customers, grouped by SKU within product category or sales order.  The second section lists all stock on order (i.e., the subject of a purchase order) which is currently not in stock, again grouped by SKU within product category or sales order.

Sold Goods by Supplier

This report creates a two-part output.  The first section details stock which is sold to customers, grouped by SKU within product category or sales order.  The second section lists all stock on order (I.e., the subject of a purchase order) which is currently not in stock, again grouped by SKU within product category or sales order.

Source Analysis

A report detailing both number of orders and order value, grouped by source of business within the specified date range.

The report is produced in three sections, the latter sections analysing source of business against week and year numbers. 

For systems operating with customer source of business, the customer source analysis report is available – this is as per the source analysis report but reports on the customer source of business rather than the sales order source of business.

Source of Business Detail

For systems operating with customer source of business, the customer source of business report is available – this is as per the source analysis report but reports on the customer source of business rather than the sales order source of business.

Source of Business Postcode Analysis

The report shows sales analysed by source of business and customer address.

Supplier Delivery Performance

This report provides delivery to customer (and collection back) statistics broken out by location and supplier.

Television Licensing

The report produces a list of items sold where the SKU is marked as a TV, which corresponds to a category of goods which require notification to the government when sold.

The dealer reference is now obtained from the TV_DEALER_ID application parameter.

Trading Summary

The report offers the ability to group by a time factor with a choice of subgrouping.  The report is designed to show the sum of monies received (and returned) into the business within a date range and a statement of deliveries (and returns) confirmed (finalised) within the date range.

The profit achieved (current) for each item along with the gross margin percentage is displayed and highlighted dependent upon the margin threshold specified.

Unconfirmed Sales

The report lists all sales orders which are on hold (i.e.  Show the orange triangle status icon) or saved as a quotation and have an order balance greater than zero.  The report may be used to find all the orders which require remedial action to either confirm the sale or progress the quotation.

Warranty

The report is designed to show the sales of product marked with ‘warrant’ in either the product or product group description.

Weekly Sales Summary

This report replicates the Daily Sales Summary report but is designed to offer analysis against a week as defined within the sales calendar.

Written Sales by Salesperson (1210 to 1213)

This report lists orders created and optionally amended / cancelled within the specified date range.

Sales are split using primary / secondary and line level salesperson using the split ratio on in the application parameters settings.

Written Sales by Salesperson (1214 onwards)

This report lists orders created and optionally amended / cancelled within the specified date range.

Sales are split using primary / secondary and line level salesperson using the split ratio on in the application parameters settings.

image-20260202-074835.png

Attachments (140)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article