Hotel360 Hotel360User Guide

Sales Reports

Introduction

Sales Reports answers "what are we selling the most?". Products Sales ranks the items sold at your POS tills. Services Sales summarises service orders (for example laundry, massage or hall hire). Both are read-only and both can be exported to PDF. For money-in-the-till questions use Financial Reports instead.

Opening Sales Reports

  1. Open Reports > Sales Reports.
  2. The page opens on the Products Sales tab. Click Services Sales for the other one.

Note

You need the See all reports permission to see Sales Reports.

Both tabs share the same date rules as the financial reports. If your business has a day rollover (for example 04:00), the day runs from rollover to rollover and the From Time and To Time boxes are ignored. See How Dates and Business Days Work.

Products Sales

The heading on the tab is Top Selling Products. It lists every product sold in the period, best seller first.

  1. Set From Date, From Time, To Date and To Time. Both dates start on today's business date.
  2. Optionally pick a Department (the default is All Departments).
  3. Read the table.
Column Meaning
Product The product name as it was on the bill.
Quantity Sold Total units sold in the period.
Total Sales (Ksh) The value of those units, in whole shillings. The list is sorted by this column, highest first.

Summary Totals under the table shows Total Products (how many different products), Total Quantity and Total Sales.

How Products Sales Is Calculated

  • It adds up the lines of every POS bill created in the period. Cancelled bills are left out. A bill that is still unpaid, or parked on hold, is counted.
  • Two lines for the same product are joined, even if the price changed in between.
  • The figure is the value billed. A bill that was settled as complimentary still counts at full value here. For sales net of comps, use Daily Sales in Financial Reports.
  • Services and accommodation are not here. They are on the Services Sales tab and the Accommodation reports.

Services Sales

This tab reports on service orders. Filters:

  • From Date, From Time, To Date, To Time. On this tab the two dates are plain date boxes.
  • Department: all departments by default.
  • Status: All Statuses, Pending, Active, Completed or Cancelled.

The Summary Cards

Card Meaning
Total Orders Orders created in the period that match your filters.
Total Revenue The total of those orders (after discount), less any value given away as complimentary. Cancelled orders are not counted.
Total Paid Payments received on those orders, leaving out complimentary tenders and cancelled orders.
Discount Given The sum of the discounts on the orders (cancelled orders excluded).

Amounts on this tab are shown as KES.

Note

Cancelled orders are counted in Total Orders and in the status counts, but never in the money figures. Pick a status to look at one group only.

Service Breakdown and Staff Performance

Service Breakdown has one row per service:

Column Meaning
Service The service name.
Orders How many orders.
Revenue Order totals before discount (net plus discount), less complimentary value.
Discount Discounts given.
Net Revenue Revenue less Discount. Rows are sorted by this, highest first.

Staff Performance has one row per staff member who took orders: Staff Member, Orders Completed and Total Revenue. Despite its name, Orders Completed counts all of that person's orders that match your filters, whatever their status except cancelled. Orders with no staff member are not listed. When there is nothing to show you see "No service sales found for selected filters." or "No staff performance data found."

Exporting to PDF

Click Export PDF at the top of a tab. A PDF preview opens with the same dates and filters. On Products Sales it holds the product table and totals. On Services Sales it holds Total Orders, Total Revenue, Total Paid and the service breakdown (no discount card and no staff table).