Skip to main content

Search

Articles in this section

See more

Sales Report

In this article

The Sales Report provides detailed information about individual transactions. Use the Sales Report as a supplement to the Stock Value Vs Sales Report when more detail is required, or in conjunction with the Income Report when investigating cash discrepancies.

Tip: This report should not be used as a single reference for overall sales information but in conjunction with the Stock Value vs Sales Report

There are a number of ways to access the sales report:

  • Quick Links > Sales Report
  • Reports > Sales Reports > Sale Report 
  • Customers > Sales Report

Tip: The Sales Report (Limited) report is similar to the sales report but excludes Cost and GP information - ideal for when staff are not authorised to view the cost information. 

Using the Sales Report

To use the Sales Report:

  1. Navigate to the report using one of the menu paths above
  2. Use the Filters as required (see below for detailed information)
  3. Click Search
  4. The results will be displayed
  5. Click the arrows in the left column to expand/collapse each section
    Tip: to avoid grouping by Outlet tick the option Do not summarise by Outlet filter
  6. To Export the file click either of the icons in the top right-hand corner (XML or CSV available); the file will download immediately

salesreport_results.png
Click to enlarge

Tip: if you require assistance or training in using Excel, free help is available directly from Microsoft

Return to Top

Filters

mceclip0.png
Click to enlarge

Most of the filters are self-explanatory, however, see the detailed information below for more advanced filtering explanations.

Filter Details
Order Number

The order number for the invoice. 

Entering an Order Number will ignore all other filter options and display this order only.
Product PLU Code

Can be used to enter multiple codes when separated by a comma e.g. 1234, 1235, 1236. Valid codes for this field are:

  • Supplier SKU
  • Manufacturer SKU
  • Product ID

Note: When filtering by a PLU the report will show the entire order including the matching PLU; not just the line item for that product only. For reports on specific products only refer to the Product Sales Report.
Date From/Date To

The date range for the transactions on the report (used in conjunction with other filters). Clicking the date/clock icons will display a calendar/time picker.

Tip: Match date and time with your Income Report
Filter by Processed Date

Tick this box to report on sales that reached the Processed status within the date range. This will exclude any orders marked as Awaiting Payment.

Note: this filter should not be confused with the Sales Status filter.
Do not summarise by Outlet

Ticking this option will display the orders in consecutive order instead of grouped by Outlet
Performed Online/Offline

If a sale was processed while the system was Online or operating in Offline Mode
Special Orders

Used to filter sales containing Special Order items (products sourced directly from the Supplier).
Sales Status

Used to filter orders by a current status where the order was created within the date from/to range

Note: this filter should not be confused with the Filter by Processed Date filter
Order Source

Where the sale originated from. 

Note: All sales placed through the eCommerce API are from an order source of "WebService". The "Webstore" option is a legacy system.

Return to Top

Related articles