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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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’.
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.
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.
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.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article