Reading and interpreting the Discounts by Product report

The Discounts by Product report summarizes discount activity on each product. Understanding how to read and interpret it helps you identify products that are being heavily discounted and adjust your pricing strategy.

What the report shows

The report displays one row per product, with the following information:

• Product Name — the name of the product or service.
• Total Discounts — the sum of all discounts given on this product in the selected period.
• Count of Discounts — how many times this product was sold with a discount.
• Percentage of Product Sales — the discounts as a percentage of this product's total pre-discount sales.
• Quantity Sold — the total units sold of this product (across all transactions).

How it works in Usystems

When you create an invoice or sales receipt with a product and apply a discount to that item, Usystems records it. The report aggregates all these item-level discounts by product so you can see:

• Which products are being discounted most often.
• Which products lose the most money (or margin) to discounts.
• Whether a product's discount percentage is sustainable given its margin.

Discounts included:

• Item-level discounts (per-product price reductions).

Discounts not included:

• Document-level discounts (applied to the entire invoice). These appear in the Discounts by Customer report instead.
• Bulk pricing if configured as a standard product price rather than a manual discount.

Where you see it

Go to Reports → Discounts by Product to view this report. Open in Usystems

Using the data to improve pricing

• Identify over-discounted products — look for high "Percentage of Product Sales" values. These products may have pricing that is too high, forcing sales staff to discount frequently.
• Spot seasonal patterns — filter by date ranges to see if certain products get discounts at specific times (e.g., seasonal items at end of season).
• Review high-count discounts — if a product appears with many small discounts, it may indicate that customers expect a discount on that item, or that your list price is misaligned with market expectations.
• Calculate true margin — subtract the discount percentage from your product margin to see the actual profit per unit sold with a discount.
• Negotiate with suppliers — if a product is heavily discounted but you cannot increase margin, you may need to negotiate a better cost with your supplier.