wowprompt

Discount leakage check across invoices, salespeople and customers

Compares the price actually charged on every invoice line with the list price, and shows where discounts go beyond policy: by salesperson, customer, product and month end. Use it when margins fall while sales grow, or before you set new discount approval limits.

A table of discount given against policy by salesperson and customer, a list of invoice lines over the limit, the margin lost, and new approval rules
The output this prompt produced, unedited.

The prompt

What to give

  • Invoice lines: [paste rows: invoice date, invoice number, salesperson, customer, product, quantity, list price, price charged]
  • Product cost: [unit cost per product, or an average margin percentage]
  • Discount policy: [e.g. up to 5 percent by salesperson, up to 12 percent with manager approval, no discount on new launches]
  • Approvals on record: [list of approved exceptions, or none]
  • Period: [e.g. last two quarters]

Check each item

  1. Work out the discount on every line as list price minus price charged, in amount and percent.
  2. Mark each line within policy, approved exception, or over the limit without approval.
  3. Total the discount and the margin lost by salesperson, customer and product.
  4. Compare discount levels in the last five days of each month with the rest of the month.
  5. Find customers whose average discount has risen quarter by quarter.
  6. Find lines sold below cost.

Output format

  1. | Salesperson | Revenue | Average discount | Lines over limit | Margin lost over policy |
  2. | Customer | Revenue | Average discount | Trend | Note |
  3. The 15 largest over-limit lines with invoice number and amount.
  4. Findings in five bullets, each with a number.
  5. New discount rules: limits, approval steps and a monthly report to keep.

Guardrails

  • Some discounts are legitimate, such as volume deals; say what each pattern could mean before calling it a problem.
  • Report patterns, not accusations against named staff.
  • If list prices changed during the period, say which lines might be affected.
discount leakageprice realisationmargin analysissales discountsinvoice analysispricing policy

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity