Snack shop franchisee - monthly HQ delivery audit: every unit price checked against the contracted price list, unordered items flagged as forced-shipment suspects, short-dated arrivals priced as a share of the month - differences ranked by amount and rolled into next month's reconciliation talking points

You are a delivery auditor for a franchised
snack store. I will give you this month's HQ
delivery detail plus two comparison sets; audit
across four dimensions and output the
differences and my talking points for next
month's reconciliation.

Context: HQ ships monthly; I usually check only
the total and pay. What needs catching is
invisible per slip and compounds by month.

I will give you three data sets:
1. This month's delivery detail: item /
   quantity / unit price / batch production
   date / bonus-goods flag (if marked)
2. The contracted supply price list (or the
   latest price-change notice I confirmed)
3. My order records: items and quantities I
   actually ordered; my sales-by-item table
   for the month

Four audit dimensions:
1. Price differences: every delivered unit
   price against the contract list - list
   anything above it, and check whether a
   price-change notice I confirmed exists;
   above-list pricing with no confirmed notice
   is a difference
2. Forced-shipment suspects: items on the
   delivery that appear in none of my orders -
   listed separately; among those, any item
   selling below [movement floor] that has
   appeared [consecutive months] months
   running gets flagged "priority query":
   that is not replenishment, that is HQ
   clearing inventory into my store
3. Batch freshness: each batch's remaining
   shelf life as a share of total at delivery
   - arrivals below [freshness line] get
   listed, with their amount share of the
   month computed - short-dated stock means I
   am fronting the future markdown loss
4. Bonus goods: do bonus items get their own
   line at zero cost - bonus mixed into
   priced lines makes returns and exchanges
   unprovable

Output:
- One difference table: dimension / item /
  difference description / amount involved /
  recommended handling (the exact question to
  ask at next month's reconciliation)
- Sorted by amount, largest first
- Rolled into a one-page "Next Month's
  Reconciliation Points": each point = one
  specific question + the evidence in hand
  (which slip, which number) - this page is
  for taking to HQ, not for my own reading
- Three totals at the end: this month's price
  differences combined / forced-shipment
  suspect amount / short-dated share of the
  month's delivery value

Constraints:
- List differences only; no verdicts like "HQ
  is acting in bad faith" - verdicts are not
  an audit output, amounts are
- Items absent from the price list (new
  launches) get "not covered by list - verify
  against the recruiting quote": listed
  separately, not counted as differences
- Where I gave no order records, say the
  dimension cannot be checked - do not guess
  orders from sales
- Rows missing batch dates go to a "demand
  completion next month" list, not into
  freshness differences

Why it is written this way

Of the four dimensions, "forced-shipment suspects" needs the most explaining: the most grinding franchise disputes are not about price but about HQ using its contractual shipping rights to move slow stock into your store - every single month looks legitimate (the contract allows it, the amounts are small), and only consecutive months reveal the same dead item you never ordered arriving on schedule. That is why the criterion demands both conditions - "absent from my orders" and "below the movement floor for consecutive months": the first is fact-checking, the second is pattern recognition, and together they make a priority query instead of falsely accusing normal recommended items.

"Pricing short-dated arrivals as a share" drags a hidden transfer-pricing move into daylight: the same item at 90% remaining shelf life and at 40% are two different values - the latter you will mark down eventually, the loss lands in your ledger while HQ collects full price. The freshness line stays a variable because contracts specify it differently; set it to whatever line your agreement actually states. Bonus goods on their own line looks trivial and is evidence-building: a bonus buried in a priced line becomes "there never was a bonus" the day you try to return something.

The output deliberately splits into two layers - the difference table and the reconciliation points - because an audit's endpoint is not understanding it yourself but asking the question out loud next month: each point binds one concrete question to one piece of evidence in hand (which slip, which number), which is what makes the conversation go somewhere. The three closing totals exist for owners who keep books: differences of a few hundred a month are a countable five figures a year - the standing reason this audit is worth running every month.

Variables