Open topic with navigation
Sales
The Sales group has twenty one main reports that are available which are:
Return to top
Stock Item Sales
This report will detail the quantities of each selected Stock Item within the range. This report will give you the following options:
- Date Range
- Sort Order – Code, Description, Best/Worst (Quantity, Sales Amount, Cost of Sales, Profit Amount, Discounts)
- Options – Show Stock Items, Group by Sell Price, Consolidate Site Items (Only available with HO & SM Modules), Unit Price is Price 1, Hide Unit Price/Tax, Portrait.
- Optional Grouping – 14 field selections (Site, Supplier, Location, POS Terminal, Sales Category, Price Level, Department, Tax, Refund Reason, Clerk, Customer, Customer Type, Sale Type, Audit, Attributes), Show Group Label, Totals Only, Totals with Group Label.
- Selection Range – Price Level, Code, Description, Supplier, Department, Location, POS System, Clerk, Sale Type (appears when the Sale Type option has been selected under Optional Grouping), Site (Only available with HO & SM Modules), Attributes, Tags (to add tags to the selection range, enter a comma after entering the tag to add the tag; the tag will appear to the right-hand side of the tags field, tags can be removed by pressing the "X" button to the right-hand side of the tag text).
This report will show the breakdown of sales by Stock Item.
The Unit Price Inc column is always inclusive, including regions which sell items with Ex Tax Rates (i.e. Tax is applied or added to the item during the finalisation of the sale).
This report is useful for viewing the total quantities of a particular item or items within a specific department when trying to achieve sales goals.
Return to top
Stock Item Sales Trend
This report will give you the following options:
- Date Range
- Sort Order – Code, Description
- Summary – Quantity, Amount, Both
- Group By – Stock Item, Department, POS, Location, Supplier, Customer, Clerk, Graph
- Date Filter – List, Comparison, Group (Hourly, Weekday, Daily, Weekly, Monthly, Quarterly, Yearly)
- Selection Range – Code, Description, Department, Supplier, Location, POS System, Stock Control (Any, Yes, No), Indirect (Any, Yes, No)
This report will display the Stock Item sales breakdown over a selected range.
Return to top
Department Sales
This report will give you the following options:
- Date Range
- Sort Order – Code, Description
- Group By – POS System, Sales Category, Location
- Options – Include Graph, Ex Tax
- Selection Range – Code, Description, Sales Category, Location, POS System
This report will provide a breakdown of each Department sales. This report is able to be printed to the receipt printer by using the relevant function in the POS Screen programming.
Return to top
Department Sales Trend
This report will give you the following options:
- Date Range
- Sort Order – Code, Description
- Report Layout – Daily Trend Report, Monthly Trend Report, Include Graph on Report
- Selection Range – Code, Description, Location, POS System
This report will display the Department sales breakdown over a selected range.
Return to top
Sales Categories
This report will give you the following options:
- Date Range
- Sort Order – Code, Description
- Group By – POS System, Location
- Report Type – Stock Items, Departments
- Options – Include Graph
- Selection Range – Code, Description, Location
This report will display the totals for Sales Categories over a defined period. Sales Categories group Departments.
Return to top
Grouped Sales
This report will give you the following options:
- Date Range
- Exclude Discounts
The grouped sales report generates one report with the ability to cascade through the report. The first level is sales categories, by double clicking on this you are taken to the department totals. Double click on a department and the stock items that make up this department are displayed. By double clicking on the stock item the report displays the time and date of the sales, the clerk that sold them, quantity sold and the sale price.
Return to top
Hourly Sales
This report will give you the following options:
- Date Range
- Sort Order – Code, Description
- Group By – POS System, Location
- Options – Summary, Include Graph, Items sent to Tables
- Report Type – Stock Items, Departments, Sales Categories
- Grouping Intervals – 60 minutes, 30 minutes, 15 minutes
This report will display the selected sales by the Hour.
Return to top
Clerk Sales
This report will give you the following options:
- Date Range
- Sort Order – Code, Description
- Report Type – Stock Items, Departments, Stock Item Price Levels, Stock Items by Hour, Stock Items by Supplier
- Options – Include Graph
- Selection Range – Clerk Code, Clerk Name, Stock Item, Department, Site (using HO/SM only)
An example of a Report of Stock Item or Department Sales sold by each Clerk.
Return to top
Weekly Sales
This report will give you the following options:
- Date Range
- Report Type – Clerk Sales, Department Sales, Sales by Hour, Sales by Location/Hour
- Options – First Day of Week, Include Graph
- Selection Range – Clerk Code, Clerk Name, Stock Item, Department, Location
This report will display the selected sales total amounts breakdown by weekday.
Return to top
Weekly Sales Trend
This report will give you the following options:
- Date Range
- Group By – None, Stock Items, Clerks, Departments, POS, Locations
- Options – First Day of Week, One Page per Group, Include Graph
- Selection Range – Clerk Code, POS Terminal, Stock Item, Department, Location
This report will display the totals as a trend over the weekday.
Return to top
Journal History
This report will give you the following options:
- Date Range - Select the date(s) that you want to run the report for
- Group by – Clerk, POS System, Location
- Options –
Show Totals/Tendering - This option will include the type of tender and amount tendered below each Journal shown in the Journal History Report.
Show Tenders Only - This option will hide all details from each journal and will simply only show the tender type and amount tendered for each Journal.
- Selection Range – Clerk Code, Clerk Name, Location, POS System
This report will show all transactions performed.
Return to top
Cash Declaration
This report will give you the following options:
- Date Range
- Sort Order – POS System, Date
- Option – Show Footer
- Selection Range – Shift End, POS System, Clerk Code
This report will show the details of the Expected, Actual and Variance totals of the End of Shift function.
Return to top
Stock Remaining
The report will give you the following options:
- Date Range
- Sort Order – Code, Description
- Group By –Department, Supplier
- Options – All Items, Only Items with Sales, Out of Stock, Out of Stock with Sales, Reached Re-Order Level, Hide Stock Item Totals, Hide Location Totals, Include Discontinued Items, Price Level
- Selection Range – Stock Code, Description, Department, Supplier, Location
This report will show the stock remaining from the current stock level after sales.
Return to top
Inactive Stock
This report will give you the following options:
- Date Range
- Sort Order – Code, Description
- Group By – Department, Location
- Selection Range – Code, Description, Department
This report will display all items that have not been sold within the selected date range.
Return to top
Pending Sales
This report will give you the following options:
- Period/Date Selection: Options available include Today, Tomorrow, This Week, Next Week, etc.
- From/To: These fields display the date range selected for reporting on. When a pre-selected period is selected from the Period/Date selection dropdown box shown above these fields, the values in the From/To fields will be pre-filled automatically. To manually select a date in the From/To fields, ensure that you select the "Custom" option from the Period/Date selection dropdown box shown above these fields.
- Group by Order Date: This option will group the Pending Sales shown in the Report by the Order Date (or the 'Pickup Date' when used with the Pre-Ordering functionality).
- Group by Status: Enabling this option will group the orders in the Pending Sales Report based on status (e.g. Takeaway, Delivery, Pickup, Cater, etc.). The Sale Type Status is selected at the time the Pending Sale is saved and the Sale Type Statuses can be configured via Setup > Global Options > Sales > Sale Type Status.
- Customer Type: This field enables the selection of the required Customer Types to include in the report. It is possible to select one or more Customer Types. To select multiple Customer Types, press the “>” button, select the Customer Type, press “OK”, then repeat the process until the required Customer Types have been selected. Alternatively, you can manually enter the Customer Type codes separated by commas.
- Quantity Totals only: When the report is run with this option enabled, the report will simply show a list of Stock Items and the quantities ordered and will be grouped by either the Order Date or Status (depending on the Group by selection made when running the report). This enables you to quickly gather a list of Items and their quantities that are required for the selected date range without displaying further details such as Customer Names, Amounts Owing, Clerk Names, etc.
- Show Bar Tabs only: When this option is enabled, the Pending Sales report will only show Bar Tabs and will exclude any non-Bar Tab Customers from appearing in the report. This option is useful when you only need to report on Bar Tabs and don't want to see other Pending Sales, useful for getting a quick listing of all Bar Tabs that are still outstanding.
This report provides a complete list of all pending sales as well as the items within each sale.
When you use the Status selections when saving a Pending Sale, these will all be grouped on the report by default, regardless of the order they were saved.
Return to top
Promotions
This report will give you the following options:
- Date Range
- Group By – POS Terminal, Location, Site
- Report Type – Promotion Summary by Type, Promotion Details by Item
- Selection Range – Promotion Group, Site and POS System. An extra option of Supplier is also displayed when using a Report Type of Promotion Details by Item which allows the report to filter the results based on the selected Supplier.
- This report will also show any Automatic Customer Discounts grouped by percentage.
This report shows the promotions activated and the totals within each.
The below example shows the Report Type "Promotion Summary by Type"
The below example shows the Report Type "Promotion Details by Item"
This Report Type will show the individual Stock Items that are included in a Promotion, along with the Cost of each Stock Item.
The Costs displayed in this report are the costs of the Stock Items at the time that the Promotion was triggered.
Should you need to review the changes to a Stock Item's Cost, use the Price Changes Report available via Reports > Stock Control > Price Changes > Enable checkbox "Cost Price Changes"
Return to top
Price Level Comparison
This report will give you the following options:
- Date Range
- Sort Order – Code, Description
- Group By – Department
- Compare Actual Sales of – All Existing Price Levels, Each Individual Price Level
- With – 3 separate fields to select an Individual Price Level
- Selection Range – Code, Description, Department, Location, POS System
This report allows you to compare the actual price level of items sales with other price levels.
Return to top
Gift Vouchers/Gift Voucher Redemption
This report will give you the following options:
- Report Type – Gift Vouchers, Gift Voucher Redemptions (by POS)
- Vouchers Bought – Date Range
- Gift Voucher Type Range
- Vouchers Expiring Range
- Report Options – All Unredeemed, Totally or Partially Redeemed, Expired, Exclude Expired, Group by Amount, Include Drill-Down Transactions. When using Include Drill-Down Transactions, you have the ability to double-click on a Gift Voucher code within the report to Drill-Down into the voucher. Drilling Down into the Voucher Code displays further details such as the initial sale of the voucher as well as any redemptions which occurred for the voucher and the values of all redemptions for the voucher (if the voucher was redeemed in multiple transactions).
This report will show the Gift Voucher details dependent of the options selected.
Return to top
Credit Notes
This report will give you the following options:
- Credit Notes Issued – Date Range
- Credit Notes Expiring – Date Range
- Report Options – All Unredeemed, Totally Redeemed, Partially Redeemed, Expired Unredeemed
This report will show the Credit Note details dependent on the options selected.
Return to top
Coupons
This report will give you the following options:
- Report Type – Outstanding Coupons, Coupons Redeemed
- Coupons Printed – Date Range
- Coupons Expiring – Date Range
- Group By - Toggle Grouping by Site on or off. When unchecked, Coupons will be displayed in a single list. When checked, Coupons will be grouped by the site which they were printed/redeemed at.
- Selection Range - Select a Site or list of sites which you want to include in the Coupon Report. If the Site field is left as blank, all sites will be included in the Coupons Report.
This report will detail the coupons that have been activated.
Open topic with navigation
