2026-07-17
product, reports

The following explains the data available on the Products report and the formulas used to calculate it.

  1. To open it, go to Reports > Income and select the Products sub-tab. It shows only income from product (shop) sales, filtered by the selected date range, staff, member group, and PC group. (Figure 1)

Figure 1

  1. Trend – Shows the total product sales per period. Use the Step buttons (Day / Week / Month) to group the chart.(Figure 2)
    Note: the Total includes balance and coin payments, so it shows the full value of products sold regardless of how they were paid.

Figure 2

  1. Rankings – Top by Qty ranks the products by number of items sold; Top by Amount ranks them by sales amount. A cheap product can rank high by quantity but low by amount, so the two lists can differ. (Figure 3)

Figure 3

  1. Details – The table at the bottom lists every product sold in the period, with PDF and CSV export buttons. Use the category tabs (All, Drinks, Tickets, Food, Combo, Snack, Offers, Kitchen) to filter by product group, and click a column header to sort by it. The columns are: (Figure 4)
  • Product Name: The name of the product.
  • Remaining Stock: The items left in stock.
  • Avg. Price: The product price at the time of sale (averaged if the price changed during the period).
  • Avg. Cost: The product cost (also averaged if changed).
  • Items Sold: Total sold items minus refunds.
  • Sales Amount: Total sold amount after discounts, including tax, minus refunds.
  • Balance Paid: Amount paid using member balance.
  • Items Sold (Coin) / Sales Amount (Coin): Purchases paid with coins and their value.
  • Tax: Paid tax minus refunded tax.
  • Profit = Sales Amount − Tax − (Avg. Cost × Items Sold).
    Ex: Red bull sold 6 items at 100.00 with cost 50.00: Profit = 590.00 − 53.64 − (50.00 × 6) = 236.36.
  • Refunded Qty: Number of refunded items.

Figure 4

Related: