Skip to main content

Daily Summary Report: Discounts tab

The discount audit trail: daily totals, every application with applier and exact time, and discounts that were later cancelled.

Written by HB

What this tab is for

The Discounts tab is the audit trail for every discount: daily totals, every single application with who applied it and when, and the discounts that were later cancelled off bills.


The tables

1. Discounts | by Day

Discounts by Day

One row per day summarising discounting: how many orders had a discount, the split between order-level discounts ("Order Disc") and item-level discounts ("Item Disc"), and the total value given away. "Disc" abbreviates discount throughout.

2. Discounts | by each Discount

Discounts by each Discount

One row per discount application, newest first:

  • Order Number / Receipt Number / Reporting Date / Order Date — which order, on which business day, opened when.

  • Discount Time — when the discount was actually applied. Comparing this to Order Date shows whether it was applied at ordering or later at settlement.

  • Type — Item (a single line was discounted) or Order (the whole bill).

  • Discount Name / Discount Amount — which discount and how much it took off.

  • Applier / Applier Role — the staff member who applied it and their role. This is the column to check when reviewing discount discipline.

  • Status — active, or cancelled if it was later removed.

3. Cancelled Discounts | by each Discount

Cancelled Discounts

Exactly the same layout, filtered to discounts that were applied and then cancelled — removed from the bill before it closed. Frequent rows here can mean staff correcting mistakes, or discount misuse worth reviewing.


Definitions

  • Discount Amount is the value taken off the bill; in the Totals table on Sales Summary the same money appears in the "Disc" column.

  • Cancelled discounts do not reduce sales — they were reversed, so the bill closed without them.

  • The Applier resolves from the staff profile; an email shows only when the account has no name saved.

What this tab does NOT show

  • Which items were discounted the most over time — Discount Summary on Sales Summary gives per-discount totals.

  • Cancelled orders/items — the Cancellations tab (different thing from a cancelled discount).

Did this answer your question?